Category Database

Patch and Provision in EM12c: #5 Provision a Real Application Cluster Database

As part of the Database Lifecycle Management (DBLM) Pack, Database Provisioning in Enterprise Manager is a powerful and quite flexible feature to provision databases. In the past, I have written several articles on Patching and Provisioning (P&P) using the #em12c and today I’d like to add one more to the list. This time, it is […]

Create a Standby Database using EM12c

I wanted to make this a quick post, because a friend was mentioning a slight problem during a manual set up of Data Guard. I told him you could do it through EM, and then recalled that I had documented it a while back. After the tube light finally went on in my head, it […]

opatch apply online on 11.2.0.4

The credit for the patch apply in the post goes to a new friend that wishes to remain anonymous, except that her initials start with KA, and who happens to work at a company in Memphis, TN. Coincidentally, that is where I had been liv. During a recent EM12c project at her company, we were […]

Grid Infrastructure 12.1.0.1.0 Cluster Health Monitor – A Deconstruction

While digging around Grid Infrastructure logs, I came across this new feature with 12c called Cluster Health Monitor (CHM) – I knew the MGMTDB database was good for something when I opted to install it even though it is not required. From Oracle’s Documentation “The Cluster Health Monitor (CHM) detects and analyzes operating system and […]

Patch and Provision with EM12c: Index

Over the last few months, I’ve written a few posts on Provisioning Databases in EM12c. After writing them out, I’ve realized that they’re note organized in the best manner. With that in mind, I’ve created a list (see below) which I hope to keep updated, and you will find as a helpful resource. 1. Patch […]

11gR1 to 11gR2 RAC – An Upgrade Experience on Solaris

I’ve recently gone through an experience (see title), that I thought would be a good one to share. As of late, I’ve started documenting the life out of any project/task, and this is one of in the long line of many. Basically, the goal here was to upgrade an existing 11gR1 RAC configuration to 11gR2 […]

SRVCTL: Add Preferred Instances

Dedicated to an old friend and colleague. 1.     Add the service. Please take note, the instance names are in UPPER case. [oowner@gxtbdb01 ~]$ srvctl status service -d utldb [oowner@gxtbdb01 ~]$ srvctl add service -d utldb -s test -r UTLDB1 2.     Start it [oowner@gxtbdb01 ~]$ srvctl status service -d utldb Service test is not running. [oowner@gxtbdb01 […]

How to Resume an RMAN Duplicate on Failure – Just Re-Run it!

If you find yourself at the with an error message like below during an RMAN Duplicate, don’t worry about it. As I found out from dumb luck, it’s quite easy! RMAN-03002: failure of recover command at 10/07/2013 15:11:47RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 53302 and starting SCN of 143193979270 […]

How long did your Database Upgrade actually take?

This might be old news, but it became new news for me after I discovered it last week. As far as I know, there’s no way to determine the length of a database upgrade. There are, however, ways to influence the length by gathering dictionary stats, truncate AUD$ and FGA_LOG$. At the end of the […]

ORA-00119 During a Database Upgrade

I consider myself a reasonably detail oriented person – reasonably… Well, every now and then, more often than not, I tend to overlook documentation. Either that, or my dyslexia kicks in. Before I go into my story, let me explain the configuration, which led me to the setup on which I had a problem.   […]

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's blog

Sharing stuff (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog