Re: OT: Linux sqlplus scriting question

doesn't matter, it'll just be changed to rtasys2 <evil grin>

On 5/23/06, z b <zimsbait_at_gmail.com> wrote:
>
> Someone has to mention this..
>
> I hope that isn't your prod password. ;-)
>
>
> On 5/23/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?
> >
> > Jeffrey Beckstrom
> > Database Administrator
> > Greater Cleveland Regional Transit Authority
> > 1240 W. 6th Street
> > Cleveland, Ohio 44113
> >
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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