Ran into a DB creation failure (DBAAS-60022) while provisioning an Oracle 23ai DB on ExaCC. After digging through logs, the root cause turned out to be a Java version mismatch. If you're hitting the same issue, I wrote up the root cause, and a quick workaround that work for me.
#Oracle23ai #ExaCC
Understanding Oracle's data consistency mechanisms is key to ensuring reliable database operations. Even after a commit, changes may not be immediately written to the datafiles due to Oracle’s DBWn process. Instead, Oracle relies on the Online Redo Log to recover committed transactions in the event
An Oracle Database Instance is more than just memory and processes—it’s the engine behind your data. In this post, I break down the core memory structures (UGA, PGA, SGA), key background processes (like PMON, SMON and LGWR). This guide offers a beginner-friendly explanation with a helpful diagram
Just getting started with Oracle Database?
Here’s a visual, back-to-basics guide to help you understand what’s really going on behind the scenes—from control files to memory structures.
#Oracle #Database #DBA
rene-ace.com/what-is-an-o...
In this post we will look at the Online Redo Log which consists of physical files that store redo records, capturing changes made to the database. These records are crucial for the recovery process, as they facilitate "roll forward" of committed changes and "roll back" of uncommitted ones.
In this back-to-basics we go into what a database instance is. We view key components like the System Global Area (SGA) and background processes such as PMON and DBWn that ensure efficient memory management and data integrity.
In this post I'll try to provide a brief explanation of what an Oracle DB undo record is along with everything surrounding it.
