The Triora Group

Staged Environments: Steven Chan has recently published a new article about utilizing pre-patched or “staged” environments (Reducing Patching Downtimes with Staged Applications Systems). Staged Applications patching is near and dear to our hearts, as it’s the easiest way to reduce the downtime window of an upgrade (except for faster hardware…:-)).  The article clearly outlines the [...]

[Read more →]

In my first blog here at Triora I talked about driving our Oracle learning. Today’s article is the result of a recent learning session. These days I am far too busy to play on my home systems as much as I would like, but every now and then I take a few of the 168 [...]

[Read more →]

Over the years, I’ve often been reminded of a diagram in the book, The 7 Habits of Highly Effective People.  In Chapter 3, Steven Covey discusses the need to “Put First Things First” and includes a discussion about four types of activities that we all face at work.  Two of the activities are critical to [...]

[Read more →]

For those of you tracking the latest releases, 10gR2 Version 10.2.0.4 is now certified for Release 11i. We’re anxiously awaiting certification for Release 12. Oracle has released the latest Critical Patch Update - be sure to check out www.integrigy.com’s evaluation of the July 2008 CPU, which points to the resolution of a high risk database [...]

[Read more →]

What am I talking about? I love playing with anagrams. Each of the anagrams above describes the topic we are going to talk about. Can you decipher it before reading on? The answer is given at the end of this article…
How about some cool Autoconfig stuff for this month’s article? Last week I upgraded an [...]

[Read more →]

Yesterday as I was walking my dogs, I spotted a little bit of “little boy heaven”: two slugs – really big slugs – slithering on my hillside. I did the only thing a reallly cool Mommy could do under the circumstances – I ran back to the house and dragged my son out of bed, made [...]

[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 →]

What do you know about the E-Business Suite and statistics? Come with us for an inside view of gathering statistics in Release 11i. One of the areas we like to look at when doing performance tuning for Release 11i systems is to review our clients’ approach to gathering database statistics. Now, gathering statistics can spark [...]

[Read more →]

There continues to be confusion about the role of Applications DBAs in supporting the E-Business Suite (EBS). We still encounter organizations that believe that any Oracle DBA can easily transition over to being an Applications DBA (it is still a database after all!). For them, EBS is seen as just another commercial-off-the-shelf (COTS) application with [...]

[Read more →]

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 [...]

[Read more →]