If you are migrating to a new database instance then it is worth having a read of the following Oracle support document "How To Change Shared Services Database Repository in EPM 11 [ID 976279.1]"
Could you please tell me, u want to update Oracle 10g to 11g? (which u have used for hyperion configuration)
U want to upgrade Hyperion version also or u want upgrade only database for the same Hyperion version?
first check the support matrix of particular version is supports to that database or not.
Then take back up of everything, reconfigure the EPM Products again.(must take backup of every thing)
Follow the John suggested document "How To Change Shared Services Database Repository in EPM 11 [ID 976279.1]"
please mark the replies as helpful or correct
Edited by: mady on Jun 3, 2013 7:19 PM
Thanks for suggested to read the document ID 976279.1, may i know other products should use the same steps also? Sorry to ask, what other products should i change besides Shared Services?
May i know do we need to change the <bean name ="Oracle 10g"> to 11g? Because i have problem import, create and copy the BQY file.