Brian Peasland

Author's posts

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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. …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading