backup script on Hp-ux

[RICARDO VILLAS BOAS]

Hi there,
I??m glad if you solve the backup script problems that I have on my environment. I??ve attached the backup script and its log. I don??t know why it is connecting 3 times to shutdown the databases and 2 times to startup them. Also the oracle 8.1.6 instance is started with other process owner (ora817) than the right one (ora816).

[Tom Danzig]

If you read the dbshut script, you can see that it parses /etc/oratab and loops to shut down each instance listed (it does in mine anyway).

Since you call it 3 times, each time as a different user, it will run the shutdown on each DB listed 3 times. This script is meant to run during boot up and should probably not be used to do scheduled DB shutdowns.

Header from script:
###################################
#
# usage: dbshut
#
# This script is used to shutdown ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################

I feel it's best to write your own for each DB and call as the appropriate user ID via su. My $ 0.02 anyway.