Infosphere CDC: Problem Reading Online Redo Logs after upgrading from 9i to 10g

Technote (troubleshooting)


Problem(Abstract)

CDC is able to read archive logs after new installation but scraper failing on online redo logs with error,


Type: Error
Date/Time: Sep 14, 2010 2:53:30 PM
Origin: com.datamirror.ts.util.oracle.OracleRedoNativeApi
Subscription: dmdtest
ID: 2919
Detail: CDC daemon has encountered an error message.
A fatal error has been encountered during scraper initialization. Replication will be terminated. Error detected in file /dmbuild/luntbuild/ts-java/work-dmcsunl/build-output/temp/iReflectEngine/src/rs/ohrslog.c at line . Refer to the preceding message(s) for additional information. Try to fix the problem(s) based on the error information provided. If problem still exists, contact technical support.

********************************************************

Type: Error
Date/Time: Sep 14, 2010 2:53:30 PM
Origin: com.datamirror.ts.util.oracle.OracleRedoNativeApi
Subscription: dmdtest
ID: 2919
Detail: CDC daemon has encountered an error message.
Oracle 9i with log parallelism is not supported. Log parallelism is explicitly set to a value greater than 1. The _log_parallelism_max Oracle parameter must be set to 1 for this Oracle instance or for every Oracle instance in a RAC cluster. After setting the parameter, each instance will need to be restarted in order for the changes to take effect. Once log parallelism has been disabled for all instances, you will need to restart replication from a log position occurring after log parallelism was disabled.

Resolving the problem

This error occurs when Oracle database had been upgraded from 9i to 10g but Online Log Groups are not re-created in 10g format. To determine the log format run the following command most recent redo log,

od –x –N 32 <redo log file>

Oracle 9i encoding:
0000000 0200 0000 0200 0000 2000 0003 5a5b 5c5d
or for Little Endian based platform 5c5d 5a5b
0000020 0000 0000 2605 0000 0000 0000 0000 0000

Oracle 10g encoding
0000000 2200 0000 0000 ffc0 0000 0000 0000 0000
0000020 0876 0000 0200 0000 5000 0000 7a7b 7c7d
or for Little Endian based platform 7c7d 7a7b

Re-create Oracle Online Redo Log Groups to resolve this issue. Also make sure compatibility parameter is also set to correct oracle version . Run following query to display compatible parameter,


Select name,value
from v$parameter
where name like 'comp%';


Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Change Data Capture
Scraper

Software version:

6.0, 6.1, 6.2.1, 6.3, 6.3.1

Operating system(s):

AIX, HP-UX, Linux, Solaris

Reference #:

1448065

Modified date:

2011-02-18

Translate my page

Machine Translation

Content navigation