Forum Stats

  • 3,875,405 Users
  • 2,266,911 Discussions
  • 7,912,196 Comments

Discussions

IO Error : The Network Adapter could not establish the connection in SQL Developer

4291012
4291012 Member Posts: 1
edited Sep 10, 2020 12:16PM in SQL Developer

I am on SQL Developer ver. 20.2.0.175.1842 and I keep getting this error. I have already searched for solutions.

  • Tried changing from Basic to TNS mode, nothing shows up in the network alias list.
  • Tried disabling firewall, no help.
  • Tried to find those 5 services in the using run --> services.msc , those services do not show up.

Please help me with a solution, I was using jdk 14 but it used to keep saying this version is not supported properly,

so I also installed jdk 11, but to no resort.

88aeb6bf-63c7-4fc9-9567-5a6229de630e

Answers

  • Jim Smith
    Jim Smith Member Posts: 2,891 Silver Trophy
    edited Jul 20, 2020 2:47AM

    In the basic connection type, you need to provide a host, a port (default 1528), and either a database sid or service.

    In the TNS connection type you need to have set up a TNSNAMES.ORA, which I suspect you haven't done.

    The TNSNAMES.ORA requires the same host,port,sid information as the basic connection, so start with the steps below.

    You don't give much information, and I don't understand your reference to 5 services. If your database is running on Windows, the database service will be OracleService<SID>, and the listener service will be something like OracleOraHomeNNListener

    This error usually means that one of host, port, sid/service is wrong, or there is a network issue.

    What is the hostname or IP address of the server where the database is running?

    Can you ping that hostname or IP address from your workstation?

    If you can't ping the hostname, you may have a DNS issue.

    If you can't ping the IP address, you either have it wrong, or there is a firewall in the way.

    What port is the listener using?

    This defaults to 1528.

    Can you telnet to  the host/IP on that port, or does a port scan show that port as open?

    telnet mydbhost 1528

    If you can't, there may be a firewall in the way, or the listener may not be running.

    If all the above are OK, check the SID  or SERVICE.

    If you are using SID, then make sure the name is correct, including the correct case.

    If you are using SERVICE,  check that the listener is showing the service.

    On the database host, run

    lsnrctl status

    If that isn't enough to fix it, come back here with the results of those tests.

    88aeb6bf-63c7-4fc9-9567-5a6229de630e
  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited Jul 20, 2020 1:00PM

    Another, very likely, possibility:  you do not have an Oracle database installed.  Here is a blog with some good advice on how to move forward:

    https://www.thatjeffsmith.com/archive/2012/12/i-have-oracle-sql-developer-installed-now-what/

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Jul 20, 2020 1:08PM

    Just to expand on Glen Conway's comment ...

    Please realize that SQL Dev is just a client application.  It is not the database, and it does not come with a database.  This is actually a rather common mistake, that people assume that by installing SQL Dev they somehow magically have a database as well.

  • 88aeb6bf-63c7-4fc9-9567-5a6229de630e
    edited Sep 10, 2020 9:32AM

    I have the same problem. I am taking the course, installed the OracleXE184_Win64 database on a laptop (windows 10 pro) and created a connection in Version: 20.2.0.175.1842 according to the course instructions. In the teacher's video, the connection went through without errors. What to do?

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Sep 10, 2020 10:02AM
    88aeb6bf-63c7-4fc9-9567-5a6229de630e wrote:I have the same problem. I am taking the course, installed the OracleXE184_Win64 database on a laptop (windows 10 pro) and created a connection in Version: 20.2.0.175.1842 according to the course instructions. In the teacher's video, the connection went through without errors. What to do?

    The first thing to do is not hijack someone else's two-month-old thread. Open your own thread so that we can address your specific details without confusing with the earlier material addressed to someone else.

    The second thing to do, since you found this thread, would be to check through the item's in Jim Smith's reply.

  • 88aeb6bf-63c7-4fc9-9567-5a6229de630e
    edited Sep 10, 2020 11:45AM

    There are some critical recommendations in your answer, but they do not solve my problem. The problem of 2 months ago is of exactly the same nature and has not been resolved. So I joined her. Jim Smith's advice is not specific to local database installation as I understand it. I'm a beginner, I could be wrong. But, in any case, I don't understand, I asked for a more detailed solution.

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Sep 10, 2020 12:03PM
    88aeb6bf-63c7-4fc9-9567-5a6229de630e wrote:There are some critical recommendations in your answer, but they do not solve my problem. The problem of 2 months ago is of exactly the same nature and has not been resolved. So I joined her. Jim Smith's advice is not specific to local database installation as I understand it. I'm a beginner, I could be wrong. But, in any case, I don't understand, I asked for a more detailed solution.

    Jim Smiths comments are exactly applicable.  If you are using a connection type of BASIC or TNS (the others are rarely used) then the connection is using network protocols and routing irrespective of the location of the database.

    88aeb6bf-63c7-4fc9-9567-5a6229de630e
  • 88aeb6bf-63c7-4fc9-9567-5a6229de630e
    edited Sep 10, 2020 12:16PM

    Thank you, you were right. I found it difficult to understand these technical guidelines. I tried at random to change the connection type from basic to TNS. And everything worked out!

  • User_YD04L
    User_YD04L Member Posts: 1 Green Ribbon
    edited Nov 16, 2022 3:18PM

    to solve the problem in windows follow following step

    1.first install oracle software and sqldeveloper saperately and have same versions.

    type about your pc in search bar

    1. find device name
    2. then go into homes folder which created in user name folder .local disk c>app>james>product>21c>homes>oradb21home1>network>admin>listner file
    3. change host name to device name and save it.
    4. come into sqldeveloper app and while creating the new connection ,change localhost name to device name.
    5. app will work