The Triora Group

For those of you on Release 12, MetaLink Doc. ID: 746824.1, “Alert! – Mandatory Patch R12.1 SCP_PF.B CU1 (12.1.01) Released” announces another mandatory patch. The SCP_PF.B CU1 patch looks like the first Critical Update patch for Release 12.1, which hasn’t been released yet. Floyd Teter tells us he thinks Release 12.1 [...]

[Read more →]

We received this question from a colleague:
I applied the RUP 6 patch (plus pre and post req patches)  in my Patch and DEV instance and all seemed to work just fine. So I applied RUP 6 to our Test environment and there were a few issues but it seemed I resolved them. The errors I [...]

[Read more →]

Special thanks go to Jeff Vold, the Apps DBA at Hazelden Foundation, who wrote this article about RUP6.

Hazelden Foundation is running Release 11.5.9 in production and is in the midst of a Release 12 upgrade. We recently applied the 12.0.6 Release Update Pack (RUP6) on top of our 12.0.4 development environment, and were asked to [...]

[Read more →]

If there is one question that we are asked most frequently by our clients, this is probably it. Unfortunately, the answer isn’t as cut-and-dried as they typically expect. Just like onions (and ogres), the answer has layers.
First, let’s ask the question, “Why do we patch?” or, more precisely, “Why do we want to [...]

[Read more →]

Many Apps DBAs already know how to automate patching for the E-Business Suite. But, it has been quite awhile since I saw anything written on this activity for the newer incoming Apps DBAs, so I though I would take a few minutes to cover this. For me, there are also some additional efficiencies to be [...]

[Read more →]

Here’s a question that popped up during one of our client’s upgrades:
Question: Are you aware of any reason that a 11.5.10.2/10.2.0.3 instance would need/want to have aq_tm_processes=0? I’m familiar with setting it to zero for patching/upgrades, but when running live in production, I have always thought (and all of the docs I can find say) [...]

[Read more →]

When applying HR Patches, we frequently have to load legislative data. This is accomplished by running a java-based tool called “DataInstall” which basically just sets a few flags.  You then use the adpatch tool to apply the latest “hrglobal.drv”.  The hrglobal.drv driver uses the flags set by DataInstall to determine which [...]

[Read more →]

This month’s blog was supposed to be about a workflow issue that I ran into on a recent upgrade. However, that problem requires some additional research before I can post the findings here. So I decided to write about a different issue that came up during the same upgrade.
The recent upgrade was centered upon upgrading [...]

[Read more →]

Since its introduction in July 2005, 10gR2 has become the database version of choice for many E-Business Suite environments. Originally released as 10.2.0.1 it has been regularly enhanced with new patches to 10.2.0.3. In the last several months, the third patch set was released for 10gR2, raising its current version to 10.2.0.4. [...]

[Read more →]

We here at Triora Group are big advocates of staying current on RDBMS versions, so we’re excitedly waiting for the next RDBMS 10g patch, Version 10.2.0.4. We know it includes more performance patches for the database – always a good thing. However, we have to stand by Oracle’s caveat – not until it’s certified for [...]

[Read more →]