_____________________________________________________________________________________________________________________
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._____________________________________________________________________________________________________________________
0 comments:
Post a Comment