This discussion is archived
3 Replies Latest reply: Apr 3, 2013 6:20 AM by Mihael RSS

tnsping shows no listener why?

879152 Newbie
Currently Being Moderated
Hi,

I have static register listenerdb and it is up.
but when i want to connect from client pc it shows no listener.
why?

LSNRCTL> status listenerdb
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENERDB)))
STATUS of the LISTENER
------------------------
Alias listenerdb
Version TNSLSNR for HPUX: Version 11.2.0.1.0 - Production
Start Date 03-APR-2013 18:19:33
Uptime 0 days 0 hr. 0 min. 43 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u02/app/oracle/diag/tnslsnr/drpdb1/listenerdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENERDB)))
Services Summary...
Service "drpdb.nblitd.com" has 1 instance(s).
Instance "drpdb1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

Please reply.

Thanks
Solaiman
  • 1. Re: tnsping shows no listener why?
    Mihael Pro
    Currently Being Moderated
    876149 wrote:
    Hi,

    I have static register listenerdb and it is up.
    but when i want to connect from client pc it shows no listener.
    why?

    Listener Parameter File /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File /u02/app/oracle/diag/tnslsnr/drpdb1/listenerdb/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENERDB)))
    Services Summary...
    Service "drpdb.nblitd.com" has 1 instance(s).
    Instance "drpdb1", status UNKNOWN, has 1 handler(s) for this service...
    There is no 'PROTOCOL=tcp' Endpoint.
  • 2. Re: tnsping shows no listener why?
    879152 Newbie
    Currently Being Moderated
    Hi,

    because it is in RAC.

    listener.ora file

    # Generated by Oracle configuration tools.

    SID_LIST_LISTENERDB =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME = /u02/app/oracle/product/11.2.0/dbhome_1)
    (SID_NAME = drpdb1)
    (GLOBAL_DBNAME = drpdb.nblitd.com)
    )
    )

    LISTENERDB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENERDB))
    )
    )

    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENERDB = ON


    Thanks
    SOlaiman

    Edited by: 876149 on Apr 3, 2013 5:40 AM
  • 3. Re: tnsping shows no listener why?
    Mihael Pro
    Currently Being Moderated
    >
    because it is in RAC.
    In this case you should connect through scan_listener that listens on tcp.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points