Oracle Network Adapter could not establish the connection tips
Question:
I am trying to install SQL Developer and when I try to open
the forst screen and connect I get this network adapter error:
java.sql.SQLException: Io
exception: The Network Adapter could not establish the connection.
How do I resolve this
Network Adapter could not establish the connection error?
Answer: Whenever you see
a
Network Adapter could not establish the connection, you have either
the wrong SQL Developer URL or you have a basic SQL*Net
connectivity issue! This error is most likely caused by one of
these factors:
– You are using the wrong URL
– The wrong
port number or IP address (or DNS host name) was used
– The
listener is not configured properly
– The listener process
(service) is not running. You can re-start it with the
“lsnrctl start” command or on Windows by starting the listener
service.
For a step by step checklist, see my notes on
troubleshooting an Oracle connection problem.
Get the Complete
Oracle SQL Tuning Information
The landmark book “Advanced Oracle
SQL Tuning The Definitive Reference” is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it
for 30% off directly from the publisher.