Apache invalid or unknown NLS parameter

Turbowy
Turbowy used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
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.

Commented:
Solution :
on *nix
export NLS_LANG=

on windows
set NLS_LANG=

Author

Commented:
I tried the export NLS_LANG= but same issue persists? any other ideas?
Commented:
Hi the solution was to put
export NLS_LANG=

in the  ~user/.profile

It worked fine after.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial