B Oracle GoldenGate Unsupported Objects and Objects in CPAT Tool Errors
In Oracle Autonomous Transaction Processing-Shared (ATP-S) database migration using Database Migration (DMS) service, the Oracle GoldenGate unsupported objects, and some objects that cause errors in the CPAT tool need to be excluded from the migration job.
The following tables provide information for the Oracle Fusion Middleware products, wherever applicable.
Oracle GoldenGate Unsupported Objects To Be Excluded
The Oracle GoldenGate unsupported objects need to be excluded from the migration job as these objects fail during the validation phase in ATP-S migration. Table B-1 lists the Oracle GoldenGate unsupported objects that need to be excluded from the migration job. For excluded tables listed with "xxxxxx" in the table name, replace "xxxxxx" with the numeric value in your specific schema table name.
Note:
When excluding tables with "$", use the backslash (\) escape character. For example,DR\$FT_IDCTEXT1\$U
.
The following table lists sample Oracle GoldenGate unsupported objects to be excluded from the migration job. Based on your setup, provide any additional GoldenGate unsupported objects, if required.
Table B-1 Oracle GoldenGate Unsupported Objects To Be Excluded
Product/Component | Unsupported Objects |
---|---|
Metadata Services (MDS) |
|
SOA for Oracle Identity Manager (OIM) |
|
Oracle Identity Manager (OIM) |
|
SOA/Oracle Business Process Management |
|
SOA/Oracle Business Activity Monitoring (BAM) |
|
Oracle Enterprise Scheduler (ESS) |
|
Oracle Managed File Transfer (MFT) |
|
User Messaging Service (UMS) |
|
Oracle WebCenter Portal (WCP) |
|
Oracle WebCenter Content (WCC) |
|
Oracle Enterprise Data Quality (EDQ) |
Owner is |
Objects To Be Excluded from the Migration Job due to CPAT Tool Errors
The check names in the CPAT tool like gg_not_unique
,
has_tables_with_xmltype_column
,
has_refs_to_restricted_packages
, and
has_xmlschema_objects
list errors in the CPAT tool. Some of
these objects need to be excluded from the migration job and some need not be
excluded from the migration job. Table B-2 lists the objects that cause errors in the CPAT tool and need to
be excluded from the migration job. However, even after excluding these objects, you
see the same errors in the CPAT tool, and these errors can be ignored.
Note:
The following table lists the sample objects to be excluded from the migration job due to CPAT tool errors for the applicable Oracle Fusion Middleware products, only.Table B-2 Objects To Be Excluded from the Migration Job due to CPAT Tool Errors
Product/Component | GG_not_unique Tables | Tables with xmltype Column | Objects with Reference to restricted_packages | xmlschema Objects |
---|---|---|---|---|
Oracle Identity Manager (OIM) |
|
|
|
When excluding in the DMS user interface, enter as: Action: Owner: Name: Object type: |
Objects Not To Be Excluded From the Migration Job
The check names, gg_not_unique
and
has_refs_to_restricted_packages
list errors in the CPAT tool.
However, some of these objects need not be excluded from the migration job, and any
errors related to these objects in the CPAT tool can be ignored. Table B-3 lists the objects that need not be excluded from the migration
job. Any errors displayed in the CPAT tool can be ignored.
Note:
The following table lists the sample objects not to be excluded from the migration job for the applicable Oracle Fusion Middleware products, only.Table B-3 Objects Not To Be Excluded From the Migration Job
Product/Component | GG_not_unique Tables Not To Be Excluded from the Migration Job | Objects with Reference to Restricted Packages Not To Be Excluded from the Migration Job |
---|---|---|
WebLogic Services |
|
None |
Common Infrastructure Services (STB) |
|
None |
IAU/Oracle Platform Security Services (OPSS) |
|
None |
SOA for Oracle Identity Manager (OIM) |
|
None |
Oracle Access Manager (OAM) |
You can ignore any errors in the CPAT tool. So, you need not exclude these objects. |
You can ignore any errors in the CPAT tool. So, you need not exclude these objects. |
Oracle Identity Manager (OIM) |
|
None |
Oracle Internet Directory |
|
|
SOA/Oracle Business Process Management |
|
None |
SOA/Oracle Business Activity Monitoring (BAM) |
|
None |
Oracle Managed File Transfer (MFT) |
|
None |
Oracle Enterprise Data Quality |
|
None |
Oracle GoldenGate Veridata |
You can ignore any errors in the CPAT tool. So, you need not exclude these objects. |
None |