Issues

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. Oracle recommends to containerize Apex installs within a PDB for...

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 of 19c. Here is a pattern...

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 SHMMAX and SHMALL. The Kernel settings were fine on my...

Fixed – EXPDP – OS/ Wallet Authentication does not work, prompts for password

I recently encountered a strange issue on a newly created multitenant database on 19.6 version. Our EXPDP job uses wallet to authenticate to the pluggable database. SQLPLUS could successfully connect/ authenticate to the database using credentials stored in the wallet. But, authentication failed for EXPDP using the...

Figure out why a target status is down on Oracle OEM when it is not

This post is to understand how to find the root cause when a target status is down on Oracle OEM (Oracle Enterprise Manager) - when in fact it is up. What OEM reports Example here shows 4 ASM instances down...

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 primary database. Though this is a single unique scenario, the post should be a diagnostic approach when troubleshooting Oracle dataguard...

DW0O terminating with fatal err=39078

Environment Oracle Database 11.2.0.4 on Oracle Enterprise Linux 6. Problem Import (IMPDP) job on a RAC database failed with very little error detail. The import executed for about 3 hours before failing. Job "SYS"."SYS_IMPORT_FULL_01" stopped...

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

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM...

Must read

- Advertisement -

You might also likeRELATED
Recommended to you

Resizing disk partitions on Oracle Exadata Database Machine

Oracle Engineers usually setup and configure an...