首页 > 代码库 > ORACLE搭建Stream过程中报错【error收集】
ORACLE搭建Stream过程中报错【error收集】
错误一:在配置完源库和目标数据库后,创建复制管理员。连接上复制管理员后,在源库执行MAINTAIN_TABLE过程:
declare v_tables DBMS_UTILITY.UNCL_ARRAY;begin v_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;/
就发现是这个错误:
就发现是这个错误:
ERROR at line 1:ORA-23616: Failure in executing block 22 for script06F6BBB2E70137C5E05054B4F621416CORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 593ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 616ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7747ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2458ORA-06512: at line 7
解决方案:
解决方案:
通过捕获源库的执行脚本,根据错误id找到是第几步执行出错
select invoking_package_owner as owner, invoking_package as package, invoking_procedure as procedure, status, total_blocks, done_block_num from dba_recoverable_script 8 where script_id = ‘06F6BBB2E70137C5E05054B4F621416C‘ 9 ;OWNER PACKAGE------------------------------ ------------------------------PROCEDURE STATUS TOTAL_BLOCKS DONE_BLOCK_NUM------------------------------ ------------ ------------ --------------SYS DBMS_STREAMS_ADMMAINTAIN_TABLES ERROR 48 21
再查一下究竟是什么原因:
select error_number, error_message from dba_recoverable_script_errors 3 where script_id = ‘06F6BBB2E70137C5E05054B4F621416C‘ and block_num=22;ERROR_NUMBER------------ERROR_MESSAGE-------------------------------------------------------------------------------- -25153ORA-25153: Temporary Tablespace is Empty
原来是临时表空间报错报空。那么就查一下源库的临时文件情况,结果显示存在。那就纳闷了。
SQL> select tablespace_name,file_name from dba_temp_files 2 ;TABLESPACE_NAME------------------------------FILE_NAME--------------------------------------------------------------------------------TEMP/u01/app/oracle/oradata/orcl/temp01.dbf
再查一下目标数据库的临时文件:
SQL> select name from v$tempfile;no rows selected
擦,居然没有,这个时候就基本可以发现了是这个问题。把目标数据库的临时文件加上去就好了。
alter tablespace temp add tempfile ‘/u01/app/oracle/oradata/weber/temp01.dbf‘;Tablespace altered.
再次执行在源库执行MAINTAIN_TABLE过程。OK,发现没有报错!
ORACLE搭建Stream过程中报错【error收集】
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。