Or a here document that allows you to iterate through a list of SID's if necessary. Env variables don't have to be static on *nix...
Scott Shafer San Antonio, TX 210.581.6217 > -----Original Message----- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 2002 12:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: svrmgrl echo v$database in script > > If fyou want to do it from within a script, you either need to code the > select into a .sql file that you run OR you need to "escape" the $ with > a \ in your ksh script > > > --- [EMAIL PROTECTED] wrote: > > 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: Baker, Barbara > > > 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). > > -- > > 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). > > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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). -- 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).