B.1.1 Regenerating User GUIDs

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

For information about locating the Oracle Business Intelligence configuration files, see Configuration Files in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

To regenerate user GUIDs:

1. Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in the 11g NQSConfig.INI file.
   1. Open the 11g NQSConfig.INI file for editing present at these locations:
      (UNIX) 11g_DOMAIN_HOME/config/OracleBIServerComponent/coreapplication_obisn
      (Windows) 11g_DOMAIN_HOME\config\OracleBIServerComponent\coreapplication_obisn
   2. 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;
   3. Save and close the file.
2. Update the Catalog element in the 11g instanceconfig.xml file present at these locations:
   (UNIX) 11g_DOMAIN_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obipsn
   (Windows) 11g_DOMAIN_HOME\config\OracleBIPresentationServicesComponent\coreapplication_obipsn
   1. Open the instanceconfig.xml file for editing:
   2. Locate the Catalog element and update it as follows:

      <Catalog>
      <UpgradeAndExit>false</UpgradeAndExit>
      <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
      </Catalog>
      

   3. Save and close the file.
3. Restart the Oracle BI system components using opmnctl:

   cd ORACLE_HOME/admin/instancen/bin
   ./opmnctl stopall
   ./opmnctl startall
   

4. Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in the NQSConfig.INI file back to NO.

   Important:

   You must perform this step to ensure that your system is secure.
5. Update the Catalog element in the 11g instanceconfig.xml file to remove the UpdateAccount GUIDs entry.
6. Restart the Oracle BI system components using opmnctl:

   cd ORACLE_HOME/admin/instancen/bin
   ./opmnctl stopall
   ./opmnctl startall