Author's posts
Aug 31
Oracle 12c Upgrade Issues
I’m in the middle of testing for my company’s Oracle 12c production upgrades coming in September. Thankfully, I have a lot of good testbeds to fine-tune the upgrade process before proceeding to production. So far, things have been pretty smooth, even much better than my 11.2.0.3 to 11.2.0.4 upgrades a year ago. I thought I’d outline …
Aug 27
How to Backup RAC VM’s
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 …
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 27
The Data Guardian
This morning, I was reading this article about employees lack of understanding how critical it is to protect business data. The article got me to think about a few different points. As a DBA, I’ve always tried to be my company’s Data Guardian. To me, the data inside the databases I manage is a valuable …
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 …