Re: OT: Linux sqlplus scriting question

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Tue, 23 May 2006 15:06:57 +0200

hi

/home/oracle/OracleHomes/db10g/bin/sqlplus /nolog <<EOF
connect sysman/rtasys1@gridctrl
select * from dual;
exit
<<EOF

<< EOF must be EOF




On 5/23/06, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote: 

 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:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006