TNS-12542 : TNS: Adress already in use

[Former Member]

We have 2 SAP System on one SUN Solaris Server. The Listener of the first system EC1 uses the port 1521 , the listener of the second system SO1 user the port 1522 - according to configurations files tnsnames.ora and listener.ora. The problem is that listener of SO1 can't be started and I receive the follow Error-Message Listener ( lsnrctl start) :

______________________________________________________

"System parameter file is /oracle/SO1/network/admin/listener.ora

Error listening on : <Adress=<Protokol+tcp><Port=1521>>

TNS-12542 : TNS: Adress already in use

TNS-12560 :TNS: protocol adapter error

TNS-00512: Adress already in use

Solaris Error : 125: Adress already in use

_____________________________________________________

From this error message is clearly that Listener of SO1 uses the port of EC1 1521. Where else could be listener ports configurated ? Why the Listener of second system use the port 1521.

On this server runs only one Listener on port 1521 for EC1.

Thank You!

_________________

Erika

SAP Basis Consultant

[Former Member]

Hi Erika,

This post is w.r.t my previous post,as I said,configure another listner.ora file.

I have just found out another SAP Note,whci will solve your issue.

The Note # : 153835 in service.sap.com/notes

This should solve your issue.

If this helped,please do not forget to award me points.

Rgs

vikas

[Former Member]

Hi Erika,

Did you check with NETSTAT?

Your listner and tnsnames .ora files look ok.

The problem is the SO1 listner is by default looking for port 1521.

Try configuring new listner.ora file from the Oracle network assistant again.

This time give anothe rport.

Reply back.

Rgs

vikas

[Former Member]

Hi Samanta,

This should help you:

Check whether you are already executing another listener that listens to the same port:

ps -ef | grep lsnr

Ensure that you are only executing one listener or that the current listeners do not use the same port numbers.

If the error cannot be explained with concurrent listeners, the port may be locked by another process. You can determine the ports that are being used with operating system tools such as NETSTAT, and you should ensure that the listener.ora and tnsnames.ora configuration files do not contain any ports that are used by other processes

If helpful,do not forget to award points !!

Rgs

vikas

[Former Member]

Can you post your listener.ora and tnsnames.ora

[Former Member]

Hi,

this is my listener.ora for SO1:

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER1 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = SO1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = SO1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sbsfierp)

(PORT = 1522)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sbsfierp)

(PORT = 1528)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = SO1)

(ORACLE_HOME = /oracle/SO1/920_64)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = SO1)

(ORACLE_HOME = /oracle/SO1/920_64)

)

)

SID_LIST_LISTENER1 =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = SO1)

(ORACLE_HOME = /oracle/SO1/920_64)

)

)

ADMIN_RESTRICTIONS_LISTENER1 = on

STARTUP_WAIT_TIME_LISTENER1 = 0

CONNECT_TIMEOUT_LISTENER1 = 10

TRACE_LEVEL_LISTENER1 = OFF

________________________________________________________

And this is my tnsnames.ora for SO1:

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

SO1.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sbsfierp)

(PORT = 1528)

)

)

(CONNECT_DATA =

(SID = SO1)

(GLOBAL_NAME = SO1.WORLD)

)

)

Thank You!

Erika