2 Replies Latest reply: May 16, 2013 3:46 AM by Eugen-Oracle RSS

    The Network Adapter could not establish the connection

    Eugen-Oracle
      Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

      I am trying to add a new connection in Oracle SQL Developer, a new database just created.

      Connection Name: **
      username: **
      password: **

      HostName: localhost
      port: 1521
      SID: CLRExtProc


      C:\...\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl status

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 16-MAY-2013 08:13
      :32

      Copyright (c) 1991, 2010, Oracle. All rights reserved.

      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 - Produ
      ction
      Start Date 15-MAY-2013 21:15:46
      Uptime 0 days 10 hr. 57 min. 48 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File C:\app\ebusu\product\11.2.0\dbhome_1\network\admin\lis
      tener.ora
      Listener Log File c:\app\ebusu\diag\tnslsnr\ebusu-ro\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 1 handler(s) for this service...
      Service "orcl.ro.oracle.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      Service "orclXDB.ro.oracle.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      The command completed successfully



      listener.ora:

      # listener.ora Network Configuration File: C:\app\ebusu\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 = C:\app\ebusu\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ebusu\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 = C:\app\ebusu


      tnsnames.ora:

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

      LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.ro.oracle.com)
      )
      )


      Any idea what could be the cause?

      Thank you

      Edited by: user635184 on May 15, 2013 10:40 PM