Invalid User "java.sql.SQLRecoverableException: IO Error: Socket read timed out" error on eHealth web login.

Document ID : KB000030432
Last Modified Date : 14/02/2018
Show Technical Document Details
Problem:
After new installation of eHealth 6.3.2.07, when we try to open eHealth web page, it comes back with following error:
Invalid User
java.sql.SQLRecoverableException: IO Error: Socket read timed out
 
The oracle sqlnet.log logs following error:
Fatal NI connect error 12545, connecting to:
(LOCAL=NO)
ORA-12545:    Connect failed because target host or object does not exist
Cause:        The address specified is not valid, or the program being connected to does not exist.
Action:        Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.
Run netstat to check whether listener is running or not - port 1521.
 
 
Environment:
eHealth 6.3.2.07 on Windows 2008 64 bit


Cause:
*The ORA-12545 error indicates that some of the information contained in the tnsnames.ora or listener.ora entry is not correct, due to which database connection fails.
 
 
Resolution: 
Restart listener with following commands:
lsnrctl stop LISTENER
lsnrctl start LISTENER
 
If listener restart doesn't help, then edit listener.ora file. Replace host name with the Physical IP address of the eHealth server and restart the listener:
(ADDRESS= (PROTOCOL = TCP) (HOST = <ip_address>)(PORT = 1521))