René Antúnez
@rene-ace.bsky.social
Oracle ACE,Principal Solutions Architect,Movie Fanatic Bringing the best from México (Mexihtli) to the rest of the world and in the process photographing it :)
http://rene-ace.com
http://rene-ace.com
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
#Oracle23ai #ExaCC
Oracle 23ai DB Creation in an ExaCC Fails with DBAAS-60022
Ran into a DB creation failure (DBAAS-60022) while provisioning an Oracle 23ai DB on ExaCC (Image 25.1.3). After digging through logs and a bit of head-scratching, the root cause turned out to be a Java version mismatch — DBCA was compiled with Java 11, but the system defaulted to Java 8. If you're hitting the same issue, I wrote up the root cause, the Oracle bug reference, and a quick workaround that worked for me.
rene-ace.com
April 10, 2025 at 9:12 PM
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
#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
Does a Commit Write My Data to the Datafiles? A Back-To-Basics Guide
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 of a crash. Learn why redo logs are essential for data integrity and how undo and read consistency maintain accurate query results across sessions.
rene-ace.com
April 7, 2025 at 8:10 PM
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
What is an Oracle Database Instance ? A Back-To-Basics Guide
Learn the fundamentals of Oracle Database architecture in this beginner-friendly guide. Discover how Oracle instances work, including essential memory structures like SGA, PGA, UGA, and key background processes such as PMON, SMON, DBW, and LGWR. Perfect for new DBAs, developers, and anyone starting their journey into Oracle databases.
rene-ace.com
April 2, 2025 at 4:05 PM
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...
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...
René Antúnez | What is an Oracle database Server ? A Back-To-Basics Guide
New to Oracle? This Back-To-Basics guide breaks down the Oracle Database Server architecture—explaining the physical and logical components, key files, and how the instance works. Perfect for aspiring...
rene-ace.com
March 30, 2025 at 9:09 PM
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...
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.
What is an Online Redo Log? : A Back-To-Basics Guide
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.
rene-ace.com
March 25, 2025 at 2:23 PM
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.
Instance Equals Processes and Memory Structures : A Back-to-Basics Guide
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. Understanding instances is crucial for database performance and administration.
rene-ace.com
March 19, 2025 at 4:03 PM
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.
Understanding Oracle Undo Records: A Back-to-Basics Guide
Confused about Oracle Undo Records and their role in database management? This guide breaks it down, explaining how undo data supports read consistency and transaction rollback. Whether you're a DBA or a developer, mastering undo records is key to maintaining data integrity and performance.
rene-ace.com
March 18, 2025 at 12:38 PM
In this post I'll try to provide a brief explanation of what an Oracle DB undo record is along with everything surrounding it.