Oracle

What I really like about Percona PMM

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)

Oracle 21C Security : diagnostics_control and enable diagnostics

By Mouhamadou Diaw Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked(…)

opatch hangs while patching OEM 13.4. concerning the log4j-vulnerability

By Clemens Bleile To address the log4j-vulnerability I recently had to fix the Oracle Enterprise Manager 13.4.-installation for a customer. REMARK: Please check the following link for details concerning the log4j-vulnerability and how Oracle is affected: alert-cve-2021-44228 and(…)

Script to calculate the network latency between the application and the Oracle DB-server

By Clemens Bleile Network latency is crucial for applications, especially if lots of “row by row”-processing (some call it “slow by slow”-processing) is used by the application or if lots of data is transported between the database and the application.

Exadata Cloud at Customer: Considerations for Backup & Recovery

Working in a project where the customer migrates from an on-premises environment to Exadata Cloud at Customer provides insights about the decisions to take and what to consider when using the Exadata Cloud at Customer environment. In a series of(…)

Upgrade AHF and TFA on an ODA

TFA (Trace File Analyzer) is part of AHF (Autonomous Health Framework). Those tools are preinstalled and part of ODA (Oracle Database Appliance). As you might know patching and upgrading are normally always going through ODA global Bundle patches. AHF can,(…)

Oracle Database Appliance 19.13: what’s new and how to patch?

Introduction Patch 19.13 is now available on ODA. It’s time to test it. What’s new? This version brings October’s PSU to database and grid homes with their bug fixes, as usual. It also brings 21.4 for DB Systems (21c being(…)

When unreachable NFS share mess up your Dbvisit Standby configuration

If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a(…)

Move a PDB from a server to another one using NFS

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on(…)

ODA 19.12: How can you manage DB Systems with odacli?

Introduction As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation.