Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_LANG Issue

Nick MDec 11 2008 — edited Dec 16 2008
All,

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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2009
Added on Dec 11 2008
8 comments
2,460 views