When you get this error while running RCU for OIM schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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:
Connec to database instance as sysdba
#sqlplus "/as sysdba"
SQL>@ORACLE_HOME/javavm/install/initxa.sql script
Run the following command
SQL>@ORACLE_HOME/rdbms/admin/xaview.sql
Check the following parameters as well
===========================
show parameters PROCESSES (should be more 300)
show parameters NLS_LENGTH_SEMANTICS (should be BYTE)
show parameters SHARED_POOL_SIZE (should be more 472456KB)
show parameters SGA_MAX_SIZE (should be more 472456KB)
show parameters DB_BLOCK_SIZE (is greater than or equal to 800KB)
show parameters OPEN_CURSORS (should be more 800)