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 !

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...