GoldenGate GGSCI Register / Unregister Extract Failed with OGG-08221 OCI Error 26,665

_____________________________________________________________________________________________________________________

Problem Description: 

GoldenGate GGSCI Register or Unregister Extract failed with following error.

GGSCI (Node 1 as PCS_OWNER@KPMUAT1) 10> register extract EXT_STS database

2016-09-21 14:02:11  ERROR   OGG-08221  Cannot register or unregister EXTRACT EXT_STS because of the following SQL error: OCI Error 26,665.

Solution Description: 

The issue is because the streams process is already existing. You have to drop the existing streams process with the same name. You have to use dbms_capture_adm.drop_capture package to drop the capture. 

 1. Find out the capture name using following query.

SQL> SELECT capture_name, queue_owner, queue_name FROM dba_capture;
CAPTURE_NAME                   QUEUE_OWNER                    QUEUE_NAME
------------------------------ ------------------------------ ---------------
OGG$CAP_EXT_STS               PCS_OWNER                      OGG$Q_EXT_STS

advertisements

 

2. Drop the capture. Pass the capture name as the argument.

Connect to PCS_OWNER user
SQL> begin
   dbms_capture_adm.drop_capture(
      capture_name => 'OGG$CAP_EXT_STS',
      drop_unused_rule_sets => TRUE);
end;
PL/SQL procedure successfully completed.

SQL> SELECT capture_name, queue_owner, queue_name
FROM dba_capture;

no rows selected

3. Add the extract again and register.

GGSCI (Node 1 as PCS_OWNER@KPMUAT1) 15> ADD EXTRACT EXT_STS, integrated TRANLOG, BEGIN NOW
register extract EXT_STS database
ADD EXTTRAIL ./dirdat/gt, EXTRACT EXT_STS MEGABYTES 500
EXTRACT (Integrated) added.

_____________________________________________________________________________________________________________________

Website Stats