搭建步骤

总结：就一个步骤，前提你是功能完备adg模式

-- 主从都开启adg_redirect_dml
alter system set ADG_REDIRECT_DML = true;

1、首先要搭建adg模式，如果搭建了adg模式后，不需要dg_broker_start为true状态

2、其次如果系统级别开了ADG_REDIRECT_DML，会话级别就不用开了，主从系统级别都要开启ADG_REDIRECT_DML

3、用普通用户登录sqlplus test/test@slave_db

SQL> show parameter ADG_REDIRECT_DML

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
adg_redirect_dml                     boolean     TRUE

ALTER SESSION ENABLE ADG_REDIRECT_DML;

4、Make sure that Primary database is reachable from ADG standby database.

这句话很关键，首先备库standby要能tnsping到主库，当时也不知道怎么了主库的防火墙是关闭的，
10.20.30.xxx为从库的IP地址

[oracle@yc]$ sqlplus test/test@10.20.30.xxx:1521/test

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 22 17:10:53 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Last Successful login time: Wed Nov 22 2023 17:05:45 +08:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> delete from a123;
1 row deleted.

SQL> commit;
Commit complete.

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,DATABASE_ROLE from v$database;

OPEN_MODE            PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE
-------------------- -------------------- -------------------- ----------------
READ ONLY WITH APPLY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY

参考：
ORA-16397 Raised in ADG by DMLs (Doc ID 2980532.1)
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-B1C66720-3EA6-45A3-986E-6E510381EC79
https://qiita.com/plusultra/items/2355ea76921ed7e85cf3
https://blog.csdn.net/JiekeXu/article/details/126313992