relocatable IP and oracle listener socket

[Former Member]

Hello

We are going to consolidate ~30 SAP system into few HPUX boxs.

~10 SAP systems per single OS is plan to run as standard practice.

Each SAP system will be "encapsulated" as Service Guard PACKAGE.

Every SAP system will have it own "virtual" IP address.

We like to have a different lisenert for every oracle based on the "virtual/relocatable" IP addres.

the question is can we have the same socket number for all oracle (i.e 1527) based on the fact that every oracle listen on it's own "relocatableIP:1527"?

TNX

Erez

[stefan_koehler · Accepted solution]

Hello Erez,

> can we have the same socket number for all oracle (i.e 1527) based on the fact that every oracle listen on it's own "relocatableIP:1527"?

As far as i know .. that is not possible... (but maybe this is different on HP-UX)

I had a look at our AIX box .. which has different adapters and different IPs - the listener configuration looks like:

> (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = <HOST>) (PORT = 1528)

And the port communication looks like:

> tnslsnr 1097742 ora<SID> 11u IPv4 0xf1000200023efb98 0t0 TCP *:1528 (LISTEN)

So as you can see, the listener is running on all adresses "*:1528".

But oracle is providing a solution for such a situation.

You can run one listener on *:1527, which is providing the service for the different instances.

=> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams095.htm#i1128493

=> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams188.htm#i1133481

Regards

Stefan