9 Replies Latest reply: Nov 23, 2012 12:03 PM by 961125 RSS

    database not getting connected from sql developer(Vendor code 20)

    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. As I was trying to do some modifications in tnsnames.ora and listener.ora, I was unable to save them, as permission is denied.

      Kindly suggest.....

      Regards,
      KK