Re: OT: Linux sqlplus scriting question

get rid of the << on the second EOF

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

On 23/05/06, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> 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_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?
>

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