Oracle Script template for Cluster

[Geetha_1]

Could somebody point me in the right direction -

I need a template for Startup, Shutdown and Monitor Script for ORACLE for putting an Oracle 9.2 database in MC/ServiceGuard. I have a template for 8i db but this doesn't seem to work for 9i. I don't know how the previous admin got the 7/8i template.

I am running MC/ServiceGuard v.A.11.12.

Thanks.
Geetha.

[Kent Ostby]

You can get the oracle toolkit information from here:

http://docs.hp.com/en/ha.html

[Julio Yamawaki]

Hi,

This template for Oracle 8i can be changed for using with Oracle 9i.
Simply change the command svrmgrl by sqlplus /nolog and connect internal by connect / as sysdba.
All the other commands are basically the same.

[Geetha_1]

Kent - Thx for the info.

Julio,
I am going to try this out. Will keep you posted. Do you have a sample script please?
Thanks.
Geetha.

[Julio Yamawaki · Accepted solution]

Hi,

I will show you two pieces:
1. First, the shutdown function:
function shutdown_cmds
{

su oracle -c ${ORACLE_HOME}/bin/sqlplus /nolog <connect / as sysdba
shutdown immediate
EOF

2. Second, the startup function:
su oracle -c ${ORACLE_HOME}/bin/sqlplus /nolog <connect / as sysdba
startup pfile=${PFILE}
exit
EOF

In my case, oracle is the user for Oracle, please change for your own name, if it is differente from oracle.

[Geetha_1]

Julio,
Thanks.
Geetha.