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 22.214.171.124.0.
I hope you can help me.
thanks in advance.