ADOP Cleanup phase results In ORA-38802: Edition Does Not Exist, SQL[ORA$BASE]
(Doc ID 2967087.1)
Last updated on AUGUST 21, 2023
Applies to:
Oracle Applications DBA - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.12 version, Online Patching - OP
When attempting to run adop cleanup,
the following error occurs.
ERROR
-----------------------
[WARNING] Could not drop covered object [ORA$BASE] APPS.PAY_US_REPORTING_UTILS_PKG (PACKAGE BODY): ORA-38802: edition does not exist
[ERROR] ORA-38802: edition does not exist, SQL[ORA$BASE]: drop VIEW "APPS"."PMIFV_QC_MATCH_HDR_V" cascade constraints
[WARNING] Could not drop covered object [ORA$BASE] APPS.PMIFV_QC_MATCH_HDR_V (VIEW): ORA-38802: edition does not exist
[ERROR] ORA-38802: edition does not exist, SQL[ORA$BASE]: drop PACKAGE BODY "APPS"."OZF_OFFER_PUB_OAW"
[WARNING] Could not drop covered object [ORA$BASE] APPS.OZF_OFFER_PUB_OAW (PACKAGE BODY): ORA-38802: edition does not exist
[ERROR] ORA-38802: edition does not exist, SQL[ORA$BASE]: drop VIEW "APPS"."PMIFV_QC_MATCH_HDR_V" cascade constraints
[WARNING] Could not drop covered object [ORA$BASE] APPS.PMIFV_QC_MATCH_HDR_V (VIEW): ORA-38802: edition does not exist
[ERROR] ORA-38802: edition does not exist, SQL[ORA$BASE]: drop PACKAGE BODY "APPS"."OZF_OFFER_PUB_OAW"
[WARNING] Could not drop covered object [ORA$BASE] APPS.OZF_OFFER_PUB_OAW (PACKAGE BODY): ORA-38802: edition does not exist
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run "adop prepare"
Changes
Migration from Solaris to Redhat Linux 8
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 |