custom glogin and RAC
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Wed, 30 Jul 2008 21:20:16 -0400
Message-ID: <f30139790807301820o5b07d7b0r4bc1356e59885f52@mail.gmail.com>
Date: Wed, 30 Jul 2008 21:20:16 -0400
Message-ID: <f30139790807301820o5b07d7b0r4bc1356e59885f52@mail.gmail.com>
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.> '
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 30 2008 - 20:20:16 CDT