Connecting to a Database from SQLDeveloper fails with IO Error: The Network Adapter Could Not Establish The Connection

Issue: New Users were trying to access a 3-node RAC Oracle Database system using SQLDeveloper


Below is the connection string provided to user for Oracle Database Connection. RAC Virtual IP is provided to connect to Database.




TESTDB01=
       (DESCRIPTION=
               (ADDRESS=(PROTOCOL=tcp)(HOST=test001-vip1.domain.com)(PORT=1521))
               (ADDRESS=(PROTOCOL=tcp)(HOST=test002-vip1.domain.com)(PORT=1521))
               (ADDRESS=(PROTOCOL=tcp)(HOST=test003-vip1.domain.com)(PORT=1521))
           (CONNECT_DATA=
               (SERVICE_NAME=TESTDB01)
               (INSTANCE_NAME=TESTDB01)
           )
       )




User tried to connect using one of the VIP and got the below error in SQLDeveloper.
Status : Failure -Test failed: IO Error: The Network Adapter Could Not Establish The Connection.


Analysis:


Verified the Oracle Database Services and Listener Services are running fine.
Other Users were able to connect to SQLDeveloper using the same Connection String.


Solution:


User does not have network communication open to port 1521 on Oracle RAC Virtual IP.


ping  test001-vip1.domain.com
ping  test002-vip1.domain.com
ping  test003-vip1.domain.com


telnet test001-vip1.domain.com 1521
telnet test002-vip1.domain.com 1521
telnet test003-vip1.domain.com 1521


Ping to VIP address works fine but Telnet to port 1521 on the VIP address is giving “Connect Failed” Error.


When Network communication is opened on port 1521 on all the Oracle RAC Virtual IP servers/Addresses, User can connect to Oracle Database using SQLDeveloper.

5 thoughts on “Connecting to a Database from SQLDeveloper fails with IO Error: The Network Adapter Could Not Establish The Connection”

  1. Dear Creative Entrepreneur,

    Today marks the final opportunity to access StockDreams – the platform that’s transformed graphic design into a simple, profitable, and enjoyable process.

    ?? Remember, StockDreams is your ticket to:

    Crafting AI-generated visuals that captivate and sell, in mere minutes.

    Opening a floodgate of traffic through eye-catching, SEO-friendly images. It’s time to tap into a gold mine that most are overlooking: Google Image Search powered by AI: https://www.growwealthy.info/stockdream

    Launching a graphic design service that requires zero traditional training.

    Earning from a variety of revenue streams, passive and active, online.

    We’ve watched users go from design novices to in-demand pros, selling their artwork on global marketplaces and securing a steady income stream, all thanks to StockDreams’ intuitive AI-powered platform.

    But now, the window is closing.

    This is your LAST CHANCE to grab StockDreams at the current offer, with full access to all its features – from AI-generated stock images and illustrations to logos, icons, and more, all crafted within a user-friendly editor that’s been a game-changer for so many.

    Don’t let hesitation hold you back from what could be the turning point in your creative and financial path.

    ?? Click here to claim your access before the clock runs out: https://www.growwealthy.info/stockdream

    As the saying goes, ‘opportunity doesn’t knock twice.’ This is your moment, seize it with StockDreams and watch as your design capabilities – and revenue – soar to new heights.

    Wishing you a future brimming with success and creativity.

    Farewell, for now, let’s make these final hours count!

    To your unlimited creative potential,

    John Ford

    P.S.: Miss this, and you’ll miss out on the simplest path to design success and financial growth. Let’s end this chapter on a high note. Join us, and let’s create masterpieces together with StockDreams.

    UNSUBSCRIBE: https://www.growwealthy.info/unsubscribe/?d=appsdbadiaries.com
    Address: 2089 Kelly Drive
    Clarksburg, WV 26301

    Reply

  3. Hi there,

    I’m reaching out because we’ve just released a complete WordPress video training package with unrestricted Private Label Rights. The package includes 19 professional video lessons across 4 courses, covering everything from WordPress basics to local development.

    Key features:

    Full PLR rights (rebrand, resell, repurpose as you wish)
    4 complete courses with 19 video lessons
    Professional production quality
    Ready-to-launch sales materials included

    This is ideal if you’re looking to quickly launch your own WordPress training business or add to your existing product line.

    For detailed information and pricing, visit: https://furtherinfo.info/wpmk

    Kind regards,
    Jorge

    Reply

  4. Looking to enhance your website’s look, feel, and performance? I specialize in custom redesigns—no predefined templates, each page is uniquely designed for a seamless user experience. Plus, we use lightweight coding, avoiding unnecessary code to ensure your site runs fast and efficiently.

    If you’re considering an upgrade, let’s discuss it further! You can reach me at Web.techdevelopment@outlook.com

    Reply

  5. Boost your local presence and stand out with our expert Local SEO and Google My Business services! Elevate your visibility, attract more customers, and dominate your local market.

    Reach out to me today at Brandbuildingassistance@outlook.com and let’s start optimizing your online presence for success!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *