Health Report shows Invalid for Oracle 19c optimizer (DE60295 )

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• STARTER PACK-CLARITY PPM

Issue/Introduction

DE60295 Health Report shows Invalid for Oracle 19c optimizer

STEPS TO REPRODUCE:

1. Have an Oracle system linked to Clarity
2. Run the healthreport in UI by going to Administration - Health Report
3. Go to Database

Expected Results: To see the Optimizer Features Enable, to be able to select 19.1.0 or equivalent. It should be accepting the default value for the Oracle 19c version

Actual Results: Optimizer Features Enable is setting Invalid for the default value. When DBA is trying to set it to the "Recommended Value = 19.0.0.0" they set an error message: ORA-00096: invalid value 19.0.0.0 for parameter optimizer_features_enable

 

Environment

Release : 15.9.1

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

The setting optimizer_features_enable should be set to the default value for the Oracle version. To do this, please delete the value from the init.ora file, and restart the database.

The health report will still show Invalid, please ignore this for now as it's going to be addressed by the fix for the defect below: 

This is DE60295, in review by Engineering