It’s important to validate your catalog when you just finish Catalog upgrade. Here are the detailed steps:
1) Stop the BI Services from EM
2) Take the backup of Catalog, instanceconfig.xml and nqConfig.ini into a separate folder.
3) Update the Catalog element in instanceconfig.xml,
Locate the Catalog element and update it as follows:
<Catalog>
<Validate>OnStartupAndExit</Validate>
<ValidateAccounts>Clean</ValidateAccounts>
<ValidateHomes>Report</ValidateHomes>
<ValidateItems>Clean</ValidateItems>
<ValidateLinks>Clean</ValidateLinks>
</Catalog>
4) Start the BI Services from EM
Note: Once you have started the BI Services, catalog validation will be done. Presentation Services will be stopped automatically once validation completed.
5) Now restore the backup version of the instanceconfig.xml that you created earlier in step-2.
6) Restart the BI Services from EM
Refer to http://obipro.blogspot.com/2014/09/obiee-11g-refresh-guids-and-validate.html
Tank Liu's Techlog 