Latest posts

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle Application Express Release 18.1. I had a requirement to install the latest version of Apex on our 19c Oracle Database....

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...

Top Articlesfor You
By Category

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle Application Express Release 18.1. I had a requirement to install...

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...

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.