OBIEE 11g: Error: "Blacklisted connection pool" Causes BI Server / NQServer to Crash

(Doc ID 1684120.1)

Last updated on DECEMBER 27, 2017

Applies to:

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


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

[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.


[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


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