OIM/OAM 12c RCU Creation failed for Oracle DB12c

25

Sep 2018

OIM/OAM 12c RCU Creation failed for Oracle DB12c

oiam

Issue:

When we run the RCU utility to create the OIM/OAM Schemas, the following error is encountered

Mon Sep 24 23:36:02.696 UTC 2018 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.OIM

Refer to RCU log at /tmp/RCU2018-09-24_23-30_1931354565/logs/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)

Mon Sep 24 23:36:02.697 UTC 2018 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.OIM

Refer to RCU log at /tmp/RCU2018-09-24_23-30_1931354565/logs/rcu.log for details.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error: Views/Synonyms required for XA transaction support are missing in this Database 12c.

These views/synonyms are required by the OIM Schema.

Action: Refer Oracle Database Administrator’s Guide to install XA transaction recovery views/synonyms¬†using the script xaview.sql. Contact your DBA.

For Database12c CDB config: execute xaview.sql from PDB SYS user
For Database12c NON-CDB config: execute xaview.sql from CDB SYS user

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Resolution:

  1. Login to your database as sys or any other user with sysdba privileges and run below two scripts

    @$ORACLE_HOME/javavm/install/initxa.sql

    @$ORACLE_HOME/rdbms/admin/xaview.sql

    Below is a screenshot of the output when the scripts are run

    rcu_error_oam12c

  2. Along with the above views, make sure the following parameters are tuned per the Oracle recommendationPROCESSES (min > 300)
    NLS_LENGTH_SEMANTICS (BYTE)
    SHARED_POOL_SIZE ( min > 200MB)
    SGA_MAX_SIZE (min > 200MB)
    DB_BLOCK_SIZE (min > 8k)
    OPEN_CURSORS (min > 1000)

Post Your Thoughts

Your email address will not be published. Required fields are marked *