Building an Oracle Image on AWS EC2

The effort behind the AWS button push does not appear accidentally. RDS makes it appear so simple. The only reason for me to build on EC2 is the ability to shut down certain configurations depending on the project. This post documents what it takes to build a fresh image of an operational, usable instance of Oracle 12c…

Read More

Oracle to PostgreSQL

After spending four months tuning an 11g instance and proprietary application SQL using Oracle tools and the Oracle Wait Interface (OWI) I am a big fan of Oracle Enterprise Edition. Oracle Standard Edition does not contain license to internal data collected by the kernel and used by the OWI. This AWR and ASH data licensing…

Read More

Old, Slow and Meticulous…

that’s me when it comes to tuning your Oracle database. Tuning an Oracle database is nothing more than configuring the system and program global areas and locking them into memory. This is relatively simple on Solaris and most Linux distributions. Oracle has been building in tuning features for thirty years. They have succeeded with version…

Read More

Install of Oracle Enterprise Manager 12c – Failed

To see why it failed, see my post here. After obtaining the required files for the 64-bit Windows installation they were unzipped into a staging area. In an effort to rule out a “null pointer” Java error, a common, catch-all error, they were unzipped a second time in sequential order (i.e., zip1, zip2, zip3)… it didn’t…

Read More