This article explains how to resolve ORA-03113 error while running ALL script.
ALL script terminates with ORA-03113 error.
Applicable Error Code
ORA-03113: end-of-file on communication channel
Replicate versions, Database version 22.214.171.124
Noticed in AIX
When Dbvisit Replicate is running with Oracle 126.96.36.199.0 - 64bit Production on AIX 5.3 we get the following error:
$ ./ora9src-all.sh Setting up Dbvisit Replicate configuration Configure database ora9src... This check fails if the DBID is not the expected one... Ok, check passed. Configure database PROD_dbvlin503... This check fails if the DBID is not the expected one... Ok, check passed. Object grants for database ora9src... Object grants for database PROD_dbvlin503... Setting up the configuration Initializing......done WARN-1850: No DDC DB available, dictionary table does not exist. DDC loaded from database (0 variables). Dbvisit Replicate version 188.8.131.5223 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/ora9src/ora9src-onetime.ddc loaded. MINE: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists) APPLY: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists) dbvrep> set ON_WARNING SKIP Variable ON_WARNING set to SKIP for process *. dbvrep> set ON_ERROR EXIT Variable ON_ERROR set to EXIT for process *. dbvrep> ENGINE SWITCH_REDOLOG dbvrep> ENGINE SETUP MINE DROP DICTIONARY 0 dictionary objects dropped. dbvrep> ENGINE SETUP MINE CREATE DICTIONARY ERR-1774: Prepare failed on SQL ' select distinct aic.column_name, min(column_position), max(algc.column_name) from all_indexes ai join all_ind_columns aic on owner = index_owner and ai.index_name = aic.index_name left join all_log_groups alg on alg.owner = ai.owner and alg.table_name = ai.table_name and always in ('Y', 'ALWAYS') left join all_log_group_columns algc on algc.owner = ai.owner and algc.table_name = ai.table_name and alg.log_group_name = algc.log_group_name and algc.column_name = aic.column_name where ai.table_owner=? and ai.table_name=? and uniqueness = 'UNIQUE' group by aic.column_name order by 2 ' with error ORA-03113: end-of-file on communication channel Process ID: 0 Session ID: 21 Serial number: 639 (DBD ERROR: OCIStmtExecute/Describe) FATAL-9043: Error detected and ON_ERROR set to EXIT. Error encountered, not starting Dbvisit Replicate.
This is an Oracle bug. Upgrade to Oracle 184.108.40.206. Sometimes rerunning the
*-all.sh script also works. Please also the see the below link, which clearly says recommended version is 220.127.116.11 and above.
Arjen Visser June 20, 2013 13:46