I’m in the middle of testing for my company’s Oracle 12c production upgrades coming in September. Thankfully, I have a lot of good testbeds to fine-tune the upgrade process before proceeding to production. So far, things have been pretty smooth, even much better than my 11.2.0.3 to 11.2.0.4 upgrades a year ago. I thought I’d outline a few things I’ve dealt with during our testing in case this helps someone else down the road.
- New for me this year is that our Test database environment is now Oracle RAC. Previously, my only non-production RAC machines were empty databases on VMs. At least now I can test out GI upgrades with our data. This is huge and led me to the next bullet point.
- Ran into Bug 19582630 in my Grid Infrastructure 12.1.0.2 installation. The new Memory Guard would incorrectly detect an out-of-memory condition which I blogged about here. A workaround was employed until such time as the bug’s patch could be installed.
- WM_CONCAT is no longer with us. This broke 4 packages for application code. It was easy to use LISTAGG as a replacement.
- Oracle 12c has deprecated the SEC_CASE_SENSITIVE_LOGON parameter. Changing to case sensitive passwords could break our application. I now have a utility to make application passwords case sensitive and I can now move forward.
- Hit Bug 20369415 in which an ACL with a timezone caused upgrade issues. The solution was to drop the ACL and recreate it without the timezone information.
- Whomever installed this database initially installed many unused database options like APEX, OLAP Catalog, and the EM Repository. I finally got around to removing these prior to the upgrade.
- CVU reports are not being purged. See Note 1964482.1 for details. I’ll get a cron job setup to remove these on a regular basis.
- Oracle 12c’s new security model with respect to Invoker’s Rights procedures required us to GRANT INHERIT ANY PRIVILEGES to a specific schema user.
How does Confido from Himalaya helps you terminate Premature Ejaculation and Erectile Dysfunction? Confido is manufactured and prepared from naturally available herbs like Salep Orchid or Salabmisri, Hygrophilia or Kokilaksha, Lettuce, Cow-Itch Plant, Suvarnavang viagra pills in canada etc. But now it is easy to cure this prescription viagra online disorder with so many drugs available in market or on online stores based in Australia. discount levitra no rx Really, it is not so. Let him/her know if you have levitra 20mg australia health ailments related to the pelvis.
That seems to be it for me, at least so far. I’ll be rolling through the rest of our non-production databases soon before upgrading prod to 12c in a few weeks. My fingers are crossed that I’ve handled all of the upgrade issues.
