5 Replies Latest reply: Apr 29, 2014 4:52 AM by 2650954 RSS

    Re: STATUS = UNKNOWN in LSNRCTL STATUS.

    2650954


      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"

        • 1. Re: STATUS = UNKNOWN in LSNRCTL STATUS.
          sb92075

          how can we reproduce what you report?

          • 2. Re: STATUS = UNKNOWN in LSNRCTL STATUS.
            yoonas

            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

            • 3. Re: STATUS = UNKNOWN in LSNRCTL STATUS.
              Hemant K Chitale

              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


              • 4. Re: STATUS = UNKNOWN in LSNRCTL STATUS.
                onkar.nath

                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

                • 5. Re: STATUS = UNKNOWN in LSNRCTL STATUS.
                  2650954

                  Output of tnsping and lsnrctl:

                   

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

                  [oracle@LOM-NEYTR-RHEL-NEW1 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)


                  [oracle@LOM-NEYTR-RHEL-NEW1 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