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).

Reply via email to