OT: Linux sqlplus scriting question
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>,<oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Tue, 23 May 2006 08:37:23 -0400
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@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
Other related posts:
