RE: svrmgrl echo v$database in script

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:wisernet100_at_yahoo.com]
> 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
>
>
> --- Scott.Shafer_at_dcpds.cpms.osd.mil wrote:
> > 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).
>
>
> __________________________________________________
> 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: wisernet100_at_yahoo.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).