Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script to start/stop Oracle 9i
"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