Skip to Content
avatar image
Former Member

TNS-12542 : TNS: Adress already in use

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 29, 2005 at 02:32 PM

    Can you post your listener.ora and tnsnames.ora

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 30, 2005 at 04:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 30, 2005 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 30, 2005 at 09:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded