OBIA 11g: ODI Repository Connection Error out "ODI-10182: Uncategorized exception during repository access" And ORA-12505
Last updated on MAY 22, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.161018 and later
Information in this document applies to any platform.
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
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