Brian Peasland
Author's posts
Jan 22
SQL Server Outage
Just like many Oracle DBA’s, I have to support other database platforms as well, which in my case does include SQL Server. My shop has regularly scheduled maintenance windows every Wednesday evening. Last night, our SysAdmins were replacing some disk in our production SQL Server box. The disk wasn’t one that SQL Server uses so …
Jan 16
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 …
Jan 12
Bad Standby
On Friday, I discovered that my standby database had not applied transactions for 8 days. This is very bad for me because I only keep 7 days worth of archived redo logs. So I had no redo to apply. I used the steps in Note 836986.1 to roll forward my standby with an RMAN incremental …
Dec 31
2014 Blog Stats
As the end of the year is right upon us, I thought it was time to look at this year’s stats for my blog. I’m averaging over 30,000 hits per month and about 3,000 unique visitors each month. I’m pleased with the attention my poor little blog is receiving. 🙂 Here are the stats: …
Dec 29
What’s a Major Version Anyway?
We all know that Oracle 12c was released quite awhile ago. Oracle 12.1.0.1 was the next major version in the Oracle database life cycle. But what’s in a major version anyway? It used to be that a major version was a big deal. ACME Corporation released their wonderful Widget 4.0 which did many things, …
Dec 28
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 …
Nov 14
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 …
Nov 13
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 …
Nov 04
ORA-00838
Ran into an interesting issue the other day that took me a while to fix. I was trying to start a non-production database and received this error: ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1428M ORA-01078: failure in processing system parameters For starters, the Oracle documentation for my version …
Oct 28
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” …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
