Does it just return to the prompt and stop? Somebody could probably
tell you why it does this but I would suggest you create three scripts
and run them from one script to get control to return to the calling
script. I have done a lot of this on Windows and even there I kept
getting hung up when trying to include all these steps in one script.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Tuesday, May 23, 2006 8:37 AM
To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com;
ORACLE-L_at_IC.SUNYSB.EDU; oracle-rdbms_at_yahoogroups.com
Subject: OT: Linux sqlplus scriting question
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 - 08:08:15 CDT
