Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT: Linux sqlplus scriting question

Re: OT: Linux sqlplus scriting question

From: Larry Lutz <larry.j.lutz_at_gmail.com>
Date: Wed, 24 May 2006 14:00:11 -0400
Message-ID: <abc34f0e0605241100m1b39633bg67812be4294d4154@mail.gmail.com>


After the exit, you should have EOF, not <<EOF.

On 5/24/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> 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
>

-- 
"  ,--o
-\\_<_
(*)/-'(*)

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 24 2006 - 13:00:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US