Error one: After configuring the source and target databases, create a replication administrator. After you connect the replication administrator, perform the maintain_table process in the Source library:
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;/
I found this error:
I found this error:
ERROR at line1: ORA-23616: FailureinchExecuting block A forScript06f6bbb2e70137c5e05054b4f621416cora-06512: at"SYS. Dbms_recoverable_script", line593ORA-06512: at"SYS. Dbms_recoverable_script", line616ORA-06512: at"SYS. DBMS_STREAMS_MT", line7747ORA-06512: at"SYS. Dbms_streams_adm", line2458ORA-06512: At line7
Solution:
Solution:
By capturing the execution script of the source library, the error ID is found to be the first few steps to perform the error
SelectInvoking_package_owner asowner, Invoking_package asPackage , Invoking_procedure asprocedure, status, Total_blocks, Done_block_num fromDba_recoverable_script8 wherescript_id ='06f6bbb2e70137c5e05054b4f621416c' 9; OWNER Package------------------------------ ------------------------------PROCEDURE STATUS total_blocks done_block_num------------------------------ ------------ ------------ --------------SYS dbms_streams_admmaintain_tables ERROR - +
Find out what the reason is:
Select error_number, Error_message from dba_recoverable_script_errors 3 where ' 06f6bbb2e70137c5e05054b4f621416c ' and block_num=; Error_number------------error_message-------------------------------------------------------- ------------------------ -25153ORA-25153 is Empty
The original is a temporary table space error report empty. Then check the source library for temporary file conditions, the results show that there are. That's a wonder.
Select from dba_temp_files 2 ; Tablespace_name------------------------------file_name------------------------------------------ --------------------------------------TEMP/u01/app/oracle/oradata/orcl/temp01.dbf
Look again at the temporary files for the target database:
Select from v$tempfile;no rows selected
Rub, incredibly did not, this time can basically find out is this problem. It would be nice to add the temporary files of the target database.
' /u01/app/oracle/oradata/weber/temp01.dbf ' ; Tablespace altered.
Perform the maintain_table process again in the Source library. OK, found no error!
"Error Collection" error during Oracle build stream