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

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google