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 (Purge …
Read More »Enable Archive Log Mode in Oracle 19c RAC
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 …
Read More »Proudly in the Top 100 Oracle Blogs on the Web
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 …
Read More »Oracle Database Archive Log Generation Details
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 …
Read More »Installing 19.18 Oracle Database on Linux 8.7
Installing 19.18 Oracle Database on Linux 8.7 [root@oratest u01]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.209.128 oratest.oracle.com oratest [root@oratest ~]# uname -arLinux oratest.oracle.com 5.15.0-3.60.5.1.el8uek.x86_64 #2 SMP Wed …
Read More »Critical Patch Update January 2025
Critical Patch Update for January 2025 The Critical Patch Update (CPU) for January 2025 was released on 21 January 2025. Oracle strongly recommends applying the CPU patches as soon as …
Read More »Oracle Database 23ai with Oracle E-Business Suite 12.2
Oracle Database 23ai with Oracle E-Business Suite 12.2 Oracle recently announced that Oracle E-Business Suite (EBS) Release 12.2 is certified with Oracle Database 23ai (DB 23ai) for on-premises Exadata …
Read More »Troubleshooting Oracle RAC Node Eviction
Troubleshooting Oracle RAC Node Eviction The RAC Node Eviction Troubleshooting Tool is designed to help diagnose and resolve RAC node eviction issues by analyzing uploaded log files. When …
Read More »ORA-01035: ORACLE only available to users with RESTRICTED SESSION
ORA-01035: ORACLE only available to users with RESTRICTED SESSION 1. First Check the Pdbs Status SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ———————————————————————————————————————— PDB$SEED …
Read More »FMW 12.2.1.4 Installation for OAM
Oracle Fusion Middleware 12.2.1.4 Introduction What is Oracle Fusion Middleware 12.2.1.4? Oracle Fusion Middleware 12.2.1.4 is a set of software tools and services that help businesses build and run applications. …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner