I'm trying to connect to a database using SQLDeveloper and I get the following error:
An Error was Encountered performing The requested operation:
IO Error: Conection reset
Vendor code 17002.
Could you please help me?
This question is related to
database
connect
oracle-sqldeveloper
Listed are the steps that could rectify the error:
services.msc and strike Enterora start these services and wait!!orcl) mysql or whatever you are using and start coding.PIn your case the "Vendor code 17002" is the equivalent of the ORA-12541 error: It's most likely that your listener is down, or has an improper port or service name. From the docs:
ORA-12541: TNS no listener
Cause: Listener for the source repository has not been started.
Action: Start the Listener on the machine where the source repository resides.
I had the same Problem. I had start my Oracle TNS Listener, then it works normally again.
I encountered same problem with ORACLE 11G express on Windows. After a long time waiting I got the same error message.
My solution is to 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.
Oh, of course you need to reboot all the oracle services (just to be safe).
Hope it helps.
I came across the similar problem again on another machine, but this time above solution doesn't work. After some trying, I found restarting all the oracle related services can fix the problem. Originally when the installation is done, connection can be made. Somehow after several reboot of computer, there is problem. I change all the oracle services with start time as auto. And once I could not connect, I restart them all over again (the core service should be restarted at last order), and works fine.
Some article says it might be due to the MTS problem. Microsoft's problem. Maybe!
Source: Stackoverflow.com