My Oracle Support Banner

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

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
Goal
Solution
References


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