Adding a REDO collector fails with error ORA-02084 "database name is missing a component"
(Doc ID 1342869.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Audit Vault - Version 10.2.3.2 and later
Information in this document applies to any platform.
Addition of a REDO collector fails with the below errors :
source testdb.jsw.in verified for REDO Log Audit Collector collector
Collector added successfully.
collector successfully added to Audit Vault
remember the following information for use in avctl
Collector name (collname): redo3
initializing REDO Collector
ERROR: java.sql.SQLException: ORA-02084: database name is missing a component
The trace file reports the below errors :
<DATE> 17:33:13 [INFO ] Got AV source user connection using
<DATE> 17:33:13 [MESG ] setting up APPLY process on Audit Vault server
<DATE> 17:33:13 [INFO ] Executing SQL as [USR@SRC] select global_name from global_name
<DATE> 17:33:13 [INFO ] Return value = testdb.jsw.in
<DATE> 17:33:13 [INFO ] Executing SQL as [ADM@AV] select to_char(source_id) from avsys.av$source where source_name = :1
<DATE> 17:33:13 [INFO ] Using bind value testdb
<DATE> 17:33:13 [INFO ] Return value = 6
<DATE> 17:33:13 [INFO ] Executing SQL as [USR@AV] begin
avsys.dbms_av_streams_collector.setup_collector( sourceid => 6, src_stradm=> 'srcuser', src_dbname => 'TESTDB.JSW.IN'); end;
<DATE> 17:33:14 [ERROR] java.sql.SQLException: ORA-02084: database name is missing a component
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 166
ORA-06512: at "AVSYS.DBMS_AV_STREAMS_COLLECTOR", line 188
ORA-06512: at line 1
Incidently this error is typically seen in countries like India and Austria were the TLDs are 'in' and 'at' respectively.
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