Make sure that the TNS_ADMIN variable is set to the location of the oratab
file for the user that will be launching the process.

I'm running on Solaris, my /etc/rc3.d/S99dbstart script looks like this
(minus the *'s):
******************************
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_OWNER=<oracle username>
export ORACLE_OWNER

case "$1" in

'start')

su $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl start"
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl start oms"
su $ORACLE_OWNER -c "$ORACLE_HOME/Apache/Apache/bin/apachectl start"

;;

'stop')

su $ORACLE_OWNER -c "$ORACLE_HOME/Apache/Apache/bin/apachectl stop"
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl stop oms
<username>/<password>"
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl stop"
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
su $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut

;;

esac
******************************




-----Original Message-----
From: Rubec Tom (xwave)
[mailto:oracledba-ezmlmshield-x16376091.[Email address protected]
Sent: Wednesday, March 01, 2006 6:09 AM
To: LazyDBA Discussion
Subject: RE: Auto start up of databases

i think thos are set up with oracle install.

you need to edit your oratab file
/var/opt/oracle/oratab
or
/etc/oratab
could be somewhere else



-----Original Message-----
From: nitin
[mailto:oracledba-ezmlmshield-x59638714.[Email address protected]
Sent: Monday, February 27, 2006 7:36 AM
To: LazyDBA Discussion
Subject: Auto start up of databases

Hi gurus,
do I need to make any changes to any of the file (like inittab or any
other file in init.d) when i configure dbstart and dbshut on Solaris? I
am using 9.2.0.1.


Nitin


Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page