INSTALL VIEW XAVIEWS FOR ORACLE IDENTITY MANAGER INSTALL

If you receive this error while running the rcu tool for fusion middle ware component oracle identity manager

 

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.

 

Solution :

As the SYS user, enable the Oracle database for XA by performing the following steps:Configure the database for XA by running the following script on the WPSDB database:

Connec to database instance as sysdba

 #sqlplus "/as sysdba"
@ORACLE_HOME/javavm/install/initxa.sql script

 

Also run 

@/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/xaview.sql

 

 Run the following commands:

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)

 

Reference