avoid reconnection of oracle client after failover

[Bal Biyo]

Is there a way to avoid reconnection of oracle client after failover?

[Rita C Workman]

Write a little something to check which node the package is on....if it's not on the node you want then don't start pkg.
I am going to presume the Oracle client is a pkg to itself, so you might just disable the pkg with a cmmodpkg -d. So it never fails over, until your re-enable it.

...or are you asking for something more?

[James R. Ferguson]

Hi:

You might consider NOT starting the Oracle Listener process on the node on which you do not want connections to occur after a failover. You should be able to alter your /etc/cmcluster//control.sh to do this. You may need to resort to referencing the hostname conditionally to start or not start the Listener.

...JRF...

[John Palmer]

Unfortunately not. All TCP connections will be lost when your package fails over.

Regards,
John