OBIEE: Refreshing / Updating GUIDs (including Clustered environment)

To regenerate user GUIDs - perform the following steps: 

(Note: In clustered environment GUID regeneration must occur with only one node operating at a time). 

1. Stop Oracle BI Server and Presentation Services on all nodes except where you are regenerating the user GUIDs.

cd ORACLE_BASE/admin/instancen/bin
./opmnctl stopproc ias-component=coreapplication_obips1 
./opmnctl stopproc ias-component=coreapplicaiton_obis1


2. Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI file:
    a. Open NQSConfig.INI for editing at:
        ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

    b. Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:
        FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
    c. Save and close the file.

3. Update the Catalog element in instanceconfig.xml:
    a. Open instanceconfig.xml for editing at:
        ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obipsn

    b. Locate the Catalog element and update it as follows:
        <Catalog>
        <UpgradeAndExit>false</UpgradeAndExit>
        <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
        </Catalog>
    c. Save and close the file.

4. Restart the Oracle BI Server and Presentation Services using opmnctl:
cd ORACLE_BASE/admin/instancen/bin
./opmnctl stopproc ias-component=coreapplication_obips1
./opmnctl stopproc ias-component=coreapplication_obis1
./opmnctl startproc ias-component=coreapplication_obis1

After you confirm that the Oracle BI Server is running, then start Presentation Services:
./opmnctl startproc ias-component=coreapplication_obips1
5. Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI file back to NO. Important: You must perform this step to ensure that your system is secure.

6. Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.

7. Restart the Oracle Business Intelligence system components using opmnctl:
cd ORACLE_BASE/admin/instancen/bin
./opmnctl stopall
./opmnctl startall

Doc Reference: http://docs.oracle.com/cd/E23943_01/bi.1111/e10543/privileges.htm#BIESC721