RE: svrmgrl echo v$database in script

What happens if the ORACLE_SID is set to one value and the caller uses SQL*Net to access a different database? While this is not usually the case in scripts, it could be a problem if the script is parted of a called function.
ORACLE_SID=DEV
sqlplus scott/tiger_at_PROD <-- I'm not connected to DEV anymore.

I realize this is nit-picking, but I've done far too many recoveries because someone thought they were in DEV when they actually connected to PROD. I'd rather know EXACTLY which db I'm connected to, not which one the O/S thinks I should be in.

My $.02

Dan Fink

-----Original Message-----
[mailto:Scott.Shafer_at_dcpds.cpms.osd.mil] Sent: Thursday, October 03, 2002 9:43 AM To: Multiple recipients of list ORACLE-L

echo $ORACLE_SID >> logfile

Scott Shafer
San Antonio, TX
210.581.6217

> -----Original Message-----
> From: Baker, Barbara [SMTP:bbaker_at_denvernewspaperagency.com]
> Sent: Wednesday, October 02, 2002 6:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: svrmgrl echo v$database in script
>
>
> Oracle 8.0.5
> Solaris 2.6
>
> List:
> I've created a script (ksh) called from elsewhere that shuts down the
> database. I REALLY want to echo the name of the database into my log file
> before I shut down. While "select name from v$database" works fine from
> svrmgrl interactively, it throws up in the script. I'd guess the $ sign
> is
> screwing it up. (I can get other commands to work within the script.)
> However, I don't know what to do about it.
>
> Any ideas?
>
> Thx!!!
>
> Barb
>
> $ svrmgrl
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> select name from v$database;
> NAME
> ---------
> TADENT
> 1 row selected.
>
>
> #!/usr/bin/ksh
> # $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
> # Name: stop_db.sh
> # Author: Barb Baker
> # Purpose: execute shutdown immediate on current database
> # (i.e., database pointed to by current value of ORACLE_SID)
> ############################################################
> echo "Stop oracle instance \"${ORACLE_SID}\" at `date` "
> ${ORACLE_HOME}/bin/svrmgrl << EOF
> connect internal
> select name from v_$database;
> EOF
>
>
> $ ./stop_db.sh
> Stop oracle instance "tadent" at Wed Oct 2 16:24:59 MDT 2002
>
>
> SVRMGR> Connected.
> SVRMGR> select name from v_
> *
> ORA-00942: table or view does not exist
> SVRMGR>
> Server Manager complete.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Baker, Barbara
> INET: bbaker_at_denvernewspaperagency.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: Dan.Fink_at_mdx.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).