Oracle 7.3.4 Startup and Halt scripts

[aliasgar]

Hi All,
Can anybody provide me the m/c service guard 11.X startup and halt scripts of oracle.
I have 2 nodes configured under m/c service guard running oracle 7.3.4 version and the hpux version is 11.x .how can i configure package script to startup and shut down oracle database .

[Sridhar Bhaskarla]

This may not run straight. YOu may have to modify it if it doesn't. This simply starts and halts oracle database and is very primitive. It will be more complicated if you want to monitor the services and it would be better to buy oracle toolkit. It doesn't cost a lot.

This is your oracle.sh script

case $1 in

'start')
su oracle -c ${ORACLE_HOME}/bin/sqldba lmode=y <connect internal
startup pfile=${PFILE}
exit
EOF

if [$? ! = 0 ]
then
echo "Oracle startup failed"
else
su oracle -c "${ORACLE_HOME}/bin/lsnrctl start your_sql_net_name
if [[ $? != 0 ]]
then
print "Listener start failed."
fi
fi

;;

'halt')

su oracle -c ${ORACLE_HOME}/bin/svrmgrl <connect internal
shutdown immediate
EOF
su oracle -c "${ORACLE_HOME}/bin/lsnrctl stop"

;;

esac

[linuxfan]

Hi,


If you are running Oracle in a MC-SG package, HP has a product called Enterprise Cluster Master Toolkit(which includes templates for different kinds of databases including Oracle).

Look for more information at
http://docs.hp.com/hpux/pdf/B5139=90019.pdf or
http://docs.hp.com/hpux/onlinedocs/B5139-90019/B5139-90019.html

-HTH
Ramesh

[Sanjay_6]

Hi,

Try installing HP Product No. B5139DA - Enterprise Cluster Master Toolkit. It has templates for most of the RDBMS. The shell script for Oracle will be under /opt/cmcluster/toolkit/oracle and the filename is ORACLE.sh . There is a README with this file. You just have to modify the variables in ORACLE.sh and you can use it for the startup and shutdown of oracle database. Also you can use the same script to monitor Oracle processes.

Hope this helps.

[Deshpande Prashant]

HI
Attached is our startup/shutdown script for package, form the toolkit, as mentioned by Sanjay & Ramesh.
It's slightly modified to keep file systems mounted even you shutdown oracle manually (with maint. flag)
Thanks.
Prashant.

[Sridhar Bhaskarla]

I am afraid we shouldn't use the script without having purchased the oracle toolkit.
There are some HP guys around here ;-)
So, either you can write your own script or purchange oracle toolkit.

-Sri