又一次体验到 LIBPATH

 expdp 报错

[backup:oracle]:/home/oracle>r exp
expdp parfile=user1.par

Export: Release 11.2.0.4.0 - Production on Mon Jun 28 10:09:36 2021

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "user1"."SYS_EXPORT_TABLE_08":  user1/******** parfile=user1.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 30.76 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE:"user1"."INSFENSUM"]
ORA-19051: Cannot use fast path insert for this XMLType table

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----
object      line  object
handle    number  name
7000101fa513c18     21979  package body SYS.KUPW$WORKER
7000101fa513c18      9742  package body SYS.KUPW$WORKER
7000101fa513c18     11838  package body SYS.KUPW$WORKER
7000101fa513c18      2808  package body SYS.KUPW$WORKER
7000101fa513c18     10422  package body SYS.KUPW$WORKER
7000101fa513c18      1824  package body SYS.KUPW$WORKER
7000101fb24ff60         2  anonymous block

Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE:"user1"."INSFENSUM"]
ORA-19051: Cannot use fast path insert for this XMLType table

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----
object      line  object
handle    number  name
7000101fa513c18     21979  package body SYS.KUPW$WORKER
7000101fa513c18      9742  package body SYS.KUPW$WORKER
7000101fa513c18     11838  package body SYS.KUPW$WORKER
7000101fa513c18      2808  package body SYS.KUPW$WORKER
7000101fa513c18     10422  package body SYS.KUPW$WORKER
7000101fa513c18      1824  package body SYS.KUPW$WORKER
7000101fb24ff60         2  anonymous block

Job "user1"."SYS_EXPORT_TABLE_08" stopped due to fatal error at Mon Jun 28 10:09:46 2021 elapsed 0 00:00:08

一共对3个用户分别导出，但是另外两个用户导出没错。

根据报错去MOS上搜一下ORA-39126、ORA-19051，大多是ORA-19051相关错误，提示xmldb相关或者与LD_LIBRARY_PATH_64有关
检查xmldb组件状态

SELECT COMP_NAME,VERSION,STATUS FROM DBA_REGISTRY WHERE COMP_NAME LIKE '%X%';

都是valid，没有问题。
况且有两个用户导出都正常。

看看环境变量

[backup:oracle]:/home/oracle>env|grep LIB
KM_CRYPTO_LIB_PATH=/usr/lib/libkmcryptolib.so
R_SHLIB_LD_LIBRARY_PATH=/usr/lib
KM_SUPPORT_LIB_PATH=/usr/lib/libkmsvcshlib.so
LIBPATH=/oracle/app/oracle/product/10201/db/lib:/oracle/app/oracle/product/11204/db/lib
LD_LIBRARY_PATH=:/oracle/app/oracle/product/11204/db/lib:/oracle/app/oracle/product/11204/db/rdbms/lib:/lib:/usr/lib

这是一个测试环境，有多个HOME，LIBPATH指向了10g的home，而我当前的库是11g的，于是去掉10201的。
export LIBPATH=/oracle/app/oracle/product/11204/db/lib
重启实例，再次导出

[backup:oracle]:/home/oracle>r expdp
expdp parfile=user1.par

Export: Release 11.2.0.4.0 - Production on Mon Jun 28 10:45:15 2021

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "user1"."SYS_EXPORT_TABLE_09":  user1/******** parfile=user1.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 30.76 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "user1"."JFEE"                                11.79 GB 74297144 rows
. . exported "user1"."JTFCROSSBANK"                        7.329 GB 28822773 rows
. . exported "user1"."ECCIFLIMITRT"                        2.705 GB 38257466 rows
. . exported "user1"."JVOUCHERPRINT"                       1.856 GB 2647084 rows
...

导出正常了。

又一次感受到 LIBPATH 的作用还有混乱环境带来的麻烦。