Many of us now have Oracle RAC installed in virtual environments on our laptops and workstations. This blog post shows how I did just that on my MacBook Pro. Recently, I was re-installing a new RAC testbed on my laptop when I ran into a few issues that took me awhile to sort out. After …
Category: Oracle
Aug 26
Can’t Compile GI 12.1.0.2 and Segmentation Fault
So I’ve been having a tough time of it lately on things I should know better. We’ve all been there before. I’m trying to recreate a 2-node RAC testbed on my laptop. This will be Oracle 12.1.0.2 on Oracle Linux 6.5 with VirtualBox 5.0. Should be pretty simple, right? I even wrote instructions on how …
Aug 18
Video: Oracle 12c IDENTITY Column Performance on RAC
I’m trying to branch out a bit and craft a few videos. This one is my first attempt and I discuss the new 12c IDENTITY column performance, specifically for Oracle RAC databases. It provides results buying levitra from canada from its first dose. IF you can’t consume tablets: Then kamagra also comes in oral on …
Aug 13
ORA-27038 on 12.1.0.2 RAC Upgrade
I am upgrading a 2-node Oracle RAC testbed from Oracle 11.2.0.4 to Oracle 12.1.0.2. This is a simple testbed and the database is virtually empty. I’m using the DBUA to perform the upgrade. Should be simple, right? After the database is upgraded, the DBUA is trying to move the RAC configuration to the new home. …
Jul 29
Memory Pressure Analysis Risk State
I have a Test database that is a 2-node RAC system. I am working towards the goal of getting the production database to Oracle 12.1.0.2 in about a month’s timeframe. This of course means that I have to get Grid Infrastructure upgraded prior to the db upgrade. I have upgraded GI on my standby cluster …
Jul 27
Remember RAC Instances in Perf Tools
I was using Lighty to examine performance of a new Oracle RAC database that went into service today. You can see something similar in Oracle Enterprise Manager 12c Cloud Control if you choose. Anyway, here is the performance graph of the RAC database in question. It is common wisdom that if …
Jul 23
Lighty In A Nutshell
As you may know from a previous post on this blog, or if you follow me on Twitter (BPeaslandDBA), I like Lighty for Oracle, a product by Orachrome. I love this product and how easy it is to obtain performance diagnostic information. I’m very familiar with Oracle’s Enterprise Manager and I use EM12c all the time when …
Jul 16
Lighty for Oracle
Not that long ago, I was pointed in the direction of Lighty for Oracle by orachrome. This is a wonderful performance tuning tool. I’m still using the 30 day trial and viagra uk sales First of the potency : Every healthy man has full capacity for sexual act, called potency. Now we know why we …
Jul 16
Web Site Down and Twitter Feed
My web site was down for the last 4 days. My apologies. I had to spend a lot of time going back and forth between my ISP and my domain registrar. But it seems to be sorted out now. So the good news, depending on your perspective, is that once my site came back up, …
Jun 25
TNS-12519 w/o Max Processes Reached
I got a call from someone that they were getting TNS-12519 errors in their application. Sure enough, those messages were in the listener.log file as well. TNS-12519: TNS:no appropriate service handler found For those that aren’t familiar with this error, it typically means one of two things. Either the service name is not registered with …
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
