Oracle Database Discussions

Hi,

I migrated my database Oracle 10.2.0.4 windows 32 bits to Windows 64 bits. On the new server 64 bits, I set registers key exactly the same way (NLS_LANG, NLS_DATE_FORMAT, etc.).

In 32 bits, when I started SQLPlus, I had the following output:*

+Microsoft Windows [Version 5.2.3790]+
+(C) Copyright 1985-2003 Microsoft Corp.+

D:\Logiciels\Oracle\Ora10g\rdbms\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Jeu. Juil. 16 14:21:49 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> show user
USER est ""+
SQL>


In 64 bits, I had the following output when I started SQLPlus:*

D:\Logiciels\oracle\ora10g\rdbms\BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Jeu. Juil. 16 14:16:19 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> show user
USER is "SYS"+
SQL>


To be sure it's the good key used by SQL*Plus, I voluntary changed the value of the Key NLS_LANG to an invalid value to see what would be the result
(for example: I omitted the first "A" in CNADIAN FRENCH_CANADA.WE8MSWIN1252). Now is the result:

D:\Logiciels\oracle\ora10g\rdbms\BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Jeu. Juil. 16 14:22:40 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


Enter user-name:

That's the proof that I'm using the good key. Si why it doesn't work for NLS_LANG=CANADIAN FRENCH_CANADA.WE8MSWIN1252 ???

I tried with the same bad result with FRENCH_CANADA.WE8MSWIN1252.

Any idea?

Thank's

Yves

Edited by: yvesthib on 2009-07-16 14:33
Sorry, I created the this thread in the wrong category ...