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 3.2.03.01 to 12.1.2.0.1 [Release 3.2.03 to 12c]Information in this document applies to any platform.
It is highly recommended to run the RCC utility:
- Prior to upgrading Repositories to a version compatible with ODI 10.1.3.6 or above.
Note if your upgrade requires intermediate steps (such as, for example, an upgrade from Sunopsis v3 to ODI 11g, which requires an intermediate upgrade from Sunopsis v3 to ODI 10g, then from ODI 10g to ODI11g), you should run the RCC prior to the first upgrade operation (in the above example, run the RCC on the Sunopsis v3 Repositories).
- To diagnose Repository data corruptions and inconsistencies.
- Regularly for Work Repositories hosted in a Microsoft SQL Server database with multiple concurrent developers.
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
| Purpose |
| Troubleshooting Steps |
| Compatibility |
| Known limitations |
| Pre-requisites |
| Installation |
| 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! |
| References |