Osman DINC - InsaneDBA

Unable to Parse the Content of exa_map Error on ExaCC Grid RU Precheck The document details troubleshooting steps taken to resolve a grid release update(19.28) error on an Exadata Cloud system. The initial issue involved SSH connectivity, followed by problems with the…

New Blog Post : Unable to Parse the Content of exa_map Error on ExaCC Grid RU Precheck dincosman.com/2026/01/31/p...

Cloning Oracle RAC Database Home to Single Instance and vice versa This blog post details the steps for cloning an Oracle Database Home from an existing Oracle Home to another server, applicable to both RAC and Single Instance environments. Cloning is preferred ov…

Cloning Oracle RAC Database Home to Single Instance and vice versa... dincosman.com/2025/12/14/c... #Oracle #Database #DatabaseClones

Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool This content discusses simulating tape backups using RMAN and a dummy SBT library (oracle.disksbt) to troubleshoot backup failures. The article details how to perform fake tape backups with Oracle’…

Backing up to a fake tape (SBT) in Oracle RMAN and using sbttest tool.

dincosman.com/2025/11/09/b...

#Oracle #RMAN #Database #BackupAndRecovery

Ping Checks Life, tnsping Checks Purpose #JoelKallmanDay The content explains various Oracle connectivity testing utilities: ping, tnsping, ociping, connping, and adbping. It honors Joel Kallman, a key figure in database development. The document details…

Ping Checks Life, tnsping Checks Purpose #JoelKallmanDay
#Oracle

dincosman.com/2025/10/15/p...

How about multiple log writer also?

My article "When Bind Variables Backfire" is published in ORAWORLD Issue 35 (July 2025), pages 53–58! 🔥

I explore surprising real-world issues around bind variables in Oracle Database.

Read it here 👉 www.oraworld.org/fileadmin/do...

#Oracle #Database #ORAWORLD

Love it. 👍🏿

Deploy Oracle Autonomous Database on your Computer Oracle Autonomous Database can be deployed locally on a laptop using container platforms such as Docker or Podman, offering features similar to those available in the Oracle Cloud Infrastructure (O…

Is it possible to deploy an Oracle Autonomous Database on your laptop with a management interface like OCI?

Yes. Here it is.

dincosman.com/2025/06/18/d...

#Oracle #AutonomousDatabase #OracleATP #Docker #OracleDeveloper #DevOps #OracleCloud #DatabaseActions #ORDS #SQLcl #DB

Oracle Database Patching with AutoUpgrade in Offline Environments This post illustrates how to use AutoUpgrade to patch an Oracle Database to in environments without internet access, making it also suitable for isolated systems. It details steps such as creating …

Oracle Database Patching with AutoUpgrade in Offline Environments

DBAs may forget some post-patching tasks, but it seems that AutoUpgrade does not.

dincosman.com/2025/06/14/a...

Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy In this blog post, I walk you through how to download Oracle patches using AutoUpgrade on a Windows host behind a proxy requiring authentication. The steps include configuring proxy environment var…

New Blog Post:
Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy

Say goodbye to the browser, after reading this post, you'll download Oracle patches the smarter way.

dincosman.com/2025/06/04/d...

#Oracle #AutoUpgrade

👍

Hi Kellyn, can you check slide decks link? I think, it may be broken.

New Blog Post:
How Oracle Changes Your SQL: Uncovering Hidden Query Transformations

Query transformations and translations are some kind of magic.

👉 Read the full post here: dincosman.com/2025/05/24/h...

#Oracle

Oracle 23ai Update – VKTM process is now TIME!

#Oracle

Part 1: NVL vs DECODE and CASE – Short Circuit Behavior The blog post discusses the behaviors of Oracle’s NVL and DECODE functions regarding NULL values. While NVL employs eager evaluation, executing all arguments regardless of necessity, DECODE u…

New Blog Post : Part 1: NVL vs DECODE and CASE - Short Circuit Behavior

dincosman.com/2025/05/17/n...
#Oracle #Database #SQL #NVLvsDECODE

Oracle Hash Partitioning: Benefits and Best Practices Hash partitioning enhances database management and performance by evenly distributing data across partitions, crucial for handling high concurrency. However, choosing an appropriate partition key i…

Oracle Hash Partitioning: Benefits and Best Practices
Whether you're seeking uniform data distribution, aiming to reduce row lock waits on index segments highlighted in AWR’s "Segments by Row Lock Waits" section, then check out
dincosman.com/2025/05/09/o...
#Oracle #Database #HashPartition

DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymore Recent Oracle Data Pump patches (19.17 and later — involving bug fix 33517865) have modified the behavior of DBMS_METADATA.GET_DDL, removing hashed passwords from its output as a security enhanceme…

DBMS_METADATA.GET_DDL Does Not Return Hashed Passwords Anymore.

Oracle has introduced a fix (bug fix 35018026) that allows access to hashed passwords under strict conditions.

dincosman.com/2025/05/02/g...

#SQL #Oracle #Database

Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes) In this post, I’m sharing the latest Ansible playbooks for patching Oracle Database and Grid Infrastructure, specifically for the Oracle 19.26 Release Update, including MRPs and recommended one-off…

Ansible Playbooks for Oracle Grid and Database Release Update (19.26 with MRP & One-Off Fixes) dincosman.com/2025/04/26/a...

#Oracle #Database #Databases #Ansible #DatabasePatching

SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases This content highlights the importance of stability in database performance, especially regarding Oracle’s SQL execution plans, which can fluctuate based on various factors. It focuses on three pri…

Ever wondered What happens when a SQL statement has conflicting hint directives from SQL Profile, SQL Plan Baseline, and SQL Patch?

In my test case, All three whispers different things to optimizer. What will optimizer do?

I answer this.
dincosman.com/2025/04/10/s...

#Oracle #SQL #Database

Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect This post discusses a perplexing issue with node evictions in an Oracle RAC setup, where node crashes occurred due to a loss of connection on a private interconnect despite redundancy. It highlight…

New blog post:

Resolving Oracle RAC Node Eviction Issue caused by Cluster Interconnect dincosman.com/2025/03/13/c...

Tools for Oracle Database Proactive Health Checks and Diagnostics The content discusses essential tools and scripts for monitoring Oracle Database Health, emphasizing the importance of proactive health checks to prevent performance issues. It introduces various t…

New Blog Post:
Tools for Oracle Database Proactive Health Checks and Diagnostics dincosman.com/2025/02/23/o...

Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE Bind variables improve SQL performance and security by reusing execution plans, reducing hard parsing overhead and mitigating SQL injection risks. However, key information can be hidden from the op…

Child Cursors: BIND_MISMATCH, BIND_LENGTH_UPGRADEABLE and BIND_EQUIV_FAILURE dincosman.com/2025/02/09/b...

Moving Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in Detail The post discusses the process of reorganizing and moving nearly 50,000 database objects across tablespaces within an Oracle database. It highlights the challenges posed by inconsistent storage pra…

New blog post: A Tale of Terabytes, Moving Thousands of Oracle Database Objects Across Tablespaces: Tables, Indexes, and LOBs Explained in Detail dincosman.com/2025/01/03/m...

Oracle Database APEX Upgrade: 19.2 to 24.1 This post outlines the process for upgrading Oracle Application Express (APEX) from version 19.2 to 24.1. APEX is a low-code platform for developing web applications with Oracle Database. The upgra…

Oracle Database APEX Upgrade: 19.2 to 24.1 dincosman.com/2024/12/21/o...

CPU-intensive query to simulate CPU load in Oracle database This blog post provides a PL/SQL script that utilizes Oracle’s DBMS_SCHEDULER to create and execute CPU-bound jobs. Also validates the CPU usage with AWR Report and docker stats command. Addi…

New blog post.
dincosman.com/2024/12/13/c...

This blog post provides a PL/SQL script that utilizes Oracle’s DBMS_SCHEDULER to create and execute CPU-bound jobs. Additionally, it addresses constraints of the Oracle Database 23ai Free version, limiting CPU usage to two cores.

#Oracle

Ansible Playbooks for Oracle Database Release Update (19.24) This post discusses the introduction of a new patching feature (one-button patching) in the AutoUpgrade tool, now at version 24.7, which simplifies the database release update process. Although cur…

I've shared my insights on my blog, which may be helpful.

For Ansible: dincosman.com/2024/11/01/a... , dincosman.com/2024/03/18/d... and dincosman.com/2024/03/17/g...

For FPP: dincosman.com/2023/10/10/u... and dincosman.com/2023/10/10/u...

I also tested both. Both are great compared to doing everything manually. I prefer using FPP in Exadata environments (rather than giving SSH equivalency to another server). Ansible works well with traditional systems and Virtual Machines, but it requires careful preparation of the playbooks.

How to Get Row Counts for All Tables in Oracle Database? This post explores the debate between using table statistics and executing SELECT COUNT(*) queries for retrieving row counts for all tables in Oracle databases. It highlights the efficiency of rely…

The Debate Between Table Statistics and SELECT COUNT(*)
#Oracle

dincosman.com/2024/12/07/f...

Install Oracle Database 23ai and Sample Schemas on Macbook M Series (Apple Silicon) Released on 12th November 2024, Oracle Database 23ai now offers free container images optimized for ARM-based Apple MacBook computers with M-series chips, enhancing development efficiency. Two imag…

Install Oracle Database 23ai and Sample Schemas on Macbook M Series (Apple Silicon)

#Oracle
dincosman.com/2024/12/03/i...

File System Corruption on Root (/) Partition of Exadata Storage Server – Oracle Linux 7 A file system corruption issue was detected on the root partition of an Exadata storage server running Oracle Linux 7.9. This was identified by AIDE due to changes in file attributes. Investigation…

New blog Post - File System Corruption on Root (/) Partition of Exadata Storage Server - Oracle Linux 7
#Oracle #Exadata
dincosman.com/2024/12/01/e...