TNS-12542: TNS:address already in use;TNS-12560: TNS:protocol adapter error;TNS-00512: Address already in use

[Former Member]

Hello,

I am running SWPM with import option ( oracle 10g on Wind2003R2) and I got this error:

An error occurred while processing option SAP NetWeaver 7.0 Support Release 3 > Software Life-Cycle Options > System Copy > Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step: Error return code. DIAGNOSIS: Return code 1 of executable D:\oracle\SID102/bin/lsnrctl indicates an error. SOLUTION: For more information, see log file lsnrctl.log.). You can now:

• Choose Retry
  to repeat the current step.
• Choose Log Files
  to get more information about the error.
• Stop the option and continue later.

Log files are written to C:\Program Files/sapinst_instdir/NW700/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/.

This is LSNRCTL.log

Connecting to (DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 61: Unknown error

I changed the port from 1521 to 1527, but the same error and 1521 and 1527 are not in use.

C:\Documents and Settings\siddm>netstat -na | findstr 1521

C:\Documents and Settings\sidadm>netstat -na | findstr 1527

My listener.ora file looks like this:

# listener.ora Network Configuration File: D:\oracle\SID\102\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = SID)

      (ORACLE_HOME = D:\oracle\QAS\102)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SID_NAME = SID)

      (ORACLE_HOME = D:\oracle\SID\102)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))

    )

    (DESCRIPTION =

      (ADDRESS =

        (PROTOCOL = IPC)

        (KEY = SID.WORLD)

      )

    )

    (DESCRIPTION =

      (ADDRESS =

        (PROTOCOL = IPC)

        (KEY = SID)

      )

    )

    (DESCRIPTION =

      (ADDRESS =

        (COMMUNITY = SAP.WORLD)

        (PROTOCOL = TCP)

        (HOST = hostname)

        (PORT = 1521)

      )

    )

  )

ADMIN_RESTRICTIONS_LISTENER = on

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

ADR_BASE_LISTENER = F:\oracle\SID\saptrace

My OracleListener service path is D:\oracle\SID\102\BIN\TNSLSNR

***************************************************************************************

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 04-JUL-2015 15:39

:40

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is D:\oracle\SID\102\network\admin\listener.ora

Log messages written to D:\oracle\SID\102\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc

)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SID)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SID.WORLDip

c)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SIDipc)))

Error listening on: (DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HO

ST=SID)(PORT=1521)))

TNS-12542: TNS:address already in use

TNS-12560: TNS:protocol adapter error

  TNS-00512: Address already in use

   64-bit Windows Error: 48: Unknown error

Listener failed to start. See the error message(s) above...

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SID)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 61: Unknown error

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=SID)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=srv

SID)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 61: Unknown error

LSNRCTL>

****************************************************************************************

Can it be this wrong? Should I change the service path?

Please suggest me something

thx

Chris

[former_member182657 · Accepted solution]

You could follow SAP Notes 723147 - ORA-12542: TNS: address already in use

& SAP KBA 2152158 - Intermittent Oracle connectivity issue

Hope this will resolve your issue.

Good luck !!

[former_member182657]

Hi Chris,

In resume could you confirm for any modifications under listener.ora file ? Generally issue comes due to duplicate TCP or IPC Key in listener.ora.

If possible try to omit any duplicate entries from listener.ora & start again.

Regards,

[former_member182657]

Hi,

Could you share result for command

netstat -na | findstr 1521

Suggest you to kill the process if already in used state or best would be restart the system & check again.

Regards,

[Former Member]

C:\Documents and Settings\sidadm>netstat -na | findstr 1521

C:\Documents and Settings\sidadm>netstat -na | findstr 1527

Its not in use, does not return anything.

Already re-started all twice.

Can this be because I had another SAP instance before, but I uninstalled it.

Thx for any suggestion you have for me

chris

[former_member182657]

Could you share values for commands

1.ps -ef | grep lsnr
2.Parameter value for ORALE_SID & ORACLE_HOME

Thanks,

[Former Member]

Hello Chris,

IF already not done...try performing these steps

goto services.msc check if any previous relevant TNSlistner services are running.Disable them and continue installation after restarting the server.

Regards

Anand