Oracle IAM and IDM Required Schema Creation

In order to use Oracle Data Base as a backing store for an IDM/IAM repository you will have to run the RCU utility outlined below.

Note: Make sure to increase PROCESSES and OPEN_CURSORS before running RCU

ALTER SYSTEM SET PROCESSES=500 SCOPE=SPFILE;
ALTER SYSTEM SET OPEN_CURSORS=1000 SCOPE=SPFILE;

Restart the db to take effect

The RCU Utility only works from windows, it will prompt for a pssword,

The only supported db is 11gr2 not 12c

 rcu.bat -silent -createRepository -connectString iam1:1521:ORCL -dbUser sys -dbRole sysdba -schemaPrefix DEV -component OIM -component MDS  -component SOAINFRA -component ORASDPM -component OPSS

rcu -silent -createRepository -connectString iam1:1521:ORCL -dbUser sys -dbRole sysdba -schemaPrefix DEV -component MDS  -component IAU-component OPSS -component OAM

rcu -silent -createRepository -connectString iam1:1521:ORCL -dbUser sys -dbRole sysdba -schemaPrefix DEV -component OID

rcu -silent -createRepository -connectString iam1:1521:ORCL -dbUser sys -dbRole sysdba -schemaPrefix DEV -component OIM -component MDS  -component SOAINFRA -component ORASDPM -component OPSS -component OAM -component IAU

We run this – For OIM, OAM & OID (or just rcu.bat and check off whats needed)

rcu.bat -silent -createRepository -connectString iam1:1521:ORCL -dbUser sys -dbRole sysdba -schemaPrefix DEV -component OIM -component MDS  -component SOAINFRA -component ORASDPM -component OPSS -component OAM -component IAU -component OID0

Select the schema options below

SYS_OIM
SYS_OAM
SYS_SOAINFRA
SYS_MDS
SYS_ORASDPM
SYS_OPSS

Next set the password, by running.

create user SYS_OIM identified by password;
create user SYS_OAM identified by password;
create user SYS_SOAINFRA identified by password;
create user SYS_MDS identified by password;
create user SYS_ORASDPM identified by password;
create user SYS_OPSS identified by password;

Next, garnet access,by running.

grant create session, grant any privilege to SYS_OAM;
grant create session, grant any privilege to SYS_OAM;
grant create session, grant any privilege to SYS_SOAINFRA;
grant create session, grant any privilege to SYS_MDS;
grant create session, grant any privilege to SYS_ORASDPM;
grant create session, grant any privilege to SYS_OPSS;

References

http://idm.guru/access-governance/deploying-the-iam-suite-with-the-deployment-wizard
http://onlineappsdba.com/index.php/2014/01/30/oracle-iam-installation-changes-in-11gr2-ps2-11-1-2-2/
http://oracleidentity.com/Oracleidentity11gR2PS2-install.htm