My Oracle Support Banner

OBIEE 12c: How To Update odbc.ini For Failover Of Repository Database Hosts (Doc ID 2364189.1)

Last updated on DECEMBER 06, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


For OBIEE 12c, the repository schemas reside on database instance with host failover configured as follows:



The two hosts host1 and host2, are exadata machines that are periodically switched in primary and backup status.

Every time there is a switch, there is a need to update the "hostname" entries in the server odbc.ini file to point to the primary host or secondary host ($DOMAIN_HOME/config/fmwconfig/bienv/core/odbc.ini).

This note details the steps update the "hostname" entries in the server odbc.ini to account for hosts failover.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.