Forum Stats

  • 3,838,112 Users
  • 2,262,333 Discussions
  • 7,900,511 Comments

Discussions

Re: STATUS = UNKNOWN in LSNRCTL STATUS.

2650954
2650954 Member Posts: 37
edited Apr 29, 2014 5:51AM in General Database Discussions


I use oracle client and ODBC but still find no luck.

while testing  connection via oracle wire protocol

it gives error like :[ oracle wire protocol driver]

" Connection refused . Verify hostname or port number. "

[ODBC oracle wire protocol driver] [oracle]

"ORA-12203: unable to connect destination"

Answers

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond

    how can we reproduce what you report?

  • yoonas
    yoonas Member Posts: 2,237 Gold Trophy

    Hi,

    Explain how you are trying to connect

    Heard of this SQLDEVELOPER, try and find how easy it is to connect

    Oracle SQL Developer</title><meta name="Title" content="Oracle SQL Developer"><meta n…

    Regards

    Yoonas

  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,759 Blue Diamond

    The error messages are quite explicit and also easy to understand.

    You need to figure out if

    a. You have the network configured correctly

    b. You have the connect-string configured correctly

    Hemant K Chitale


    Hemant K Chitale
  • onkar.nath
    onkar.nath Member Posts: 733 Silver Badge

    are you able to tnsping your tns string ? (it will be in your tnanames.ora file). If no then you have problem with connection settings, correct that.

    Also what is the output of lsnrctl status command?

    Onkar

  • 2650954
    2650954 Member Posts: 37
    edited Apr 29, 2014 5:52AM

    Output of tnsping and lsnrctl:

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

    [[email protected] dbhome_1]$ tnsping ACDM

    TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-APR-2014 15:06:00

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

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = LOM-NEYTR-RHEL-NEW1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ACDM)))
    OK (0 msec)


    [[email protected] dbhome_1]$ lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-APR-2014 15:16:15

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date                26-APR-2014 14:48:51
    Uptime                    3 days 0 hr. 27 min. 24 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File         /home/oracle/app/oracle/product/11.2.0/diag/tnslsnr/LOM-NEYTR-RHEL-NEW1/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LOM-NEYTR-RHEL-NEW1)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LOM-NEYTR-RHEL-NEW1)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
    Services Summary...
    Service "ACDM" has 2 instance(s).
      Instance "ACDM", status UNKNOWN, has 1 handler(s) for this service...
      Instance "ACDM", status READY, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

This discussion has been closed.