Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

GeekyOmega

Problem

Please note that I changed details for security purposes. However, the problem remains intact.

I installed an Oracle 11g database on a server at location, say, herp-devDV.derp.edu. Now I have another Oracle 11g database on a server at location, say, derp-db.derp.edu.

I entered the connection name, username, password, hostname, and service name in Oracle SQL developer for both herp-devDV.derp.edu and derp-db.derp.edu. I can connect to schema in derp-db.derp.edu, but not herp-devDV.derp.edu. It gives me this message:

Failure - Test failed: The Network Adapter could not establish the connection

Details

I have the following information:

  • Port 1521 is not open for either server when I telnet
  • My listener is up and running for both.
  • I can access derp-db.derp.edu on Oracle SQL Developer.
  • Oracle client is on my local machine + Oracle SQL Developer
  • I can remote desktop to both servers

What I have done

  • Googled
  • Stackoverflow
  • Ran stop and start lnrctl commands
  • On herp-devDB.derp.edu I ran lsnrctl status

I received the following output

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                03-JUN-2014 13:37:22
Uptime                    6 days 0 hr. 53 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\oracle\diag\tnslsnr\HERP-DEVDB\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HERP-DEVDB.derp.edu)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "HERPDEVDBXDB" has 1 instance(s).
  Instance "herpdevdb", status READY, has 1 handler(s) for this service...
Service "herpdevdb" has 1 instance(s).
  Instance "herpdevdb", status READY, has 1 handler(s) for this service...
The command completed successfully

I then check out my listener.ora and find

  SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = HERP-DEVDB.derp.edu)(PORT = 1521))
    )
  )

At this point, I confess I am scratching my head as I don't see anything sticking out and telling me why this should not be working.

The only clue is when I check derp-db.derp.edu and run the command lsnrctl status. Please see excerpt below:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DERP-DB.edu)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Start Date                18-MAY-2014 02:19:01
Uptime                    22 days 12 hr. 23 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
---etc----

So I am still scratching my head. Why would derp-db be connecting to the DERP-DB.edu but herp-devDB is connecting to EXTPROC1521? How do I fix this? The listener.ora and other files between these two servers are almost identical except for the name of the instances. Hmmm.

  • EDIT1: I changed the listener.ora in herp. This didn't fix it.

  • EDIT2: I cannot telnet into derp-db.derp.edu on port 1521. But I can still connect to it with SQL Developer? Wth?

  • EDIT3 I cannot telnet into herp-devdb.derp.edu on port 1521 either.
  • EDIT4 I cannot ping IP addresses of either server.

Anyway assistance would be greatly appreciated. Thanks

Regards, Geeky

GeekyOmega

I am answering this for the benefit of future community users. There were multiple issues. If you encounter this problem, I suggest you look for the following:

  • Make sure your tnsnames.ora is complete and has the databases you wish to connect to
  • Make sure you can tnsping the server you wish to connect to
  • On the server, make sure it will be open on the port you desire with the specific application you are using.

Once I did these three things, I solved my problem.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

From Dev

test failure:io error: the network adapter could not estailish the connection in sql developer

From Dev

JDBC The Network Adapter could not establish the connection/Connection reset/recv failed

From Dev

IO Error: The Network Adapter could not establish the connection when running oracle DB as docker container

From Dev

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

From Dev

Getting "IO Error: The Network Adapter could not establish the connection" randomly

From Dev

cnc-mon-0024 monitor service paging error: The Network Adapter could not establish the connection

From Dev

Experiencing "IO Error: The Network Adapter could not establish the connection" from Local Machine

From Dev

The driver could not establish a secure connection to SQL Server by using SSL

From Dev

copy from one database to another using oracle sql developer - connection failed

From Dev

copy from one database to another using oracle sql developer - connection failed

From Dev

Cannot make local connection between Oracle SQL Developer and SQl plus

From Dev

Could not establish JDBC connection in Spring MVC

From Dev

Laravel/Lumen: Could not establish Memcached connection

From Dev

Safari could not establish secure connection to my localhost

From Dev

Kafka Brokers for Hyperledger Fabric could not establish a connection

From Dev

JDBC Could not establish SSL connection (Domino Java Agent FP 9) to SQL Server

From Dev

Creating a new database and new connection in Oracle SQL Developer

From Dev

Generate test data using Oracle PL/SQL developer

From Dev

Generate test data using Oracle PL/SQL developer

From Dev

SQL Developer connection issue

From Dev

Connection parameters in SQL Developer

From Dev

SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

From Dev

Failure to establish SSL connection from CLIENT to PROXY with LoadRunner

From Dev

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key"

From Dev

ORACLE SQL Developer (Query)

From Dev

New to Oracle SQL developer

From Dev

Oracle SQL Developer update

From Dev

Oracle SQL Developer(4.0.0.12)

Related Related

  1. 1

    IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

  2. 2

    test failure:io error: the network adapter could not estailish the connection in sql developer

  3. 3

    JDBC The Network Adapter could not establish the connection/Connection reset/recv failed

  4. 4

    IO Error: The Network Adapter could not establish the connection when running oracle DB as docker container

  5. 5

    java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

  6. 6

    Getting "IO Error: The Network Adapter could not establish the connection" randomly

  7. 7

    cnc-mon-0024 monitor service paging error: The Network Adapter could not establish the connection

  8. 8

    Experiencing "IO Error: The Network Adapter could not establish the connection" from Local Machine

  9. 9

    The driver could not establish a secure connection to SQL Server by using SSL

  10. 10

    copy from one database to another using oracle sql developer - connection failed

  11. 11

    copy from one database to another using oracle sql developer - connection failed

  12. 12

    Cannot make local connection between Oracle SQL Developer and SQl plus

  13. 13

    Could not establish JDBC connection in Spring MVC

  14. 14

    Laravel/Lumen: Could not establish Memcached connection

  15. 15

    Safari could not establish secure connection to my localhost

  16. 16

    Kafka Brokers for Hyperledger Fabric could not establish a connection

  17. 17

    JDBC Could not establish SSL connection (Domino Java Agent FP 9) to SQL Server

  18. 18

    Creating a new database and new connection in Oracle SQL Developer

  19. 19

    Generate test data using Oracle PL/SQL developer

  20. 20

    Generate test data using Oracle PL/SQL developer

  21. 21

    SQL Developer connection issue

  22. 22

    Connection parameters in SQL Developer

  23. 23

    SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

  24. 24

    Failure to establish SSL connection from CLIENT to PROXY with LoadRunner

  25. 25

    The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key"

  26. 26

    ORACLE SQL Developer (Query)

  27. 27

    New to Oracle SQL developer

  28. 28

    Oracle SQL Developer update

  29. 29

    Oracle SQL Developer(4.0.0.12)

HotTag

Archive