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).
Received on Thu Oct 03 2002 - 12:44:04 CDT