Auto DB Start in Sun Solaris [message #66938] |
Wed, 19 March 2003 07:08 |
Velu Natararaj
Messages: 12 Registered: March 2003
|
Junior Member |
|
|
Hello Guru's,
I have installed Oracle Database in Sun Solaris system. It's work fine. But every time i want to start manually. Is there is any way to auto start the service while the system loges in, what NT & Advance Server does...
Waiting for you'r reply,
Velu N
|
|
|
Re: Auto DB Start in Sun Solaris [message #66943 is a reply to message #66938] |
Thu, 20 March 2003 06:29 |
Frank Naude
Messages: 4581 Registered: April 1998
|
Senior Member |
|
|
Yes, ask your sysadmin to create a startup file. Example:
File: /etc/rc3.d/S98dboracle
#!/bin/sh
#
# Startup for Oracle Databases as defined in /var/opt/oracle/oratab
#
echo "Starting Oracle in the background..." > /dev/console
ORACLE_HOME=`cat /var/opt/oracle/oratab|grep -v '^#'|tail -1|cut -d: -f2 -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
exit 0
Best regads.
Frank
|
|
|
Re: Auto DB Start in Sun Solaris [message #67634 is a reply to message #66943] |
Sat, 27 November 2004 17:35 |
Susmit Sarkar
Messages: 2 Registered: November 2004
|
Junior Member |
|
|
Although the earlier reply is correct, you can also use these steps:
When installing Oracle in Solaris, the following files are created in $ORACLE_HOME/bin :
#1) lststart (Listener auto start)
#2) dbshut (Database shutdown)
#3) dbstart (Database auto start)
All you need to do is, make a soft link to /etc/init.d/dbora
The dbora file already has the code written for Auto startup of Oracle Database, Listener and shutdown.
Instead of creating an entire file, just create a link "S98dboracle" in /etc/rc2.d location.
|
|
|