Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

compatible parameter for 19c

Upgrading to 19c. from 12..1.0.2 for EBS and a data warehouse.

Do i set the compatible parameter to 19.0.0 or 19.10.0? The Jan CPU is applied to 19.0.0 which makes the version 19.10.0.

What about these parameters? I know anything after the 3rd digit is not necessary.

SQL> select name, value from v$parameter where value like '12.%'

 

NAME                          VALUE

------------------------------ --------------------

compatible                    12.1.0.2.0

_compression_compatibility    12.1.0.2.0

optimizer_features_enable     12.1.0.2

_optimizer_undo_cost_change   12.1.0.2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center