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

Question

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

User · Answer

I solved this by writing the explicit IP address defined in the Listener.ora file as the hostname.

So, instead of "localhost", I wrote "192.168.1.2" as the "Hostname" in the SQL Developer field.

In the below picture I highlighted the input boxes that I've modified:

User · Answer

You can locate a file named listener ora under the installation folder oraclexe app oracle product 11 2 0 server network ADMIN It contains the following entries  SID LIST LISTENER      SID LIST        SID DESC          SID NAME   PLSExtProc         ORACLE HOME   C  oraclexe app oracle product 11 2 0 server         PROGRAM   extproc             SID DESC          SID NAME   CLRExtProc         ORACLE HOME   C  oraclexe app oracle product 11 2 0 server         PROGRAM   extproc             LISTENER      DESCRIPTION LIST        DESCRIPTION          ADDRESS    PROTOCOL   IPC  KEY   EXTPROC1          ADDRESS    PROTOCOL   TCP  HOST   Codemaker-PC  PORT   1521              DEFAULT SERVICE LISTENER    XE    You should verify the HOST  Here it is Codemaker-PC  should be the computer name  If it s not correct the change it as computer name   then try the following command on the command prompt run as administrator   lsnrctl start

User · Answer

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

User · Answer

I just had same issue when I installed the oracle 11g and then creating the database   I don t even know that the listener has to create manually  Hence  I open Net Configuration Assistant and manually create the listener   And I can connect the database that I created locally through sql developer

User · Answer

For me  the HOST was set differently in tnsnames ora and listener ora   One was set to the full name of the computer and the other was set to IP address  I synchronized them to the full name of the computer and it worked  Don t forget to restart the oracle services   I still don t understand exactly why this caused problem because I think IP address and computer name are ultimately same in my understanding

User · Answer

only start listner then u can connect with database  command run on editor      lsnrctl start   its work fine

User · Answer

This worked for me  may help some one  Turn off firewall  on RHEL 7  systemctl stop  firewalld

User · Answer

Curiously  I was able to solve the same issue by doing the exact opposite move to svc s   I had to    1  replace the FQDN hostname in my tnsnames ora   listener ora files with localhost  and restart the listener service  and  2  two  I had to use  SYS as SYSDBA  as the username in the SQL Developer input textbox  to finally be able to have SQL Developer hook to my local instance

User · Answer

I faced the same problem  I had to turn off my firewall  then it worked   You could also open the port  http   windows microsoft com en-in windows open-port-windows-firewall 1TC windows-7

User · Answer

I had a similar issue where I also continuously got the same error  I tried many things like changing the listener port number  turning off the firewall etc  Finally I was able to resolve the issue by changing listener ora file  I changed the following line    ADDRESS    PROTOCOL   TCP  HOST   localhost  PORT   1521     to    ADDRESS    PROTOCOL   TCP  HOST   hostname  PORT   1521      I also added an entry in the  etc hosts file    you can use Oracle net manager to change the above line in listener ora file  See Oracle Net Services Administrator s Guide for more information on how to do it using net manager    Also you can use the service name  database name domain name  instead of SID while making the connnection   I Hope it helps

User · Answer

I solved just by  given correct host and port so    Open oracle net manager Local Listener    in Listener on address 2 then copy host to Oracle Developer   finally connect to oracle

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

Examples related to oracle

Examples related to oracle11g

Examples related to database-connection

Examples related to oracle-sqldeveloper