我的DBA之路 2014-03-27
Oracle bug 文档 ID 549781.1
影响版本从10.2.0.2.0 到11.2.0.3.0
提示报错,但是expdp log 里面提示是成功,oracle 说导出的dmp文件是好的。只能忽略这个报错,无法修复!
UDE-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2772
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3886
ORA-06512: at line 1
_dm00_4372.trc
*** 2014-03-25 09:40:11.792
*** ACTION NAME:(SYS_EXPORT_FULL_01) 2014-03-25 09:40:11.792
*** MODULE NAME:(Data Pump Master) 2014-03-25 09:40:11.792
*** SERVICE NAME:(SYS$USERS) 2014-03-25 09:40:11.792
*** SESSION ID:(1605.4781) 2014-03-25 09:40:11.792
kswsdlaqsub: sub:SYS$SM_SYS svc:SYS.KUPC$C_2_20140325093630 unexpected exception err=604, err2=24010
kswsdlaqsub: stmt=DECLARE subscriber sys.aq$_agent; BEGIN subscriber := sys.aq$_agent('SYS$SM_SYS', NULL, NULL); dbms_aqadm.remove_subscriber(queue_name => 'SYS$SERVICE_METRICS', subscriber => subscriber); END;