RE: svrmgrl echo v$database in script

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