Press Summary
Cloning Oracle Databases with EMC SnapView and RecoverPoint
July 8th, 2010
Written by Centroid
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 "clones" within the framework of the following environment/architecture:
Oracle 11.1.0.7, HP-UX 11iV2
EMC CLARiiON CX4 storage arrays at production...
Large SGA on 32-bit Redhat Linux
June 10th, 2010
Written by Centroid
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 use ramfs instead of tmpfs because it doesn't use swap; tmpfs does. With ramfs memory allocation will also grow dynamically, whereas when...
Using DBMS_SQLDIAG
March 3rd, 2010
Written by Centroid
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 to reproduce the issue in-house.
The situation had to do with optimizer_features_enable being set to 11.1.0.7 in a database recently upgraded form 9.2.0.5 in an Oracle eBusiness Suite environment (11.5.10.2) that utilized...
Future Proofing Oracle EBS: Tip 1
January 30th, 2010
Written by Centroid
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, 20 percent will eventually apply 6 to 9 months later while another 20 percent have no...
Oracle EBS 12.1.1 Upgrade from 12.0.6 - Lessons Learned
October 12th, 2009
Written by Centroid
So you're going to patch from 12.0.6 to 12.1.1? It's basically like any other major upgrade with Oracle's e-Business Suite; tons of pieces to upgrade, patch, validate, and a high potential for running into problems. The documentation for all the "gotchas" is all over the place, but Metalink document 752619.1 is the best place to start and has all the major steps listed. In general, the following is required:
Confirm database version
Upgrade 10.1.3 home to 10.1.3.4
Upgrade 10.1.2 home to...
