Hello,
Database : Oracle Enterprise Edition 11.2.0.4 - Single Instance
During upgrade of our application, we run few dbc script file. We observed that Oracle connection is getting closed at some point due to which script execution terminated in between. We would like to know the possible reasons that may cause connection to be closed. Our Updatedb log says :
Closed Connection
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3404)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3438)
at psdi.dbmanage.connection.DatabaseConnection.commit(Unknown Source)
at psdi.dbmanage.statement.Script.runStatement(Unknown Source)
at psdi.dbmanage.statement.Script.run(Unknown Source)
at psdi.dbmanage.ScriptRun.run(Unknown Source)
at psdi.dbmanage.Utility.runDbcScriptLastGoodLine(Unknown Source)
at psdi.tools.UpdateDB.runDbcScript(Unknown Source)
at psdi.tools.UpdateDB.runDbcFileInfo(Unknown Source)
at psdi.tools.UpdateDB.runScripts(Unknown Source)
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)
at psdi.tools.UpdateDB.main(Unknown Source)
rollback
;
-- BEGINUPDATEDBERROR
-- Product: IBM TPAE Integration Framework
-- Error running file: V7510_14
-- UPDATEDBFILE:V7510_14.dbc
-- Script: Error
rollback
;
psdi.util.MXSystemException: dbchange#ScriptFailure
at psdi.dbmanage.ScriptRun.run(Unknown Source)
at psdi.dbmanage.Utility.runDbcScriptLastGoodLine(Unknown Source)
at psdi.tools.UpdateDB.runDbcScript(Unknown Source)
at psdi.tools.UpdateDB.runDbcFileInfo(Unknown Source)
at psdi.tools.UpdateDB.runScripts(Unknown Source)
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)
at psdi.tools.UpdateDB.main(Unknown Source)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3404)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3438)
at psdi.dbmanage.connection.DatabaseConnection.commit(Unknown Source)
at psdi.dbmanage.statement.Script.runStatement(Unknown Source)
at psdi.dbmanage.statement.Script.run(Unknown Source)
... 9 more
java.lang.Exception: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS IN UPDATE LOG FILE -Updatedb20151022173009.log
dbchange#ScriptFailure
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.startProcess(Unknown Source)
at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)
at psdi.tools.UpdateDB.main(Unknown Source)
We couldn't find anything important in alert.log and listener.log. Oracle connection issues are generally logged in which log file and where to find that?