<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta content="MSHTML 6.00.6000.17092" name="GENERATOR">
</head>
<body>
<div><font face="Arial" size="2">
<div style="FONT-SIZE: 10pt; FONT-FAMILY: arial,helvetica,sans-serif">Hello there,<br>
<br>
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?
<br>
<br>
$ python<br>
Python 1.5.2 (#9, May 23 2000, 14:18:02) [C] on hp-uxB<br>
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam<br>
>>> import oracledb<br>
>>> a=oracledb.oracledb("gen812ora8/gen812db1ora8@DB1ORA9")<br>
Traceback (innermost last):<br>
File "<stdin>", line 1, in ?<br>
OracleDbError: LOGON caused a ORA-12705: Cannot access NLS data files or invalid environment specified<br>
<br>
>>> <br>
$ uname -a<br>
HP-UX zmy02hp3 B.11.31 U ia64 3240906838 unlimited-user license<br>
$ sqlplus gen812ora8/gen812db1ora8@DB1ORA9<br>
<br>
SQL*Plus: Release 11.1.0.7.0 - Production on ÅúóÖѱ 3åô 8 12:10:24 2011<br>
Copyright (c) 1982, 2008, Oracle. All rights reserved.<br>
Connected to:<br>
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production<br>
With the Data Mining option<br>
With the Data Mining option<br>
SQL> <br>
<br>
Regards,<br>
Wah Meng<br>
</div>
</font></div>
</body>
</html>