Home » RDBMS Server » Networking and Gateways » Auto DB Start in Sun Solaris
Auto DB Start in Sun Solaris [message #66938] Wed, 19 March 2003 07:08 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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&#124grep -v '^#'&#124tail -1&#124cut -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 Go to previous message
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.
Previous Topic: Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error
Next Topic: Port Listener for Oracle
Goto Forum:
  


Current Time: Wed May 01 20:05:13 CDT 2024