Deleting duplicate users in Oracle Portal

May 15, 2012

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.

Oracle Portal

Posted by:

anandmandilwar

Enterprise Solutions Architect with 8x AWS Certified & Project Management Professional (PMP). Passionate about solving customer problems through innovative solutions and improving operational efficiency by automating everything possible.

About Me

I’m a Hands-On Technical & Entrprise Solutions Architect based out of Houston, TX. I have been working on Oracle ERP, Oracle Database and Cloud technologies for over 20 years and still going strong for learning new things.

You can connect me on Linkedin and also reach out to me

I am certified for 8x AWS, OCP (Oracle Certified Professionals), PMP, ITTL and 6 Sigma.

Disclaimer

This is a personal blog. Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. Any script available on the blog post MUST be tested before they are run against Production environment.

My Journey to the cloud…