An Inherited Oracle Instance

What do you do when you become responsible for an Oracle database that has been running for three years, accumulating nobody really knows what, other than it’s all very important. You have the Window 2008 r2 server administrator password, and the Oracle “system” password. You are the administrator of something else, and now, this is…

Read More

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 PULA is Real but Why?

It is not always clear what rumors about Oracle licensing are true. With regard to the new Perpetual User License Agreement (PULA), some you hear is probably true. The best advice I keep in mind is that anything which was ever once negotiable remains negotiable. Oracle prices are not set in stone (or gold) as…

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

What About Data Guard Experience?

Oracle Data Guard and Active Data Guard are basically GUIs used to accomplish some form of data replication. I have been doing data replication with Oracle since 1990 where I built a rapid prototype, integrated, distributed database system between Fort Lee (Oracle/PC) and Fort Monroe (SQL DS/4381). Designed, coded, and demonstrated product in four weeks….

Read More

No RAC Here; but,

As an independent contractor working with Oracle databases, I frequently am asked about RAC experience. Here is my analysis of the product written in 2004 when Oracle went fro “i” to “g”. As contract DBA for Guidance Software, I accomplished the forensic preservation of the Oracle database of the infamous 77 Million Users Data Breach. Under…

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

Oracle Can Be So Difficult

A year ago a Navy IT friend of mine came over so we could install Oracle Enterprise Manager (OEM) on an AWS (Amazon) instance. He had installed the Oracle 11g database on some hardware running Linux; but, Enterprise Manager was a separate download. The last few times I had installed it, EM was included in the…

Read More

Good News for Oracle RDS Users

An Oracle database is not for everyone. The preferred course to database selection would be a requirements analysis and formal responses to a request for proposal (RFP). Chances are when this is done that either Oracle Enterprise Edition will be selected, or some other database product completely. Enterprise Edition is Oracle’s only product that (normally)…

Read More

X11 and xclock error message

This one will either be simple enough to resolve or become one of those glitches one learns to accept. “xclock” doesn’t hold a big place in my life. I have learned to love a good GUI; at least on my Oracle database. The management console, no matter what name Oracle gives it, for a while….

Read More