While creating the database objects (granting privileges to the schema user) of the monitored schema I got the following error:
The database operation failed.
TNS Listener Port: 1521
Generated the following exception:
ORA-24344: success with compilation error
While trying to grant the privileges manually the following error occurs:
ORA-06550: line 165, column 13
ORA-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 165, column 9
PL/SQL: Statement ignored
The problem is that the "PLSQL_CODE_TYPE " parameter of the database was set to "NATIVE" which means that it will try to compile all plsql code to native binaries.
Resetting the parameter to "INTERPRETED" resolved issue.
Use the Oracle command ALTER SYSTEM or ALTER SESSION to change the parameter.
PLSQL_CODE_TYPE specifies the compilation mode for PL/SQL library units.
PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine.
PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed native without incurring any interpreter overhead.
When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with each library unit.
If a PL/SQL library unit is compiled native, all subsequent automatic recompilations of that library unit will use native compilation.