Instance are reboot on System startup !

[Henk]

Hallo specialists,

i have problems with a 9i Database on FSC Primepower Solaris 8. On Systemstartup, the Database makes an reboot (starting an shutdown). the dbstart-Script looks good (like this):

---------------------------------------------------------------------

#
# $Header: dbstart.sh.pp 03-apr-2001.13:38:21 jboyce Exp $ dbstart.sh.pp Copyr (c) 1991 Oracle
#

###################################
#
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################

ORATAB=/var/opt/oracle/oratab

trap 'exit' 1 2 3
case $ORACLE_TRACE in
T) set -x ;;
esac

# Set path if path not set (if called from /etc/rc)
case $PATH in
"") PATH=/bin:/usr/bin:/etc
export PATH ;;
esac
# Save LD_LIBRARY_PATH
SAVE_LLP=$LD_LIBRARY_PATH

#
# Loop for every entry in oratab file and and try to start
# that ORACLE
#

cat $ORATAB | while read LINE
do
case $LINE in
\#*) ;; #comment-line in oratab
*)
# Proceed only if third field is 'Y'.
if [ "`echo $LINE | awk -F: '{print $3}' -`" = "Y" ] ; then
ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
if [ "$ORACLE_SID" = '*' ] ; then
ORACLE_SID=""
fi
# Called programs use same database ID
export ORACLE_SID
ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
# Called scripts use same home directory
export ORACLE_HOME
# Put $ORACLE_HOME/bin into PATH and export.
PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc ; export PATH
# add for bug # 652997
LD_LIBRARY_PATH=${SAVE_LLP}:${ORACLE_HOME}/lib ; export LD_LIBRARY_PATH
PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
SPFILE=${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora

# See if it is a V6 or V7 database
VERSION=undef
if [ -f $ORACLE_HOME/bin/sqldba ] ; then
SQLDBA=sqldba
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
/SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
print V[1]}'`
case $VERSION in
"6") ;;
*) VERSION="internal" ;;
esac
else
if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
SQLDBA=svrmgrl
VERSION="internal"
else
SQLDBA="sqlplus /nolog"
fi
fi

STATUS=1
if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf ] ; then
STATUS="-1"
fi
if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora ] ; then
STATUS="-1"
fi
pmon=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
if [ "$pmon" != "" ];
then
STATUS="-1"
echo "Database \"${ORACLE_SID}\" already started."
fi

if test $STATUS -eq -1 ; then
echo ""
echo "Database \"${ORACLE_SID}\" possibly left running when system went down (system crash?)."
echo "Notify Database Administrator."
case $VERSION in
"6") sqldba "command=shutdown abort" ;;
"internal") $SQLDBA $args < connect internal
shutdown abort
EOF
;;
*) $SQLDBA $args < connect /as sysdba
shutdown abort
EOF
;;
esac
if test $? -eq 0 ; then
STATUS=1
else
echo "Database \"${ORACLE_SID}\" NOT started."
fi
fi

if test $STATUS -eq 1 ; then
if [ -f $PFILE -o -f $SPFILE ] ; then
case $VERSION in
"6") sqldba command=startup ;;
"internal") $SQLDBA < connect / as sysdba
startup
EOF
;;
*) $SQLDBA < connect / as sysdba
startup
EOF
;;
esac

if test $? -eq 0 ; then
echo ""
echo "Database \"${ORACLE_SID}\" warm started."
else
echo ""
echo "Database \"${ORACLE_SID}\" NOT started."
fi
else
echo ""
echo "Can't find init file for Database \"${ORACLE_SID}\"."
echo "Database \"${ORACLE_SID}\" NOT started."
fi
fi
fi
;;
esac
done

---------------------------------------------------------------------

Has anyone an idea?

Thx
Henk

[davey23uk]

whats the actual problem, thats just look the dbstart script from $ORACLE_HOME/bin.

Also whats in your /etc/init.d directorys and /etc/rc2.d and /etc/rc3.d

[Henk]

in /etc/init.d are the dbora-file:

---------------------------------------------------------------------

#!/usr/bin/sh
#
# chkconfig: 345 50 49
# description: starts the oracle dabase deamons
#
echo "Oracle 9i auto start/stop"

case "$1" in
'start')

echo "Starting Oracle9i: "
su - oracle -c /oracle/OraHome1/bin/dbstart

echo "Starting the Listener for 9i: "
su - oracle -c "/oracle/OraHome1/bin/lsnrctl start"

touch /var/lock/subsys/oracle9i
echo
;;

'stop')
echo "Shutting Oracle9i: "
su - oracle -c /oracle/OraHome1/bin/dbshut

echo "Shutting down Listener for 9i: "
su - oracle -c "/oracle/OraHome1/bin/lsnrctl stop"

rm -f /var/lock/subsys/oracle9i
echo
;;

'restart')

echo -n "Restarting Oracle9i: "
$0 stop
$0 start
echo
;;

*)
echo "Usage: oracle9i {start | stop | restart }"
exit 1

esac
exit 0

--------------------------------------------------------------------

and in /etc/rc2.d are a link S95oracle -> /etc/init.d/dbora
and in /etc/rc0.d are a link K10oracle -> /etc/init.d/dbora

[davey23uk]

and you say the database gets started up and then shutdown? so you have to start it manually each time you restart?

[Henk]

Yes, that´s right!

[davey23uk]

what happens if you run the scripts diretly from the command line

so do cd /etc/rc2.d
./S95oracle start

[Henk]

that´s work fine !!! :-(( also dbstart works

but it dosn´t work at system startup!