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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

XE 18 database connection (NLS trouble ?)

Accepted answer
8
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!