How to reconfigure OBIEE to connect to new Database Host

For some reason, your database have been moved to new host. And then you must reconfigure OBIEE application to replect the new Database Host. The following is the steps that you will do to make changes:

Change DB connection information in tnsnames.ora file:

$MW_HOME/Oracle_BI1/network/admin/tnsnames.ora

$MW_HOME/oracle_common/network/admin/tnsnames.ora

Reconfigure OBIEE using Administration Console & Enterprise Manager

Datasources:

Update new Database connection for all Data Sources as below:

BI Scheduler

configure file: $ORACLE_INSTANCE/config/OracleBISchedulerComponent/coreapplication_obisch1/ instanceconfig.xml

Start OBIEE component(opmnctl startall)

You cant also use this topic to move BI Application and Database to new hosts for many purpose, ex: Testing, Develop, …