OBIEE Connection to the Database from Administration Tool in Online Mode Produces Error: "The Connection has failed" (Doc ID 1605206.1)

Last updated on JANUARY 23, 2017

Applies to:

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

Symptoms

Connecting to a database to import metadata in online mode produces the following error, "The Connection has failed. "

The following error messages are also found in the Administration Tool Log <servername>_NQSAdminTool.log

[2013-12-03T06:02:16.000-05:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1204]  [46153] The configuration file (security.xml) was not found or is inaccessible.
[2013-12-03T06:04:19.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1204]  [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
 at OCI call OCIServerAttach.
]]
[2013-12-03T06:05:04.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1204]  [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
 at OCI call OCIServerAttach.
]]
[2013-12-03T10:15:12.000-05:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: e0c]  [46153] The configuration file (security.xml) was not found or is inaccessible.
[2013-12-03T10:15:27.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: e0c]  [nQSError: 43113] Message returned from OBIS. [[
[nQSError: 43126] Authentication failed: invalid user/password.
[nQSError: 37001] Could not connect to the Oracle BI Server instance.
]]

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