| Product: | Syniti Data Replication, DBMoto |
| Version: | All |
| ID: | 3003 |
| Summary: | With Oracle non-US/English locales, the Verifier may not work. Modify the language setting for Oracle to run the Verifier successfully |
When running the Syniti DR/DBMoto Verifier with an Oracle database on Windows, the Verifier might returns inaccurate results because of the language setting inside the Oracle driver. Once the setting is changed, the Oracle driver will return the data sorted properly and the Verifier will work correctly. This usually happens when installing the Oracle driver on a Windows system where the locale is not US/English or a compatible one.
Be sure that the language is set correctly in the Region dialog:
Restart the system so that the Oracle provider picks up the changes.
If this fails, you could also modify the NLS_LANG setting for Oracle in the Windows registry:
- Navigate to the following path in the registry: Computer/HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraClient11g_home1 -> NLS_LANG
- Change the value of the NLS_LANG attribute to “AMERICAN_AMERICA.WE8MSWIN1252”
- Restart Syniti DR/DBMoto Server Agent.
- Run the verifier.
NLS_LANG FAQ from Oracle: