Category: RAC

GWFG in Oracle RAC

I have a deadlock being reported in my 3-node Oracle RAC database (version 11.2.0.4) as can be seen in the Alert Log. Being that this is an Oracle RAC database, resources are managed globally and the Lock Manager Daemon (LMD) gets involved. The message in the alert log pointed me to a LMD trace file …

Continue reading

cursor: pin S wait on X

On my main production RAC database, I do see periods of slowness and the dominant wait event, system wide, is “cursor: pin S wait on X”. The event comes and goes, but I do see it from time to time. So I needed to get the bottom of this. Note, that this is not a …

Continue reading

GI Upgrade missing OS patches

I was trying to upgrade Grid Infrastructure on Sun Solaris 10 from 11.2.0.3 to 11.2.0.4 and got a nice suprise. When I ran the rootupgrade.sh script on the first node, I got the following errors:   2014-12-28 17:08:45: Successfully removed file: /var/tmp/maaVdayif 2014-12-28 17:08:45: /bin/su exited with rc=1 2014-12-28 17:08:45: cluvfy patch check failed, output …

Continue reading

High Space Usage From crfclust.bdb

I have a 2-node testbed running Oracle RAC 11.2.0.4 on OL6. Pretty much everything is in the system disk. This is just a testbed after all. The root partition has been filling up. I got an alert from EM about the disk space issue and went in and cleaned up some log files. As I …

Continue reading

InMemory DUPLICATE Confusion in Oracle RAC

Most people are probably aware of the new Oracle 12.1.0.2 feature, the InMemory database option. When using this option on Oracle RAC, the DBA can specify the DUPLICATE clause to have an object be duplicated among the InMemory column store in all instances. This clause is for Oracle’s Engineered Systems like Exadata. However, in non-Engineered …

Continue reading

ORA-24247: network access denied by access control list (ACL)

I have a regularly scheduled job on an Oracle RAC database that will send me an email alert for a condition. This happens every 30 minutes. The job has been failing on one of the nodes, but not the others. The job spits out these errors:   ORA-12012: error on auto execute of job “OWNER”.”JOB_NAME” …

Continue reading

Error 1033 received logging on to the standby

Upgraded production to 11.2.0.4 a few nights ago. The primary is 3-node RAC and the standby is 2-node RAC. Notice that one of the threads was not transmitting redo to the standby. Saw this repeatedly in the alert log:   Error 1033 received logging on to the standby   Turns out this was a problem …

Continue reading

GI 12.1.0.2 Upgrade

The 12.1.0.2 patchset has been out for a bit now. I am just now finding time to be able to take my first look at it. I’m interested, like many others, in looking at the In Memory database option. But I need to upgrade my Grid Infrastructure before I can upgrade my database. The upgrade went …

Continue reading

Grid Infrastructure Upgrade Assistants

Yesterday I was working on testing an upgrade of Grid Infrastructure 11.2.0.3 to 11.2.0.4 in my testbed. This is my first step in my larger plan to upgrade our production systems to 11.2.0.4 this calendar year. For my X-windows environment which I need to run the Oracle Universal Installer, I run Ubuntu Linux in Virtual …

Continue reading

ORA-01618

This is my 100th post to this blog!!! I am trying to duplicate a problem where I have threads 4, 5, and 6 in my primary and my standby has threads 1 and 2. When I did a switchover, everything was fine, but I could not switch back because the old primary, now the standby, …

Continue reading