Oracle RAC Release Update 19.24 on RHEL8.10 Issues   Whille applying the RU on base 19.3 Oracle RAC version on RHEL 8.10 we faced the below issue Error#1——– [root@oraclehost bin]# …

Troubleshooting KVM Reboots on Oracle ODA Due to OOM Kills and HugePages Misconfiguration Recently, I encountered an unusual behavior in one of our Oracle Database Appliance (ODA) environments that I …

Export & Import Process in Oracle 19c Container Database (CDB/PDB)   In this guide, we’ll walk through how to use the Data Pump (expdp/impdp) utility for export and import when …

An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 32 with name “$TEMPUNDOSEG” too small   ERROR ———————–XLAACCUP: Accounting Program+—————————————————————————+ Current system time …

Scheduling Purge Concurrent Request and Manager Data in Oracle E-Business Suite (EBS) : A Step-by-Step Guide   To schedule the purging of Concurrent Request and/or Manager Data in Oracle E-Business …

Purge Concurrent Request and Manager Data Program Concept and Effecting Tables   Overview To maintain database performance and avoid excessive disk space usage, Oracle EBS provides the FNDCPPUR concurrent program …

How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide   In this article, we will learn how to enable Archive Log Mode in an Oracle 19c …

Oraclesolutions  Ranked Among the Top 100 Oracle Blogs Worldwide Since 2017 I am incredibly proud and excited to share a milestone that means a lot to me and the growing …

Implementing Class of Secure Transport (COST) in Oracle RAC 11.2   Introduction:Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances …

Oracle Database Archive Log Generation Details   The Blog presents a script designed to query and report on redo log switch history and the size of archived logs in an …