The plan is to add a few more tables to the Golden Gate Bi-Directional replication. I used the below syntax to do this. Surprisingly the expdp failed with the below error.
- Before adding that to the Golden Gate, supplemental logging should be enabled for the tables.
- Add Tables in the Extract process
- Add tables in the Pump process
- Replicat mapping
(oracle):PRODT@ORA-X2:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> impdp ggadmin/Welcome1 directory=DMPDIR dumpfile=SCOTT_4TABLES_6.dmp table_exists_action=replace Import: Release 19.0.0.0.0 - Production on Tue Jun 7 20:31:53 2021 Version 19.15.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ... .. . UDI-31623: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747 ORA-06512: at "SYS.KUPV$FT_INT", line 2144 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.KUPV$FT_INT", line 2081 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496 ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127 ORA-06512: at line 1
After searching a bit more found the below solutions from the MOS Note EXPDP Failed with ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle (Doc ID 2731229.1)
+ Golden Gate is consuming more memory.
+ In a Busy Database, If More Memory is being consumed by Golden Gate Extraction Process and there is not much free memory available to be allocated to “Stream Pool Size” by MMAN process. DataPump job will fail.
+ Check the processes consuming memory and Release or Increase Memory.
Observed not much memory is in use, tried expdp several times but no luck. After bouncing the database, the issue disappeared.
Tip: Bouncing the database is not in all situations. Since this is POC perfectly acceptable to address the issue.
