A fresh year is the perfect time to learn something new. Recently, I have come across warning messages in the RMAN level 0 backup log file and this post describes how I dealt with them.       The file…

Most corporations have huge amounts of data in RDBMS (relational database management system). When considering a RDBMS data transfer and you only need a subset of data to migrate to the cloud, follow this very efficient and easy data ingestion…

Recently a client asked to upgrade their Oracle EBS 12.1 running on RHEL6 to RHEL7 hosted on Amazon Cloud. On the surface, it didn’t look like a job for an Application DBA, but rather, for a SysAdmin or CloudOps team….

What are the licensing considerations for deploying Oracle Enterprise Manager and using OEM for monitoring database servers? Read on to find out.     Oracle documentation states that base installation of Enterprise Manager Cloud Control 13c is free when used…

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we moved  indexes between tablespaces.       A client requested we reduce the size of an Automatic Storage…

This is the sixth in a series of blog posts, that covers the details to deploy the Oracle Management Servers for a high available set up of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is…

I received the above message related to an ORA-7445 on my 11.2.0.4 database: ORA-07445: exception encountered: core dump [kcflfi()+1016] [SIGFPE] [Integer divide by zero] [0x10053AD10] [] []     After some checks, I noticed the following: SQL> select file_name, bytes…

For many of us, the recent log4j vulnerability (CVE-2021-44228) became a severe headache this past weekend. I thought we’d publish a summary of some of our findings gathered so far. We’ll  keep it updated with news and details published by…

Exadata has been Oracle’s gold standard platform for running mission-critical Oracle databases for over a decade. Oracle is extending the availability of Exadata onto the cloud by offering it in two flavors: Exadata Cloud @ Customer (ExaCC) and Exadata Cloud…

From ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT) and Hang Manager, to Cluster Health Advisor (CHA), Cluster Verification Utility (CVU), Memory Guard and Tracefile Analyzer (TFA), Oracle DBAs have an abundance of great tools at their fingertips. Another plus is there’s…