CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
crocodile2221
crocodile2221

Reputation: 41

How to fix Oracle SQL Developer - vendor code 17002?

I install only Oracle SQL Developer from their page. When i try to create new conntection(user) program show me error like:

An error was encountered performing the requested operation:

IO: The Network Adapter could not establish the connection

Vendor code 17002

I try find file tnsnames.ora and listener.ora they not exist. This is my first use Oracle SQL Developer.

Upvotes: 3

Views: 62937

Answers (3)

Abdul Agfar
Abdul Agfar

Reputation: 69

Vendor code 17002 usually comes when Listener Control is down.

lsnrctl (Listener Control) is an SQL*Net utility used for controlling database listeners. A listener is required for allowing remote (not local) 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

now check the status and try to connect the db. it will work ;)

Upvotes: 3

João Azevedo
João Azevedo

Reputation: 9

You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener.

Check this link for more details: http://www.dba-oracle.com/t_sql_developer_vendor_error_17002.htm

Upvotes: 0

Connor McDonald
Connor McDonald

Reputation: 11616

As others have said, you need a database to connect to. If you're just getting started, then Express Edition is the ideal option. Here's a complete video walkthrough of download and installing it done by the Oracle on Windows team

https://youtu.be/DYleroLay5E

Take note of the host/port/service strings mentioned in the video. Then with SQL Developer, you will use those to connect

Upvotes: 0

Related Questions