Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

                                   Drop Oracle Database We can drop oracle database in 2 ways : 1. Using DBCA (Database Configuration Assistance) utility . 2. Drop Database Manually . In this Blog I am covering Drop oracle database manually. Please make sure you have proper backup before dropping database.   Connect to target database with sys user, and issue following query to check database mode:  sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 11 12:27:53 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options  Step 1:  Normally shutdown your database: SQL> shut immediate; Database closed....

During Subscriber Removal we were getting below Oracle Error. SQL> DECLARE   subscriber   SYS.aq$_agent; BEGIN   subscriber := SYS.aq$_agent ('ORA_692K6D2264P48DHO6OR3ACPJ6T', NULL, NULL);   DBMS_AQADM.remove_subscriber (queue_name      => 'WF_BPEL_Q',                                 subscriber      => subscriber                                ); END;  / DECLARE * ERROR at line 1: ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pmucalm coll) ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7560 ORA-06512: at "SYS.DBMS_AQADM", line 441 ORA-06512: at line 5 == We were running a PL/SQL package or procedure and are consistently encountering an ORA-4030 when the process uses 4GB.  The values for the _PGA_MAX...

Remove Subscriber from WF_BPEL_Q consumers How to Check your current consumers SELECT * FROM ALL_QUEUE_SUBSCRIBERS WHERE QUEUE_NAME = 'WF_BPEL_Q';     SELECT * FROM apps."AQ$_WF_BPEL_QTAB_S" WHERE NAME IS NOT NULL and name like 'ORA_*****';  How to Remove Subscriber from WF_BPEL consumer DECLARE    subscriber       sys.aq$_agent;    begin subscriber := sys.aq$_agent('<CONSUMER_NAME>', NULL, NULL);    dbms_aqadm.remove_subscriber(queue_name => 'WF_BPEL_Q', subscriber => subscriber); End;