tnsping SID : TNS-12541: TNS:no listener

[Former Member]

Hello,

We have upgraded our oracle 9.2.0.8 to 11.2.0.3 (sap 4.72 with KERNEL 640_EXT2)

When we execute : tnsping PR1     (PR1 is our SID)

we have the following error

"

sapprd1:orapr1> tnsping PR1

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production o

n 07-AUG-2012 01:06:24

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:

/oracle/PR1/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL

= TCP)(HOST = sapprd1)(PORT = 1527)) (CONNECT_DATA = (SERVER = DEDICATED) (SERV

ICE_NAME = PR1)))

TNS-12541: TNS:no listener

"

tnsping sapprd1 : it's ok

cat listener.ora

=================================

LISTENER_PR1 =

  (ADDRESS_LIST =

        (ADDRESS=

          (PROTOCOL=IPC)

          (KEY= PR1.WORLD)

        )

        (ADDRESS=

          (PROTOCOL=IPC)

          (KEY= PR1)

        )

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = sapprd1)

          (PORT = 1527)

        )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SDU = 32768)

      (SID_NAME = PR1)

      (ORACLE_HOME = /oracle/PR1/112_64)

    )

  )

  )

ADR_BASE_LISTENER_PR1 = /oracle/PR1/saptrace

cat tnsnames.ora

===============================================

PR1.WORLD =

  (DESCRIPTION =

    (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapprd1)(PORT = 15

27))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = PR1)

    )

  )

LISTENER_PR1.WORLD =

  (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapprd1)(PORT = 1527

))

thank you for your help

[Former Member · Accepted solution]

Hi Adil.

Ora-12541: listener Could not be started.

it can be due the wrong entries in listener.ora or tnsnames.ora files.

1) Correct Host name, protocol or port(1521 to 1527) in the above files and start the listener .

2)Check the listener when it is started or not 

>lsnrctl start

Regards

Tunga.Bhasker.

[Former Member · Accepted solution]

Hello

I can now execute tnsping with success. I simply do "lsnrtl start LISTENER_PR1"

Thanks for your help

[former_member197466]

Hi Adil,

Please check sap note  609332 - Composite note: ORA-12541/ORA-12224 for the possible reason.

Ensure that the Oracle net configuration files under $ORACLE_HOME\NETWORK\ADMIN and $TNS_ADMIN are same.

Cheers,

Ivy

[former_member189725]

I suggest you upgrade the SAP kernel to NW 640_EX2

Refer this SAP note Note 1106096 - EX2 Kernels: Extended Kernel Maintenance

                             Note 1058988 - 640_EX2 Kernels

Also refer this SAP note Note 819829 - Oracle Instant Client Installation and Configuration on Unix

to move to using Oracle 11.2.0.x instant client.

Once done , change the LIBPATH of <sid>adm pointing to new instant client.

Then start the listener.  Then do a tnsping test.

Regards

Ratnajit