The Triora Group

PLEASE READ THIS BEFORE YOU START!

While performing a recent upgrade FROM Release 11.5.9.2 / RDBMS 9.2.0.8 TO Release 12.0.4 (with the 12.0.5 Financials Family Pack) on RDBMS 10.2.0.3, we encountered many issues that stemmed from the same root cause. With a little research, we determined that two database options, OLAP and Data Mining, needed to be installed as pre-requisites for the Release 12 upgrade.

Given that these options are listed at $20K/CPU on Oracle’s price list, this caused some concern, as you can imagine.

We opened a Service Request (SR) with Oracle and they confirmed that the options needed to be installed for the worker jobs to finish. After a lively discussion, we’ve now done so after being assured by Oracle that this was a “runtime” requirement and, as such, did not have a charge associated with it. The MetaLink documents to refer to are: 552973.1and 362203.1

We have verified this at another Release 11.5.9.2 / RDBMS 10.2.0.3 RAC client site with different modules and the requirement to install the database options still exists. We have asked Oracle to create a MetaLink document addressing this specific issue because many Applications upgrades will encounter this issue.

Here are some of the metrics from the two major patches we applied:

- The 12.0.4 RUP ran in approximately 24 hours with 140,000 worker jobs.

- The 12.0.5 Financials Family Pack patch ran in approximately one hour.

Good luck on your upgrade!

If you enjoyed this post, make sure you subscribe to my RSS feed!