Changing RDBMS Server for Hyperion Essbase

Take the backup of old databases and restore in new database server

Navigate to \Oracle\Middleware\user_projects\epmsystem1\bin

Run resetConfigTask.bat to release the configuration with old RDBMS server

Navigate to Oracle/Middleware/user_projects/epmsystem1/bin and run the

epmsys_registry.bat to generate report (to check the details of Hyperion Products and RDBMS information)

Run the EPMSystemConfiguration with new Database Server name.

Check reg.properties file whether this updated the RDBMS server or not.

reg.properties file will be located under \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0

Restart the EPMSystem

To check whether Essbase is running or not run the below command through Command Prompt

\Oracle\Middleware\user_projects\epmsystem1\bin>opmnctl status

Places where changes happened

Table Name : dbo.HSS_COMPONENT 
In this table in two places updated old server name with new server name

Table Name : dbo.HSS_COMPONENT_PROPERTY_VALUES 

In this table in 3 places updated old server name with new server name

Updated reg.properties file with new RDBMS server name

Now i have changed RDBMS server successfully and everything working fine.