2 Replies Latest reply: Nov 21, 2012 8:32 PM by 961125 RSS

    Unable to connect db from sql dev

    961125
      Am getting the following error while connecting db from sql dev

      "network adapter could not establish connection vendor code 20"

      FYI - database is up and running fine in sqlplus, and am not able to find the service in lnsrctl. As am using OIM db as service name while its showing CLRExtProc.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
      ction
      Start Date 21-NOV-2012 20:28:48
      Uptime 0 days 0 hr. 27 min. 32 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File d:\app\Karan\product\11.2.0\dbhome_1\network\admin\li
      tener.ora
      Listener Log File d:\app\karan\diag\tnslsnr\Karan-PC\listener\alert\log
      xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
      The command completed successfully
      Also contents of tnsnames.ora and listener.ora are shown below
      # listener.ora Network Configuration File: d:\app\Karan\product\11.2.0\dbhome_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = d:\app\Karan\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:d:\app\Karan\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
      )

      ADR_BASE_LISTENER = d:\app\Karan

      ---------------------------------------------tnsnames.ora-----------------------------------------------------
      # tnsnames.ora Network Configuration File: d:\app\Karan\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      OIMDB =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OIMDB)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )
      FYI - yesterday all database was running fine.

      Kindly suggest.....

      Regards,
      KK
        • 1. Re: Unable to connect db from sql dev
          orafad
          First, your issue is unrelated to ODBC. There is a forum dedicated to SQL Developer.

          What message do you see when trying to connect with sqlplus using the same (unknown) connection details you used in Sql Developer?

          Are you running everything on a single pc?


          What do you get from entering following commands:
          c:\> sqlplus / as sysdba
          
          SQL> startup
          Edited by: orafad on Nov 22, 2012 12:44 AM

          Edited by: orafad on Nov 22, 2012 12:45 AM
          • 2. Re: Unable to connect db from sql dev
            961125
            yes am running everything on single pc and am getting Unable to establish connection vendor code 20.