Saturday, October 29, 2011

Refreshing GUID in obiee11g

Hi,

To regenerate 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 to remove the modification. For information about where to locate Oracle Business Intelligence configuration files, see "Where Configuration Files are Located" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
1.Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:
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.
2.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.
3.Restart the Oracle Business Intelligence 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 NQSConfig.INI back to NO.
Important: You must perform this step to ensure that your system is secure.
5.Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.
6.Restart the Oracle Business Intelligence system components again using opmnctl:
cd ORACLE_HOME/admin/instancen/bin
./opmnctl stopall
./opmnctl startall
   

For More:
 Refreshing in obiee11g
good one
http://obiee11gqna.blogspot.com/2011/10/obiee11g-updating-guids.html

http://varanasisaichand.blogspot.com/2011/08/refresh-user-guids-obiee-11g.html
http://gerardnico.com/wiki/dat/obiee/migration


Reading the Oracle Documentation I see that the refresh of GUIDs need to be done for Presentation services as well. http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/privileges.htm#CHDHGAAH

Thanks

Deva

No comments:

Post a Comment