Vendor code 17002 to connect to SQLDeveloper

Question

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

User · Answer

I had the same Problem  I had start my Oracle TNS Listener  then it works normally again   See LISTENER  TNS-12545     No such file or directory

User · Answer

Listed are the steps that could rectify the error    Press Windows R Type services msc and strike Enter Find all services   Starting with ora start these services and wait   When your server specific service is initialized  in my case it was orcl   Now run mysql or whatever you are using and start coding P

User · Answer

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

User · Answer

In 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

[database] Vendor code 17002 to connect to SQLDeveloper

Examples related to database

Examples related to connect

Examples related to oracle-sqldeveloper