Oracle SQL Developer Failure – Test failed The Network Adapter could not establish the connection | Edureka Community
Please take note that I modified certain facts for security. However, the issue is still present.
I set up an Oracle 11g database on a server @ herp-devDV.derp.edu, for example. My current Oracle 11g database is located on a server at, let’s say, derp-db.derp.edu.
For both herp-devDV.derp.edu and derp-db.derp.edu, I typed the connection name, username, password, hostname, and service name in Oracle SQL Developer. Derp-schema db.derp.edu’s is accessible, but not herp-devDV.derp.edu. This is the message I receive:
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----
Can someone please help me this?