UDE-00008: operation generated ORACLE error 31626

哎!人不順了,喝口冷水都塞牙縫.

下午做了一個很簡單的測試就又出來了一個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.

:~> 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

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

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_02":  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

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.

:~> 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

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

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