ORA-12705: invalid or unknown NLS parameter value specified

jbossjdbcodbcoracle

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=

Best Answer

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
Related Topic