ORA-01338 Other process is attached to LogMiner session

Not Able To Drop Disabled Golden Gate Capture and getting ORA-03113 and ORA-01338: Other process is attached to LogMiner session (Doc ID 2338387.1)

CAUSE
ORA-01338: Other process is attached to LogMiner session

select * from dba_capture;
select * from system.logmnr_uid$;
select * from system.logmnr_session$;
select * from sys.streams$_capture_process;
select * from SYS.STREAMS$_EXTRA_ATTRS order by process#;
select * from dba_queues where name like '%OGG%' order by queue_table, name;

Once the identifying the session then please execute  and drop the capture.

define QUEUE_NAME='OGG$Q_EX0';
define CAPTURE_NAME='OGG$CAP_EX0';

exec dbms_streams_adm.remove_queue('&&QUEUE_NAME');
exec dbms_capture_adm.drop_capture(capture_name =>'&&CAPTURE_NAME'); 
exec DBMS_CAPTURE_ADM.DROP_CAPTURE(capture_name => '&&CAPTURE_NAME',drop_unused_rule_sets => true);
delete from system.logmnr_session$ where session#=6;
delete from sys.streams$_capture_process where CAPTURE_NAME='&&CAPTURE_NAME';
delete from obj$ where name = '&&CAPTURE_NAME';
delete from sys.streams$_process_params;
delete from SYS.STREAMS$_EXTRA_ATTRS;

可能会没有清理干净，需要从OGG上执行unregister

unregister extract ex0 database;

GGSCI (db3 as c##ggs@QNZW/CDB$ROOT) 26> register extract ex0 database container (pdb2)
2021-04-08 16:19:07  ERROR   OGG-08232  ERROR: Database container PDB2 has already been registered.

GGSCI (db3 as c##ggs@QNZW/CDB$ROOT) 27> unregister extract ex0 database;
2021-04-08 16:19:19  INFO    OGG-01750  Successfully unregistered EXTRACT EX0 from database.

GGSCI (db3 as c##ggs@QNZW/CDB$ROOT) 28> register extract ex0 database container (pdb2)
2021-04-08 16:19:36  INFO    OGG-02003  Extract EX0 successfully registered with database at SCN 9943246.