Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
XE 18 database connection (NLS trouble ?) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

XE 18 database connection (NLS trouble ?)

Accepted answer
7
Views
5
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 5 comments

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''')}

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!