Manual modification of the OID database is not supported. The proper way is to always restore from a valid backup. However, in certain circumstances you may need to delete the duplicate rows from the CT_DN table. In such circumstances you may need to follow the steps given below. You MUST take a backup of system…
1) Finding the GUID of a User a. Using SQL SQL> select guid from portal.wwsec_person$ where user_name = ‘<user_name>’; b. Using ldapsearch: ldapsearch -h myhost -p 3060 -D cn=orcladmin -w <GUI_password_for_orcladmin_user> -b “” -s sub “cn=<cn_for_problem_user>” “*” orclguid 2) Manually updating a users GUID SQL> update portal.wwsec_person$ set guid = <OID_user_GUID> where user_name =’user_name’; SQL>…
I had a recent activity which involved configuring Oracle BI Applications to utilize the preconfigured reports that come with it. I was able to do the entire setup on my Dell Vostro with 4GB RAM and 2.2 GHz processer, but for better performance I would recommend better hardware. When I initially started I had difficulty…