My Oracle Support Banner

How To Use The Oracle Data Integrator (ODI) - Repository Consistency Checker (RCC) Tool (Doc ID 1058107.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Oracle Data Integrator - Version to [Release 3.2.03 to 12c]
Information in this document applies to any platform.

It is highly recommended to run the RCC utility:

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 Known limitations
 How does it work?
 Execution errors and warnings
 What are the outputs of an RCC run?
 When to involve Oracle Support?
 Use the RCC utility!
 Troubleshooting the RCC utility
 "Out of Memory" received when executing the RCC
 Failed to connect to the RCC Master Repository. Verify that the ODI Repository Consistency Checker environment is up and running
 Can not access a member of class oracle.jdbc.driver.OraclePreparedStatementWrapper with modifiers "public"
 The connection to one of the analyzed Repositories fails with, for example, TNS-12505 or "I/O Exception" error messages
 The connection to the analyzed Repositories fails if the URL refers to a Port setup as **dynamic**
 What to do if the RCC utility has been running for several hours
 The execution of "start_diag.bat" fails
 The .properties configuration file does not contain a valid Master Repository connection
 The RCC on Windows 2008 R2 fails to execute command ([\'sh\', \'-c\', \'rccencode.bat myPassword
 On Unicode Oracle database, the size of CHAR2 and VARCHAR2 columns is four times larger than the expected
 Before re-executing the RCC a same day, please ensure all the previously generated .csv files are closed
 Error received if running the RCC to prepare an upgrade to ODI 12c, with Repositories on a technology other then Oracle
 Help us to improve the RCC utility!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.