Unable to add new Data sources in Datamanager .

Document ID : KB000007205
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When creating a new Data source in Data-manager , once you  select a Data Source Type

You  receive the following  error : 

An error occured while processing your request. 

A database error occured while processing your request. Please try again.. 

java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."COMPARE": invalid identifier 

Resolution:

The database user used by data manager  to connect to the oracle database does not have the right permissions 

The ORA-00904 error in conjunction with dbms_lob indicates that the execute privilege has not been granted to "PUBLIC" or has been revoked. 

The execute priv on dbms_lob needs to be granted to PUBLIC or the individual user.

Log into SQLPlus as sys as sysdba: 

SQL> grant execute on dbms_lob to Public; 

or 

SQL> grant execute on dbms_lob to [database user];