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.
>

First I would use svrmgrl instead of sqldba lmode=y, since it goes away in 7.3.x. The following csh scripts will work to shutdown your database:

#!/bin/csh -f

# Use the lastest RDBMS bin files

   setenv ORACLE_HOME /path/product/7.3.2    set path="$ORACLE_HOME/bin"

# Shutdown 7.1.4 rdbms

   setenv ORACLE_HOME /path/product/7.1.4    setenv ORACLE_SID db01

   svrmgrl << EOF

     connect internal;
     shutdown immediate;

   setenv ORACLE_HOME /path/product/7.3.2    setenv ORACLE_SID db02

   svrmgrl << EOF

      connect internal;
      shutdown immediate;