ORA-16397 trying to use Active Data Guard DML Redirection in a pluggable database

Andy Haack

Hi

I'm trying to use Active Data Guard DML Redirection.

I set up a standby database which works in READ ONLY WITH APPLY mode.

I use the following doc as a guideline:

Active Data Guard DML Redirection 19c (Doc ID 2465016.1)

It works fine for me in the Standby CDB. E.g: sqlplus [email protected] as sysdba

But when I connect to the Standby PDB and try to perform an insert or create a gtt, I recieve the following error:

ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed

The similar error is displayed in the generated trace file

ORA-16397: primary database could not be reached

Please let me know if any additional configuration is required to use this feature in the standby pluggable databases?

Thank you

LaserSoft

Hi Andy,

Please check the below URL regarding enabling parameter "ADG_REDIRECT_DML" for Active Redirect DML for PDB level.

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/ADG_REDIRECT_DML.html#GUID-AC98F026-33BE-41FE-8F2F-EFA296723AD8

Solution is here:

https://www.fernandosimon.com/blog/dml-over-standby-for-active-data-guard-in-19c/

Thanks

LaserSoft.