Forum Stats

  • 3,873,344 Users
  • 2,266,537 Discussions
  • 7,911,514 Comments

Discussions

TNS-01151: Missing listener name, LISTENERá, in LISTENER.ORA

968361
968361 Member Posts: 85
edited Jul 24, 2014 8:48PM in Multitenant

Hi All,

I am trying to understand how the Listener and TNS files are linked. Basically the I have installed oracle 12C and created 2 pluggable database PDB1 and PDB2 in the container database CDB1.

The Listner.ora file is

# listener.ora Network Configuration File: C:\app\Vinod\product\11.2.0\client_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = C:\app\Vinod\product\11.2.0\client_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Vinod\product\11.2.0\client_1\bin\oraclr12.dll")

    )

    (SID_DESC =

      (SID_NAME = PDB1)

      (ORACLE_HOME = C:\app\Vinod\product\11.2.0\client_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Vinod\product\11.2.0\client_1\bin\oraclr12.dll")

    )

    (SID_DESC =

      (SID_NAME = PDB3)

      (ORACLE_HOME = C:\app\Vinod\product\11.2.0\client_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Vinod\product\11.2.0\client_1\bin\oraclr12.dll")

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = VINRAINA-IN.in.oracle.com)(PORT = 1522))

    )

  )

Also the TNS entry is

# tnsnames.ora Network Configuration File: C:\app\Vinod\product\11.2.0\client_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_CDB1 =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

CDB1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = cdb1)

    )

  )

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl.in.oracle.com)

    )

  )

PDB1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = PDB1)

    )

  )

 

PDB3 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = PDB3)

    )

  ) 

If I issue the command like this

C:\Users\Vinod>lsnrctl start

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 24-JUL-2014 15:50:55

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production

System parameter file is C:\app\Vinod\product\11.2.0\client_1\network\admin\listener.ora

Log messages written to C:\app\Vinod\diag\tnslsnr\VINRAINA-IN\listener\alert\log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VINRAINA-IN.in.oracle.com)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VINRAINA-IN.in.oracle.com)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production

Start Date                24-JUL-2014 15:51:00

Uptime                    0 days 0 hr. 0 min. 8 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   C:\app\Vinod\product\11.2.0\client_1\network\admin\listener.ora

Listener Log File         C:\app\Vinod\diag\tnslsnr\VINRAINA-IN\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VINRAINA-IN.in.oracle.com)(PORT=1522)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "PDB1" has 1 instance(s).

  Instance "PDB1", status UNKNOWN, has 1 handler(s) for this service...

Service "PDB3" has 1 instance(s).

  Instance "PDB3", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

But when I share the TNS entry with other collegue who is using 11g client and try to connect the system It says

NO listner

But while connecting from my system I dont face any error as I am using LOCALHOST in host name and DB is installed in my system

Please advise me the root cause of error. I have very limited knowledge of this part.

Also I  dont know how to format the entries to post in this form

Regards

Answers

  • 968361
    968361 Member Posts: 85

    Also to add

    if I issue

    C:\Users\Vinod>lsnrctl start LISTENER

    LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 24-JUL-2014 15:57:07

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

    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production

    System parameter file is C:\app\Vinod\product\11.2.0\client_1\network\admin\listener.ora

    Log messages written to C:\app\Vinod\diag\tnslsnr\VINRAINA-IN\listenerá\alert\log.xml

    TNS-01151: Missing listener name, LISTENERá, in LISTENER.ORA

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

  • But when I share the TNS entry with other collegue who is using 11g client and try to connect the system It says
     
    NO listner But while connecting from my system I dont face any error as I am using LOCALHOST in host name and DB is installed in my system

    Your TNS entry uses LOCALHOST so your 'collegue' can  NOT use that entry to connect to the DB on your system.

    To connect from remote clients the TNS entry needs to use the IP address of your machine or the hostname. If they use hostname then that hostname needs to be resolved to the IP address.

This discussion has been closed.