Cannot drop OGG_USER: ORA-65274: operation not allowed from outside an application action (Doc ID 2738157.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

User upgraded database from 18c to 19c, upon troubleshoot decided to drop GoldenGate schema from database and register again. They were able to delete extract from ggsci but got following error while dropping GG schema at database level.

SQL> drop user <OGG_USER> cascade;
drop user <OGG_USER> cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-65274: operation not allowed from outside an application action
ORA-06512: at "SYS.DBMS_AQADM", line 707
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7735
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 604
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 135
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 227
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 539
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7483
ORA-06512: at "SYS.DBMS_AQADM", line 702
ORA-06512: at line 1
SQL> exit

There were few queue tables which they tried to drop but didn't help:

select owner,queue_table,type from dba_queue_tables where owner='<OGG_USER>';
<OGG_USER> OGG$Q_TAB_E_AK OBJECT
<OGG_USER> OGG$Q_TAB_E_HK OBJECT

..as SYS user
SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'<OGG_USER>.OGG$Q_TAB_E_HK',force =>TRUE);
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'<OGG_USER>.OGG$Q_TAB_E_HK',force =>TRUE); END;
*
ERROR at line 1:
ORA-65274: operation not allowed from outside an application action <======================
ORA-06512: at "SYS.DBMS_AQADM", line 707
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7735
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 604
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 135
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 227
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 539
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7483
ORA-06512: at "SYS.DBMS_AQADM", line 702
ORA-06512: at line 1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.