[BangPypers] ORA-12705: Cannot access NLS data files or invalid environment specified

Wah Meng Wong wah_meng at yahoo.com
Tue Mar 8 05:13:50 CET 2011

Hello there,

My oracledb module on HP-UX is unable to connect to database when I export 
environment variable NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK". There is no 
issue when such environment variable is exported and the SQLPLUS is issued. The 
DBA determined that this is an application error. Does anyone know this might be 
related to the some national language library not properly installed on the 
server? I noticed that there is no $ORACLE_HOME/ocommon folder on my server 
where Oracle installed is 11g, and I googled that environemnt variable ORA_NLS33 
by default is pointing to $ORACLE_HOME/ocommon/nls/admin/data. Or ORA_NLS33 is 
no longer in use for Oracle 11g?  

$ python
Python 1.5.2 (#9, May 23 2000, 14:18:02) [C] on hp-uxB
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import oracledb
>>> a=oracledb.oracledb("gen812ora8/gen812db1ora8 at DB1ORA9")
Traceback (innermost last):
  File "<stdin>", line 1, in ?
OracleDbError: LOGON caused a ORA-12705: Cannot access NLS data files or invalid 
environment specified

$ uname -a
HP-UX zmy02hp3 B.11.31 U ia64 3240906838 unlimited-user license
$ sqlplus gen812ora8/gen812db1ora8 at DB1ORA9

SQL*Plus: Release - Production on ÅúóÖѱ 3åô 8 12:10:24 2011
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Data Mining option
With the Data Mining option

Wah Meng


More information about the BangPypers mailing list