Osman’s DBlog

New Exachk Criterion: Hardware Assisted Resilient Data (HARD) Validation During ASM Relocation

26 Jul 2025 21:55

—

by

Osman DİNÇ

Databases, Exadata, Oracle

The recent analysis of an Exachk report revealed a new check for Hardware Assisted Resilient Data (HARD) capability during the ASM Relocation (rebalance, resync, or resilver) process. HARD checks validate data integrity in Exadata storage servers, preventing corruption. Setting the content.check attribute of asm diskgroup to TRUE will enable Hardware Assisted Resilient Data (HARD) Validation During ASM Relocation. This change aligns with Exadata best practices for improved data protection.
Deploy Oracle Autonomous Database on your Computer

18 Jun 2025 08:52

—

by

Osman DİNÇ

Autonomous DB, Databases, Oracle

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 (OCI) Autonomous Database (ADB). Images are available for both ADW (Autonomous Data Warehouse) and ATP (Autonomous Transaction Processing) workloads. In this post, the deployment is demonstrated on the ARM-based Apple Macs, which requires configuring Docker along with Rosetta. Users can access the database via REST APIs and manage it easily through the Database Actions web interface, powered by Oracle REST Data Services (ORDS).
Oracle Database Patching with AutoUpgrade in Offline Environments

14 Jun 2025 13:40

—

by

Osman DİNÇ

Databases, Oracle, Update

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 necessary directories, copying setup files, running prechecks, applying patches, and performing post-upgrade operations. The AutoUpgrade utility automates many tasks traditionally handled manually by DBAs.
Downloading Oracle Patches with AutoUpgrade on Windows Behind a Proxy

4 Jun 2025 19:22

—

by

Osman DİNÇ

Databases, Oracle, Update

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 variables, creating the necessary directory structure, importing SSL certificates into the Java truststore and setting up a keystore for My Oracle Support (MOS) credentials. Additionally, I share a workaround for a language-specific issue encountered when the Windows display language is set to Turkish, which will be fixed on the next release.
How Oracle Changes Your SQL: Uncovering Hidden Query Transformations

24 May 2025 13:33

—

by

Osman DİNÇ

Databases, Oracle, Performance

The post explores hidden transformations and transltion framework in Oracle databases. It introduces tools like DBMS_SQL_TRANSLATOR.SQL_ID and DBMS_UTILITY.EXPAND_SQL_TEXT, which help analyze and uncover underlying operations, highlighting the intricate nature of database queries and their optimizations.
Avoid Misusing LEFT JOIN in SQL Queries

17 May 2025 11:26

—

by

Osman DİNÇ

Databases, Oracle, Performance

The use of LEFT JOIN in SQL queries is common but often misapplied. This post highlights two pitfalls: using LEFT JOIN when INNER JOIN is appropriate, and applying filter conditions incorrectly. Proper usage of joins enhances clarity and performance for optimizers.