Issues

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

Steps to remove OEM Agent

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

DBCA fails with ORA-27125 on 19c

Issue I recently encountered an issue where DBCA failed with ORA-27125 when creating a...

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

Must read

Register missing archive logs on a standby database

Sometimes we may end up with archive...

DW0O terminating with fatal err=39078

Environment Oracle Database 11.2.0.4...
- Advertisement -

You might also likeRELATED
Recommended to you

Register missing archive logs on a standby database

Sometimes we may end up with archive...

Resizing disk partitions on Oracle Exadata Database Machine

Oracle Engineers usually setup and configure an...