cdb ERROR OGG-08221 Cannot register or unregister EXTRACT ＜extname＞

[송지환]

This is Setup/Configuration issue, related to the PDB GLOBAL_NAME not having the db_domain appended, while the CDB GLOBAL_NAME does have the db_domain appended.

In this case, following is observed:

CDB GLOBAL_NAME: <CDBNAME>.<DB_DOMAIN>
PDB GLOBAL_NAME: <PDBNAME>


The failure can be seen in the trace file:


*** 2019-12-23 13:27:11.727
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=10, mask=0x0)
----- Error Stack Dump -----
ORA-40201: invalid input parameter SOURCE_DATABASE_NAME
ORA-01403: no data found
----- Current SQL Statement for this session (sql_id=84m6t4r5bb1gs) -----
declare extract_name varchar2(100) := :1; source_global_name varchar2(4000) := :2; firstScn number := :3; startScn number := :4; container_global_name varchar2(4000) := :5; container_short_name varchar2(128) := :6; outbound_server_name varchar2(30); outbound_capture_name varchar2(30); capture_queue_name varchar2(30); queue_table_name varchar2(30); outbound_comment varchar2(125); optimized_mode number := :7; BEGIN dbms_xstream_gg_adm.wait_for_inflight_txns := 'n'; dbms_xstream_gg_adm.synchronization := 'none'; dbms_xstream_gg_adm.is_goldengate := true; /* Construct the queue table name */ queue_table_name := SUBSTR('OGG$Q_TAB_' || extract_name, 1, 30); /* Construct the capture queue name */ capture_queue_name := SUBSTR('OGG$Q_' || extract_name, 1, 30); /* create capture queue */ dbms_streams_adm.set_up_queue(queue_table => queue_table_name, queue_name => capture_queue_name); /* Construct the outbound capture name */ outbound_capture_name := SUBSTR('OGG$CAP_' || extract_name, 1, 30); /* Construct the outbound server name */ outbound_server_name := SUBSTR('OGG$' || extract_name, 1, 30); /* Construct the comment assosciated with this outbound server */ outbound_comment := extract_name || ' GoldenGate Extract'; /* create capture specifying the first scn */ DBMS_XSTREAM_GG.SET_GG_SESSION(); if (optimized_mode = 1) then DBMS_XSTREAM_GG.SET_GG_SESSION_FLAGS(16, dbms_xstream_gg.MODE_MERGE); end if; if (container_global_name = '' OR container_global_name IS NULL) then dbms_capture_adm.create_capture(queue_name => capture_queue_name, capture_name => outbound_capture_name, first_scn => firstScn, start_scn => startScn, source_database => source_global_name, source_root_name => source_global_name, capture_class => 'goldengate'); DBMS_XSTREAM_GG_ADM.ADD_OUTBOUND(server_name => outbound_server_name, capture_name=> outbound_capture_name, source_database=> source_global_name, source_container_name=> NULL, source_root_name => source_global_name, committed_data_only => FALSE, wait_for_inflight_txns => 'N', synchronization => 'NONE', start_scn => startScn, comment => outbound_comment); else dbms_capture_adm.create_capture(queue_name => capture_queue_name, capture_name => outbound_capture_name, first_scn => firstScn, start_scn => startScn, source_database => container_global_name, source_root_name => source_global_name, capture_class => 'goldengate'); DBMS_XSTREAM_GG_ADM.ADD_OUTBOUND(server_name => outbound_server_name, capture_name=> outbound_capture_name, source_database=> container_global_name, source_container_name=> container_short_name, source_root_name => source_global_name, committed_data_only => FALSE, wait_for_inflight_txns => 'N', synchronization => 'NONE', start_scn => startScn, comment => outbound_comment); end if; if (optimized_mode = 1) then DBMS_XSTREAM_GG.SET_GG_SESSION_FLAGS(16, dbms_xstream_gg.MODE_CLEAR); end if; DBMS_XSTREAM_GG.SET_GG_SESSION(FALSE); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
.
.