Upgrade to 12.1.0.2 database fails with error “ORA-04063: package body “SYS.DBMS_ISCHED” has errors” (Doc ID 2093731.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Upgrade to 12.1.0.2 database fails with below errors-

ERROR at line 1:
ORA-04063: package body “SYS.DBMS_ISCHED” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_ISCHED”
ORA-06512: at line 9

When do manual recompilation, getting the below errors.

SQL> alter package dbms_isched compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_ISCHED:

LINE/COL ERROR
——– —————————————————————–
3867/1 PL/SQL: Item ignored
3875/1 PLS-00311: the declaration of “schedFileWatcherJava.fwWrapper(
oracle.scheduler.agent.fwReqListWrapper,
oracle.scheduler.agent.fwHstListWrapper[],
java.lang.String,
java.lang.String,
java.lang.String) return oracle.scheduler.agent.fwResListWrapper”
is incomplete or malformed

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms