Forum Stats

  • 3,733,857 Users
  • 2,246,830 Discussions
  • 7,856,898 Comments

Discussions

SQL Developer Connection to Oracle XE 18c

User_EYE0A
User_EYE0A Member Posts: 2 Green Ribbon

The SQL Developer shows the following error message after testing the connection to the Oracel XE 18c database.

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=oN8etyzVSyCgYUJpNd+efA==)

parameter:

  • user: sys with correct password
  • hostname, port and SID is aligned with tnsnames.ora and listener.ora
  • Listener is started: LSNRCTL start

Any idea why this IO Error comes up?

Thanks

Answers

  • User_EYE0A
    User_EYE0A Member Posts: 2 Green Ribbon

    lsnrctl status shows:

    LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 11-JUN-2021 18:43:39

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

    TNS-12535: TNS:operation timed out

    TNS-12560: TNS:protocol adapter error

    TNS-00505: Operation timed out

    64-bit Windows Error: 60: Unknown error

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

    STATUS of the LISTENER

    ------------------------

    Alias           LISTENER

    Version          TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production

    Start Date        11-JUN-2021 17:57:27

    Uptime          0 days 0 hr. 46 min. 37 sec

    Trace Level        off

    Security         ON: Local OS Authentication

    SNMP           OFF

    Default Service      XE

    Listener Parameter File  E:\app\name\product\18.0.0\dbhomeXE\network\admin\listener.ora

    Listener Log File     E:\app\name\product\18.0.0\diag\tnslsnr\MAE412QQYV\listener\alert\log.xml

    Listening Endpoints Summary...

     (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

     (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

    Services Summary...

    Service "CLRExtProc" has 1 instance(s).

     Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

    The command completed successfully

Sign In or Register to comment.