After new installation of eHealth 6.3.2.07, when we try to open eHealth web page, it comes back with following error:
java.sql.SQLRecoverableException: IO Error: Socket read timed out
The oracle sqlnet.log logs following error:
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.
eHealth 6.3.2.07 on Windows 2008 64 bit
*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.
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))