OBIEE 11g: How To Restore a Blacklisted Connection Pool Without a Restart (Doc ID 2086161.1)

Last updated on MAY 19, 2017

Applies to:

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

Goal

When an OBIEE database connection becomes Blacklisted, is there an alternative method to restore the database connection
without having to restart OBIEE ?

Once OBIEE 11g detects a database connection is down, it internally marks it as a Blacklisted Connection
and the affected Initialization Block will not attempt a connection until the Blacklisted tag is removed by
an OBIEE restart. This Doument provides alternative methods to restore the Database connection without
requiring an OBIEE restart

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