UDE-00008: operation generated ORACLE error 31626

最新推荐文章于 2022-12-20 11:17:49 发布

cixin1802

最新推荐文章于 2022-12-20 11:17:49 发布

阅读量445

点赞数

文章标签：数据库

哎!人不顺了,喝口冷水都塞牙缝.

下午做了一个很简单的测试就又出来了一个BUG,记录一下吧,

SQL> show user ;
USER is "SYS"
SQL> create directory dir1 as '/home/oracle/bak';

Directory created.

SQL> grant write on directory dir1 to yxyup;

Grant succeeded.

oracle@sles10sp1-db2:~> expdp system/system dumpfile=yxyup.dump directory=dir1 schemas=yxyup

Export: Release 10.2.0.1.0 - Production on Wednesday, 25 June, 2008 17:18:45

UDE-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.KUPC$QUE_INT", line 529
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
ORA-06512: at line 1

metalink BUGS

https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=5600320

https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=5416274

Bug 5663241 EXPDP CLIENT GETS UDE-00008 ORA-31626 BUT SERVER SIDE EXPORT LOG HAS NO ERROR.

Bug 4173696 ORA-24018 FOUND IN DM0 TRACES DURING MULTIPLE CONCURRENT IMPDP EXECUTION

Bug 5416274 EXPDP CLIENT GETS DISCONNECTED(ORA-31626) WHILE THE SERVER SIDE EXPORT IS OK

就一个测试机,懒得去升级了,重启数据库后,再expdp解决.

SQL> startup force;
ORACLE instance started.

Total System Global Area   83886080 bytes
Fixed Size                  1217860 bytes
Variable Size              75500220 bytes
Database Buffers            4194304 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

oracle@sles10sp1-db2:~> expdp system/system dumpfile=yxyup.dump directory=dir1 schemas=yxyup

Export: Release 10.2.0.1.0 - Production on Wednesday, 25 June, 2008 17:27:32

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_04": system/******** dumpfile=yxyup.dump directory=dir1 schemas=yxyup
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "YXYUP"."TEST_ONE" 4.937 KB 2 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_04" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_04 is:
/home/oracle/bak/yxyup.dump
Job "SYSTEM"."SYS_EXPORT_SCHEMA_04" successfully completed at 17:28:55