Wednesday, 29 January 2014

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)