problematic phenomenon
The following error message occurs when importing/exporting an Oracle 11g database on a Windows server, and the output log file is no longer output from the location where the error was reported.
ORA-39064: Unable to write log file
ORA-29285: File Write Error
Cause of the problem
The reason is that the client environment variable NLS_LANG is inconsistent with the database character set, and the data pump uses the ---- database character set when writing log files, and the two character sets are compatible when writing to certain characters, such as Chinese characters, resulting in a log output error.
cure
Set the client character set variable to match the database character set.
Here are the steps to fix it:
1, query the database character set, here is theSIMPLIFIED CHINESE_CHINA.AL32UTF8
# View test library
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
2, Win + R run, enterregedit
Open the registry manager
Registry Path:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG
The current value of NLS_LANG was found to beSIMPLIFIED CHINESE_CHINA.ZHS16GBK
, which needs to be changed toSIMPLIFIED CHINESE_CHINA.AL32UTF8