Kevin Kempf's Blog

About

An Oracle R12.2 DBA in South Carolina, USA.

This blog will likely focus mainly on Oracle, with a few diversions as I see fit.   I would describe myself as a healthy skeptic and rather pragmatic in regard to Oracle products.

Interestingly, it can also serve as a nice place to send friends and relatives when they really want to know what I do at work. (And why I’m no expert at Windows problems)

My Oracle landscape looks like this, for a total of 8 instances on 6 nodes:

  • Oracle Apps 12.2.3 on Oracle Linux 6 (x86-64, UEK) with RDBMS 11.2.0.4 on Oracle Linux 5 (x86-64, UEK) sitting on VMWare,  utilizing Dataguard over WAN as disaster recovery insurance
  • Development, Regression Testing, Training, and Audit versions of the 12.2 environment
  • A handful of standalone Oracle databases (10.2 – 11.2) on Oracle Linux 6 (x86-64, UEK) running disparate applications. One of these runs on Windows 2008R2, due to 3rd party vendor constraints (all VMWare virtual machines)
  • Oracle Enterprise Manager 11g with RDBMS 11.2 on Oracle Linux 5 (x86-64) with Diagnostics and Tuning packs.
  • Oracle APEX integrated into R12 as our solution to replace Discoverer since we’re not sophisticated/rich enough for OBIEE.
  • RMAN backups for everything, orchestrated out of EM 11g.

All the opinions and explanations expressed in the blog are my own, use at your own risk!

Please feel free to leave comments! I’d like to know if you agree, disagree, have had a similar issue, etc.

I look forward to hearing from you.

3 Comments »

  1. Hi
    I’m from Mexico and you have no idea how much I laugh with your article “Resolved with Solution? “, it’s awesome how we can get the same comments from different topics, and I thought I couldn´t be more surprise that when I receive an update from the analyst: “Do you still have the issue?” after a week waiting for her update… its unbelievable.
    You´ll be surprised how things are when you´re in an On Demand @Oracle schema… I figure it out you can imagine.

    Please continue writing about technical topics and other not so much… its refreshing knowing you´re not the only one with Oracle Support issues

    Best regards

    Comment by JP — September 25, 2012 @ 6:43 pm

  2. Hi Kevin –

    I’m in Houston, Texas supporting an environment with Oracle 9i (in the process of decommission), 10g, 11g, and 12c (coming soon) running on Windows and Linux in VMware.

    Your article on rotating the listener logs is a total lifesaver! As our environment grows, quite frankly I am astonished at the maintenance issues that just never came up when studying how to manage your databases in school. I really appreciate your sense of humor about this stuff!

    Are you planning to attend Oracle World in a couple of weeks?

    Comment by Teresa Dillard — September 17, 2014 @ 2:04 pm

    • Glad you found my ramblings of use; I won’t be at OOW this year, though I do get out there occasionally.

      Comment by kkempf — September 17, 2014 @ 3:17 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.