-
Instance are reboot on System startup !
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
-
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
-
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
-
and you say the database gets started up and then shutdown? so you have to start it manually each time you restart?
-
-
what happens if you run the scripts diretly from the command line
so do cd /etc/rc2.d
./S95oracle start
-
that´s work fine !!! :-(( also dbstart works
but it dosn´t work at system startup!
Last edited by Henk; 11-18-2003 at 04:02 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|