Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TNS-12541: TNS:no listener

Hello,

I am installing a SAP ERP EHP4 on Linux PPC + Oracle 10.2 platform but I am having trouble. I installed the Oracle 10.2 and applied the pacth 10.2.0.4.

At the beginning of "Import ABAP" phase (Testing database connection) is going the error:

sqlnet.log:

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

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=hades)(PORT=1527))(CONNECT_DATA=(SID=ED0)(GLOBAL_NAME=ED0.WORLD)(CID=(PROGRAM=R3load)(HOST=hades)(USER=ed0adm))))

  VERSION INFORMATION:

  TNS for Linux: Version 10.2.0.2.0 - Production

  TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.2.0 - Production

  Time: 02-JUL-2015 00:30:08

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12541

    TNS-12541: TNS:no listener

    ns secondary err code: 12560

    nt main err code: 511

    TNS-00511: No listener

    nt secondary err code: 111

    nt OS err code: 0

R3load.exe.log:

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

Follow que R3trans command error:

hades: ed0adm 65> R3trans -d

This is R3trans version 14.6 (release 701 - 01/26/09 - 12:46:00).

unicode enabled version

2EETW169 to connect possible, "DBMS = ORACLE --- dbs_ora_tnsname = 'ed0'"

R3trans finished (0012).

hades: ed0adm 65>

The listener is not starting, it just does nothing when given the command:

hades: oraed0 42> lsnrctl start

hades: oraed0 43>

I checked the tnsnames.ora and the listener.ora files and found no problem.

Ther is no listener.log file created on the log directory.

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

# Filename......: tnsnames.ora

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

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $

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

ED0.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = hades)

          (PORT = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = ED0)

       (GLOBAL_NAME = ED0.WORLD)

    )

  )

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

# Filename......: listener.ora

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

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#1 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

  (ADDRESS_LIST =

        (ADDRESS =

          (PROTOCOL = IPC)

          (KEY = ED0.WORLD)

        )

        (ADDRESS=

          (PROTOCOL = IPC)

          (KEY = ED0)

        )

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = hades)

          (PORT = 1527)

        )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = ED0)

      (ORACLE_HOME = /oracle/ED0/102_64)

    )

  )

Someone know what's going on?

Thanks

Former Member
Former Member replied

Hello guys,

Problem solved!

See the sapnote http://service.sap.com/sap/support/notes/1404424.

Open for edit the file $ORACLE_HOME/network/lib/env_network.mk and identify the following line:

TNSLSNR_LINKLINE+=$(SYSLIBS)

Add above the line TNSLSNR_LINKLINE+=$(SYSLIBS) the following entry:

LLIBCRYPT = -lcrypt

Modify the entry TNSLSNR_LINKLINE+=$(SYSLIBS) as below

from

TNSLSNR_LINKLINE+=$(SYSLIBS)

to

TNSLSNR_LINKLINE+=$(SYSLIBS) $(LLIBCRYPT)

Relink again oracle:

$ cd $ORACLE_HOME/bin

$ ./relink all

Thank you for all!

Regards.

Fábio Belli

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question