How to configure oracle listener profile for multiple oracle database

[former_member236859]

Hi,

I am going to install solution manager system in the same server of ERP EHP4 on Windows. Both DB are oracle.

I'd like to know how to configure listener in this kind of envirnmonent.

a. use two listener and different ports

b. use same listener but different ports

c. use same listener and same port

Which is the correct mothed?

And, after installation, there seem three set of profiles of listten, one for ERP, one for SLM, and the other for OS?(%windir%system32), which one is functional?

Please advise.

Thanks a lot.

Regards,

Alex

[Former Member]

Hi Alex,

I did some installations of multiple SAP in same MSCS cluster henxce i faced issues with listner.

The way to go is two different listner with different ports.

As same listner willcreate havoc if there is an issue with one database listner is down.

Cheers!!!

ElNino

[volker_borowski2]

I like to have a seperate listener with seperate port.

Eases life when it comes to patching, as you are totally seperate.

Volker

[Former Member]

Hi,

standard installation is creating new configs for listener for each instance.

I would recommend to use one listener per each instance.

YOU CAN NOT HAVE one port number for two differnet systems!

If you want to use one listener than you must adapt tnsnames.ora, listener.ora and ensure that both systems will use different port numbers.

For example PORT= 15<system number>

Peter

[Former Member]

Hi,

The good method is to use same listener but different ports. Enter a new port when SAPINST prompt u to enter the listener port (if u have chosen custom installation else u have to revise this value in the summary screen).

Regards,

Varadharajan M