Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> OT: Linux sqlplus scriting question

OT: Linux sqlplus scriting question

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 23 May 2006 08:37:23 -0400
Message-Id: <s472c9eb.043@gcrta.org>


I am trying to make a script to stop the OMS and restart it after running sqlplus. Right now testing with select from DUAL.  

# set Oracle_home

ORACLE_HOME=/home/oracle/OracleHomes/db10g export ORACLE_HOME  

# stop OMS

cd /home/oracle/OracleHomes/oms10g/opmn/bin ./opmnctl stopall
/home/oracle/OracleHomes/db10g/bin/sqlplus /nolog <<EOF connect sysman/rtasys1_at_gridctrl
select * from dual;
exit
<<EOF
# start OMS

cd /home/oracle/OracleHomes/oms10g/opmn/bin ./opmnctl startall  

The script is stopping after doing sqlplus, what am I missing?  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 07:37:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US