How to diagnosis the problem on Solaris 10 for DB startup

UNIX for Advanced & Expert Users
1

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.

2

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

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

Review the logs and see if that highlights anything.

Cheers,
ZB

3

zazzybob:

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