AVDF_Audit Trail Is In Unreachable Status because of an UNUSABLE index [(sub)partition]

(Doc ID 1939869.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.2.0 to 12.1.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When checking the audit trails using AVCLI you notice one of the audit trails is in status 'unreachable' as follows:

 

AVCLI> LIST TRAIL FOR SECURED TARGET ORCL;
-----------------------------------------------------------------------------------------------------------
| AUDIT_TRAIL_TYPE | HOST     | LOCATION                   | STATUS      | REQUEST_STATUS | ERROR_MESSAGE |
===========================================================================================================
| TABLE            | hostname | SYS.AUD$                   | UNREACHABLE |                |               |
-----------------------------------------------------------------------------------------------------------

 

Upon searching on log files below error messages have been seen.

[2014-09-19T10:03:54.511+07:00] [collfwk] [ERROR] [] [] [tid: 0] [ecid: 10.9.9.4:57607:1411095835004:0,0] OAV-8020: Error fetching data from serverCollectionController : run : Exception from process(). [[
Error fetching data from server
at oracle.av.platform.agent.collfwk.impl.filter.recovery.HoldNoneRecoveryFilter.filter(HoldNoneRecoveryFilter.java:434)
at oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.applyBulkFilters(ArrayBasedBatch.java:142)
at oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.flush(ArrayBasedBatch.java:171)
at oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.sendRecord(ArrayBasedBatch.java:116)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.process(CollectionController.java:543)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:350)
at java.lang.Thread.run(Thread.java:735)
Nested Exception:
java.sql.SQLException: ORA-12801: error signaled in parallel query server P024
ORA-01502: index 'AVSYS.MARKER_IDX' or partition of such index is in unusable state

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)

  

 

Changes

 N/A

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