Re: custom glogin and RAC

I've always used this, and it did work on RAC (10.2.0.3 - Linux), but didn't work at our level of Grid Control (I believe there is now a patch for this, but certain things done through grid control did not like non-standard SQL> prompts and would bomb out)

• Set up SQL Prompt to show database name set ARRAYSIZE 14 set termout off define osid='NOLOG' column sid new_value osid noprint select lower(user) || '@' || case when instr(global_name,'.')>1 then lower(substr(global_name,1,instr(global_name,'.')-1)) else lower(global_name) end sid from global_name; set sqlprompt '&osid> ' column sid clear

  ---

  Bradd Piontek Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Wed, Jul 30, 2008 at 8:20 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:

> 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-l