Recently I was testing OCI database upgrade from 12c to 19c and ran into an issue I wanted to fix. I was doing this via dbaascli (on Exadata) and the upgrade hit Bug 34455245 – db12c upgrade to 19c fails with ORA-600 [kxhfmgetextent.1] (Doc ID 34455245.8). I tried few things as with dbaascli you can…
Issues with OCI ExaCS PDB cloning
This is mostly just to document if you hit similar issues and how to get past them. I had to perform some remote cloning in ExaCS (from one CDB to another CDB) within same VM cluster, but hit few issues which I had to resolve first before getting it to work. [DBT-05514] Failed to connect…
Exadata Cloud Service scaling (adding nodes) hangs
This will be a short post, mainly just to guide where to look if you ever encounter this issue. Recently I was tasked on adding a database node on Exadata Cloud Service X8M. The new X8M has dynamic deployment options so if you need more storage or compute power for your database nodes, you can…
How I studied for the Oracle Cloud Infrastructure 2019 Certified Architect Professional 1Z0-997
Earlier this week I took the 1Z0-997 Oracle Cloud Infrastructure 2019 Certified Architect Professional. In this post I’ll try to share on how I studied on the test and what areas I feel helped me on passing the certification. I won’t be posting any questions or answers but rather want to help you on studying…
Configuring OCI Email Delivery with OCI Exadata to send emails
I had a task to configure email sending from our OCI Exadata recently and having done it earlier for on-premise Exadata I was expecting a trivial task. Not so fast! First of all OCI documentation for the Email Delivery is clear and available here. In short what you need to do is setup user with…
Oracle Cloud Infrastructure and provisioning Exadata part 1
One of the biggest reasons we started to use Oracle Cloud Infrastructure was that we could get Exadata provisioned for our use. We already had on-premise setup but to get similar setup in the cloud was important. I’m going to write a two part series on provisioning Exadata. On this first part I’ll discuss on…
How is my EBS instance using Exadata write-back flash cache?
When we were planning migration from commodity hardware to Exadata X5-2 one open topic we had was if it makes sense to enable write-back flash cache in Exadata. The default mode is write-through where read operations utilize flash cache but not the write operations. Write-back then uses the flash cache to both read AND write…
Resize backup LVM on Exadata
We were patching Exadata and one of the YUM pre-checks failed due to invalid LVM size. We hadn’t done any resizing lately so I think issue had been there already but for whatever reason it wasn’t noticed. For backing up and rolling back on OS updates Exadata takes snapshot on identical LVM volume as the…
Exadata failing RAID HBA card
This is more of informative story what happened to us recently. In the past we had issue with one of the Exadata cell node where the RAID HBA card has failed. After working with support they decided to replace the card and at the same time update the card firmware. That issue was described in detail…
CELLDIAG user for Exadata
I was doing some tasks off from my task list and one of the things exachk highlighted was that we should create user CELLDIAG on cells. Beginning with Exadata Storage Server Software version 12.1.2.2.0, the storage server user “CELLDIAG” is created during deployment which allows access to diagnostics without using a more privileged user. The…