My Oracle Support Banner

Datapatch Reports: Package Body created with compilation errors on RECLAIMTEMPSEGMENT and KCP_PLG_RECLAIM_SEGMENT (Doc ID 2687525.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.
Linux x86-64 on Oracle Public Cloud

Symptoms

1. After installing 12.1.0.2.200414DBBP and running Datapatch reports errors attempting to rollback an old patch from PDB$SEED and other user PDBs:

Patch 28281213 rollback (pdb PDB$SEED): WITH ERRORS
  logfile: <PATH>>/cfgtoollogs/sqlpatch/28281213/22303559/28281213_rollback_DUMMY121_PDBSEED_2020Jun16_12_03_23.log (errors)
    Error at line 34: Warning: Package Body created with compilation errors.
    Error at line 40: 398/13   PLS-00323: subprogram or cursor 'RECLAIMTEMPSEGMENT' is declared
    Error at line 44: 671/13   PLS-00323: subprogram or cursor 'KCP_PLG_RECLAIM_SEGMENT' is

2. A query on  PDB_PLUG_IN_VIOLATIONS shows errors:

12-JUN-20 09.22.10,4 PDB$SEED SQL patch error ERROR 0 1 SQL patch ID/UID 28281213/22303559 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 19809171 2800 PENDING
Call datapatch to reinstall 63003  ROLLBACK with status WITH ERRORS in the PDB.

3. The error persists even if we recompile the objects.

4. Note that the patch that Datapatch is pointing was installed before in a previous installed 12.1.0.2.180717DBBP
 

Changes

 

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
Changes
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.