topic Oracle with Service Guard in Operating System - HP-UX

Oracle with Service Guard

Rpger Tavener — Fri, 29 Jun 2001 09:39:14 GMT

We have a 2 node Service Guard Cluster. We want to run one Oracle package, pkgA on Server A, and the other package, PkgB on Server B. with the ability to fail over either package to either server. What's the best way to configure the listener and tnsnames for Oracle?

Thanks for your input !!

Re: Oracle with Service Guard

John Palmer — Fri, 29 Jun 2001 10:02:38 GMT

What I do is to have a separate listener for each package which is bound to the package IP address. Package A startup starts database A and listener A etc.

Tnsnames justs references the relevant package IP address and SID.

Both tnsnames.ora and listener.ora are identical on both servers. I keep them in /etc. You do have to remember to keep them the same on both servers though.

Let me know if you need any more info...

Regards,
John

Re: Oracle with Service Guard

Magdi KAMAL — Fri, 29 Jun 2001 14:51:23 GMT

Hi,

As john said, you need to do the following :

1. Configer your cluster to run both nodes A and B.
2. Configer pkgA so that it will have primary node as node A and Alternate node as node B.
3. Configer pkgB so that it will have primary node as node B and Alternate node as node A.
4. Configer within pkgA listener LISTENER_A accessing oracle db1 on package pkgA.
5. Configer within pkgB listener LISTENER_B accessing oracle db2 on package pkgB.

This will allow you to have db1 running and clients could access it on node A ( respectively node B if node A comes down ).
And will allow you also to have db2 running and clients could access it on node B ( respectively node A if node B comes down ).

Re: Oracle with Service Guard

Magdi KAMAL — Fri, 29 Jun 2001 14:55:01 GMT

Hi again,

each package will be responsible to run one listener ( pkgA(LISTENER_A) and pkgB(LISTENER_B) ).

the file tnsnames.ora MUST be identical on both nodes A and B.

Re: Oracle with Service Guard

Rpger Tavener — Fri, 29 Jun 2001 19:17:18 GMT

Thanks everyone for your quick response!
I appreciate your help...