sqlplus显示登录用户名和实例名
1.Entry $ORACLE_HOME/sqlplus/admin,edit glogin.sql,add as follow SQL statement behind.
[hrmsoraclone@hrmodbt01 admin]$cp glogin.sql glogin.sql.bak
[hrmsoraclone@hrmodbt01 admin]$vi glogin.sql
define_editor=vi
set timing on
set serveroutput on size 100000
set linesize 100
set trimspool on
set long 5000
set termout off
default gname=idle
column global_name new_value gname
SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NAME FROM v$instance;
set sqlprompt '&gname> '
set termout on
2.when entry sqlplus,it show as follow
set timing on
set serveroutput on size 100000
set linesize 100
set trimspool on
set long 5000
set termout off
default gname=idle
column global_name new_value gname
SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NAME FROM v$instance;
set sqlprompt '&gname> '
set termout on
2.when entry sqlplus,it show as follow
[hrmsoraclone@hrmodbt01 admin]$ sql
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 29 09:50:56 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-769474/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
绑定2网卡为bond0
请登录后发表评论
登录
全部评论
