Sometimes after enabling LDAP Sync in OIM we get error while creating user or editing the IT Resource. The reason for this error is that while configuring LDAP Sync the parameters we have provided doesn't get encrypted. Please follow the steps below to solve this error.
1) Open SQL Developer and make the connection to DEV_OIM Schema.
2) Run the following query:
select svr.svr_name, spd.spd_field_name, svp.svp_key, svp_field_value from svp inner join spd on spd.spd_key = svp.spd_key inner join svr on svr.svr_key = svp.svr_key;
Observe the result of the query and check which of the values are not encrypted.
3) In my case these are the values that are not encrypted. You please check all the values. Now first we have to make this value as null. But before this take the backup of the table. Run the following query.
create table DEV_OIM.svp_bkp as (select * from DEV_OIM.svp);
4) Now run the query
update svp set svp_field_value=null where svp_field_value like ‘%dc%’;
run the same command for other values also. After running the command make sure you perform the commit also, otherwise the changes will not reflect.
5) we have made some value null.That value we have to provide manually in directory by editing the IT Resource as shown in figure below.
6) Now create the user. It won't show any error.
1) Open SQL Developer and make the connection to DEV_OIM Schema.
2) Run the following query:
select svr.svr_name, spd.spd_field_name, svp.svp_key, svp_field_value from svp inner join spd on spd.spd_key = svp.spd_key inner join svr on svr.svr_key = svp.svr_key;
Observe the result of the query and check which of the values are not encrypted.
|
SVR_NAME
|
SPD_FIELD_NAME
|
SVP_KEY
|
SVP_FIELD_VALUE
|
|
Directory Server
|
Admin login
|
4
|
cn=oimLDAP,cn=system
ids,dc=your domain,dc=com
|
|
Directory Server
|
Admin Password
|
5
|
oracle123
|
|
Directory Server
|
Search base
|
18
|
dc=your domain,dc=com
|
|
Directory Server
|
User reservation container
|
20
|
cn=Reserve,dc=your
domain,dc=com
|
3) In my case these are the values that are not encrypted. You please check all the values. Now first we have to make this value as null. But before this take the backup of the table. Run the following query.
create table DEV_OIM.svp_bkp as (select * from DEV_OIM.svp);
4) Now run the query
update svp set svp_field_value=null where svp_field_value like ‘%dc%’;
run the same command for other values also. After running the command make sure you perform the commit also, otherwise the changes will not reflect.
5) we have made some value null.That value we have to provide manually in directory by editing the IT Resource as shown in figure below.
6) Now create the user. It won't show any error.
No comments:
Post a Comment