RE: custom glogin and RAC
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "oracledbaquestions@xxxxxxxxx" <oracledbaquestions@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 31 Jul 2008 01:35:29 -0400
What version of oracle?
If you're on at least 10g, just do:
set sqlprompt "_user'@'_connect_identifier> "
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of Dba DBA [oracledbaquestions@xxxxxxxxx]
Sent: Wednesday, July 30, 2008 9:20 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: custom glogin and RAC
I have used a glogin like the following for years. When I try to start svrctl
with this, it looks for db name and username parameters and it fails to start.
anyone know how to change this so I can make it work with RAC ?
undefine usr db
col usr new_value usr
col db new_value db
set termout off
select lower(user) usr,
substr(global_name, 1, instr(global_name, '.')-1) db
from global_name
/
set termout on
set sqlprompt '&&usr.@&&db.> '
--
//www.freelists.org/webpage/oracle-l
Other related posts:
