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

Home -> Community -> Usenet -> c.d.o.server -> Re: Script to start/stop Oracle 9i

Re: Script to start/stop Oracle 9i

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Aug 2004 06:55:17 -0700
Message-ID: <2687bb95.0408020555.7d88f860@posting.google.com>


"BAD8888" <bad8888l_at_nowhere.com> wrote in message news:<2n6l4kFsq1b9U1_at_uni-berlin.de>...
> How can I write a script to start/stop Oracle 9i on Redhat Linux 3.0
> Advanced server. Any examples or helpful links would be great.
>
> thanx.

Just use standard UNIX shell script features to execute sqlplus command stream.

# using dot command execute script to set Oracle environment # if TWO_TASK is set unset TWOTASK here
sqlplus /nolog <<EOF
connect / as sysdba
startup
EOF HTH -- Mark D Powell -- Received on Mon Aug 02 2004 - 08:55:17 CDT

Original text of this message

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