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

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

Let’s Catch Up, Okay?

I have not posted here in a while; it was my original expectation to post here more often during a learning period as I explore exactly what AWS is offering, how it is used, and how it is kept safe. The distinction between private vs. public is still customarily considered to be physical hardware in…

Read More

Oracle, Amazon has the right model

I want to go on record with my preliminary investigation of Oracle licenses obtained through traditional sources and those provided by Amazon. There are two different philosophies at work here. Oracle and Amazon are at odds. Amazon will win. Either Oracle prices will be allowed to get cheaper, or people will move off to other…

Read More

“When the moon is in the seventh house

And Jupiter aligns with Mars, Then peace will guide the planets, And love will steer the stars. This is the dawning of the age of Aquarius, the age of Aquarius, Aquarius, Aquarius”. This is the dawning of the age, the Age of Aquarius Amazon. Amazon Web Services is, or has the ability to become, everything at one’s fingertips. Before…

Read More