custom glogin and RAC

From: Dba DBA <>
Date: Wed, 30 Jul 2008 21:20:16 -0400
Message-ID: <>

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.> '

Received on Wed Jul 30 2008 - 20:20:16 CDT

Original text of this message