Oracle

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.

5 things that aren’t true about RMAN

Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore,(…)

Dbvisit 10 on Oracle Database Appliance

By Mouhamadou Diaw Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and(…)

Install Enterprise Manager 13c R5: Check the db edition Failed

By Mouhamadou Diaw A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database(…)