| database startup [message #172418] |
Tue, 16 May 2006 07:48  |
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  |
Frank Naude
Messages: 4581
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 |
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.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
