My Oracle Support Banner

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 MARCH 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.