ORA-12705: "invalid or unknown NLS parameter value specified"
- There are two possible causes:
- An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value.
- The NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.
Oracle also says that the ORA-12705 can happen under these conditions and MetaLink has resolutions for these ORA-12705 conditions:
1. ORA-12705 with incorrect NLS_LANG parameter
2. ORA-12705 with incorrectly specified ORA_NLSx
3. ORA-12705 from incorrect Oracle install or configuration
4. ORA-12705 when using Special Character sets
5. ORA-12705 when connecting with SQL*Net
6. ORA-12705 during migrations
7. ORA-12705 when connecting with SQL*Plus
8. ORA-12705 when connecting with language pre-compilers
9. ORA-12705 during Export/Import
For ORA-12705 errors caused by invalid NLS_LANG settings, you need to verify that it is "unset" at the system-level:
Windows - The NLS_LANG must be unset in the Windows registry (re-named is best). Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.
Linux/UNIX - Here you simply issue the Linux command "unset NLS_LANG"
Я это все читал и так
Странность в том что к локальной базе конектюсь нормально
а к удаленным криво
На локальной стоит NLS=AMERICAN_AMERICA.CL8MSWIN1251
кстати на серваках стоит AMERICAN_AMERICA.CL8MSWIN1251