AWS Database Blog

Category: RDS for Oracle

Migrate from Oracle RAC to AWS: Alternatives on AWS

Oracle Real Application Clusters (RAC) are a way of accessing a database from multiple database servers. This provides some added high availability (HA) features over a single-instance database. In this post, we talk about why you might choose Oracle RAC for your Oracle databases, and the different ways to implement similar architecture on AWS while […]

Read More

Securely assess database schema migrations using AWS SCT, Amazon RDS for Oracle, and AWS Secrets Manager

Database migration is a multi-step process comprised of assess, mobilize, and modernize phases with different tools and technologies involved. You can use tools such as AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to accelerate each of these phases. An important part of AWS SCT is the report that it […]

Read More

Options to run deprecated major versions of Oracle databases on AWS

Oracle Database version 12c is past end of support, as announced by Oracle. Oracle 12c Release 1 (12.2.0.1) stands unsupported beyond March 31, 2022, and Oracle 12c Release 2 (12.1.0.2) is unsupported beyond July 31, 2022. After these dates, Oracle no longer releases Critical Patch Updates for these versions. To ensure that our customers continue […]

Read More

Managed Oracle Data Guard Switchover with Amazon RDS for Oracle

Amazon Relational Database Service (Amazon RDS) for Oracle now supports a fully managed, switchover-based role transition for Oracle Database replicas using Oracle Data Guard. You can initiate a switchover to a replica that is mounted or open read-only and the replicas can reside within an Availability Zone of a Region, across an Availability Zones of […]

Read More

Recreate an Amazon RDS Custom for Oracle database: Part 2

In this series, we discuss best practices and step-by-step instructions to perform common customizations on Amazon Relational Database Service (Amazon RDS) Custom for Oracle without breaking the support perimeter: Part 1 covers customizing the time zone and character set of the database Part 2 (this post) discusses customizations such as changing the default block size, […]

Read More

Make configuration changes to an Amazon RDS Custom for Oracle instance: Part 1

Amazon Relational Database Service (Amazon RDS) Custom is a managed database service that provides the flexibility to customize your database, underlying server, and operating system configurations to support applications that require more control than a typical managed RDS provides. Amazon RDS Custom for Oracle is built for legacy, custom, packaged applications and any application that […]

Read More

Migrate to Amazon RDS for Oracle with cost optimization

When migrating Oracle Database applications to AWS, you have many opportunities to modernize and optimize your architecture. This migration provides increased agility and flexibility, as well as the potential to migrate to a fully managed service, such as Amazon Relational Database Service (Amazon RDS) for Oracle. RDS for Oracle offers compute scaling, automated backups, event […]

Read More

How AEVI substituted Oracle materialized views fast refresh with AWS DMS when migrating to Amazon Aurora

AEVI took the journey to migrate to AWS. In their own words, “AEVI provides merchant-facing businesses—banks, acquirers, PSPs, ISOs, ISVs, and others—with a platform that enables merchants to run their business smarter by giving them easy access to any payment technology and business solution for the best in-store customer experience. AEVI’s Platform for Smart Merchant […]

Read More

Set Oracle diagnostics system events on Amazon RDS for Oracle

With Amazon Relational Database Service (Amazon RDS) for Oracle, you can now set Oracle diagnostic events parameters requested by Oracle Support at the system level to enable Oracle to dump additional diagnostics information from the database instance on the Oracle database Ora-errors or process context of a malfunctioning process. You can set these events parameters […]

Read More

Security auditing in Amazon RDS for Oracle: Part 2

Security auditing is an effective method of enforcing strong internal controls that can enable you to monitor business operations to find activities that may deviate from company policy and meet various regulatory compliance requirements. Security auditing allows you to record the activity on the database for future examination and is one part of an overall […]

Read More