The Oracle Maximum Availability Architecture (MAA) product management team invites you to attend its next MAA Summit for informative and interactive sessions on Oracle Database high availability and disaster recovery, Oracle Vector Search, and Exadata MAA. Learn about what’s new and provide your feedback directly to Oracle product management. When and Where Tuesday, May 14,…
Tag: High Availability
Use ACCHK to Understand your Application Protection by Application Continuity
Introduction Oracle RAC and Oracle Active Data Guard provide high availability and disaster recovery for the Oracle Database. During maintenance operations such as patching and upgrades or in case of failures and outages, applications can reconnect to another active Oracle RAC instance or to the Data Guard standby database. Oracle Application Continuity extends the high…
How to Use AWR to Check if Your Application is Protected by Application Continuity
Introduction Oracle provides the Checklist for Application Continuity alongside many other resources to get you started with Application Continuity. After completing the configuration at the database and application side, the question is how to verify whether your application calls are protected by Application Continuity? This information can be easily found in the AWR report. The…
How Application Continuity Works for Unplanned Interruption in Oracle RAC Environments
Introduction In a previous blog post, we discussed how Draining and Application Continuity work for maintenance events like rolling patching with Oracle RAC. For planned maintenance, draining can be used to allow active sessions to finish their work (drain) before the database instance is shut down. However, in unplanned events like an instance failure, all…
How Draining and Application Continuity Work for Maintenance with Oracle RAC
Introduction Oracle RAC provides scalability and high availability for the Oracle Database. If one server (RAC node) fails or is taken offline for maintenance, the database is still accessible through the additional nodes. However, what happens to client sessions that are executing some work, whether reading or changing data, when maintenance begins? That work will…
The Evolution of Oracle and Microsoft’s Partnership and the Challenges it solves
Introduction Customers moving their workloads from on-premises to the Cloud want to take advantage of the best features and lowest prices each public cloud provider offers alongside other benefits. Microsoft’s customers usually prefer to run their applications in Azure while continuing to rely on Oracle Database for data management using Oracle Autonomous Database and Exadata…
A Java Example for Oracle Application Continuity with Autonomous Database
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
A Java Example for Oracle Application Continuity with Oracle Active Data Guard
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
A Java Example for Oracle Application Continuity with Oracle RAC
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
How to create Oracle Database Services for High Availability
Introduction To use High Availability features like Fast Application Notification (FAN), Draining, and Application Continuity, you need to create a custom database service and set the high availability attributes accordingly. This is not possible when using the default database service, which is the service with the same name as the PDB. Additionally, custom database services…
Database Heartbeat 