Home » Infrastructure » Unix » database startup  () 1 Vote
database startup [message #172418] Tue, 16 May 2006 07:48 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello
everytime i shutdown my AIX 5.2 and start the server , oracle database dosent start automatically,
when i log on to sqlplus>
iget an error that there is no listener
so i run
lsnrctl> start listener
then
sqlplus> /as sysdba
startup
an everything goes fine
the issue :
how can i automate this issue so i dont have to do it everytime is restart my AIX im using oracle 9i
thanks
best regards for all ur help
Re: database startup [message #172895 is a reply to message #172418] Thu, 18 May 2006 09:19 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Add a startup sctipt in your /etc/rc.d/rc2.d directory. Example:

#!/bin/sh
#
#
# Startup for Oracle Databases as defined in /var/opt/oracle/oratab
#

echo "Starting Oracle in the background..." > /dev/console
ORACLE_HOME=`/usr/bin/cat /var/opt/oracle/oratab|grep -v '^#'|head -1|cut -d: -f
2 -s`
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_HOME LD_LIBRARY_PATH

su oracle -c "${ORACLE_HOME}/bin/dbstart" < /dev/null

echo "Usage: /etc/rc.d/rc2.d/S98dboracle"

exit 0
Re: database startup [message #183620 is a reply to message #172418] Fri, 21 July 2006 10:10 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
is there not an oratab file as in Solaris that tells the system to bring up the database and listener upon restart?

If there is a file that runs on system startup, then put your commands in it.
Previous Topic: backing up and restoring solaris
Next Topic: Open Ports on Solaris
Goto Forum:
  


Current Time: Thu Mar 28 09:51:19 CDT 2024