-
debugging dbstart / dbstop
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.
- Cookies
-
yes, learn shell scripting
-
tell us what you have done - crystal ball broken
-
Been testing on a Linux box with same version 9.2.0.4
What I did:
Code:
- 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.
- Cookies
-
Are you positive the server is executing them at the runlevel you expect?
Jeff Hunter
-
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.
- Cookies
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|