ORA-00600 and "Failed to setAutoCommit to true for pool connection" on Target When Trying to Mirror Site Config (Doc ID 2055411.1)

Last updated on APRIL 05, 2024

Applies to:

Symptoms

When trying to mirror the site configuration, the following exception is thrown on the target:

2015-08-27 12:19:11,481 EST] [ERROR] [Thread-953] [fatwire.logging.cs.db] Exception getting database connection
java.sql.SQLException: Cannot obtain connection: driverURL = jdbc:weblogic:pool:csDataSource, props = {EmulateTwoPhaseCommit=false, connectionPoolID=csDataSource, jdbcTxDataSource=true, Log
gingLastResource=false, dataSourceName=csDataSource}.
Nested Exception: java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection.
  at weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:53)
  at weblogic.jdbc.pool.Driver.allocateConnection(Driver.java:221)
  at weblogic.jdbc.pool.Driver.connect(Driver.java:145)
  at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)
  at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:533)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
  at com.fatwire.cs.core.db.DataSourceBackedPool.acquire(DataSourceBackedPool.java:47)
  at COM.FutureTense.Servlet.JDBCTable.get_trans(JDBCTable.java:698)
  at COM.FutureTense.Servlet.JDBCTable.get(JDBCTable.java:611)
  at COM.FutureTense.Servlet.JDBCTable.(JDBCTable.java:288)
  at COM.FutureTense.Servlet.JDBCConn.GetTable(JDBCConn.java:1346)
  at COM.FutureTense.Common.ftDBTable.getconn(ftDBTable.java:3913)
  at COM.FutureTense.Common.ftDBTable.grab(ftDBTable.java:992)
  at COM.FutureTense.CatalogManager.CatalogEngine.newTable(CatalogEngine.java:418)
  at COM.FutureTense.CatalogManager.CatalogEngine.newTable(CatalogEngine.java:230)
  at COM.FutureTense.CatalogManager.CatalogEngine.executeStatement(CatalogEngine.java:5046)
  at COM.FutureTense.Common.CS.SQL(CS.java:1164)
  at com.fatwire.queue.PersistentAssetQueueRegistry.getQueues(PersistentAssetQueueRegistry.java:344)
  at com.fatwire.search.util.AssetQueueIndexSourceUtil._processAll(AssetQueueIndexSourceUtil.java:81)
  at com.fatwire.search.util.AssetQueueIndexSourceUtil.access$000(AssetQueueIndexSourceUtil.java:35)
...

This exception is preceded by an ORA-00600 error:

[2015-08-27 11:20:39,610 EST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO tt1440499163655 (QRYNAME,URL,DEFTABLE) VALUES (?,?,?)
QRYNAME = OpenMarket/Xcelerate/AssetType/<assettype>/SelectSummary
URL = OpenMarket/Xcelerate/AssetType/<assettype>/SelectSummary.sql
DEFTABLE = <assettype>,AssetPublication
java.sql.SQLException: ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound], [203269], [], [], [], [], [], [], [], [], [], []

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
    at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
...

Changes

Sites target server is running on Oracle RAC database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.