"ODI-10147: Repository type mismatches" Or "Invalid Object Name SNP_LOC_REP" Signaled By ODI When Connecting To The Repositories (Doc ID 563007.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 11.1.1.9.99 [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.

Symptoms

The below message:

oracle.odi.core.config.NotMasterRepositorySchemaException: ODI-10147: Repository type mismatches.    
PreparedStatementCallback; bad SQL grammar [select REP_SHORT_ID, REP_NAME, REP_TYPE, REP_TIMESTAMP, REP_VERSION, MIN_EXE_VERSION, IND_INSTALL_OK from SNP_LOC_REP]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

or

Invalid object name 'SNP_LOC_REP'

is signaled when one of the following operations is executed:

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