When moving from one system to another, one of my favorite migration methods is using data guard. It has its restrictions – the destination should be the same platform (exceptions noted in MOS note #413484.1), same version unless you’re performing an upgrade, and that a block-for-block copy of the database is acceptable. Utilizing data guard… Read More »
I spoke with a customer that mentioned they were moving an Exadata rack from one datacenter to another and they had a few questions about what needed to change in order to complete the move. The customer wanted to make the move as much of a “lift and shift” as possible, avoiding the need to… Read More »
I decided this week to be a little brave and upgrade one of the Enkitec Exadata racks to 12.2.0.1. I installed the 12.2.1.1.0 Exadata image a few weeks ago, and have been waiting for a chance to upgrade clusterware to 12.2. Thankfully, Oracle provides a very good note for this, but I did hit one large… Read More »
I ran in to a small issue while applying the July 2016 quarterly patch to a couple of Exadata racks last week. The systems were running GI 12.1.0.2, previously with the January 2016 PSU. The patches applied successfully, and we were beginning the process of running the post-patch scripts on the databases in the cluster. This… Read More »
By default on an Oracle RAC installation, the listeners are configured to allow any database to register with them. There is no security out of the box to determine which databases may register. While this makes it easy to create new databases without worrying about listener registration, this can cause potential problems in a real environment.… Read More »
If you’ve run an exachk report, y0u may have seen the following message with regard to your databases: Status Type Message Status On Details FAIL Database Check Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value db01:dbm011, db02:dbm012 View This check is commonly seen when a database is created on Exadata without using the custom… Read More »
I noticed something for the first time tonight when I was playing around in the Enkitec lab – something that I have been doing wrong for a while. When working in the lab, I often rely on the crsctl command to shut down the entire cluster stack for me. It’s really easy to use “crsctl… Read More »
As you may have guessed, applying patches on the Oracle Database Appliance can be a little bit different from your standard Oracle environment. Oracle releases a software version that covers all aspects of the ODA – firmware, operating system, and Oracle software stack (grid infrastructure, rdbms). Versions are numbered like this (image courtesy MOS note… Read More »
A recent discussion thread on the OTN Exadata forum made me want to test a feature of 11.2 RAC – voting disk redundancy. There was one section of the Clusterware Adminsitration and Deployment Guide (http://goo.gl/eMrQM) that made me want to test it out to see how well it worked: If voting disks are stored on… Read More »
In part 1 of this series, we took a look inside the ODA to see what the OS was doing. Here, we’ll dig in a little further to the disk and storage architecture with regard to the hardware and ASM. There have been a lot of questions about the storage layout of the shared disks.… Read More »