Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: Oracle Identity Manager : Use oimbulkload Utility in OIM for loading User data.

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412

    Oracle Identity Manager : Use oimbulkload Utility in OIM for loading User data.

    Before using the Bulk Load utility, you must complete these requirements:

    1) Verify that the JAVA_HOME variable is set to the base directory of your installed JDK.

    export ORACLE_HOME=/u01/accounts/ora11g/devdb/11.2.0
    export JAVA_HOME=/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64
    export PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH


    2) Verify that the JDK version is 1.5 or greater.

    3) Verify that the $OIM_HOME\server\db\oim\oracle\Utilities\oimbulklo ad\lib directory contains a copy of the ojdbc.jar file. This file can be retrieved from the
    OIM_HOME\modules\oracle.oes_11.1.1\thirdparty directory.

    cd $OIM_HOME/server/db/oim/oracle/Utilities/oimbulkload/lib
    ls $OIM_HOME/modules/oracle.oes_11.1.1/thirdparty
    cp $OIM_HOME/modules/oracle.oes_11.1.1/thirdparty/ojdbc5.jar $OIM_HOME/server/db/oim/oracle/Utilities/oimbulkload/lib

    4) At the minimum, you must have the USR_LOGIN,USR_FIRST_NAME, and USR_LAST_NAME columns in your input source.

    5) OIM_BLKLD_USRSEQ field should exist

    6) Verify that you have write permission to the directory from which you started executing the Bulk Load utility. This permission enables the directory to create the logs directory for the transaction you are executing.

    7) NOTE : that the following default values are inserted into Oracle Identity Manager if the table does not contain values for these columns:

    ORG_NAME: Xellerate Users

    USR_TYPE: End-User

    USR_STATUS: Active

    USR_EMP_TYPE: Full-Time



    Example to load the data :
    ===================
    Create the table with data as the Input Source :

    create table dev_oim.my_users
    (OIM_BLKLD_USRSEQ NUMBER(19),USR_FIRST_NAME varchar2(20),USR_LAST_NAME varchar2(20),USR_LOGIN varchar2(20));

    insert into dev_oim.my_users values (1,'Miguel','Vives','Miguel');
    insert into dev_oim.my_users values (2,'Vaishali','Gupta','Vaishali');
    insert into dev_oim.my_users values (3,'Varun','Prasad','Varun');
    insert into dev_oim.my_users values (4,'Hemant','Fulfagar','Hemant');
    commit;


    ora11g@dbaquest scripts]$ ./oim_blkld.sh




    ***************************************
    M A I N M E N U
    ***************************************

    Select the operation to perform:
    1) Load User Data
    2) Load Account Data
    3) Load Role Data
    4) Load Role Hierarchy
    5) Load Role Membership
    6) Load Role Category
    7) Generate Audit Snapshot
    8) Exit


    ## Enter your option [1-8] :
    1





    Checking whether JAVA_HOME is set

    JAVA_HOME is set.
    Checking if the version is correct

    Java version is correct.






    ---------------------------
    Enter Database Details:
    ---------------------------

    ################################################## ####
    ###### ENTER DATABASE INFORMATION #######
    ################################################## ####

    ###### Get the ORACLE_HOME #######

    ## Enter the ORACLE HOME directory or Press [Enter] to
    accept the default /u01/accounts/ora11g/devdb/11.2.0 as ORACLE_HOME.


    The ORACLE_HOME ==> /u01/accounts/ora11g/devdb/11.2.0 IS VALID


    ###### Get the database connect string ######

    ## Enter the OIM database connect string in following format //HostIPAddress:Port/ServiceName

    //dbaloungeapps:1925/devdb

    The database is successfully pinged using the given connect string.



    ###### Get the Oracle Identity Manager Database schema user name #######

    ## Enter Oracle Identity Manager(OIM) database user name

    DEV_OIM

    The OIM database user name entered is ==> DEV_OIM

    ###### Get the Oracle Identity Manager password #######

    NOTE : You will need to enter OIM database user password twice.
    ## Enter password for Oracle Identity Manager (DEV_OIM) database user


    **** Password Entered ****

    ==== Attempting to connect to OIM database ====


    Connection to OIM database is established successfully...





    Compiling Procedures ....




    Compilation done...


    Enter password for OIM database user again :
    **********************************
    Select the input for user load:
    **********************************
    1) DB Table
    2) CSV File
    3) Exit

    Enter your option (1, 2 or 3):
    1

    Enter the name of the DB table, to be used as load source:
    DEV_OIM.ALL_USERS

    Enter the comma separated column names, to be loaded, of table DEV_OIM.ALL_USERS :
    USR_FIRST_NAME,USR_LAST_NAME,USR_LOGIN

    Enter the Name of tablespace to be used for creating custom objects, by the utility [DEV_OIM]:

    DEV_OIM is selected as default tablespace

    Enter the batch size for processing ( default size is 10000 ) :


    Do you wish to insert log msgs (This will impact performance) (y/Y/n/N) :
    y
    -------------------------------------------------------------
    Utility expects you to create a User using OIM web console
    and enter a password for this user, which will be used as
    initial password for all users loaded using Bulk Load utility
    -------------------------------------------------------------

    Enter the User ID (USR_LOGIN), of the user created from web console :
    xelsysadm
    Exception table name EV_OIM.ALL_USERS_EX1


    Processing TMP table: DEV_OIM.ALL_USERS


    ************************************************** ************************************************** ****************
    ****** User load for table 'DEV_OIM.ALL_USERS' complete.
    For details check file ../logs_20120411_2255/oim_blkld_user_load_summary.log ******
    ************************************************** ************************************************** ****************



    Doing Manager Lookup, for all users loaded by the utility.


    Done with manager key updation.


    ****** RE-BUILDING INDEXES and ENABLING CONSTRAINTS ******
    ************** THIS MAY TAKE SOMETIME **************


    ****** Indexes and FK constraints successfully enabled ******



    The data Load Operation is Complete.
    Last edited by Hemant; 04-18-2012 at 02:21 AM.
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412
    Log Table Post Bulk Load :



    SQL> l
    1* select * from DEV_OIM.OIM_BLKLD_LOG
    SQL>



    MSG_SEQ_NO LOG_LEVEL
    ---------- --------------------
    MSG
    --------------------------------------------------------------------------------
    MODULE LOAD_SOURCE CREATE_DA
    -------------------- ---------------------------------------- ---------
    2 DEBUG
    INSERT INTO USR ( ACT_KEY , USR_CHANGE_PWD_AT_NEXT_LOGON , USR_CREATE , USR_CREA
    TEBY , USR_CREATED , USR_DISABLED , USR_DISPLAY_NAME , USR_EMP_TYPE , USR_KEY ,
    USR_LOCKED , USR_LOGIN_ATTEMPTS_CTR , USR_MANUALLY_LOCKED , USR_PASSWORD , USR_P
    ROVISIONED_DATE , USR_PWD_RESET_ATTEMPTS_CTR , USR_ROWVER , USR_STATUS , USR_TYP
    E , USR_UPDATE , USR_UPDATEBY , USR_FIRST_NAME,USR_LAST_NAME,USR_LOGIN )
    select 1,
    '1',
    '29-JUL-12',
    1,
    '29-JUL-12',
    '0',
    USR_FIRST_NAME||' '||USR_LAST_NAME, 'Full-Time',
    USR_SEQ.NEXTVAL, '0',
    0,
    '0',
    '0776:UW02cuu0Qs8ua7mh/WfU/Q==',
    '29-JUL-12',
    '0',
    '0000000000000000',
    'Active',
    'End-User',
    '29-JUL-12',
    1,
    USR_FIRST_NAME,USR_LAST_NAME,UPPER(USR_LOGIN) from DEV_OIM.MY_USERS
    where OIM_BLKLD_USRSEQ >= 1 AND
    OIM_BLKLD_USRSEQ < 10001
    USER DB Table 12-JUL-29

    3 DEBUG
    Working on USR_KEY between : 62 and 65
    USER DB Table 12-JUL-29

    4 PROGRESS_MSG
    Number of Records Loaded: 4
    USER DB Table 12-JUL-29

    5 PROGRESS_MSG
    Start Time: 29-JUL-12 10.08.57.668746 PM
    USER DB Table 12-JUL-29

    6 PROGRESS_MSG
    End Time: 29-JUL-12 10.09.01.313500 PM
    USER DB Table 12-JUL-29

    7 PROGRESS_MSG
    Number of Records Processed: 4
    USER DB Table 12-JUL-29

    8 PROGRESS_MSG
    Number of Records Loaded: 4
    USER DB Table 12-JUL-29

    9 PROGRESS_MSG
    Number of Records Rejected: 0
    USER DB Table 12-JUL-29


    8 rows selected.
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412
    No Exceptions in The Bulk Load :

    SQL> select * from dev_oim.MY_USERS_EX1;

    no rows selected

    SQL>
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412
    TO Load Data from CSV Files :

    CSV File Contents :

    Location :
    $OIM_HOME/server/db/oim/oracle/Utilities/oimbulkload/csv_files

    [oim10sep@dbaquest csv_files]$ ls
    a.csv a.csv_old master.txt Readme.txt

    [oim10sep@dbaquest csv_files]$ cat a.csv
    USR_FIRST_NAME,USR_LAST_NAME,USR_LOGIN
    White,White,White
    Yellow,Yellow,Yellow
    Green,Green,Green
    Maroon,Maroon,Maroon
    [oim10sep@dbaquest csv_files]$ cat master.txt
    a.csv
    [oim10sep@dbaquest csv_files]$





    ---------------------------
    Enter Database Details:
    ---------------------------

    ################################################## ####
    ###### ENTER DATABASE INFORMATION #######
    ################################################## ####

    ###### Get the ORACLE_HOME #######

    ## Enter the ORACLE HOME directory or Press [Enter] to
    accept the default /u03/oim10sep/Oracle/ohome as ORACLE_HOME.


    The ORACLE_HOME ==> /u03/oim10sep/Oracle/ohome IS VALID


    ###### Get the database connect string ######

    ## Enter the OIM database connect string in following format //HostIPAddress:Port/ServiceName

    //dbaloungeapps.com:1970/devoim

    The database is successfully pinged using the given connect string.



    ###### Get the Oracle Identity Manager Database schema user name #######

    ## Enter Oracle Identity Manager(OIM) database user name

    dev_oim

    The OIM database user name entered is ==> dev_oim

    ###### Get the Oracle Identity Manager password #######

    NOTE : You will need to enter OIM database user password twice.
    ## Enter password for Oracle Identity Manager (dev_oim) database user


    **** Password Entered ****

    ==== Attempting to connect to OIM database ====


    Connection to OIM database is established successfully...





    Compiling Procedures ....




    Compilation done...


    Enter password for OIM database user again :
    **********************************
    Select the input for user load:
    **********************************
    1) DB Table
    2) CSV File
    3) Exit

    Enter your option (1, 2 or 3):
    2

    Enter the name of the master file containing names of all CSV file to be loaded:
    master.txt

    Enter the Name of tablespace to be used for creating custom objects, by the utility [DEV_OIM]:

    DEV_OIM is selected as default tablespace

    Enter the date format for data load:
    DD-MON-YYYY

    Enter the batch size for processing ( default size is 10000 ) :


    Do you wish to insert log msgs (This will impact performance) (y/Y/n/N) :
    n
    -------------------------------------------------------------
    Utility expects you to create a User using OIM web console
    and enter a password for this user, which will be used as
    initial password for all users loaded using Bulk Load utility
    -------------------------------------------------------------

    Enter the User ID (USR_LOGIN), of the user created from web console :
    xelsysadm
    Username:


    Processing File: a.csv

    SQL*Loader: Release 11.2.0.1.0 - Production on Mon Sep 17 08:56:10 2012

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


    Load completed - logical record count 4.

    ************************************************** ************************************************** ****************
    ****** User load for CSV 'a.csv' complete.
    For details check file ../logs_20120917_0854/oim_blkld_user_load_summary.log ******
    ************************************************** ************************************************** ****************



    Doing Manager Lookup, for all users loaded by the utility.


    Done with manager key updation.


    ****** RE-BUILDING INDEXES and ENABLING CONSTRAINTS ******
    ************** THIS MAY TAKE SOMETIME **************


    ****** Indexes and FK constraints successfully enabled ******


    [oim10sep@dbaquest scripts]$
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

+ Reply to Thread

Similar Threads

  1. Oracle Identity Manager 11g R2 Administration - OIM 11G Training Course Content
    By Hemant in forum Oracle Administration Training Modules, Online Exam Assessment for OCA, OCP Certfication
    Replies: 2
    Last Post: 04-25-2013, 12:51 PM
  2. Oracle GRC and Oracle Identity Management
    By mdmasood in forum Oracle Fusion Middleware 11G
    Replies: 1
    Last Post: 07-06-2012, 08:54 PM
  3. Replies: 0
    Last Post: 01-10-2012, 06:22 PM
  4. Purge concurrent request and/or manager data
    By sneha in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 12-08-2011, 01:53 PM
  5. Responsibility not visible to the user in list of responsibilities assigned to user
    By Amit in forum SCRIPTS : Users,Profiles,Applications & Responsibilities,Forms,JDBC Sessions
    Replies: 0
    Last Post: 11-03-2011, 04:37 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics