Solaris 10 System Boot and Database Startup

From: Michael42 <melliott42_at_yahoo.com>
Date: 5 Aug 2006 18:47:52 -0700
Message-ID: <1154828871.959799.29290@i3g2000cwc.googlegroups.com>

Hello,

On a Solaris 10 (sparc) system I am unable to get my Oracle 10 listener to start using a technique that I commonly use on Solaris 8 systems. My database comes up OK and the script I have will start both the database and listener if I run it manually AFTER the system has booted. In the /ect/init.d my is basically:

---

#!/bin/sh
#
# CREATE pfile'/usr1/home/oracle/product/10.2/dbs/initDB1.ora' FROM

spfile;

# Set Variables ORA_HOME should be equivalent to the ORACLE_HOME ORA_HOME=/usr1/oracle/product/920
ORA_OWNER=oracle
LOGDIR=/usr1/oracle/admin

case "$1" in

   'start')
    su - $ORA_OWNER -c $ORA_HOME/bin/dbstart 2>&1 >
$LOGDIR/dbstart.log

    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" 2>&1 >
$LOGDIR/lsnrstrt.log

    ;;

   'stop')
    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" 2>&1 >
$LOGDIR/lsnrstp.log

    su - $ORA_OWNER -c $ORA_HOME/bin/dbshut 2>&1 >
$LOGDIR/dbshut.log

   ;;
esac

---

On system boot when it runs, the error I am getting is that the network is unavailable.

Can anyone please share your Sun UNIX script that starts your Oracle database and listener (and any required OS changes etc.)?

Thanks,

Michael42 Received on Sat Aug 05 2006 - 20:47:52 CDT