The Triora Group

Oracle E-Business Suite and the Oracle Database

The Triora Group header image 4

Entries Tagged as 'Database'

The Latest Scoop on Patches for Irritating Problems

July 30th, 2008 · No Comments

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

Tags: Critical Patch Update · DBA · Database · E-Business Suite · Patch · Release 11i

Force Coagulation, Caution Focal Ogre and Inaccurate Fool Go

July 30th, 2008 · No Comments

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

Tags: DBA · Database · E-Business Suite · Release 11i

Slugs, it Turns Out, Do Not Make Good Pets

July 25th, 2008 · No Comments

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

Tags: DBA · Data Vault · Database · E-Business Suite · Release 11i · Security

New Oracle Database 10g Patch #3 Certified (10.2.0.4)

July 23rd, 2008 · No Comments

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

Tags: Critical Patch Update · DBA · Data Vault · Database · Oracle · Patch · Premier Support · Release 11i · Steven Chan

Auditing Options

July 1st, 2008 · No Comments

We’re often asked about the different ways of auditing to help ensure security for an E-Business Suite environment. Here’s a quick summary of some of your options:
Operating System Auditing
Many types of auditing are available, especially if “sudo” is utilized. “sudo” should be utilized for ALL accounts, though we find that it often is not in […]

[Read more →]

Tags: DBA · Database

Time to Upgrade to RDBMS Version 10.2.0.4? Not Quite.

July 1st, 2008 · No Comments

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

Tags: DBA · Database · E-Business Suite · Release 11i · Release 12

Lies, Damned Lies, and Statistics

June 30th, 2008 · 1 Comment

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

Tags: DBA · Database · E-Business Suite · SOA Suite · Uncategorized

Upgrading to Release 12?

June 3rd, 2008 · No Comments

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

Tags: Database · E-Business Suite · Release 12 · Upgrades

DB Vault now certified with E-Business Suite 11i

February 7th, 2008 · No Comments

For years companies have had to guess whether their DBA’s were avoiding the temptation to run a few SELECTS on confidential financial information. After all, who doesn’t occasionally wonder what their manager is making?
And I’ve seen at least one case where it happened deep in the heart of Texas. […]

[Read more →]

Tags: DBA · Data Vault · Database · E-Business Suite · Oracle · Security