1 Ответить Последний ответ: 09.01.2019 6:38, автор: Moe_ADF_541

    Error While setting up RCU for Identity and Access manager

    Moe_ADF_541

      Dear Experts,

       

      I am setting up RCU for Oracle Identity and Access Manager 12c , version 12.2.1.3

       

      I have Oracle DB 12c, version 12.1.0.2 SE

       

      while setting up RCU, I faced the error:

       

      "

      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 C:\Users\User\AppData\Local\Temp\RCU2019-01-08_18-04_1613409790\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)

       

       

      Tue Jan 8 18:06:27.140 EET 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.OIM

      Refer to RCU log at C:\Users\User\AppData\Local\Temp\RCU2019-01-08_18-04_1613409790\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

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

       

       

      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)

       

       

      Tue Jan 8 18:23:28.193 EET 2019 NOTIFICATION assistants.common.wizard.WizardExt: oracle.sysman.assistants.common.wizard.WizardExt::doCancel: User Canceled the operation

      Tue Jan 8 18:23:28.195 EET 2019 NOTIFICATION assistants.common.wizard.WizardExt: oracle.sysman.assistants.common.wizard.WizardExt::doCancel: User cleanup the tablespaces: true

      "

       

      I have been looking around and I found this suggested solution:

       

      Cloud and Mobile Security: 12C RCU failed on Oracle Identity Manager Schema

       

       

      but it does not work, I have started RCU again with the same error.

       

      if I run the script one more time:

      @D:\app\dbAdmin2\product\12.1.0\dbhome_1\RDBMS\ADMIN\xaview.sql

       

      I get the error:

       

      "

      View D$XATRANS$ dropped.

       

       

       

       

      View D$PENDING_XATRANS$ dropped.

       

       

       

       

      View D$PENDING_XATRANS$ created.

       

       

       

       

      Error starting at line : 43 File @ D:\app\dbAdmin2\product\12.1.0\dbhome_1\RDBMS\ADMIN\xaview.sql

      In command -

      create synonym v$pending_xatrans$ for d$pending_xatrans$

      Error report -

      ORA-00955: name is already used by an existing object

      00955. 00000 -  "name is already used by an existing object"

      *Cause:   

      *Action:

       

       

      View D$XATRANS$ created.

       

       

       

       

      Error starting at line : 58 File @ D:\app\dbAdmin2\product\12.1.0\dbhome_1\RDBMS\ADMIN\xaview.sql

      In command -

      create synonym v$xatrans$ for d$xatrans$

      Error report -

      ORA-00955: name is already used by an existing object

      00955. 00000 -  "name is already used by an existing object"

      *Cause:   

      *Action:

       

       

      Commit complete.

      "

       

      Any hints and advices are greatly appreciated,

       

      Regards,

       

      Windows 10 64-bit

      Oracle database 12.1.0.2

      Middleware 12.2.1.3

      Java Jdk 1.8.0_131

        • 1. Re: Error While setting up RCU for Identity and Access manager
          Moe_ADF_541

          to update, running the scripts alone did not solve the issue, even after I restarted my database. I had to change the parameters manually to arbitrary values as per the blog post suggestion:

           

          "show parameters PROCESSES (should be more 300)

           

          show parameters NLS_LENGTH_SEMANTICS  (should be BYTE)

           

          show parameters SHARED_POOL_SIZE (should be more 147456KB)

           

          show parameters SGA_MAX_SIZE (should be more 147456KB)

           

          show parameters DB_BLOCK_SIZE (is greater than or equal to 8KB)

           

          show parameters OPEN_CURSORS (should be more 800)"

           

          For anyone who faces this same issue:

           

          1- Restart the database after the scripts' execution.

           

          2- Check how the parameters above have changed. For any parameter that did not change, do it manually using:

           

          "alter system set <PARAMETER_NAME> =<PARAMETER_VALUE> scope=spfile;"

           

          Where "<PARAMETER_NAME>" is the parameter name (processes, shared_pool_size, etc) and "<PARAMETER_VALUE>" is the parameter value (6M, 8912, etc)

           

          Don't forget to restart your database after any change.

           

          After that I was able to successfully run RCU and create OAM/OIM schemas correctly.

           

          Hope this helps a similar case in the future,

           

          Regards,

          show parameters PROCESSES (should be more 300)

          show parameters NLS_LENGTH_SEMANTICS  (should be BYTE)

          show parameters SHARED_POOL_SIZE (should be more 147456KB)

          show parameters SGA_MAX_SIZE (should be more 147456KB)

          show parameters DB_BLOCK_SIZE (is greater than or equal to 8KB)

          show parameters OPEN_CURSORS (should be more 800)