安装OIM RCU失败,提示XATRANS Views are not installed on this Database. This is required by the OIM Schema

2016-07-17 19:34:00
sucheasy
原创
2186
摘要:XATRANS Views are not installed on this Database. This is required by the OIM Schema

APPLIES TO:

Identity Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

SYMPTOMS

On : 11.1.2.3.0 version, Install
Running the Repository Creation Utility for OIM installation/configuration and getting the following error when the prerequisites check is performed:

2016-02-23 08:13:31.220 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.PrereqTask::execute: Prereq Evaluation Failed
oracle.sysman.assistants.rcu.backend.validation.PrereqException: RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at /export/home/oracle/rcu/rcuHome/rcu/log/logdir.2016-02-23_08-10/rcu.log for details.
  at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.executePrereqTask(PrereqEvaluator.java:663)
  at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:68)
  at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
  at java.lang.Thread.run(Thread.java:745)
2016-02-23 08:13:31.223 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at /export/home/oracle/rcu/rcuHome/rcu/log/logdir.2016-02-23_08-10/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.
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:76)
  at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
  at java.lang.Thread.run(Thread.java:745)

 

CAUSE

XAVIEW objects missing on the database prior to running RCU.


解决方案



想解决这个问题,那么就按照下面的方法来吧。

a) As the SYS user, enable the Oracle database for XA by performing the following steps:

管理员登录,然后执行标蓝语句

sqlplus / as sysdba 
@$ORACLE_HOME/javavm/install/initxa.sql 
PL/SQL procedure successfully completed.

JVMRMACTION
--------------------------------
FULL_REMOVAL
PL/SQL procedure successfully completed.
Package created.
Package body created.
Synonym created.
Grant succeeded. 
SQL>@$ORACLE_HOME/rdbms/admin/xaview.sql 
DROP VIEW v$xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist
DROP VIEW v$pending_xatrans$
*
ERROR at line 1:
ORA-00942: table or view does not exist
View created.
View created.
SQL>
b) 然后就是核对以下的值是否符合要求了。。。
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)



文章分类
联系我们
联系人: 如易
Email: admin@sucheasy.com
QQ: 172787898
微信: sucheasy
地址: 北京市海淀区上地十街辉煌国际1号院1号楼20层