OBIEE 12c: How To Update odbc.ini For Failover Of Repository Database Hosts
Last updated on FEBRUARY 26, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.171017 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 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.
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