RE: custom glogin and RAC

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Thu, 31 Jul 2008 01:35:29 -0400
Message-ID: <667C10D184B2674A82068E06A78382B523C8F2A5@AAPQMAILBX01V.proque.st>

What version of oracle?

If you're on at least 10g, just do:
set sqlprompt "_user'@'_connect_identifier> "

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA [oracledbaquestions_at_gmail.com] Sent: Wednesday, July 30, 2008 9:20 PM
To: oracle-l_at_freelists.org
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.> '

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 31 2008 - 00:35:29 CDT