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
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