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: z b <zimsbait_at_gmail.com>
Date: Tue, 23 May 2006 09:53:02 -0400
Message-ID: <5b1f2b700605230653w27508999s9d32ec11913060b5@mail.gmail.com>


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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 08:53:02 CDT

Original text of this message

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