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.

7 Comments:

Blogger Hozefa said...

What is the version of AV are you using?

8:14 AM  
Blogger Oracle said...

Oracle Certification (Newbie)
http://career-assessments.blogspot.com/2008/01/oracle-certifications-newbies.html

Oracle 11g DBA OCA, OCP, DBA OCM Certification Aspirants
http://career-assessments.blogspot.com/2008/01/oracle-certifications-aspirants.html

9:22 PM  
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 pbsl said...

you have a nice site. thanks for sharing this valuable resources. keep it up. anyway, various kinds of ebooks are available here

http://feboook.blogspot.com

8:01 PM  
Blogger for IT the said...

I have read your blog its very attractive and impressive. I like it your blog.

Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

Java Online Training Java Online Training Core Java 8 Training in Chennai Core java 8 online training JavaEE Training in Chennai Java EE Training in Chennai

8:17 PM  
Blogger for IT the said...

Java Training Institutes Java Training Institutes Java EE Training in Chennai Java EE Training in Chennai Java Spring Hibernate Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai Core Java Training Institutes in Chennai Core Java Training Institutes in Chennai

8:22 PM  
Blogger for IT the said...

Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training

Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Java Online Training Java Online Training Java Online Training Java Online Training

8:22 PM  

Post a Comment

<< Home