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.