After Database Import Of ODI Repositories Into An Oracle Database, ODI 11g Studio Fails To Connect To The Master Repository Signalling ODI-26130: Could Not Connect To Repository, ODI-10181 and ORA-00942 (Doc ID 1582582.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After having restored ODI 11g Master and Work Repositories from backups into an Oracle database, ODI Studio fails to connect to the Master Repository with following message :

Changes

ODI repositories have been restored from backup using the Oracle imp (import) utility. 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms