Listing 3 An example initialization script for Oracle database instances

#!/bin/ksh

ORATAB=/var/opt/oracle/oratab

for DB in `cat $ORATAB | sed '/^#/d' | sed 's/ //g' | sed '/N$/d'`
do
        ORACLE_SID=`echo $DB | awk -F: '{print $1}'`
        ORACLE_HOME=`echo $DB | awk -F: '{print $2}' `
        ORACLE_VERSION=`basename $ORACLE_HOME`
        PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc:
        LD_LIBRARY_PATH=$ORACLE_HOME/lib
        export ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH

        PMON=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
        if [ "$PMON" != "" ]
        then
        /usr/bin/newtask -p $ORACLE_SID sqlplus /nolog << EOF
connect / as sysdba
startup
EOF
        fi
done