Kevin Kempf's Blog

January 6, 2015

Oracle R12.2 Post-Upgrade Ramblings

Filed under: R12.2 — kkempf @ 4:55 pm


Live on 12.2

Over Thanksgiving weekend, we upgraded from to 12.2.3.  It was a monumentally big project, at least for our organization, and I’m very happy it’s in the rear-view mirror.  There was only one “if this doesn’t get fixed we’re rolling back” moment, and for the most part the upgrade and transition has gone smoothly.  After being live for over a month, and surviving month end closes, year end closes, and multiple clones, I feel confident saying R12.2 behaves better than once properly tweaked.

What the Upgrade Looks Like

To be honest, the upgrade is a ton of work.  There’s 11i pre-patching and prep-work (some of which cannot be done prior to down time for go-live), followed by a rapid install of 12.2, application dba tasks, running good old adpatch against a gigantic merged driver, another rapid install pass on 12.2, enabling online patching, apply lots of techstack patches, applying 12.2.3 with adop (your new best friend/worst enemy), and enough post-install tasks to make any DBA happy.  In real terms, this meant cramming about 50 hours worth of wall time into 62 hours of a weekend window.  Not much sleep.

Next Post

While the task is still fresh in my mind, I’m going to express some of the (many) pain points R12.2 brought with it, and how we coped with them.  It’s a whole new ballgame.



  1. When you upgraded to 12.2.3, were you able to migrate all your modplsql apps or did you have to use the work around of creating a separate 10gAS installation and routing apps through that? Can you share your experience.

    Comment by sarveswara — January 9, 2015 @ 7:20 pm

    • Wasn’t an issue for us, so I’m no help to you there. I might suggest looking at Apex as a solution to move forward with.

      Comment by kkempf — January 10, 2015 @ 8:17 pm

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Blog at