Troubleshooting Oracle Cloud Infrastructure Automatic Backups

I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 click distance in any cloud, so it should be the same for the database backups in Oracle…

Read More >

Exadata Smart Scan: A Quick Overview

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Read More >

How to manage Oracle Flashback Log size

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…

Read More >

How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

Have you received this error on OMS 12.1.0.3? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…

Read More >

How to Reduce Exadata Core Count

During preparation for a client’s datacenter migration, we decided to move services one-by-one to the datacenter / hardware in order to keep the scope of changes controlled. To accomplish this, we also needed to resize the CPU count of Exadata…

Read More >

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Read More >

Three Announcements from Oracle OpenWorld You Probably Didn’t Hear

The buzz from OpenWorld this year was the permanently free Oracle Cloud offering, the new Exadata X8M (reportedly capable of 12 million I/O per second!), Oracle Autonomous Cloud at Customer, and the new Blockchain table. Here are three interesting or…

Read More >

Exadata: 7 Useful Commands to check Port/Sensor Alarms

Some days ago I was checking for the alarm below, with a very generic message: Message=The aggregate sensor /SYS/CABLE_CONN_STAT has a fault. So, I decided to document some useful commands I used to verify all ports/sensors in my Exadata cluster….

Read More >

How to fix InfiniBand Error: Cable is present on Port “X” but it is polling for peer port

Facing an InfiniBand error? Let me guess: Ports 03, 05, 06, 08, 09 and 12 are alerting? You have a Quarter Rack? Have recently installed Exadata plugin to version 12.1.0.3 or higher? Don’t panic! This is probably related to Bug 15937297:…

Read More >

How to extend the /u01 filesystem on an Exadata

Marketers are very good at selling everyone on the fact that resources (CPU, disks, memory) are now infinite, which is mainly true on a slide but it’s less true in real life. You may one day face this situation with…

Read More >
Page 1 of 2112345...10...Last Page »