Centroid Blog

I’m sure this is well-known and documented behavior to RecoverPoint appliance experts, but we recently found what we think to be a very nice feature in EMC’s RecoverPoint behavior that perhaps some folks new to the technology are unaware of …
Today we did a large (1Tb) backup of an assortment of Oracle database files on [...]

Many are familiar with the steps required to clone Oracle database using “rman duplicate” or “hot backup” cloning .  Many are also familiar with steps required to create EMC SnapView Clones or SnapView Snapshots, either with the Navisphere web interface or CLI.  In this post, I’ll outline steps required to build consistent, usable Oracle database [...]

Goals:

Move Oracle storage from HP XP platform to EMC CLARiiON storage array
Utilize EMC Enterprise Flash Drives (EFDs) for most database files, FC drives for application/Oracle software, Oracle redo logs, archive log destination, and UNDO tablespace files
Transition from HP-UX 11.23 file-system based storage to Oracle ASM (on combination of EFDs and FC drives)

Environment Details:

HP RP8420 PA-RISC, [...]

Many DBAs are familiar with the SGA size limitations on 32-bit platforms.  This post shows how to allocate a 3Gb buffer cache on 32-bit RHAS 3.

Step 1: Mount /dev/shm to as type ramfs.  Edit /etc/fstab and add an entry like this:

none                    /dev/shm                ramfs defaults,size=4G 0 0

Step 2: do a “mount -a” to mount /dev/shm.  I [...]

In R12 the formatting of payments (Checks, ACH, wires) and the output of related documents (positive pay, Separate Remittance Advice) is done by a Java concurrent programs that generate XML output which is then formatted by BI Publisher.
Oracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to [...]

I recently received a requirement to account for the entire deferred revenue amount of a sale, then recognize the revenue over time, based on consumption or clicks from a customer. Oracle Receivables has two “commitment” transaction classes to support this type of requirement.
The two commitment transaction classes are:
Guarantees: as you associate invoice transactions the amount [...]

As a DBA, have you ever had an issue you suspected may be a bug and have been asked to generate “test data” for Oracle development?  We ran into this at a client recently and found a cool 11g utility (at least I *think* it’s new :)) to get Oracle Support the data they need [...]

On a recent project we had a business and technology reason to connect Oracle EBS running 11g to a DB2 database.  After a few weeks of researching for the best practice and approach we decided on the following implementation steps.

Download a DB2 driver, such as from DataTek, and download to your application server in any [...]

Most organizations leave their mission critical systems vulnerable to security threats and performance degradation. Recent studies show that organizational constraints are at the core of this issue. These constraints range from organizational policies, budgets and staff availability and even competency.
26 percent of organizations apply critical security and performance patches as they are released, [...]

Often, in Oracle E-Business Suite Release 12 (R12) during an implementation or after patching, the pre-compiled jsp’s need to be recompiled because you aren’t seeing the change you expect. You can selectively recompile jsp’s using this program, but I like to just blow away everything and start fresh. Support documentation states [...]