My Oracle Support Banner

OBIEE 11g Client Admin Tool Connection To Datasource In Offline Mode Fails With Error "The Connection Has Failed" (Doc ID 1296370.1)

Last updated on SEPTEMBER 02, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version [1905] and later
Generic Windows
***Checked for relevance on 17-Jan-2019***


Created a new repository (RPD) using the Oracle Business Intelligence Enterprise Edition (OBIEE) Admin Tool.  When trying to import data in offline mode, the following error occurs with both ODBC and OCI connection:

The Connection has failed.
[OracleBIServerComponent] [nQSError: 17003] Oracle gateway error: OCIEnvNlsCreate or OCIEnvInit failed to initialize environment. Please check your Oracle Client installation and make sure the correct version of OCI libraries are in the library path.
[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
[nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12705, message: ORA-12705: Cannot access NLS data files or invalid environment specified at OCI call OCISessionBegin

You may also notice all or some of the following errors in NQSAdminTool.log. The issue is not reproducible while in Online mode.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.