Streams errors

在创建streams时遇到如下错误。

old   4:  SOURCE_DATABASE => '&source_db_name..&db_domain',
new   4:  SOURCE_DATABASE => 'MCSPSR.central',
old   6:  DESTINATION_DATABASE       => '&target_db_name..&db_domain',
new   6:  DESTINATION_DATABASE       => 'RPTPSR.central',
old  10:  APPLY_NAME => 'APPLY$_&source_db_name._ADC',
new  10:  APPLY_NAME => 'APPLY$_MCSPSR_ADC',
old  11:  APPLY_QUEUE_NAME => 'APPLY$_&source_db_name._ADCQ',
new  11:  APPLY_QUEUE_NAME => 'APPLY$_MCSPSR_ADCQ',
old  12:  PROPAGATION_NAME => 'PROP$_&source_db_name._ADC',
new  12:  PROPAGATION_NAME => 'PROP$_MCSPSR_ADC',
BEGIN
*
ERROR at line 1:
ORA-23616: Failure in executing block 12 for script
AD9B04ECD1BC448CE04400212826A59C with
ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 139
ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 485
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7983
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2703
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2764
ORA-06512: at line 2

使用下面语句查看具体错误原因：
SQL> select forward_block,forward_block_dblink,status
     from dba_recoverable_script_blocks
   where script_id='AD9B04ECD1BC448CE04400212826A59C' and block_num=12  2    3
  4
SQL>
SQL> /

FORWARD_BLOCK                                                         FORWARD_BLOCK_DBLINK                        STATUS
--------------------------------------------------------------------- ------------------------------------------- -----------------------
--                                                                    RPTPSR.CENTRAL                              PURGED
-- Datapump SCHEMA MODE IMPORT
--
DECLARE
  h1                NUMBER := NUL

查看与data pump相关的日志。

$ more  fullexpMCSPSR_110925.log

;;;
Export: Release 11.2.0.2.0 - Production on Sun Sep 25 18:00:02 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "ORACLE"."SYS_EXPORT_FULL_07":  /******** full=Y directory=EXPDIR compression=ALL dumpfile=fullexpMCSPSR_110925.dmp logfile=fullexpMCSPSR_110925.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 7.894 GB
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.COMPLETE_EXP_OBJECT [TABLESPACE]
ORA-31616: unable to write to dump file "/orahome/oracle/acfsdata/mcs_share/dpdumps/MCSPSR/fullexpMCSPSR_110925.dmp"
ORA-19502: write error on file "/orahome/oracle/acfsdata/mcs_share/dpdumps/MCSPSR/fullexpMCSPSR_110925.dmp", block number 3 (block size=4096)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 4096
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
48f951290     19208  package body SYS.KUPW$WORKER
48f951290      8385  package body SYS.KUPW$WORKER
48f951290      6086  package body SYS.KUPW$WORKER
48f951290      2702  package body SYS.KUPW$WORKER
48f951290      9054  package body SYS.KUPW$WORKER
48f951290      1688  package body SYS.KUPW$WORKER
58e61d4e0         2  anonymous block
Job "ORACLE"."SYS_EXPORT_FULL_07" stopped due to fatal error at 18:02:44
$ df -h
Filesystem             size   used  avail capacity  Mounted on
/dev/md/dsk/d10         25G    14G    10G    58%    /
/devices                 0K     0K     0K     0%    /devices
ctfs                     0K     0K     0K     0%    /system/contract
proc                     0K     0K     0K     0%    /proc
mnttab                   0K     0K     0K     0%    /etc/mnttab
swap                    46G   1.2M    46G     1%    /etc/svc/volatile
objfs                    0K     0K     0K     0%    /system/object
sharefs                  0K     0K     0K     0%    /etc/dfs/sharetab
/platform/SUNW,T5240/lib/libc_psr/libc_psr_hwcap2.so.1
                        25G    14G    10G    58%    /platform/sun4v/lib/libc_psr.so.1
/platform/SUNW,T5240/lib/sparcv9/libc_psr/libc_psr_hwcap2.so.1
                        25G    14G    10G    58%    /platform/sun4v/lib/sparcv9/libc_psr.so.1
fd                       0K     0K     0K     0%    /dev/fd
swap                    46G    43M    46G     1%    /tmp
swap                    46G    48K    46G     1%    /var/run
/dev/md/dsk/d30         80G    11G    68G    14%    /export
/dev/md/dsk/d50         89G    25G    63G    29%    /orahome
/dev/asm/mcs_share-182

                        20G    20G     0K   100%    /orahome/oracle/acfsdata/mcs_share

果然空间不足导致出错，移动一些文件释放空间后再执行建立streams语句！