Skip to Main Content
  • Questions

  • Database upgrade from 12c to 19c parameter change

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pradeep Kumar.

Asked: December 12, 2021 - 3:49 pm UTC

Last updated: May 23, 2022 - 4:12 am UTC

Version: 19.11

Viewed 1000+ times

You Asked

Hello Sir,

Need one suggestion after upgrade oracle database from 12c to 19c which are the initialization parameter need to change for better performance.

kindly help to understand this.

One more suggestion required is there any precheck we can follow for successful GI upgrade from 12c to 19c.


Thanks
Pradeep

and Connor said...

During an upgrade I would recommend

1- not changing any parameters unless explicitly told to do so in the upgrade manual
2- ideally changing any parameters *you* have set back to defaults to get back to a "vanilla" environment

Obviously with (2), you would do this in your testing environment first.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Auto upgrade utility.

Rajeshwaran Jeyabal, December 15, 2021 - 4:32 am UTC

But would you recommend to go with Auto Upgrade utility in this case?

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html#GUID-71883C8C-7A34-4E93-8955-040CB04F2109
Connor McDonald
May 23, 2022 - 4:12 am UTC

Definitely.

Whenever possible, autoupgrade is the way to go


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database