RCU Fails when Using Non-default (SYS) SYSDBA Username, "RCU-6083 Prerequisite check failed for selected component:" for OAM Component. (Doc ID 2517591.1)

Last updated on AUGUST 16, 2023

Applies to:

Symptoms

When running RCU and specifying a SYSDBA user that is not SYS the RCU encounters an error creating the OAM schemas.

Thu Jan 31 11:55:25.759 UTC 2019 ERROR assistants.rcu.backend.task.PrereqTask: oracle.sysman.assistants.rcu.backend.task.PrereqTask::execute: Prereq Evaluation Failed
oracle.sysman.assistants.rcu.backend.validation.PrereqException:
ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.OAM
Refer to RCU log at <PATH>\rcu.log for details.
at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:713)
at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:346)
at java.lang.Thread.run(Thread.java:748)

Thu Jan 31 11:55:25.759 UTC 2019 ERROR assistants.rcu.backend.task.ActualTask: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException:
ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.OAM
Refer to RCU log at <PATH>\rcu.log for details.
GRANT EXECUTE ON DBMS_LOB TO [Non SYSDBA User] WITH GRANT OPTION;
   GRANT EXECUTE ON DBMS_OUTPUT TO [Non SYSDBA User] WITH GRANT OPTION;
   GRANT EXECUTE ON DBMS_STATS TO [Non SYSDBA User] WITH GRANT OPTION;
   GRANT EXECUTE ON sys.dbms_aq TO [Non SYSDBA User] WITH GRANT OPTION;
   GRANT EXECUTE ON sys.dbms_aqadm TO [Non SYSDBA User] WITH GRANT OPTION;
   GRANT EXECUTE ON sys.dbms_aqin TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON sys.dbms_aqjms TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON sys.dbms_aqadm TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON sys.dbms_aq TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON utl_file TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON dbms_lock TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON sys.V_$INSTANCE TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON sys.GV_$INSTANCE TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON sys.V_$SESSION TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON sys.GV_$SESSION TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_scheduler_jobs TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_scheduler_job_run_details TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_scheduler_running_jobs TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_aq_agents TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON sys.DBMS_SHARED_POOL TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_2pc_pending TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_pending_transactions TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON DBMS_FLASHBACK TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON dbms_crypto TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON DBMS_REPUTIL TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT EXECUTE ON dbms_job TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON pending_trans$ TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON dba_scheduler_job_classes TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON SYS.DBA_DATA_FILES TO [Non SYSDBA User] WITH GRANT OPTION;
           GRANT SELECT ON SYS.V_$ASM_DISKGROUP TO [Non SYSDBA User] WITH GRANT OPTION;

   1. Copy these commands and Replace "Non SYSDBA user" with the non-sysdba username used while running RCU for OAM schema creation.
   2. Run these commands as SYS on the Database Instance and resume Schema creation by RCU.

at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:77)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:346)
at java.lang.Thread.run(Thread.java:748)

Cause

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