get rid of the << on the second EOF
or remove the entire sqlplus bit as you dont do anything with the return value
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?