This discussion is archived
2 Replies Latest reply: Nov 21, 2012 6:32 PM by 961125 RSS

Unable to connect db from sql dev

961125 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    yes am running everything on single pc and am getting Unable to establish connection vendor code 20.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points