sqlplus prompt question in 9i

From: Guang Mei <gmei_at_incyte.com>
Date: Wed, 29 Oct 2003 08:24:37 -0800
Message-ID: <F001.005D4F2D.20031029082437@fatcity.com>

Hi:

With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and added

set termout off
col site_name noprint new_value site_name_new select 'SQL> ' site_name from dual;
select user

       || substr(proc.program, instr(proc.program,'@'),
                 instr(proc.program,' ') - instr(proc.program,'@'))
       || '-SQL> ' site_name

from v$process proc
where proc.pid = 2;
set sqlprompt '&&site_name_new'
set termout on

so that when a user launches sqlplus, it would show something at prompt like

username_at_hostname-SQL>

instead of

SQL> I found that doing this in 9i will prevent me starting up my instance, when I use

sqlplus '/as sysdba'

In 8i, I always used svrmgrl to bounce db so there was no problem with modified glogin.sql.

Has anyone found a work-around in 9i so that sqlplus prompt displays "username" and "hostname" when launched? I know there is a new _CONNECT_IDENTIFIER in 9i, but that's not good enough.

TIA. Guang

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 29 2003 - 10:24:37 CST