Home / server / Questions / 71337
In Process
Viky
Asked: 2009-10-06 05:17:44 +0800 CST

ORA-12705: invalid or unknown NLS parameter value specified

  • 772

I have a J2EE application hosted on JBoss on Linux.

When I try to access the application, I see following error in the server.log file.

ORA-12705: invalid or unknown NLS parameter value specified

When I point the same JBoss instance to a different schema, the application works fine.

I tried to go through a few forums and found that the NLS parameter settings are fine.

Can anyone help.

  • Jboss version = 4.0.2
  • DB version = oracle 10.2

output of locale command on linux

$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
oracle

1 Answers

  1. You can try this:

    1. Make sure en_US.UTF-8 is installed. It should appear in the list generated by "locale -a". If it isn't you'll need to install it.
    2. export LC_ALL=en_US.UTF-8
    3. export NLS_LANG=AMERICAN_AMERICA.UTF8
    • 0