IMPDP中不一样的 UDI-31623

在测试环境impdp导入过程中，出现UDI-31623报错

经搜索发现最多的是关于streams_pool的设置，该环境数据库内存是手动管理，streams_pool为正常设置

尝试不使用dblink，错误一样

oracle@xxdb01:/home/oracle/expdp> impdp "'sys/xxxxxx@xxdb as sysdba'" directory=impdp_xx schemas=xx network_link=link_xx logtime=all logfile=impdp_xx.log

Import: Release 12.1.0.2.0 - Production on Fri May 27 16:17:48 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1

alert.log中有关报错时间点记录如下内容：

Fri May 27 16:17:53 2022
Resize operation completed for file# 56, old size 266240K, new size 276480K
opidrv aborting process DM00 ospid (90182) as a result of ORA-447

/*查看该报错信息

oracle@xxdb01:/home/oracle> oerr ora 447
00447, 00000, "fatal error in background process"
// *Cause: One of the background processes died unexpectedly.
// *Action: Warm start the system.

后经测试发现，去掉logtime参数后就可以正常导出，logtime=all导致？

在Mos找到一篇靠谱介绍:

Data Pump Export Or Import Throws ORA-31623 When Using LOGTIME Parameter (Doc ID 1936319.1)

Data Pump export/import with LOGTIME parameter crashes if the environment variable NLS_DATE_FORMAT is set. In some cases the errors are seen if both NLS_DATE_FORMAT and NLS_LANG are set.

The problem is addressed in
Bug 18920652 - DATAPUMP WITH LOGTIME CRASHES WHEN NLS_LANG IS SET AT O/S LEVEL
closed as a duplicate of
Bug 17714887 - ORA-31623 ON IMPDP WITH DBLINK

Please note that Bug 17714887 has been superseded by unpublished Bug 21094393

Unpublished Bug 21094393 is fixed in 12.2.

NLS_DATE_FORMAT 变量设置过后，使用logtime参数，数据泵导出导入过程中会出错--某些情况下NLS_DATE_FORMAT、NLS_LANG 都设置之后，也会出现该错误

查看环境变量NLS_DATE_FORMAT 、NLS_LANG均配置的有，在对该变量unset之后，重新执行导入正常

解决方式：

1.打补丁，影响版本为12.1

2.不使用logtime参数

3.别设那俩变量