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 !
