Thanks for the question, Pamela.
Asked: September 15, 2017 - 12:40 pm UTC
Last updated: June 14, 2018 - 1:17 am UTC
Version: 11g
Viewed 50K+ times! This question is
You Asked
IO Error: The Network Adapter could not establish the connection. My laptop is client/server using Windows 10. I added Port 1521 as exception to Firewall, but this did not resolve the problem. I am knowledgeable in DB design/build using SQL Server, but not Oracle SQL Developer. I am also not a configuration expert in Windows 10. Require step-by-step instructions please.
and Connor said...
When you do a connection request in Oracle, we send the request to a host H and port P (as you've seen from the SQL Developer connection screen).
That request is picked up by what we call a "listener", ie, a program running on host H and is listening on port P.
You'll typically see 17002 if we cannot successfully get to the listener. So things to look for:
1) host name resolves correctly
2) network access to the host is ok
3) there is a listener running on the host (check windows services, or at the command line try: lsnrctl status)
3) the listener is configured to run on port P. (eg if you try to connect on port 1521 but the listener is listening on port 1525 then it won't work). You can see this by firing up the Network Config Assistant or just looking in XXX\network\admin\listener.ora, where "XXX" is where your oracle software is installed.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment