A) Change your unholy methods to use the light side of the force. or B) 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@current_sid ... exit echo $current_sid >> logfile" in your script. Scott Shafer San Antonio, TX 210.581.6217 > -----Original Message----- > From: Fink, Dan [SMTP:[EMAIL PROTECTED]] > 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@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:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
