RE: Auto-start Oracle on reboot problem
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
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
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?Received on Tue Jan 08 2008 - 23:03:56 CST