1 Reply Latest reply on Nov 6, 2012 10:01 AM by Annamalai A

    ERROR OGG-00663 in goldengate initial load

    961013
      Hi experts,


      please help me in solve this issue.posting here logfile.

      012-11-06 14:10:29 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, load1.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of WE8MSWIN1252.
      2012-11-06 14:10:30 ERROR OGG-01960 Oracle GoldenGate Capture for Oracle, load1.prm: Failed to validate table SH.PRODUCTS. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it.
      2012-11-06 14:10:30 ERROR OGG-00663 Oracle GoldenGate Capture for Oracle, load1.prm: OCI Error retrieving bind info for query (status = 100), SQL < select (select count(*) from dba_tables where logging = 'NO' and owner = 'SH' and table_name = 'PRODUCTS') + (select count(*) from dba_tab_partitions where table_owner = 'SH' and table_name = 'PRODUCTS' and logging = 'NO') + (select count(*) from dba_tab_subpartitions where table_owner = 'SH' and table_name = 'PRODUCTS' and logging = 'NO') from DUAL >.
      2012-11-06 14:10:30 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, load1.prm: PROCESS ABENDING.