Listener Start problem

[former_member184114]

Hi All,

I have installed 2 different SAP instances on a single machine. After installing these, when I tried to start both of them, they were not coming up. I noticed that the listeners were not started. I started one of the listeners (lets say for SAP system ABC) and then system came up. However, when I tried to start another listener(lets say for SAP system XZY), it started and then stopped. I am using windows operating system.

Then I stopped SAP system ABC and shutdown the listener for its database. Then I started listener for database of SAP system XYZ and then this SAP system came up successfully. After that I tried to start the listener for the dabatase of SAP system ABC, this time, this listener started and stopped and consequently, ABC system did not come up.

Conclusion is that, at any given time, only one listener is allowed to run. As a result of this, the other SAP system in unable to talk to its datbase.

I have also learnt that we can use one listener for multiple database. Can any one help me in configuring it rightly and start both SAP systems simultaneously?

Would be waiting for your kind replies.

Regards,

Faisal

[Former Member · Accepted solution]

SIngle listener can listen for multiple databses as well

your listener.ora can look like

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ABC)

(ORACLE_HOME = /oracle/ABC/112_64) - This is your oracle_home

)

(SID_DESC =

(SID_NAME = XYZ)

(ORACLE_HOME = /oracle/XYZ/112_64) - This can be same as above as well

)

)

and your tnsnames.ora can look like

ABC=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <DBHOSTNAME>)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = ABC)

(GLOBAL_NAME = ABC.WORLD)

)

)

XYZ=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <DBHOSTNAME>)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = XYZ)

(GLOBAL_NAME = XYZ.WORLD)

)

)

regards,

MJ

[Former Member]

Hello Faisal,

Can you post the LISTENER.ORA files of your two Listeners here? I am pretty confident that will immediately reveal the problem, which is either a naming conflict or - more probably - a port number conflict.

Regards,

Mark

[Former Member]

Hi Faisal,

Stop all the listeners.

Have the listener names changed for two different servers.

Say for ABC the listener name can be LISTENER_ABC

Change the configuration manually in tnsnames.ora and listener.ora at both of the following locations.

/sapmnt/<SID>/profile/oracle

and

/oracle/<SID>/102*/network/admin

Also, ensure both listeners use different port numbers.

And then, try to start both the listeners.

Br,

Venky

[Former Member]

In cases like this the most probable reason will be:

Both listeners are configured to use the same tcp port.

Look at your installation guide for correct configuration.

regards