oracle11g expdp遇到bug
maclean liu 您好：下面是我遇到的一个问题
数据库：oracle 11.2.0.3
操作系统：AIX 6.1
1，使用expdp导出数据时，报如下错误：
ORA-31626: Job does not exist
ORA-31638: cannot attach to job Your_JOBNAME for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_4_220050709685000 to queue "KUPC$C_4_20130428220032"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
2，通过MOS查看，这是oracle的一个bug,触发版本为11.2.0.1及以后版本,oracle给出的解决方案。
1，做数据库全备
2，执行以下步骤
After encountering this symptom, this is not resolved unless recreating of datapump like followings.
@$ORACLE_HOME/rdbms/admin/catdph.sql
@$ORACLE_HOME/rdbms/admin/prvtdtde.plb
@$ORACLE_HOME/rdbms/admin/catdpb.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Generally speaking, we can recreate the datapump objects in 11g by calling;
1. Catproc.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
2. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
因为现在有新的系统上线，主机为AIX6.1 ，数据库11.2.0.4
1,请问在11.2.0.4中是否已经修复了此bug?
2,请问上述11.2.0.3修复bug的过程可能有哪些风险？应如何规避。
1、给出具体的bug号码
2、 就他给的solution看，是重建了datapump对象， 如果是bug 那么是那种造成 对象状态不正常的bug Bug 16473783 All of a sudden, your data pump export jobs all fail with the following bunch of errors:
Export: Release 11.2.0.3.0 - Production on Sunday, Apr 28, 22:00:26 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: Job does not exist
ORA-31638: cannot attach to job Your_JOBNAME for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_4_220050709685000 to queue "KUPC$C_4_20130428220032"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
CHANGES
Nothing changed
CAUSE
When the sequence of datapump reaches more than 999999, every attempt to run datapump export fail with the same bunch of error messages.
This issue is identical to the one filled under Bug 6471833 IMPDP FAILED WITH ORA-39002, ORA-31626
This has been closed as duplicate of Bug 16473783 EXPDP ENCOUNTERS ORA-39077 AND ORA-31638
This issue matches with Rediscovery information of Bug 16473783:
When executing expdp ORA-39077 AND ORA-31638 are reported if value of sequence number generated by "SYS"."AQ$_KUPC$DATAPUMP_QUETAB_1_N" is more than 6 digits.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 12.2
Versions confirmed as being affected
11.2.0.3
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
12.2 (Future Release)
就bug note看， 没有明确写在 11.2.0.4 中已经修复， 查了下 相关的几个 patch似乎目前都不可见了
2、这个论坛不谈风险 ，任何操作都有风险 包括select ， 需要风险评估 请找你的 数据库服务供应商 好的，谢谢刘大
页:
[1]