sqlplus登录环境设置

通过glogin.sql文件设置sqlplus登录的环境设置

编辑$ORACLE_HOME/sqlplus/admin下的glogin文件

详细内容如下所示：

define_editor=viset serveroutput on size 1000000set trimspool onset long 5000set linesize 100set pagesize 9999column plan_plus_exp format a80column global_name new_value gnameset termout offdefine gname=idlecolumn global_name new_value gnameselect lower(user) || '@' || substr(global_name,1,decode( dot,0,length(global_name),dot-1) ) global_name from (select global_name,instr(global_name,'.') dot from global_name );set sqlprompt '&gname> 'set termout on

保存之后使用sqlplus登录查看设置后的效果

[oracle@rac1 ~]$ sqlplus system/oracleSQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 7 15:11:45 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionssystem@RACDB>

使用sys登录

[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 7 15:12:27 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionssys@RACDB>