Oracle 9i errors with error ORA-03113: end-of-file on communication channel

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
2 min read

This article explains how to resolve ORA-03113 error while running ALL script.

Problem Details

Problem Statement

ALL script terminates with ORA-03113 error.

Applicable Error Code

ORA-03113: end-of-file on communication channel

Affected Versions

Replicate versions, Database version 9.2.0.1 

Affected Platforms

Noticed in AIX

 

Description

When Dbvisit Replicate is running with Oracle 9.2.0.1.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 2.4.31.2923 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.

Solution

This is an Oracle bug. Upgrade to Oracle 9.2.0.8. Sometimes rerunning the *-all.sh script also works. Please also the see the below link, which clearly says recommended version is 9.2.0.4 and above.

https://dbvisit.atlassian.net/wiki/display/ugd7/Supported+Platforms

Arjen Visser June 20, 2013 13:46