OBIEE 11g: Error: "Blacklisted connection pool" Causes BI Server / NQServer to Crash (Doc ID 1684120.1)

Last updated on SEPTEMBER 25, 2015

Applies to:

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

Symptoms

When attempting to use OBIEE, the BI Server shuts down with the following error occurring in NQServer.log file:

ERROR
-----------------------
[43143] Blacklisted connection pool: '".......l"'
[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004yN2nm6CwBP985njx0iZ0006mV00002H,0:6363] [tid: 403ee940] [nQSError: 17010] SQL statement preparation failed. [[
[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist  at OCI call OCIStmtExecute.

OR

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 28001, message: ORA-28001: the password has expired
 at OCI call OCISessionBegin.
[nQSError: 43059] Init block '...': Dynamic refresh of repository scope variables has failed.
]]
[2015-07-21T16:42:56.000+03:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [43143] Blacklisted connection pool: '"..."'
[2015-07-21T16:42:56.000+03:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [43144] Skipping execution of Initialization Block: '...' due to blacklisted Connection Pool



Cause

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