Adding a REDO collector fails with error ORA-02084 "database name is missing a component"

(Doc ID 1342869.1)

Last updated on OCTOBER 24, 2017

Applies to:

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

Symptoms


Addition of a REDO collector fails with the below errors :

source testdb.jsw.in verified for REDO Log Audit Collector collector
Adding 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 :

11-03-10 17:33:13 [INFO ] Got AV source user connection using
jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname)(P
ORT=1521))(CONNECT_DATA=(SERVICE_NAME=AVTEST)))
11-03-10 17:33:13 [MESG ] setting up APPLY process on Audit Vault server
11-03-10 17:33:13 [INFO ] Executing SQL as [USR@SRC] select global_name from
global_name
11-03-10 17:33:13 [INFO ] Return value = TESTDB.JSW.IN
11-03-10 17:33:13 [INFO ] Executing SQL as [ADM@AV] select to_char(source_id)
from avsys.av$source where source_name = :1
11-03-10 17:33:13 [INFO ] Using bind value testdb
11-03-10 17:33:13 [INFO ] Return value = 6
11-03-10 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;
11-03-10 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

Changes

Incidently this error is typically seen in countries like India and Austria were the TLDs are 'in' and 'at' respectively.

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