RE: Linux sqlplus scriting question

The second '<<EOF' should be 'EOF'.

So what happens is sqlplus fails?  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Tuesday, May 23, 2006 6: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

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l