My Oracle Support Banner

What to do if the status of a datapatch action was not SUCCESS due to finding non-ignorable errors (Doc ID 1635056.1)

Last updated on OCTOBER 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

datapatch reports non-ignoreable errors were found during an apply or rollback.  For example:

Errors during an apply

 

Changes

Datapatch was executed to perform SQL patch apply or rollback

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
 Errors during an apply
 Errors during a rollback
Changes
Cause
Solution
 Solution for errors during an apply
 Fix the issue and rerun SQL apply
 Rollback patch from ORACLE_HOME and rollback SQL from db (via force rollback)
 Solution for errors during a rollback
 Fix the issue and rerun SQL rollback
 Resolve the issue causing the SQL errors and reinstall the patch

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