datapatch error : will be skipped because it has no components OK
(Doc ID 2882340.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and laterInformation 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
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
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 |