topic Re: ServiceGuard Oracle Scripts in Operating System - HP-UX

ServiceGuard Oracle Scripts

George Doller — Thu, 14 Oct 2004 09:12:42 GMT

I just upgraded my Oracle from 8.1.7 to 9.2. My ServiceGuard Scripts were written for version 8.1.7. Does anyone have a script for Oracle 9.2 to start, stop and monitor that they'd like to share. This way I won't have to reinvent the wheel.
Thank you

Re: ServiceGuard Oracle Scripts

Sridhar Bhaskarla — Thu, 14 Oct 2004 09:16:59 GMT

Hi George,

oracle serviceguard script comes with oracle toolkit that is not free. So, I am not sure if anyone can (should) provide you with the script.

I have been having the same script for the last four years. I simply modify the script to change the parameters (like ORACLE_HOME, svrmgrl or sqlplus) etc., depending on the version.

It's not hard to do.

-Sri

Re: ServiceGuard Oracle Scripts

Steven E. Protter — Thu, 14 Oct 2004 09:17:38 GMT

Your best bet might be to adapt your current monitor scripts.

The database is different, but the basic processes that must be monitored are very similar.

Some stuff:
http://www.fujitsu.com/downloads/SYSWLK/pdf/ora_f.pdf

http://www.google.com/search?hl=en&lr=&q=oracle+9.2+ServiceGuard+monitor+script&btnG=Search

SEP

Re: ServiceGuard Oracle Scripts

George Doller — Thu, 14 Oct 2004 09:38:24 GMT

I really meant it more for the startup and shutdown. I don't see why that would come from Oracle? I know I could rewrite the scripts but I thought someone would be able to provide it.
Thanks

Re: ServiceGuard Oracle Scripts

Simon Hargrave — Thu, 14 Oct 2004 10:14:49 GMT

Your current script likely do something like: -

svrmgrl <connect internal
shutdown immediate
EOF

svrmgrl <connect internal
startup
EOF

Replace these with something like: -

sqlplus /nolog <connect / as sysdba
shutdown immediate
EOF

sqlplus /nolog <connect / as sysdba
startup
EOF

svrmgrl was still supported in 8.x, but the sqlplus method was encouraged. svrmgrl is now removed in 9.x

Re: ServiceGuard Oracle Scripts

George Doller — Thu, 14 Oct 2004 10:22:11 GMT

I'll give that a try thanks....

Re: ServiceGuard Oracle Scripts

ROLAHER — Fri, 15 Oct 2004 03:10:59 GMT

You can use
#stop database
sqlplus "/ as sysdba"
shutdown immediate
exit

#start database
sqlplus "/ as sysdba"
startup
exit

Or
#stop database in 0 seconds
sqlplus "/ as sysdba"
shutdown abort
exit

#start database with automatic recovery
#and no problem of consistency
sqlplus "/ as sysdba"
startup
exit

Rodrigo