Oracle DBA

Fix ORA-12899 Error During RDS to ATP Schema Import

by
Resolving ORA-12899 During RDS to ATP Schema Import

In this blog, we will discuss how to resolve the following Oracle Data Pump import error encountered while migrating an AWS RDS Oracle schema backup to Oracle ATP: Although the schema import completed successfully, a few rows failed to import into the table ORAKLDBA.P_ATTD_CONFIG_TAG_DTL. The import log showed the following warning: This issue occurs because … Read more

Apply RU 19.31 Patch on Oracle 19c Database

by
Apply RU 19.31 Patch on Oracle 19c Database

Applying the Oracle 19c RU 19.31 Patch is essential for improving database security, performance, stability, and Oracle support compliance. In this step-by-step guide, you will learn how to apply the Oracle 19c RU 19.31 Patch on Oracle Database 19c running on Linux using the OPatch utility. This tutorial covers prerequisite checks, OPatch upgrade, patch installation, … Read more