My Oracle Support Banner

Data Analysis Synchronization Fails with Error 'Exception during ODI connect: oracle.odi.core.config.NotWorkRepositorySchemaException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges' (Doc ID 1601076.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Application Access Controls Governor - Version 8.6.4 and later
Information in this document applies to any platform.

Goal

While running  DA synchronization the following error appearing in the grc.log, need details about this error.
ERROR
-----------------------
2013-07-22 19:54:49,205 ERROR [Thread-81] OdiInstanceManager:161 Exception during ODI connect:
oracle.odi.core.config.NotWorkRepositorySchemaException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
 

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.