<div>
ORA-12705 invalid or unknown NLS parameter value specified<br />
<br />
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.<br />
<br />
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.<br />

</div>


ORA-12705 invalid or unknown NLS parameter value specified

Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.


<div>
Solution : <br />
on *nix <br />
export NLS_LANG=<br />
<br />
on windows<br />
set NLS_LANG=<br />

</div>


Solution :
on *nix
export NLS_LANG=

on windows
set NLS_LANG=


<div>
I tried the export NLS_LANG= but same issue persists? any other ideas?
</div>


I tried the export NLS_LANG= but same issue persists? any other ideas?

<div>
<div class="content wysiwyg-content">
when we type the following URL<br />
<br />
http://name.domain.com:8107/dir/dir1/COMMON.ph_main<br />
<br />
In the Apache logs on Solaris 8 server I see the following error:<br />
<br />
mod_plsql: /dir/dir1/COMMON.ph_main HTTP-503<br />
&nbsp;ORA-12705 ORA-12705: invalid or unknown NLS parameter value specified\n<br />
<br />
How can I fix that?
</div>
</div>


when we type the following URL

http://name.domain.com:8107/dir/dir1/COMMON.ph_main

In the Apache logs on Solaris 8 server I see the following error:

mod_plsql: /dir/dir1/COMMON.ph_main HTTP-503
 ORA-12705 ORA-12705: invalid or unknown NLS parameter value specified\n

How can I fix that?

Apache invalid or unknown NLS parameter

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.

Apache Web Server

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.

Unix OS

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.