Following errors are seen when trying to log onto eHealth web, after fresh install of 6.3.2.07
java.sql.SQLRecoverableException: IO Error: Socket read timed out
The oracle sqlnet.log should log the following:
Fatal NI connect error 12545, connecting to:
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.
*The ORA-12545 error indicates that some of the information contained in the tnsnames.ora or listener.ora entry is not correct.
Try to restart listener with following commands:
lsnrctl stop LISTENER
lsnrctl start LISTENER
If listener restart doesn't help please edit listener.ora file. Replace host name with the real ip address of the eHealth server and restart the listener:
(ADDRESS= (PROTOCOL = TCP) (HOST = <ip_address>)(PORT = 1521))