My Oracle Support Banner

How to start audit trail for character set customized target database (Doc ID 2317900.1)

Last updated on MARCH 14, 2019

Applies to:

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

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

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

:
[collfwk] [ERROR] [] [] [tid: 23] [ecid: 18****1:6****5:**********6377:0,0] Unexpected error occurred in thread Collector for Source <DB_NAME> 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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