FAQ
Heh heh,

Just popped in for a quicky !!!!!!!

Regards

Lee

-----Original Message-----
Sent: 03 October 2002 19:29
To: Multiple recipients of list ORACLE-L

Lee, you're alive. I'll let the OT list know! Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Thursday, October 03, 2002 1:33 PM
Hi,

This works....

#!/bin/ksh
export ORACLE_SID=ADW
export ORACLE_HOME=/usr/app/oracle/product/8.0.5
export PATH=$ORACLE_HOME/bin:$PATH

svrmgrl < connect internal
select name from v_\$database;
exit

EOF
Just escape the $ sign with a backslash.

HTH
Lee

-----Original Message-----

Sent: 03 October 2002 16:43
To: Multiple recipients of list ORACLE-L


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




**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: lerobe_at_acxiom.co.uk

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: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

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: Robertson Lee - lerobe
INET: lerobe_at_acxiom.co.uk

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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 14 of 14 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 2, '02 at 11:28p
activeOct 4, '02 at 8:08a
posts14
users11
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase