To load Roles Membership in OIM, follow the below steps:
Step 1: Copy the “oimbulkload” folder from OIM machine to database machine (i.e. the machine where Oracle database is installed and used by OIM). If database is on the OIM machine itself then skip this step.
The oimbulkload folder is present in the following location:
MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload
Step 2: Create the .csv file and place it in /oimbulkload/csv_files folder.
(Some of the sample csv files are present in / oimbulkload/sample_data folder which can be used as reference).
The Rolem.csv file looks like,
UGP_NAME,USR_LOGIN
CRM Administrator,jbaker
CRM Administrator,abadal
AD Admin,ukumar
AD Admin,akumar
CRM Administrator,jbaker
CRM Administrator,abadal
AD Admin,ukumar
AD Admin,akumar
Step 3: Create a .txt file named master.txt. Enter the name of the csv file which you want to use for bulk load operation and place it in /oimbulkload/csv_files folder.
Step 4: The following variables need to be set before we execute the bulk load script:
JAVA_HOME: path till jdk
eg: export JAVA_HOME=/home/oracle/jdk1.7.0_25
ORACLE_HOME: path till db_home
eg: /home/oracle/app/oracle/product/11.2.0/dbhome_1
Step 5: Stop Oracle Identity Manager server.
Step 6: Execute bulkload script
Go to /oimbulkload/scripts directory and run below command :
./oim_blkld.sh
It will prompt to ask which script to run.
Select option 5. Load Role Membership.
Press enter if you have set ORACLE_HOME , otherwise give the path till DB_HOME.
Enter db details:
//HostIPAddress:Port/ServiceName
Enter the OIM schema user name.
Enter the OIM schema password.
Enter the OIM schema password again.
Select the type of input which will be used to get data. In this case, we are taking data from a csv file, so enter 2.
Enter the file which contains the list of csv files to be used as input. In this case, enter “master.txt”.
Enter the name of the tablespace to be used for creating custom objects. In this case, we are using the default tablespace (R2PS2_OIM)
It also gives us an option whether we want to insert log messages or not. Enter Y or N, as needed.
Role Memberships are created successfully in OIM.
Happy Learning!!!
Hi Anand,
ReplyDeleteI am trying the load the role membership. Using a cvs file for the same.
This is the content for CSV,
UGP_NAME,USR_LOGIN
OPERATORS,OIMINTERNAL
But once i run the bulk upload utility for role, I am getting the below error,
SQL*Loader: Release 11.2.0.1.0 - Production on Fri Oct 14 10:25:08 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-350: Syntax error at line 1.
Expecting field-name, found ",".
OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( , "UGP_NAME"
Can you please advice.
Its urgent.
Open file in Notepad++,Select all the data and go to Edit Tab ->Blank Operations ->Trim Trailing Spaces
DeleteThanks Pankaj!!!
DeleteLooks like there are no blank spaces at the end. But still it gives that error error described above. Tried Notepad++, select all data, go to edit tab -> Blank Operations -> Trim Trailing Space. It did not work.
DeleteDespite being mechanical in nature, the hydraulic type is more common than other types. Its weight ranges are estimated at up to 10 million lbs while its accuracy is valued at 0.25%. yük hücresi
ReplyDelete