RE: svrmgrl echo v$database in script

1. Change your unholy methods to use the light side of the force. or
2. Just use a different variable to hold the tnsnames.ora entry of wherever you happen to be connecting to. Or initialize the $ORACLE_SID variable to whatever you want it to be. This allows you to iterate through a list of SIDs to perform ops on multiple db's if needed, i.e.,

"sqlplus user_at_current_sid
 ...
 exit
 echo $current_sid >> logfile"

in your script.

Scott Shafer
San Antonio, TX
210.581.6217

> -----Original Message-----
> From: Fink, Dan [SMTP:Dan.Fink_at_mdx.com]
> Sent: Thursday, October 03, 2002 12:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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: 
  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).