又一次体验到 libpath -凯发app官方网站

[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
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
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 的作用还有混乱环境带来的麻烦。

阅读(1164) | 评论(0) | 转发(0) |

上一篇：pctp tidb 题库

下一篇：db file async i/o submit 等待事件

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们