Errors/Workarounds19c

Corrupted Undo Tablespace in an Oracle RAC Database Overview Recently, I came across an issue in one of the Oracle RAC database environments where the undo tablespace became problematic and …

Oracle Data Guard Broker Drill (19c): Switchover + Failover Using DGMGRL (End-to-End Runbook) This week I ran a Data Guard Broker DR drill for a client on Oracle 19c, covering …

Copy Password File From Primary to Standby ASM        If you’ve worked with Oracle Real Application Clusters (RAC) or Data Guard, you know that because the password file …

ASM Command-Line Utility (ASMCMD) – Complete Guide for Oracle DBAs Introduction Oracle ASM Command-Line Utility (ASMCMD) is a powerful and essential tool for Oracle DBAs and Grid Infrastructure administrators working …

ORA-15041: Diskgroup “DATA” Space Exhausted — How to Diagnose & Fix the Issue When working in Oracle RAC/ASM environments, one of the common storage-related issues is ORA-15041: diskgroup space exhausted.This …

Oracle RAC Release Update 19.24 on RHEL8.10 Issues   Whille applying the RU on base 19.3 Oracle RAC version on RHEL 8.10 we faced the below issue Error#1——– [root@oraclehost bin]# …

Disabling and Uninstalling AWR (Doc ID 1909073.1)   Some reference on it?– How To Avoid the AWR Usage Without Having Diagnostic Pack License (Doc ID 2276199.1)– Controlling Diagnostic and Tuning …

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 …

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    …

Rename Datafile In Oracle Standby on New Location “Suppose you come across a situation while serving a customer, where the DR server faces space limitations. In order to address this …