RE: Auto-start Oracle on reboot problem

  • From: <krish.hariharan@xxxxxxxxxxxx>
  • To: <mrothouse@xxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 8 Jan 2008 22:03:56 -0700

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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? 

Other related posts: