Re: OT: Linux sqlplus scriting question

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Tue, 23 May 2006 14:06:15 +0100

get rid of the << on the second EOF

or remove the entire sqlplus bit as you dont do anything with the return

On 23/05/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

# 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;
# start OMS
cd /home/oracle/OracleHomes/oms10g/opmn/bin
./opmnctl startall

The script is stopping after doing sqlplus, what am I missing?

Other related posts: