The Network Adaptor could not establish the connection

Posted on 2012-08-19
Last Modified: 2012-08-19
I am trying to connect using oracle sql developer providing username/password, hostname, and service name.

However, i get the following error:

The Network Adaptor could not establish the connection

The hostname is valid since i can ping successfully

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.


Pinging [] with 32 bytes of data:
Reply from bytes=32 time=202ms TTL=58
Reply from bytes=32 time=202ms TTL=58
Reply from bytes=32 time=202ms TTL=58
Reply from bytes=32 time=202ms TTL=58

Ping statistics for
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 202ms, Maximum = 202ms, Average = 202ms

Cannot do tnsping since i don't want to use tnsnames.ora file to make connections. I can configure sql developer to directly connect to the database without using tnsnames.ora
Question by:gram77
    LVL 25

    Expert Comment

    Is the Oracle database's service name configured in your tnsnames.ora?

    btw. which Oracle client are you using - full or instant?
    LVL 67

    Accepted Solution

    You can use tnsping with EazyConnect, too:
        tnsping Server:Port/Instance
    will check if you can connect to the instance. :Port is optional if using the default port of 1521.

    The error shown by SQL Developer is the same as ORA-12541 "TNS no listener", so the port might be different from the default 1521, or the listener not running on the server machine.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now