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)

1 comment:

  1. Oracle Access Management Online Training
    http://www.21cssindia.com/courses/oracleaccessmanagement-online-training-5.html
    Introduction to Identity and Access Management Systems
    Introduction to Oracle Access Manager
    Installing Oracle Access Manager Identity System
    Configuring Identity System Object Classes
    Creating Derived Attributes
    Configuring Tabs, Profile Pages, and Panels
    Configuring Access Controls in Identity System
    Access System Configuration
    Configuring Policy Domains and Policies
    Configuring User Authorization
    Managing Access Servers
    Configuring Single Sign-On and Integrating with Oracle WL Single Sign-On
    If you are seeking training and support you can reach me on 91-9000444287

    ReplyDelete