Hi everyone,

i have an issue on my server(Windows Server) where i tried to create a new db oracle but i made a mistake creating it on the same port of already existing db.

Now i have two services first one is ON and the second one is of the new db that i disabled. i

When i try to access on the old db SQL developer give me this error :

Vendor code17002- IO:The network adapter could not establish the connection

Can anyone help me or indicate how i can fix it and restore the access on the already existing db?

Thanks

Vendor code 17002 usually comes when Listener Control is down.

Make sure the hostname in tnsnames.ora (usually it’s not “localhost”) and the default hostname in sql developer(usually it’s “localhost”) same.
You can either do this by changing it in the tnsnames.ora, or filling up the same in the sql developer.
So first check the tnsnames.ora file and ensure that it points to the correct server and port.

lsnrctl (Listener Control) is an SQL*Net utility used for controlling database listeners.
The listener is required for allowing remote clients to connect to the Oracle database via the network.

You can validate it by using below command

lsnrctl status

If its down you can use the below command to start it.

lsnrctl start

To fix the “Vendor code 17002 - IO, The network adapter could not establish the connection” error in SQL Developer , Please follow the below steps in order to get desired outcome .

let me if it works !