Re: Solaris 10 System Boot and Database Startup

From: Lothar Armbrüster <lothar.armbruester_at_t-online.de>
Date: Mon, 07 Aug 2006 22:39:41 +0200
Message-ID: <87mzag9t6a.fsf@prometeus.none.local>

"Michael42" <melliott42_at_yahoo.com> writes:

> Bob,
>
> Thanks for the response.
>
>>> If you can start it manually, then your script is working. You just need to
> make sure the script is run after the network in your boot process.
>
> BINGO! :-)
>
> ...but where is that in Solaris 10?
>
> In Solaris 8 know it is controlled via the proper rcn.d run level dir
> (rc2.d and rc3.d etc.) and the appropriate Snn link in the rc.n
> directory to your script (/ect/init.d/dbora). So S10StartNetworkStuff
> then S99StartOracle would do the trick.
>
> I could be wrong, but I think the rules have changed in Solaris 10.
>
> Any suggestions?
>

Hello Michael42,
on my Solaris 10 box, I linked /etc/init.d/dbora to /etc/rc3.d/S99dbora and /etc/rc0.d/K01dbora. That seems to work.

But I did some changes on the dbora script. Here is my version:

----------------> cut <----------------------------
#! /usr/bin/sh  -x
#

# Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation.

ORACLE_HOME=/usr/ora/oracle/10.2.0/db_1

#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#

ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then

   if [ "$PLATFORM" = "HP-UX" ] ; then

      remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
      exit
   else
#      rsh $HOST -l $ORACLE  $0 $1 ORA_DB
      su - $ORACLE -c "$0 $1 ORA_DB"
      exit

   fi
fi
#
case $1 in
'start')

        $ORACLE_HOME/bin/dbstart $ORACLE_HOME &
        $ORACLE_HOME/bin/isqlplusctl start &
        $ORACLE_HOME/bin/emctl start dbconsole &
        ( ORACLE_HOME=/usr/ora/oracle/10.2.0/companion_1 ; $ORACLE_HOME/opmn/bin/opmnctl startall ) &
        ;;
'stop')
        ( ORACLE_HOME=/usr/ora/oracle/10.2.0/companion_1 ; $ORACLE_HOME/opmn/bin/opmnctl stopall ) &
        $ORACLE_HOME/bin/emctl stop dbconsole &
        $ORACLE_HOME/bin/isqlplusctl stop &
        $ORACLE_HOME/bin/dbshut $ORACLE_HOME
        ;;
*)
        echo "usage: $0 {start|stop}"
        exit
        ;;

esac
#
exit

-----------------> cut <-------------------------

Hope that helps,
Lothar

-- 
Lothar Armbrüster  | lothar.armbruester_at_t-online.de
Hauptstr. 26       |
65346 Eltville     |

Received on Mon Aug 07 2006 - 15:39:41 CDT