Monday, June 16, 2014

XATRANS Views are not installed on this Database. This is required by the OIM Schema Action

I was trying to install RCU schema for Identity manager and I got this error.
RCU-6083:Failed - Check prerequisites requirement for selected component:OIM Please refer to RCU log at C:\Software\RCU\rcuHome\rcu\log\logdir.2014-06-16_14-37\rcu.log for details. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: XATRANS Views are not installed on this Database. This is required by the OIM Schema Action: Install view XAVIEWS as SYS user on this Database. Refer to the Oracle Database Release Documentation for installation details. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ RCU-6092:Component Selection validation failed. Please refer to log at C:\Software\RCU\rcuHome\rcu\log\logdir.2014-06-16_14-37\rcu.log for details.
The reason is that there are some pre requisite that needs to be done before installing the RCU schema. XATrans view needs to be enabled in the database.
Solution- In order to resolve this issue run the following script
@$ORACLE_HOME/javavm/install/initxa.sql
$ORACLE_HOME/rdbms/admin/xaview.sql
Once you have run the script re run the RCU creation utility and you will be able to create it successfully.

No comments: