5 Replies Latest reply: Aug 30, 2005 11:28 AM by vikas bakthula RSS

TNS-12542 : TNS: Adress already in use

Erika Mezmale
Currently Being Moderated

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

  • Re: TNS-12542 : TNS: Adress already in use
    Peter Alphen
    Currently Being Moderated

    Can you post your listener.ora and tnsnames.ora

    • Re: TNS-12542 : TNS: Adress already in use
      Erika Mezmale
      Currently Being Moderated

      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

  • Re: TNS-12542 : TNS: Adress already in use
    vikas bakthula
    Currently Being Moderated

    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

  • Re: TNS-12542 : TNS: Adress already in use
    vikas bakthula
    Currently Being Moderated

    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

  • Re: TNS-12542 : TNS: Adress already in use
    vikas bakthula
    Currently Being Moderated

    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

Actions