Understand directory structures of OIM

Oracle database installation directory

/u01/app/oracle/product/11.1.0/db_1

WebLogic middleware home directory

WebLogic has been installed at the following location

/odrive/oracle/oim11g_MWH

WebLogic domain for OIM and SOA

 The directory for WebLogic the domain that contains the server components for OIM and SOA is at the following location:

/odrive/oracle/oim11g_MWH/user_projects/domains/oim11g_domain

SOA Home directory within WebLogic Middleware home

/odrive/oracle/oim11g_MWH/Oracle_SOA1

Execute Repistory Creation Utility (RCU) PART 2

Repistory Creation Utility (RCU)

·         Download the RCU software and unzip to a directory.       

   

·         Navigate to rcuHome/bin directory in a terminal

·         Execute rcu.bat command or run.sh for unix

·         Welcome screen will be displayed. Click Next to continue 

·         select Create to create schemas for OIM 

·         Enter the database connection details. Username : SYS 

·         In the Pre-Requisites check page, click next and OK in the next screens 

·         Select the Components to create schema’s and also select the schema prefix value.  Make sure that Oracle Identity Manger , Metadata Services and Oracle Platform Security Services and Oracle SOA are selected.

·         Enter the passwords for the schema’s to be created

·         Click Next to Continue

·         In the Summary page, Click on Create to create the selected schema’s

·         The required schema’s will be created and the RCU execution status will be displayed in next page

·         Click on close

Oracle Identity Manager 11gR2 PS2 Installation PART 1

Setting-up an Oracle Identity Manager 11gR2 PS2 environment

Content

1. Installing a database for Identity Management suite
2. Execute Repistory Creation Utility (RCU)
3. Install JDK
4. Install Oracle Weblogic 10.3.6
5. Install SOA 11.1.1.7
6. Install OIM
7. Configure OIM Server and Design Console Oracle Identity and Access Management 11gR2 PS2
8. Configuring Weblogic for OIM
9. Configure OIM Server and Design Console
10. Issues faced while Installation

1.      Installing a database for Identity Management suite.

 ·         Installing a database for Identity Management suite.

·         Download Oracle Database 11 g Release 2 for Microsoft Windows from

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html.

·         Download and unzip both files to the same directory ( here C drive)

·         Run setup.exe

·         If received an error, check for Oracle Hardware Minimum requirements for database installation

are met.  

·         Click on ‘yes’

·         Click on next on the step Configure Security Updates

·         Select Create and Configure database on the installation Option step, click on next

·         Select System Class 

·         On step Typical Installation enter the details , set Global database name as OMDB(in our case) and set administrative password. Click on Next

·         Prerequisite Checks are completed, click on next

·         Review the Summary window to verify what is to be installed. Then, click Install

·         The Progress window appears

·         Once Database installation is completed, Configuration Assistant Window appears. 

·         Click OK

·         Click Exit

·   To Test Database Installation is Completed successfully, Login to the Database Control URL in the

Configuration assistant window 

https://localhost:1158/em

·  Enter SYSMAN as the User Name and enter the Password, and then click Login

·         The database Control Home page appers. Thus installation was successful

Install and Configure Connector

 Install OUD Connector
1. Extract OID-11.1.1.5.0.zip.
2. Copy it to the following directory.

$ cd /app/software

$ cd /app/software

$ cp -r OID-11.1.1.6.0/ /app/Middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/

Unzip OID-11.1.1.6.0.zip

3. Hit the Sysadmin console in a new browser window.
4. Login as ADMIN.
5. In the Provisioning Configuration menu, click on Manage Connector.
6. A new Connector Management window will pop up. Click on Install button.
7. From the Connector List list, select ODSEE/OUD/LDAPV3 Connector 11.1.1.6.0. This list displays the names and release numbers of connectors whose installation files you copy into the default connector installation directory.

8.From the Connector List list, select ODSEE/OUD/LDAPV3 Connector 11.1.1.6.0. This list displays the names and release numbers of connectors whose installation files you copy into the default connector installation directory.

9. Click Load.

10. To start the installation process, click Continue

11. If all three tasks of the connector installation process are successful a message indicating successful installation is displayed

QUERY to get the IT Resource and Application Instance

QUERY to get the IT Resource and Application Instance

SELECT

    app_instance_name,

    app_instance_display_name,

    app_instance_description,

    svr.svr_name,

    app_instance_dataset

FROM

    app_instance,

    svr

WHERE

        app_instance_name LIKE '%Instance Name%'

    AND

        svr.svr_key = app_instance.itresource_key 

OIM

QUERY to get the INPUT VALUES

SELECT
mil.mil_name,MIl.Mil_kEY,
ADJ.ADJ_METHOD,ADJ.ADJ_Constructor,ADJ.ADJ_METHOD_DISPLAY,adj.adj_jar_file,
ADT.ADT_NAME,ADT.ADT_TYPE,
adp.adp_name,adp.adp_description,
evt.evt_name,
mil.mil_name
,adv.adv_name,adv.adv_desc,adv.adv_data_type,adv.adv_map_value
,adm.adm_display_value,adm.adm_map_value
,atp.atp_in_out_flag,atp.atp_type
from ADJ,ADT,ADP,evt,mil
--,ars
,adV,adm,atp
where ADJ.ADT_KEY = ADT.ADT_KEY
AND ADT.ADP_KEY = ADP.ADP_KEY
AND adp.evt_key = evt.evt_key
and evt.evt_key= mil.evt_key
---check process
--and adp.adp_key = ars.adP_Key
AND ADP.ADP_KEY = ADv.ADP_KEY
And ADT.ADT_KEY = atp.ADT_KEY
and atp.atp_key=adm.atp_key
And atp.atp_in_out_flag = 'Input'
and mil.mil_name  in ('System Validation') order by mil.mil_name

OIM Schemas

OIM Schemas

In 11g all the OIM data will get stored in database schemas XXX_OIM, XXX_SOAINFRA, XXX_ORASDPM, XXX_MDS.

XXX_OIM: This contains all the OIM specific schema.

XXX_SOAINFRA: If there are workflows configured in the environment, this schema has all of it.

XXX_ORASDPM: This is the user messaging schema.

XXX_MDS: Stores all the metadata of the environment.