[OBIEE 11g] Refresh User GUIDs

 

OBIEE 11G – Refresh User GUIDs

In OBIEE 11G, sometimes it is not possible to login to the BI Application after the migration even with weblogic login. In that case, follow the below steps to login to the application.

Refresh the User GUIDs

If you change the directory server used as the identity store for the authentication provider, then you must refresh the user GUIDs as described below. If you do not refresh the GUIDs and the same user name exists in both directory servers (original and new), then the original user GUID might conflict with the user GUID contained in new directory server, resulting in authentication errors.

To refresh the user GUIDs:

This task requires that you manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to refresh the GUIDs on restart. Once completed, you edit these files to remove the modification.

1.   Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:

1.   Open NQSConfig.INI for editing at:

b.ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

1.   Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:

d. FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

1.   Save and close the file.

2.   Update the ps:Catalog element in instanceconfig.xml:

1.   Open instanceconfig.xml for editing at:

b.ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/

c. coreapplication_obipsn

1.   Locate the ps:Catalog element and update it as follows:

e. <ps:Catalog xmlns:ps=”oracle.bi.presentation.services/config/v1.1″>

f. <ps:UpgradeAndExit>false</ps:UpgradeAndExit>

g. <ps:UpdateAccountGUIDs>UpdateAndExit</ps:UpdateAccountGUIDs>

h. </ps:Catalog>

1.   Save and close the file.

2.   Start the Oracle Business Intelligence system components using opmnctl:

4. cd ORACLE_BASE/admin/instancen/bin

5. ./opmnctl startall