RE: Auto-start Oracle on reboot problem
Date: Fri, 11 Jan 2008 13:58:15 -0500
FYI, Oracle's standard is to install oraenv and dbhome into /usr/local/bin by default. When the ORACLE_HOME is installed, that's one of the things the root.sh does. (It actually prompts you for the location, w/ a default of /usr/local/bin.) If you default the location to /usr/local/bin, but it isn't in your path when the startup scripts are being run, that's going to be a problem.
Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_il.proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Rothouse
Sent: Friday, January 11, 2008 1:47 PM
To: Pedro Espinoza
Subject: Re: Auto-start Oracle on reboot problem
Just sending a final e-mail on the resolution to my Oracle auto-start on reboot problem. I actually copied dbhome to /usr/bin and that resolved the problem. I think some of the other suggestions may have worked as well and I will try them on a test server when I more time.
Thanks again to all who responded. And special thanks to Pedro for providing the location of the Solaris 10 log files containing the results of the server reboot.
On Jan 9, 2008 2:36 PM, Mike Rothouse < mrothouse_at_gmail.com<mailto:mrothouse_at_gmail.com>> wrote: Thanks Pedro. Was able to find the error in /var/svc/log/milestone-multi-user: default.log. Now to figure out why dbhome is not found during reboot. Perhaps because dbhome is not found in /usr/bin. Will begin investigation.
Executing legacy init script "/etc/rc2.d/S99oracle".
Oracle Startup/Shutdown Begins
/etc/rc2.d/S99oracle: dbhome: not found
ORACLE_HOME =  ? /etc/rc2.d/S99oracle: test: argument expected Legacy init script "/etc/rc2.d/S99oracle" exited with return code 1.
On Jan 9, 2008 1:32 PM, Pedro Espinoza <raindoctor_at_gmail.com<mailto:raindoctor_at_gmail.com>> wrote: Given it is solaris 10, the whole rc scripts are legacy services, which in turn are controlled by svc.startd. Definitely, there should be logs in /var/svc/log/*.
You should get something like the following:
milestone-multi-user-server:default.log:Executing legacy init script
milestone-multi-user-server:default.log:Legacy init script "/etc/rc3.d/S911oracle" exited with return code 0.
http://www.freelists.org/webpage/oracle-l Received on Fri Jan 11 2008 - 12:58:15 CST