Oracle Cluster

[simon_164]

I am willing to build an Oracle cluster but I do not have the oracle tool kit. Is the simple listener start and listener stop is enough to build it. I will supply these commands in the package control script.

Any advice? Any document?

[IT_2007 · Accepted solution]

Simon,

It depends on the ServiceGuard package design how you want to control it. You can supply a script which brings up listener and as well as Database. In case of failure, it can notify to you via e-mail or pager for troubleshooting. Are you planning to implement ORACALE RAC?

Thanks,
Srini

[spex]

Hi Simon,

See this thread:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=919612

PCS

[A. Clay Stephenson]

All a listener start and stop command will do is start and stop the listener; that does nothing about the Oracle instance itself. One can certainly build an Oracle package under MC/SG without the toolkit. You need to make some very fundamental decisions. Do the Oracle binaries move with the package or are they statically installed? Do you dedicate a listener for each instance or have listeners listen for multiple instances? There are no right or wrong answers to these questions but the answers to these questions radically change how you setup the packages.

My preference is to move the Oracle binaries with the data and to dedicate a listener per package --- but that's just me.
You also need to give some serious thought to your monitor scripts. For example, if an instance should fail do you immediately failover to another node or do you try to restart Oracle on the same node?

[simon_164]

NO Oracle RAC. Just an oracle database and a sap instance on a different package on a different node. the scripts will be to start the listener only. start the listener and then the sap instance.