If your EXTRACT process is abending with error like below:
2014-03-18 20:15:23 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext_sou1.prm: OCI Error getting OCI_ATTR_NAME for UDT SYS.XMLTYPE (status = 24328-ORA-24328: illegal attribute value), SQL.
Check if that is a new table created with XMLYPE column data type.
select distinct data_type from dba_tab_columns ;
select object_name,object_type, created from dba_objects where object_name in (select table_name from dba_tab_columns where data_type= 'XMLTYPE');
Add a new line in your EXTRACT parameter excluding this table from replication:
TABLEEXCLUDE owner.yournewtable;
This work for me.
Best Regards,
Paulo Portugal
2014-03-18 20:15:23 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext_sou1.prm: OCI Error getting OCI_ATTR_NAME for UDT SYS.XMLTYPE (status = 24328-ORA-24328: illegal attribute value), SQL
Check if that is a new table created with XMLYPE column data type.
select distinct data_type from dba_tab_columns ;
select object_name,object_type, created from dba_objects where object_name in (select table_name from dba_tab_columns where data_type= 'XMLTYPE');
Add a new line in your EXTRACT parameter excluding this table from replication:
TABLEEXCLUDE owner.yournewtable;
This work for me.
Best Regards,
Paulo Portugal
2017-01-02 10:13:08 ERROR OGG-00665 Oracle GoldenGate Delivery for Oracle, reptar.prm: OCI Error getting OCI_ATTR_NAME for UDT SYS.XMLTYPE (status = 24328-ORA-24328: illegal attribute value), SQL.
ReplyDeleteI'm getting this error, due to this replicat process has been ABENDING. pls help