Monday 18 December 2017

OIM 12C RCU Creation XATRANSACTIONS Views Support are missing in 12C Database

OIM 12C RCU Creation  XATRANSACTIONS Views Support are missing in 12C Database

 Error faced while creating schemas for OIM&OAM 12C using RCU
 
 As per below screenshot in my case i am trying to create OIM&OAM 12C schemas
 In IDM Schemas i have selected OIM & OAM components and click on Next
 Started facing below error


To troubleshoot this issue we need to go to rcu log location 
In my case below is the following location for RCU logs 
          RCU Logfile: /tmp/RCU2017-12-18_21-42_424237021/logs/rcu.log



Error:- 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)

Follow and execute below steps to resolve issue 
1.Connect sqlplus / as sysdba as per below screenshot placed
2.Execute following as @$ORACLE_HOME/javavm/install/initxa.sql
3.Execute following @$ORACLE_HOME/rdbms/admin/xaview.sql
Make sure show parameters OPEN_CURSORS (should be more 800)
show parameters PROCESSES (should be more 300)
Shutdown and Restart your Database
4.Now try to run RCU and provide DB details and select OIM&OAM components
 to create schemas and click on Next
You should be able to proceed with installation and Next steps without any failure






No comments:

Post a Comment