Re: Start/Shutdown of Oracle Databases in Unix

trazz_at_interaccess.com wrote:

>Does anyone have any unix shell scripts to startup and shutdown
>multiple databases in unix. i have to do the following manually and it
>gets boring every time.
>
>1. su - oracle
>2. set environment variables (ORACLE_SID is the one that will need to
>change each time i need to startup a differnet database.
>3. sqldba lmode=y
>inside the sqldba i then type
>4. connect internal
>5. startup or shutdown immediate
>6 . exit
>
>I have to repeat that process each time for every database on the
>server. how can i make it automatically in a shell script do all of
>those things without the need for user intervention. i want to start
>and stop it from cron as well. I need it to be able to change to a
>different database name each time and be able to start or stop all or
>some of them.
>
>
>We are running on Sun OS 5.4/Solaris 2.4
>
>Oracle 7.1.4 & Oracle 7.3 &
>
>SQL*DBA: Release 7.2.2.3.0 - Production on Tue Aug 27 22:46:23 1996
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>Oracle7 Server Release 7.2.2.3.0 - Production Release
>With the distributed and parallel query options
>PL/SQL Release 2.2.2.3.0 - Production
>
>SQLDBA>
>
>Thanks,
>
>
>Trazz
>

Have a look in $ORACLE_HOME/bin at dbshut and dbstart. You should be able to modify that to suit your needs.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!