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:
Oracle Fusion Middleware - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |