Hi Genius,
I have installed and configured Hyperion (11.1.2.1) Essbase & Planning successfully on windows server 2008 64 bit. For that I installed Oracle 10g Standard Edition as supported RDBMS. Due to RAM consumption I planned to install the Oracle Express Edition instead of Standard Edition. For that I export the tablespace which contains metadata of Hyperion products from existing database(SE) to current database(XE). After that I reconfigured all the Hyperion Products.
Once re-configuration completed, I tried to log-in to the Administration Server via EAS Console by providing server name as localhost and username as Admin. Then EAS console throwing error as "Could not connect to Administration server".
To solve this issue I tried following steps,
1> Remove the Cwallet.sso and create a new Cwallet.sso by using orapki bat file.
2> Backup the original ESSBASE.SEC file and rename the ESSBASE.BAK file to ESSBASE.SEC then I started the Essbase Administration service.
3> I re-installed and re-configured the EAS console.
After following these steps I am not able to overcome this issue.
For your kind information,
1> I can able to login to the Essbase through ESSCMD.
2> I can able to view the list of essbase applications through Smart View.
Kindly guide me how to overcome this issue.
Best Regards
SC