This discussion is archived
0 Replies Latest reply: Feb 29, 2012 6:29 PM by user12100209 RSS

Oracle Streams apply error at database vault realm

user12100209 Newbie
Currently Being Moderated
OS: SLES 11 x86_64 SP1
Oracle version: 11.2.0.3.0

I have configured an streams replication environment with the downstream database as the destination database where the changes are applied. I have both databases, source and downstream, configured with Oracle Database Vault. My problem is the following:
When I create a realm to protect the objects in the schema being replicated at the destination database, the dba_apply_error view give me an ora-01031 insufficient privileges. Once I disable the realm the apply process continues working normally.
The streams administrator user has granted all needed privileges: dv_streams_admin, become user and also has the dba privilege.

The same environment works fine using the same OS and Oracle Version 11.2.0.1.0.
I hope you can help me.
thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points