适用范围

Oracle 12.2-19.3 OS Linux 7.9

问题概述

某客户的12.2两节点rac升级到19.3两节点rac之后，对象KUPW$WORKER无效，它是数据泵的内部对象，虽然暂时不影响数据库的正常使用，但是在使用datapump的时候会发生错误，例如ORA-04063: package body “SYS.KUPW$WORKER” has errors，mos上有如下说明： The package is used for export/import purpose. Data pump uses advance queuing for maintaining its all the jobs. Some time in newly created /clonned database this advance queuing for datapump is not installed.

问题原因

Caused due to incorrect package body definition

解决方案

SQL> conn / as sysdba