The Network Adaptor could not establish the connection

Posted on 2012-08-19
Medium Priority
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.

H:\>ping abc.def.com

Pinging abc.def.com [xxx.xx.x.xxx] with 32 bytes of data:
Reply from xxx.xx.x.xxx: bytes=32 time=202ms TTL=58
Reply from xxx.xx.x.xxx: bytes=32 time=202ms TTL=58
Reply from xxx.xx.x.xxx: bytes=32 time=202ms TTL=58
Reply from xxx.xx.x.xxx: bytes=32 time=202ms TTL=58

Ping statistics for xxx.xx.x.xxx:
    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

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

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

Accepted Solution

Qlemo earned 2000 total points
ID: 38309270
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

809 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