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, …
