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

Document created by Darshan_Desai Employee on Apr 17, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

---DESCRIPTION---

Following errors are seen when trying to log onto eHealth web, after fresh install of 6.3.2.07


Invalid User

java.sql.SQLRecoverableException: IO Error: Socket read timed out


---DIAGNOSIS---

The oracle sqlnet.log should log the following:

 

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.


---Solution---

*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))

Attachments

    Outcomes