topic Re: Oracle Package failover in Operating System - HP-UX

Oracle Package failover

Walker_3 — Sun, 21 May 2006 05:19:57 GMT

Hi there,

I have an oracle package cluster with 2 node currently running on node1. Oracle is installed in the external storage and running on a virtual IP. I need to failover an oracle package. To move the package I need to halt the package and then to run it on other node. I think the database will stop. Am I right?

Then how can I move the oracle package?

Best rgds,
Walker

Re: Oracle Package failover

Steven E. Protter — Sun, 21 May 2006 05:26:48 GMT

Shalom,

Yes, if everything is configured correctly oracle will stop on one node and start on the second node.

/usr/sbin/cmhaltpkg

Is what you run on the first node.

You should also test loss of power on node 1 and loss of heartbeat on node 1 to make sure everything fails over correctly.

SEP

Re: Oracle Package failover

Ninad_1 — Sun, 21 May 2006 05:31:29 GMT

Yes you are right. You need to halt the package on the 1st node then run the package on the 2nd node and then enable package switching (So that it can failover to node1 - if desired)
On node 1
cmhaltpkg oraclepkg
cmrunpkg -n node2 oraclepkg
cmmodpkg -e oraclepkg

Also you are right that the oracle database needs to be shutdown as part of the package halt script. Apart from this if you are not using the VGs as shared or are not Veritas Cluster filesystems then the VGs will be exported after unmounting the filesystem from node1 as part of package halt script. [ The package halt script should take care of all these things ]
Then as part of package startup on node2 the VGs will be imported and activated and filesystem mounted before starting the oracle database.

If you are using Oracle RAC then I guess your database will still be running even if you stop the package running on node1 - but int that case oracle is already running on node2.

Regards,
Ninad

Re: Oracle Package failover

Walker_3 — Sun, 21 May 2006 06:02:15 GMT

Hi,

What if I do not want to halt package instead of I would like to stop cluster on current node that is containing the package now. In that case package will be automatically switched over to the node that is running cluster and free? Since the auto switch of package is on. Am I correct?

Rgds,
Walker

Re: Oracle Package failover

Darrel Louis — Sun, 21 May 2006 06:29:29 GMT

Walker,

When you do a cmhaltpkg the package will stop and won't switch to the other node.
If you want to start the package on the other node just do asfollow:
cmrunpkg -p -n

Darrel

Re: Oracle Package failover

Walker_3 — Sun, 21 May 2006 07:21:19 GMT

its ok.