Brian Peasland

Author's posts

Oct 18

Security Patch Monkey Business

A few days ago, Oracle released their quarterly patches for currently supported Oracle versions. Now in the past, the DBA had the option of installing the Cumulative Patch Update (CPU) or the Patch Set Update (PSU). Basically, the CPU contains just security patches and the PSU contains security patches and other bug fixes. Beginning in …

Continue reading

Oct 12

ORA-1017 in Grid Control for Standby

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

Oct 11

ORA-12541: TNS:no listener in DGMGRL

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

Oct 01

Email Alerts in EM12c

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

Sep 27

Oracle Management Server is Down

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

Sep 21

Compression Advisor is Evil Part II

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

Aug 30

DB Control Nearing Its Death

On August 20th, Oracle published Note 1484775.1 Database Control To Be Desupported in DB Releases after 11.2. If you use Enterprise Manager to manage and monitor your Oracle databases, you have two options, DB Control and Grid/Cloud Control. DB Control is easy to set up but only interacts with one Oracle database. If you have …

Continue reading

Aug 22

Fun With Messages

Recently, I saw someone indicate that they had an Oracle tech on site some years ago. This tech had changed SQL*Plus so that its feedback said something like “about XX rows selected” instead of just “XX rows selected”. He wondered how the tech did that. I just had to dig into this and have some …

Continue reading

Aug 21

Relink Grid Infrastructure

I recently had to work with my SysAdmin on a minor OS upgrade on a two-node RAC cluster. I am running Oracle Grid Infrastructure 11.2.0.2 with Oracle RDBMS 11.2.0.2 and we were upgrading from Oracle Enterprise Linux 5.2 to 5.8. As most Oracle DBA’s know, it is a good idea to recompile the Oracle software …

Continue reading

Aug 16

SQL Developer Won’t Start

One of the things I like most about SQL Developer is that it runs everywhere. I have it installed on my Windows workstation. It is installed automatically on your database server, even Unix/Linux. And I have it installed on my MacBook Pro. The same product runs everywhere giving me a consistent tool no matter which …

Continue reading