ServiceGuard Oracle Scripts

[George Doller]

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

[Sridhar Bhaskarla]

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

[Steven E. Protter]

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

[George Doller]

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

[Simon Hargrave · Accepted solution]

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

[George Doller]

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

[ROLAHER]

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