Category: Uncategorized

I have a two-node RAC cluster for my standby databases. I recently moved instances from one node to a new replacement node. In one of my standby databases, Grid Control was reporting a configuration error for an instance I moved to the new node. I went to Targets->All Targets and found the instance in error. …

Continue reading

I recently needed to replace some physical hardware on my 2-node RAC standby cluster. Both nodes were being replaced by new servers. I went through the process of adding one of the new servers as a third node in the cluster and then I was going to drop one of the old nodes. Adding the …

Continue reading

Email alerting has changed a bit in Enterprise Manager 12c Cloud Control. After you have defined your email address in EM12c and your notification schedule (this is similar to the way it was done in EM 11g), you have a few more steps to do. The out-of-the-box rules do not apply to Warning alerts, only …

Continue reading

Well this is one of those frustrating situations that make you ask why it cannot be simplified. I am trying to start my Enterprise Manager 12c Cloud Control environment and I get the following: Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved. Starting WebTier… WebTier Successfully …

Continue reading

In a previous post, I lamented about how I do not like the Compression Advisor that runs automatically in Oracle 11.2. I do not have this option licensed yet Oracle insists on letting me know which tables would benefit from compression when I cannot legally compress them! In the previous post, I referred to the …

Continue reading

I’ve been having a problem with a 3rd party application. Whenever I run DBMS_STATS on the application schema my database will peg the CPU and will run for days without completion until I cancel it. The part that took me forever to figure out is the SQL statement that is consuming all of the CPU …

Continue reading

Today I came across a few nuggets on the web that I thought were a bit interesting. Jonathan Lewis talks about proactive tuning on his blog. Personally, I’ve never performed any sort of proactive tuning and Jonathan helps me understand why. The manufacturers of this reputed brand launched brand viagra from canada effective medicines by …

Continue reading

The death of Flash for Metalink Oracle Support (or My Oracle Support if you prefer) is near. Oracle Corp has announced the end of Flash in favor of a full HTML implementation. I’ve been using the HTML interface for a while now and it works well for me. There have only been three types of …

Continue reading

So I’ve been trying to track down why I seem to have bad stats in one of my production 11.2.0.2 databases. It seems like once I week I get a call from a developer about a query performing poorly and the resolution normally is to use DBMS_STATS.GATHER_TABLE_STATS to update the optimizer statistics and the query …

Continue reading

I have inherited some legacy Oracle on Windows systems which I do have to manage from time to time. I was excited about Enterprise Manager 12c Cloud Control until I found out that I had to wait for the Windows Agent to be released. My wait is over and I can now use 12c Cloud …

Continue reading