ADG_REDIRECT_DML in Oracle Active Data Guard 19c

SYSMAN.MGMT_NOTIFY_Q_R is created by AQ, cannot be dropped directly

You want to drop user SYSMAN and you see error?
SQL> drop user sysman cascade;
drop user sysman cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24170: SYSMAN.MGMT_NOTIFY_Q_R is created by AQ, cannot be dropped directly
ORA-06512: at "SYS.DBMS_RULE_ADM", line 158
ORA-06512: at line 1


You can try:
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict
ORACLE instance started.

Total System Global Area 523108352 bytes
Fixed Size 1314492 bytes
Variable Size 100663620 bytes
Database Buffers 415236096 bytes
Redo Buffers 5894144 bytes
Database mounted.
Database opened.
SQL> drop user sysman cascade;

User dropped.

SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 523108352 bytes
Fixed Size 1314492 bytes
Variable Size 100663620 bytes
Database Buffers 415236096 bytes
Redo Buffers 5894144 bytes
Database mounted.
Database opened.

Comments