Article Figure 1 Listing 1 Listing 2 Listing 3
Listing 4 Listing 5 Listing 6 Listing 7 Listing 8
Listing 9 Listing 10 oct2005.tar

Listing 4 An example initialization script for Oracle database listeners

#!/bin/ksh

ORATAB=/var/opt/oracle/oratab

for DB in `cat $ORATAB | sed '/^#/d' | sed 's/ //g' `
do
        ORACLE_SID=`echo $DB | awk -F: '{print $1}'`
        ORACLE_HOME=`echo $DB | awk -F: '{print $2}' `
        RUNATSTART=`echo $DB | awk -F: '{print $3}' `
        ORACLE_VERSION=`basename $ORACLE_HOME`
        PATH=$ORACLE_HOME/bin:$PATH
        export ORACLE_SID ORACLE_HOME PATH
        if [ $RUNATSTART = "Y" ] || [ $RUNATSTART = "y" ];then
                /usr/bin/newtask -p $ORACLE_SID lsnrctl start lsnr_$ORACLE_SID
        fi
 done