OBIA 11g: ODI Repository Connection Error out "ODI-10182: Uncategorized exception during repository access" And ORA-12505

(Doc ID 2305797.1)

Last updated on MAY 22, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.161018 and later
Information in this document applies to any platform.

Symptoms

Post migration of Database from VM to Exadata, connecting to ODI Repository is failed

oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Changes

 

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