DB Provisining

DB Provisioning


Creating DataBase table

First connect to SQLPLUS from cmd
c:\sqlplus

Username: sys as sysdba
give password

then connect as system/<pwd>

sql>connect system/<password>;

then create table using blow command

create table MY_USERTEST ( USER_ID varchar2(4000 BYTE) NOT NULL ENABLE,
FIRST_NAME varchar2(4000 BYTE),
LAST_NAME varchar2(4000 BYTE),
PASSWORD varchar2(4000 BYTE),
EMAIL varchar2(4000 BYTE),
PHONE_FIX varchar2(4000 BYTE),
PHONE_MOBILE varchar2(4000 BYTE),
USER_STATUS varchar2(4000 BYTE),
Location varchar2(4000 BYTE),
Country varchar2(4000 BYTE),
CONSTRAINT MY_USERTEST PRIMARY KEY (USER_ID));


then insert values into the table

INSERT INTO MY_USERTEST (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, EMAIL, PHONE_FIX, PHONE_MOBILE, USER_STATUS, Location, Country)
   VALUES ('ruser10', 'ruser10', 'ruser10', 'Mvts1234', 'ruser10@rlabs.com', 2045455, 987878455, 'ENABLE', 'Hyd', 'India');


INSERT INTO MY_USERTEST (USER_ID, FIRST_NAME, LAST_NAME, PASSWORD, EMAIL, PHONE_FIX, PHONE_MOBILE, USER_STATUS, Location, Country)
   VALUES ('ruser11', 'ruser11', 'ruser11', 'Mvts1234', 'ruser11@rlabs.com', 2045455, 987878455, 'ENABLE', 'Hyd', 'India');


then go Admin Console


create Lokuptable with user staus (Enable and Disable) fields.

then go copy the connector data base folder in shown path

C:\Oracle\Middleware\Oracle_IDM1\server\ConnectorDefaultDirectory

copy Database_App_Tables_9.1.0.5.0 folder

then go to Manager connctors in Admin Console and install the connetor

we have already insall DB connector so no need to install again

Creat a GTC using required data base parameters.

then create IT Resource and using sandbox create Application Instance and publish the sandbox
then run the catalog Synchronization schedular.

then go Identity self service

the create a user in OIM and provision to the DB table.(MY_USERTEST)

record updated

DB provisioning to the DB table is done.:):)