How to diagnosis the problem on Solaris 10 for DB startup - UNIX for Advanced & Expert Users

duke0001 · #1 (**permalink**) 09-06-2007

I run Oracle 10g on Solaris 10 Sparc machine. I created a dbora file to automatically start Oracle database when UNIX system reboot. I created this dbora file under /etc/init.d, Then link it to /etc/rc0.d/K10dbora and /etc/rc2.d/S99dbora. When I reboot solaris 10 system to test this script. It seems not working.

Then I used 'svcs -a' and see S99dbora legacy service did run at /etc/rc2_d. However, the database was not started up. I have checked scripts carefully. It was coding correctly. The same scripts and the same procedures have been implemented on other UNIX servers with oracle 10g DB. They are all working fine. Question is: how can I diagnosis where the problem is? How to find why the script was running and DB was not started up.Please advise me your thoughts and methods. Thanks a lot.

zazzybob · #2 (**permalink**) 09-09-2007

Add something like this to the top of your Oracle start script

Code:

set -x
exec 1>/tmp/stdout.log
exec 2>/tmp/stderr.log
...

Review the logs and see if that highlights anything.

Cheers,
ZB

duke0001 · #3 (**permalink**) 09-10-2007

zazzybob:

Thanks so much. I will test it and come back to report the progress.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
X server startup on Solaris 9	purveshkhatri	SUN Solaris	6	09-05-2007 11:33 PM
[Help] startup script on solaris 8	bucci	Shell Programming and Scripting	0	11-05-2006 09:38 PM
Solaris Startup script for Apache.	Zak	Shell Programming and Scripting	3	07-26-2006 08:15 AM
Application can't startup?? Solaris and Linux RedHat	TRUEST	UNIX for Advanced & Expert Users	1	02-25-2003 02:02 PM
problem with the startup	Mr.Rudiment	UNIX for Dummies Questions & Answers	4	11-14-2001 09:51 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode