NLS_LANG Issue
Nick MDec 11 2008 — edited Dec 16 2008All,
I installed Oracle 10g v10.1 on to a Windows 2000 server w/ SP4. I can tnsping the database, however when I try to attach to it, I get the following error:
java.sql.SQLException: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
I've set the NLS_LANG variable in the following locations:
Registry --
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1
NLS_LANG = American_America.WE8MSWIN1252
Environment Variable -- System Variable
NLS_LANG = American_America.WE8MSWIN1252
If I run "SELECT * from NLS_SESSION_PARAMETERS" in sqlplus, I see the correct values.
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA
Is there anything I am missing?
Thanks,