Menu
I had made connection to the remote oracle database through sqldeveloper on my system. Suddenly the power went down and I had to restart the system. Now, when I am trying to connect to the remote oracle database, it's throwing an error message:
The Network adapter could not establish the connection. Vendor code 20
Can anyone help me solving this problem.
292
Restart it with the "lsnrctl start" command or on a Windows OS by starting the listener service. Ensure the correct hostname is specified in listner. ora. Add the hostname and IP address in the hosts file located under C:\Windows\System32\drivers\etc folder.
Go go to a command prompt and use sqlplus to connect 'as sysdba'. Then alter the password for the user in question.
This error usually means that one of host, port, sid/service is wrong, or there is a network issue. What is the hostname or IP address of the server where the database is running?
First check the tnsnames. ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener.
https://forums.oracle.com/forums/thread.jspa?threadID=2150962
Re: SQL DevErr:The Network Adapter could not establish the connection VenCode20 Posted: Dec 7, 2011 3:23 AM in response to: MehulDoshi Reply
This worked for me:
Open the "New/Select Database Connection" dialogue and try changing the connection type setting from "Basic" to "TNS" and then selecting the network alias (for me: "ORCL").
119
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
