List of Packages that needs install before installing IDM product

binutils-2.20.51.0.2-5.28.el6.x86_64
compat-libcap1-1.10-1.x86_64
compat-libcap1-1.10-1.i686
compat-libstdc++-33-3.2.3-69.el6 for x86_64
compat-libstdc++-33-3.2.3-69.el6 for i686
gcc-4.4.4-13.el6.x86_64
gcc-c++-4.4.4-13.el6.x86_64
glibc-2.12-1.7.el6 for x86_64
glibc-devel-2.12-1.7.el6 for x86_64
glibc-2.12-1.7.el6 for i686
glibc-devel-2.12-1.7.el6 for i686
libaio-0.3.107-10.el6 for x86_64
libaio-0.3.107-10.el6 for i686
libaio-devel-0.3.107-10.el6 for x86_64
libaio-devel-0.3.107-10.el6 for i686
libgcc-4.4.4-13.el6 for x86_64
libgcc-4.4.4-13.el6 for i686
libstdc++-4.4.4-13.el6 for x86_64
libstdc++-4.4.4-13.el6 for i686
libstdc++-devel-4.4.4-13.el6 for x86_64
libstdc++-devel-4.4.4-13.el6 for i686
libXext for i386
libXtst for i386
libXi for i386
openmotif-2.2.3 for x86_64
openmotif22-2.2.3 for x86_64
redhat-lsb-4.0-3.el6 for x86_64
sysstat-9.0.4-11.el6

list of tables used in oim

Connect to the database:

sqlplus username/password@database-name

To list all tables owned by the current user, type:

select tablespace_name, table_name from user_tables;

To list all tables in a database:

select tablespace_name, table_name from dba_tables;

To list all tables accessible to the current user, type:

select tablespace_name, table_name from all_tables;

You can find more info about views all_tables, user_tables, and dba_tables in Oracle Documentation. To describe a table, type:

desc <table_name>

How to find schema version of fusion middleware components

 SQL>Select * from schema_version_registry;

find list of tables in OIM schema

sqlplus "/as sysdba"

select table_name from DBA_TABLES where owner='DEV_OIM';


SELECT *
  FROM DEV_OIM.USR where USR_LOGIN='XELSYSADM';

If you get this type of error then follow below fix

Error:

RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at /u01/app/oracle/logdir.2015-07-23_18-26/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 /u01/app/oracle/logdir.2015-07-23_18-26/rcu.log for details.

Fix:

sqlplus "/as sysdba"

@<ORACLE_HOME>/javavm/install/initxa.sql
@<ORACLE_HOME>/rdbms/admin/xaview.sql


and also check the below parameters


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)