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 188.8.131.52.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!