debugging dbstart / dbstop

[Cookies]

Oracle 9.2.0.4 on SunOS sunprod1 5.8
Generic_108528-23 sun4u sparc SUNW,Ultra-80

What would be the most appropriate way to debug dbstart and dbstop?
I read the docs, edited the appropriate files on the server, but the database does not startup on reboot.

Perhaps there is a better tutorial link out there than I have found.

[pando]

yes, learn shell scripting

[davey23uk]

tell us what you have done - crystal ball broken

[Cookies]

Been testing on a Linux box with same version 9.2.0.4

What I did:

-	Changed /etc/oratab file to: DEV1:/opt/ora9/product/9.2:Y
-	Create file /etc/init.d/dbora
#!/bin/sh
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/opt/ora9/product/9.2
ORA_OWNER=oracle

if [! -f $ORA_HOME/bin/dbstart]
Configuration Tasks to Perform as the root User
then
	echo "Oracle startup: cannot start"
	exit
fi

case "$1" in
	’start’)


		# Start the Oracle databases:
		# The following command assumes that the oracle login
		# will not prompt the user for any values

	su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
	;;

	’stop’)
		# Stop the Oracle databases:
		# The following command assumes that the oracle login
		# will not prompt the user for any values

	su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
	;;
esac

- chmod 755 dbora
- ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
- ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora

[Cookies]

I got the dbstart and dbshut scripts to work on their own,
but I still am having problems getting the server to run them
on reboot.

[marist89]

Are you positive the server is executing them at the runlevel you expect?

[Cookies]

Originally posted by marist89
Are you positive the server is executing them at the runlevel you expect?

I wasn't positive about that so I added the run-script to every runlevel and it worked. Yay for me!

Also, before that, I realized that oracle F-ed up with their
stupid scripts which I had to edit to account for spfiles and
a few other configurations.

The end result was that I got it working.