Saturday, February 23, 2008

Oracle Audit Vault 10g against 11g source.

When Oracle Audit Vault is being configured to collect audit data from Oracle 11g database, it can throw Java SQL exception originated from ORA-27452 when you add REDO Collector.
In a log file you can find the call of dbms_src_streams_collector.setup_collector(...av_dbname => 'AV.REGRESS.RDBMS.DEV.US.ORACLE.COM' ...)
The default global name of AV Server database (
AV.REGRESS.RDBMS.DEV.US.ORACLE.COM) is longer than 30 characters, this probably causes an error ORA-27452 during adding of REDO Collector.
To work this issue around I had to rename the global name of AV Server DB to something shorter.