Categories
- All Categories
- Oracle Analytics Learning Hub
- 23 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
XE 18 database connection (NLS trouble ?)
Summary
Cannot create a database connection
Content
Hi,
Filling the fields for creating a XE 18 database connection, an error occured.
See the following log error
[nQSError: 17001] Code d'erreur Oracle : 12705, message : ORA-12705: Cannot access NLS data files or invalid environment specified
at OCI call OCISessionBegin.
********** Task: 1. Running for (mls): 187 **********
Description: Execute Query
Repository Name: ssi
Catalog: Sample Targets Lite
Tenant:
Tenant ID:
Service Name:
User: weblogic
Session ID: 0x1830000
Request ID: 0x1830003
ProcedureID: 1000230
Logical SQL:{call NQSExternalVerifyConnection('<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>OCI 10g/11g</cm:cliName><cm:targetName>Oracle 11g</cm:targetName><cm:providerName>oracle</cm:providerName></cm:dsMetadata><cm:connectionParameters><cm:inputParameter><cm:paramName>retry-delay</cm:paramName></cm:inputParameter><cm:inputParameter><cm:paramName>retry-limit</cm:paramName></cm:inputParameter></cm:connectionParameters><cm:dsSignon><cm:dsn>soutou-HP:1521/XE</cm:dsn><cm:host>soutou-HP</cm:host><cm:port>1521</cm:port><cm:serviceName>XE</cm:serviceName><cm:userName>eod</cm:userName><cm:password>XXXXXX</cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass><cm:sslType>NoSSL</cm:sslType></cm:dsSignon><cm:enablePooling>true</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>1200</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>', '''weblogic''.''sboob1''')}
An unresolved post seems to be similar
https://cloudcustomerconnect.oracle.com/posts/5bcac7818d
Best regards
Version
12.2.5.2.0-20190413174153
Answers
-
Are you sure about the settings you entered?
I believe 18c XE is installed by default as a pluggable database, and "XE" is the CDB, not the PDB (at least based on some default 18c XE installs I have around).The PDB is called "XEPDB1" by default (if not wrong), but you can anyway check that in your own database to make sure about the names of the CDB and PDB.
0 -
Hi Gianni, Thanks
I tried with XE CDB and XEPDB1 as PDB, the problem still exists
I read Oracle MOS document relating to this error message "Error ORA-12705: Cannot access NLS data files or invalid environment specified", they advise to delete or rename NLS_LANG in Windows registry
See the pdf joined, the sql+ test, the entry of tnsnames, the non presence of NLS_LANG and the error in the xml fragment quoting Oracle 11g ?
0 -
Bonjour Christian,
Just to be sure I get the whole picture: you are using Data Visualization Desktop and have Oracle 18c XE installed on Windows on the same PC/laptop (or another one in the same network which can be joined just by its host name).
Right?Just to give it a try on my side to see how it looks like, knowing that my 18c XE is linux based (in my mind Oracle products and Windows struggle to match
)0 -
Salutare Gianni
Yes both DVD and XE18c same PC
I reinstall the latest version of DVD and set you the logs (C:\Users\soutou\AppData\Local\Temp\DVDesktop\logs\OBIS\obis1-diagnostic.log) after attempt a connection
0 -
Problem solved : I deleted an old NLS_LANG variable in Windows environment
It certainly overwriting the ODVD setting default.
Thanks for the time
0
