Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 7.3.4 Startup and Halt scripts

aliasgar
Valued Contributor

Oracle 7.3.4 Startup and Halt scripts

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 .
aliasgar
5 REPLIES
Sridhar Bhaskarla
Honored Contributor

Re: Oracle 7.3.4 Startup and Halt scripts

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



You may be disappointed if you fail, but you are doomed if you don't try
linuxfan
Honored Contributor

Re: Oracle 7.3.4 Startup and Halt scripts

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
They think they know but don't. At least I know I don't know - Socrates
Sanjay_6
Honored Contributor

Re: Oracle 7.3.4 Startup and Halt scripts

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
Honored Contributor

Re: Oracle 7.3.4 Startup and Halt scripts

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.
Take it as it comes.
Sridhar Bhaskarla
Honored Contributor

Re: Oracle 7.3.4 Startup and Halt scripts

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
You may be disappointed if you fail, but you are doomed if you don't try