db load error | ORA-00406 | ORA-00722

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

In the step of upgrading the database using UCYBDBLD against UC_UPD.TXT, the following error occurs

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', ", 'ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater ORA-00722: Feature "Editions"

Hitting "OK" goes to "U00038077 Do You want to ignore this error?" 
Please Note: Do not continue without contacting Automic Support!

Environment

Release : 21.0.5

Resolution

Based on information from Oracle, the compatible parameter in the database must be updated.  A DBA needs to be involved as this requires an update to the database outside of Automic.  The DBA will need to update the parameter (it may require a restore of the database first), then they'll need to restart the database:

• The following statement:
  CREATE OR REPLACE FORCE EDITIONABLE VIEW XEVENTS AS ...
  is returning this error from the database:
  ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater
  ORA-00722: Feature "Editions"
• A search on Oracle Support's site explains this error and says that a DBA must review Note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
• Please review the compatible parameter within the database and follow steps to update this

Prior to 21.0.10, the database has already been altered when this error occurs and you will likely need the DBA to restore the database to a snapshot taken before running the DB Load.  As of 21.0.10, this will be checked prior to the database being updated, so a database restore should not be needed.