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
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