Oracle Exalytics and OBIEE 11g: Connection Fails When Importing Data Via OBIEE 11g Admin Tool: "ORA-12705: Cannot access NLS data files or invalid environment specified..."
(Doc ID 1533240.1)
Last updated on APRIL 02, 2024
Applies to:
Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.5.0 [Release 1.0]Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
Symptoms
Using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Admin Tool to import data from an Oracle database. When running the data import wizard, the import fails with below error:
The Connection has failed
The NQSAdminTool.log shows error:
[2013-02-27T16:09:21.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: ] [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.
]]
The TNSNAMES.ORA has been defined on the OBIEE Admin Tool environment and the OBIEE server (Exalytics or standalone OBIEE server).
Cause
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
| Symptoms |
| Cause |
| Solution |