Datapatch Trying to Update non-Installed Components with "-force" Option in 18c
(Doc ID 2694439.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 18.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Datapatch tries to update non-installed components in database during post-installation steps of DB RU 18.x -
-> Error at line 135313: script md/admin/prvtsidx.plb
- ORA-24344: success with compilation error
-> Error at line 135456: script md/admin/prvtsidx.plb
- ORA-22330: cannot alter a type that is not valid
- ORA-06512: at line 14
- ORA-06512: at line 7
-> Error at line 135503: script md/admin/prvtsidx.plb
- Warning: Package created with compilation errors.
-> Error at line 135540: script md/admin/prvtsidx.plb
- Warning: Package created with compilation errors.
-> Error at line 135547: script md/admin/prvtsidx.plb
- 3/3 PL/SQL: Declaration ignored
-> Error at line 135548: script md/admin/prvtsidx.plb
- 3/23 PLS-00201: identifier 'MDSYS.SDO_GEOMETRY' must be declared
-> Error at line 135549: script md/admin/prvtsidx.plb
- 10/3 PL/SQL: Declaration ignored
-> Error at line 135550: script md/admin/prvtsidx.plb
- 10/23 PLS-00201: identifier 'MDSYS.ST_GEOMETRY' must be declared
-> Error at line 135551: script md/admin/prvtsidx.plb
- 17/3 PL/SQL: Declaration ignored
-> Error at line 135552: script md/admin/prvtsidx.plb
- 17/23 PLS-00201: identifier 'MDSYS.ST_GEOMETRY' must be declared
-> Error at line 135553: script md/admin/prvtsidx.plb
- ORA-24344: success with compilation error
-> Error at line 135456: script md/admin/prvtsidx.plb
- ORA-22330: cannot alter a type that is not valid
- ORA-06512: at line 14
- ORA-06512: at line 7
-> Error at line 135503: script md/admin/prvtsidx.plb
- Warning: Package created with compilation errors.
-> Error at line 135540: script md/admin/prvtsidx.plb
- Warning: Package created with compilation errors.
-> Error at line 135547: script md/admin/prvtsidx.plb
- 3/3 PL/SQL: Declaration ignored
-> Error at line 135548: script md/admin/prvtsidx.plb
- 3/23 PLS-00201: identifier 'MDSYS.SDO_GEOMETRY' must be declared
-> Error at line 135549: script md/admin/prvtsidx.plb
- 10/3 PL/SQL: Declaration ignored
-> Error at line 135550: script md/admin/prvtsidx.plb
- 10/23 PLS-00201: identifier 'MDSYS.ST_GEOMETRY' must be declared
-> Error at line 135551: script md/admin/prvtsidx.plb
- 17/3 PL/SQL: Declaration ignored
-> Error at line 135552: script md/admin/prvtsidx.plb
- 17/23 PLS-00201: identifier 'MDSYS.ST_GEOMETRY' must be declared
-> Error at line 135553: script md/admin/prvtsidx.plb
Oracle Spatial is not configured in DB but datapatch creates below objects during patch apply -
OWNER OBJECT_NAME OBJECT_TYPE
------------ ---------------------------------------- ----------------------------------------
SYS PRVT_IDX PACKAGE
SYS MDPRVT_IDX PACKAGE
SYS MDPRVT_IDX PACKAGE BODY
SYS PRVT_IDX PACKAGE BODY
SYS SDO_INDEX_METHOD_10I TYPE
SYS SDO_INDEX_METHOD_10I TYPE BODY
------------ ---------------------------------------- ----------------------------------------
SYS PRVT_IDX PACKAGE
SYS MDPRVT_IDX PACKAGE
SYS MDPRVT_IDX PACKAGE BODY
SYS PRVT_IDX PACKAGE BODY
SYS SDO_INDEX_METHOD_10I TYPE
SYS SDO_INDEX_METHOD_10I TYPE BODY
Patch 28437849 is already applied.
BUG:28437849 - DATAPATCH IGNORES INSTALLED COMPONENTS W/OPTIONS NOQI OR FORCE
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 |