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