Latest posts

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of our SQLs were slow and started taking longer to execute. We did not see this issue in an earlier release...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM system. I had to clean up the targets from 12c OMS and remove the OEM agent. Here are the steps...

DBCA fails with ORA-27125 on 19c

Issue I recently encountered an issue where DBCA failed with ORA-27125 when creating a 19c database on Oracle Linux 7. Most of the support notes and posts on the internet pointed to Kernel parameters...

How to rename a PDB in 19c

Let's look at how to rename a PDB in 19c. The steps are the same as 12c. Per Oracle note referenced below, you must have the ALTER DATABASE privilege, either granted commonly or granted locally in the...

How to change the ethernet switch password on Exadata

Let's look at how to log in and change the ethernet switch (adm) password on an Exadata system. During the installation of the system, the admin user is created. You must have got...

Top Articlesfor You
By Category

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of our SQLs were slow and started taking longer to execute....

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM system. I had to clean up the targets from 12c...

How to rename a PDB in 19c

Let's look at how to rename a PDB in 19c. The steps are the same as 12c. Per Oracle note referenced below, you must have the ALTER...

Register missing archive logs on a standby database

Sometimes we may end up with archive logs missing on a standby database. It can happen due to a variety of reasons. Here we discuss some scenarios...

Troubleshooting Oracle Dataguard Transport and Apply issue

I share this post to explain how we identified and fixed an issue when our physical standby (Active Dataguard) apply was delayed and replication fell behind the...

Safely remove primary and standby databases in a Dataguard configuration

In this article, we will see how we can safely remove a clustered primary and standby databases that are in an Active Dataguard configuration.