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.

4 Comments:

Blogger Hozefa said...

What is the version of AV are you using?

8:14 AM  
Blogger Noby said...

Hi, Mark.
Please send me your email.

I've made a lot of forms for Monopolija, for your shop at Krasnojarsk :)

10:39 AM  
Blogger Shanthi Cabs said...

Keep sharing the post like this...


12:18 AM  
Blogger French language classes in Chennai said...

this blog its very helpful to implement in our work
German Language Classes in Chennai | German Institute in Chennai | German Language Course in Chennai

10:19 PM  

Post a Comment

<< Home