哎!人不顺了,喝口冷水都塞牙缝.
下午做了一个很简单的测试就又出来了一个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
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
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
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