Home > Oracle Portal > Deleting duplicate users in Oracle Portal

Deleting duplicate users in Oracle Portal

In one of our PROD application (Oracle portal), user reported that he is not able to login and getting some weird error message. Later on while troubleshooting, it was found that this is happening due to duplicate user in OID.

      How to remove the duplicate user from Oracle portal


Step1 : Login to Portal using ‘orcladmin’ accound and query the problematic user and you will see 2 entries for the same user
Step2 : Login to OID database using ‘portal’ user

a)Query wwsec_person$ table – this table is populated ONLY when the user logs into the portal
b)DELETE the entry from wwsec_person$ table. If there is an error while deleting the user, disable the below triggers, delete the record and then enable the trigger again
-portal.wwsec_pers_brd_trg
-portal.wwsec_pers_ard_trg
Step3 : Remove the entry from LDAP using ldapdelete command
-ldapdelete -h -D “cn=orcladmin” -w -p -v “”
Step4 : Confirm by running the ldapsearch command on the Infra tier
-ldapsearch -h -p -D “cn=orcladmin” -w -b ” -s base “objectclass=*” orclobjectguid

Now the user must be made to synch again with OID. This can be verified from LDAP log.

Advertisements
Categories: Oracle Portal
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: