ASRblogger

Oracle AI Database 26ai Free RPM Installation On Oracle Linux 9 (OL9)

Introduction An RPM-based installation performs preinstallation checks, extracts the database software, reassigns ownership of the extracted software to the preconfigured user and groups, maintains the Oracle inventory, and runs all…

Anish Kumar March 15, 2026No Comments

Oracle RAC

Oracle RAC Startup Architecture

When troubleshooting an Oracle Real Application Clusters environment, understanding the startup sequence of cluster components is extremely important. Many issues during node boot, cluster startup or database availability can be…

Anish Kumar March 1, 2026No Comments

Oracle RAC

Voting Disk in Oracle RAC

Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members of the cluster1. You can store…

asrblogger February 18, 2026No Comments

Oracle RAC

Oracle Local Registry (OLR) in RAC

Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each voting disk must be accessible…

asrblogger February 18, 2026No Comments

Oracle

Cursor Sharing in Oracle

Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server process executes SQL or PL/SQL code, the process uses the…

asrblogger February 1, 2026No Comments

ASM DataGuard Oracle

Reinstate or Recreate Standby DB after Failover

Reinstate Previous Primary DB as standby after Failover completed Fast_start failover initiated by Oracle: Oracle will try to reinstate old primary db as new standby. In case of failure (corrupted…

Anish Kumar January 29, 2026No Comments

DataGuard

Fast Start Failover Issues

Enable/disable: Prerequ.: Flashback needs to be enabled on primary and failover target: SQL> select NAME, OPEN_MODE, FLASHBACK_ON from v$database; NAME OPEN_MODE FLASHBACK_ON --------- -------------------- ------------------ ITSDBTST READ ONLY WITH APPLY…

Anish Kumar January 29, 20261

ORA-00020: maximum number of processes (<limit>) exceeded</limit>

Oracle

ORA-00020: maximum number of processes () exceeded

Check database parameter To check database parameter in general: SQL> show parameter cursors ## list all parameter with name .*cursors.* NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer 300 session_cached_cursors…

Anish Kumar January 29, 2026No Comments

ASM DataGuard Oracle

Approach for Troubleshooting Oracle Database Unavailability in a Production Environment

Quickstart When an Oracle Database becomes unavailable in a production (PRD) environment, troubleshooting should follow a structured and non-destructive approach to preserve evidence and avoid data loss. 1. Capture the…

Anish Kumar January 29, 2026No Comments

Oracle

Analyzing Oracle Database Performance Issues in Production Environments

Introduction A top-down approach is strongly recommended when analyzing database performance issues. The sequence of topics in this guide should not be interpreted as a fixed starting point; effective troubleshooting…