I have a developer who is able to connect to Oracle database using SQL*Plus from command line.
But the person is not able to connect by using SQL*Developer.
The error is as follows :
"IO Error: The network adapter could not establish the connection"
7
-
1That means you use the wrong host / port / whatever in SQL Developer. Using tnsnames? Or simple connection?– LennieyJan 15, 2018 at 16:46
-
I am using simple connection.– oradbanjJan 15, 2018 at 16:49
-
Compare the SQL connection string to the one entered in SQL Developer, or edit them into your question.– LennieyJan 15, 2018 at 16:52
-
On Command prompt, I am using SQLPLUS U/P@server, where server name is IP address. In SQL*Develoer, I am using Basic connection, and I am specifying relevant entries in Username, Password, Hostname (IP address), Port and Service_Name– oradbanjJan 15, 2018 at 17:15
-
This seems to be something specific to SQL*Developer. I tried using a different client tool and am able to connect.– oradbanjJan 15, 2018 at 17:21
|
Show 2 more comments
2 Answers
Here are some of the things I did to resolve the problem.
- Download latest version of SQL*Developer ( I downloaded 17.4.0 )
- Go to Tools -> Preferences -> Database -> Advanced
- At the bottom of the screen look for "Oracle Client" and "Use OCI/Thick driver"
- Press "Configure" and set Oracle client to ORACLE_HOME
- Press "Browse" and set TNSNAMES.ORA directory
That resolved the problem.
First in SQL Plus, reset the SYS password by: ALTER USER SYS IDENTIFIED BY oracle ACCOUNT UNLOCK;
In the SQL Developer In the connection box, enter user name as "SYS as SYSDBA" and the password "oracle" from step 1.
This works.
