"ORA-12705 Cannot access NLS data files or invalid environment specified" When Testing Connections To ODI Data Server

(Doc ID 471749.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

When testing the connection to an Oracle Data Server in the Oracle Data Integrator (ODI) Topology > Physical Architecture, the following message is signalled:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
  ...

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms