Linux patching (OS security updates, kernel upgrades, etc.) is a routine activity for system administrators. For Oracle RAC environments, DBAs must ensure pre-patching checks, safe shutdowns, and post-patch relinks are properly executed to avoid service disruption. 1. Why Pre-Patching Checks Are Critical Before handing over the server to the Linux team, DBAs must: These pre-checks […]
These questions focus on architectural depth, troubleshooting acumen, performance tuning, HA/DR integrations, and strategic considerations, aligning with enterprise-level expectations. 1. Explain the internals of Oracle RAC interconnect. How do you troubleshoot interconnect latency or packet loss? 2. How does Oracle 19c handle split-brain scenarios? What improvements were made over previous versions? 3. What are the […]
When a database is originally created with the Global Database Name <database>, its db_name and db_unique_name are the same. The CRS (Cluster Ready Services) database resource is named as ora.<database>.db. Changing the db_unique_name involves a complete database restart and requires careful coordination of steps. Step 1: Remove the Database, Instance, and Service Resources from CRS […]
Sequences are a fundamental feature in Oracle databases, commonly used for generating unique identifiers such as primary keys. However, in a Real Application Clusters (RAC) environment, sequence behavior introduces certain performance and ordering challenges that require careful configuration. This blog provides insights into sequence configurations, gaps, and their performance impact in a RAC setup. 1. […]