OBIEE 12c: How To Update odbc.ini For Failover Of Repository Database Hosts

(Doc ID 2364189.1)

Last updated on FEBRUARY 26, 2018

Applies to:

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

Goal

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 top all 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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms