AVDF Audit Trail Fails With Error ORA-25153

(Doc ID 2354728.1)

Last updated on FEBRUARY 04, 2018

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.2.9 and later
Information in this document applies to any platform.

Symptoms

Audit trail is failed and ORA-25153 is logged into AV Agent log into a target environment:

[2018-01-15T23:00:22.621+09:00] [collector] [ERROR] [] [.....] [tid: 1606283]
[ecid: 172.17.124.1:89859:1516024822622:606,0] Coll12cAuditDataSource : connectToSecuredTarget : Error in SecuredTarget connection[[
java.sql.SQLException: ORA-12801: error signaled in parallel query server PPA3, instance apxdcs0001.kcdomain.kcnet.co.jp:core1psf1 (1)
ORA-25153: Temporary Tablespace is Empty

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.executeMaybeDescribe(OracleStatement.java:1199)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
at com.sun.proxy.$Proxy19.executeQuery(Unknown Source)
at oracle.av.platform.agent.collfwk.ezcollector.table.TableAuditDataSource.executeRetrievalQuery(TableAuditDataSource.java:952)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditDataSource.connectToSecuredTarget(Coll12cAuditDataSource.java:763)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditCollector.initializeCollector(Coll12cAuditCollector.java:207)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.initialize(CollectionController.java:316)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.process(CollectionController.java:402)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:350)
at java.lang.Thread.run(Thread.java:745)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms