RE: Auto-start Oracle on reboot problem

One way to debug this is to add the line  

exec >/tmp/dbora_debug.log 2>&1  

somewhere in the beginning of dbora to see what transpires during start up
(BTW, the log file of shutdown will not persist since it is in /tmp). If
not anything else it will at least tell if if this is being invoked during startup. You also mentioned that you ran is as root. Was this as (a) sudo
(b) su (c) su - root
 

If you could, please post the dbora here which may help  

-Krish  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Rothouse
Sent: Tuesday, January 08, 2008 8:17 PM
To: Oracle-L
Subject: Auto-start Oracle on reboot problem  

Oracle 10.2.0.3 on Solaris 10 (64-bit SPARC)

I'm having a problem getting my Oracle database to auto-start upon reboot
(init -6) on . Yet when I run the dbora script manually (./dbora start)
using the root account, the database starts without a problem ( i.e. the script works as expected).

-rwxr-xr-x 1 oracle dba 1193 Nov 18 19:03 /etc/init.d/dbora

lrwxrwxrwx 1 root root 17 Jan 7 11:20 /etc/rc0.d/K01oracle -> /etc/init.d/dbora

lrwxrwxrwx 1 root root 17 Jan 7 11:19 /etc/rc2.d/S99oracle -> /etc/init.d/dbora

My UNIX Admin tells me there are no errors in any log files during the reboot. I wouldn't expect any errors as it seems to skip both shutdown and startup of Oracle and as previously mentioned I am successful (shutdown and startup) when running the script manually after the server is up.

I don't encounter this problem on another server running Solaris 9/Oracle 10.2.0.3, so I'm not sure if Solaris 10 is somehow different.

Anyone else encounter this problem on Solaris 10 and find a resolution?

--
http://www.freelists.org/webpage/oracle-l