How to start audit trail for character set customized target database

(Doc ID 2317900.1)

Last updated on OCTOBER 26, 2017

Applies to:

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

Symptoms

When starting Audit Trail in AVS, "Could not Initialize NLS Language handle" is caused and Audit Trail cannot be started.

(av.oracle.coll.file)
:
Oct 28,2016 16:13:48 PM logError
SEVERE: zaodr.c : zaodrinis : Could not Initialize NLS Language handle
Oct 28,2016 16:13:48 PM logError
SEVERE: zaodr.c : zaodropds : Error in Source initialization for source "DB_ORCL"
Oct 28,2016 16:13:48 PM logError
SEVERE: zaodr.c : zaodropds : Failed to start trail while opening source "DB_ORCL"!
Oct 28,2016 16:13:48 PM logError
SEVERE: zaodr.c : zaodropds : could not start collector 24 for source DB_ORCL, internal error: [zaodropds], Error code[48]
Oct 28,2016 16:13:48 PM logError
SEVERE: zaodr.c : zaodropds : Error during Cleanup of file list
Oct 28,2016 16:13:48 PM logError
SEVERE: zaoag.c : zaoagInitCollector : Could not open data source "DB_ORCL"
Oct 28,2016 16:13:49 PM logError
SEVERE: zadcoll.c : zadcolldeamon : Collecting thread died with status 1
Oct 28,2016 16:15:24 PM logError
SEVERE: zadcoll.c : zadcollpproc : Error to call to collection process: 23

:
[collfwk] [ERROR] [] [] [tid: 23] [ecid: 1890551951:64635:1478242436377:0,0] Unexpected error occurred in thread Collector for Source DB_ORCL trail 1[[
java.lang.NullPointerException
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:4141)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:300)
at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:1460)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditDataSource.getVersion(Coll12cAuditDataSource.java:194)
at oracle.av.plugin.orcldb.agent.collector12c.Coll12cAuditCollectionFactory.createAuditCollection(Coll12cAuditCollectionFactory.java:85)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.initialize(CollectionController.java:396)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.process(CollectionController.java:530)
at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:480)
at java.lang.Thread.run(Thread.java:745)

 

Changes

This issue is caused when a database character set on a target database is customized.

SQL> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
PARAMETER
-------------------------------
VALUE                           CON_ID
------------------------------- ----------
NLS_CHARACTERSET
JA16EUCAAA                      0

(JA16EUCAAA is an example of user-defined customized characterset)

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