KB Article #178453

PassPort fails to start with java.sql.SQLRecoverableException: IO Error: Connection reset

Problem

PassPort failed to start with error

2017-02-10 13:07:39,565 - [PassPort_Startup] DEBUG (FileRegistry.getFile:111) - Found registered file: datastoreconfig.xml
2017-02-10 13:08:39,630 - [PassPort_Startup] ERROR (UpgradeExecuter.executeUpgrades:69) - Error in executing upgrade class: class com.axway.passport.upgrade.am.postupgrade.ComponentUrlsUpdate
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:428)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)

Error in ORACLE ORA-3136: Inbound Connection Timed Out


Resolution

Have the Oracle DBA check the alert log for more details on the source of the problem. It may be due to network latency, in which case you will need to have your network admin check for any possible problems there. (If the network speed between Passport and the database can't be improved, it may be necessary to raise Oracle's SQLNET.INBOUND_CONNECT_TIMEOUT value.)


Alternatively, the connection timeout may be due to heavy load on the DB server. (Here, too, raising the timeout value may be used as a workaround.)


Restarting the complete Oracle database - not just the TNS listener - may allow Passport to start successfully, but won't address the underlying cause of the issue.


See http://www.orahow.com/2015/03/ora-3136-inbound-connection-timed-out.html for useful troubleshooting tips on this error.