My Oracle Support Banner

datapatch error : will be skipped because it has no components OK (Doc ID 2882340.1)

Last updated on JULY 13, 2022

Applies to:

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

Symptoms

When attempting to execute datapatch, below is the error encountered :

Installation queue:
For the following PDBs: PDB1
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
31193695 (ORA-13029 FROM SDO_GEOM.SDO_AREA FOR 3D GEOMETRYS WITH SRID 27700): will be skipped because it has no components OK

This brought in plugin violation for the patch 31193695, thus putting the respective PDB1 in restricted mode.

PDB1    SQL Patch ERROR    PENDING    Interim patch 31193695/23988877 (ORA-13029 FROM SDO_GEOM.SDO_AREA FOR 3D GEOMETRYS WITH SRID 27700):
Installed in the CDB but not in the PDB

CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
PDB$SEED  READ ONLY NO
PDB1 READ WRITE YES

 

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.