When validating connections in Oracle, adding a new Oracle agent, or run the check permissions script the results show missing privileges, but when checking the privileges individually, the privileges are present for the user and there hasn’t been privileges errors in the agent log files. This prevents the installation or validation from completing.
DECLARE
*
ERROR at line 1:
ORA-20100: Check failed - missing_advisory_privileges
CDB_CDB_RSRC_PLAN_DIRECTIVES, CDB_DATA_FILES, CDB_DIRECTORIES, CDB_FREE_SPACE,
CDB_JOBS, CDB_JOBS_RUNNING, CDB_LIBRARIES, CDB_OBJECTS, CDB_PDB_HISTORY,
CDB_SCHEDULER_JOBS, CDB_SCHEDULER_RUNNING_JOBS, CDB_TABLESPACES,
CDB_TEMP_FILES, CDB_TEMP_FREE_SPACE, CDB_UNDO_EXTENTS, CDB_USERS, CDB_WAITERS
ORA-06512: at line 308
Missing permissions for the database agent user to execute the DBMS_SQL package
Add permissions for the Oracle database agent user to execute the DBMS_SQL package
