Tuesday, March 27, 2012

Io exception: The Network Adapter could not establish the connection


 

For some days DB Console worked well, but after restart DB I get the error in browser:


Io exception: The Network Adapter could not establish the connection

and a connect string was shown in bowser:


(description=(address_list=(address=(host=ed01-scan.fors.ru)(protocol=tcp)(port=1521))(address=(host=ed01-scan.fors.ru)(protocol=tcp)(port=1521))(load_balance=yes))(connect_data=(service_name=bi.fors.ru)))

 The connect test showed good connectivity:
[oracle@ed01db02 dbs]$ sqlplus system/oracle@'(description=(address_list=(address=(host=ed01-scan.fors.ru)(protocol=tcp)(port=1521))(address=(host=ed01-scan.fors.ru)(protocol=tcp)(port=1521))(load_balance=yes))(connect_data=(service_name=bi.fors.ru)))'

SQL> select host_name from v$instance;

HOST_NAME
------------------
ed01db02.fors.ru


Metalink gave the advice:
- check if there is firewall
- check the host name and port number
- check the host, port in the target.xml
- check if the sysman, dbsnmp is locked


But in my case the solution was very simple: server reboot.

After server reboot DB Console works well again !

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...