2 Replies Latest reply on Nov 22, 2012 2:32 AM by 961125

    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