Re: How to identify the 'current' instance
From: AMARENDRA B NETTEM <nettama_at_charlie.acc.iit.edu>
Date: 1996/10/14
Message-ID: <32631954.56DB_at_charlie.acc.iit.edu>#1/1
Date: 1996/10/14
Message-ID: <32631954.56DB_at_charlie.acc.iit.edu>#1/1
j4xprel_at_pbsrv10.isp.pacbell.com wrote:
>
> running under hp-ux, after exporting ORACLE_SID=TST, TWO_TASK=DEV and
> then logging on to sql*plus with 'sqlplus user_id_at_T:host_name:PRD' is
> there any way to query the correct current instance?
>
> thanks in advance.yes at the oerating system prompt type
echo $ORACLE_SID
gives the current instance
-- AMARENDRA B NETTEM PH.No. (312)945-2116 HOMEPAGE: http://www.iit.edu/~nettama E-MAIL : nettama_at_charlie.acc.iit.eduReceived on Mon Oct 14 1996 - 00:00:00 CEST