IGL 7.2 - upgrading from Oracle 12 to 19

[AndyCheek]

We're going to be upgrading our 7.1.1 installation to 7.2 while still on Oracle 12 then doing a separate Oracle upgrade to go from 12 to 19. Does the 7.2 documentation list any configuration changes required for the new DBMS version?

I know someone might say "better do it all at the same time", but this is due to resourcing/timing constraints outside of our control.

I have been assured the Oracle upgrade is straightforward - what is the impact on IGL?

[MHelmy · Accepted solution]

Yes first get to v7.2.0 then upgrade to Oracle 19c. If you upgrade Oracle to 19c before upgrading to v7.2.0, the application will not even start. Our application checks the database version on start-up, and if the detected version is not a supported one (19c is not supported for anything before v7.2.0) then it will fail and not start at all.

As for the required parameter changes on 19c, check out this KB:

000039034 - Recommended Oracle 19c Optimizer Settings for RSA Identity Governance & Lifecycle