*************************************** 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] : 2 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 /home/oracle/db/app/oracle/product/11.2.0/dbhome_1 as ORACLE_HOME. The ORACLE_HOME ==> /home/oracle/db/app/oracle/product/11.2.0/dbhome_1 IS VALID ###### Get the database connect string ###### ## Enter the OIM database connect string in following format //HostIPAddress:Port/ServiceName //localhost:1521/orcl 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 account load: ********************************** 1) DB Table 2) CSV File 3) Exit Enter your option (1, 2 or 3): 2 Do you know the Application Instance name? (Y,y,N,n) y Enter the Application Instance name: BadgeAccess Enter the comma separated CSV file names (parent CSV followed by child CSVs): BadgeAccessParent.csv,BadgeAccessChild.csv Enter the comma separated names of columns linking data between parent and child : UD_BAD3805_ACCOUNTID 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-YY 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 Enter the User Login ID. It will be used for determining provisioned by for Accounts using Bulk Load utility ------------------------------------------------------------- Enter the User ID (USR_LOGIN): xelsysadm Username: Username: Processing started .... SQL*Loader: Release 11.2.0.1.0 - Production on Tue Jun 23 23:33:29 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Load completed - logical record count 5. SQL*Loader: Release 11.2.0.1.0 - Production on Tue Jun 23 23:33:29 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Load completed - logical record count 5. ******************************************************************************************************************** ****** Account load complete. For details check file ../logs_20150623_2331/oim_blkld_account_load_summary.log ****** ******************************************************************************************************************** ****** RE-BUILDING INDEXES and ENABLING CONSTRAINTS ****** ************** THIS MAY TAKE SOMETIME ************** ****** Indexes and FK constraints successfully enabled ****