錯誤一：在配置完源庫和目標數(shù)據(jù)庫后，創(chuàng)建復制管理員。連接上復制管理員后，在源庫執(zhí)行MAINTAIN_TABLE過程：

declarev_tables DBMS_UTILITY.UNCL_ARRAY; beginv_tables(1) := 'hr.test01';v_tables(2) := 'hr.test02';v_tables(3) := 'hr.test03';dbms_streams_adm.maintain_tables(table_names => v_tables,source_directory_object => null,destination_directory_object => null,source_database => 'orcl.net',destination_database => 'weber.net',perform_actions => true,bi_directional => true,include_ddl => true,instantiation => dbms_streams_adm.instantiation_table_network); end; /

就發(fā)現(xiàn)是這個錯誤：

就發(fā)現(xiàn)是這個錯誤：

ERROR at line 1: ORA-23616: Failure in executing block 22 for script 06F6BBB2E70137C5E05054B4F621416C ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 593 ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 616 ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7747 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2458 ORA-06512: at line 7

解決方案：

解決方案：

通過捕獲源庫的執(zhí)行腳本，根據(jù)錯誤id找到是第幾步執(zhí)行出錯

select invoking_package_owner as owner,invoking_package as package,invoking_procedure as procedure,status,total_blocks,done_block_numfrom dba_recoverable_script8 where script_id = '06F6BBB2E70137C5E05054B4F621416C'9 ;OWNER PACKAGE ------------------------------ ------------------------------ PROCEDURE STATUS TOTAL_BLOCKS DONE_BLOCK_NUM ------------------------------ ------------ ------------ -------------- SYS DBMS_STREAMS_ADM MAINTAIN_TABLES ERROR 48 21

再查一下究竟是什么原因：

select error_number, error_messagefrom dba_recoverable_script_errors3 where script_id = '06F6BBB2E70137C5E05054B4F621416C' and block_num=22;ERROR_NUMBER ------------ ERROR_MESSAGE ---------------------------------------------------------------------------------25153 ORA-25153: Temporary Tablespace is Empty

原來是臨時表空間報錯報空。那么就查一下源庫的臨時文件情況，結果顯示存在。那就納悶了。

SQL> select tablespace_name,file_name from dba_temp_files2 ;TABLESPACE_NAME ------------------------------ FILE_NAME -------------------------------------------------------------------------------- TEMP /u01/app/oracle/oradata/orcl/temp01.dbf

再查一下目標數(shù)據(jù)庫的臨時文件：

SQL> select name from v$tempfile;no rows selected

擦，居然沒有，這個時候就基本可以發(fā)現(xiàn)了是這個問題。把目標數(shù)據(jù)庫的臨時文件加上去就好了。

alter tablespace temp add tempfile '/u01/app/oracle/oradata/weber/temp01.dbf';Tablespace altered.

再次執(zhí)行在源庫執(zhí)行MAINTAIN_TABLE過程。OK，發(fā)現(xiàn)沒有報錯！

轉載于:https://www.cnblogs.com/yaoweber/p/4071759.html

總結

以上是生活随笔為你收集整理的ORACLE搭建Stream过程中报错【error收集】的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。