AWS Database Blog
Category: RDS for Oracle
Rethink Oracle Standard Edition Two on Amazon RDS for Oracle
Organizations are adopting the cloud as the standard and actively evaluating their database needs. Amazon Relational Database Service (Amazon RDS) for Oracle is a managed service that makes it easy to set up, operate, and scale Oracle deployments in the cloud. This helps migrate your legacy Oracle database to Amazon RDS for Oracle and, as […]
Integrate Amazon RDS Custom for Oracle with Amazon EFS
As customers migrate their Oracle databases to the AWS Cloud, they often need a shared file system to be available on their Oracle database systems either to share files between the database and application servers or as a staging location to keep backups, data loads, and more. Amazon RDS Custom automates database administration tasks and […]
Achieve minimal downtime for major and minor version upgrades of Amazon RDS for Oracle using Oracle GoldenGate
Amazon Relational Database Service (Amazon RDS) for Oracle provides new engine versions of databases and Oracle Critical Patch Updates for existing versions of databases, so you can keep your database instances up to date. These versions include bug fixes, security updates, and other enhancements. In this post, we show you how to perform an upgrade […]
Use Oracle Real Application Testing features with Amazon RDS for Oracle
February 2024: This post was reviewed and updated with the Amazon Elastic File System (EFS) integration in RDS for Oracle. The updates show how to use RDS for Oracle as source for Real Application Testing (RAT). Customers running databases in a self-managed environment face many challenges, such as scalability, performance, maintenance overhead, and reliability. To […]
Best practices for upgrading Amazon RDS for Oracle DB instances from 12c to 19c
Amazon Relational Database Service (Amazon RDS) for Oracle provides newer versions of databases as they are introduced by Oracle so you can keep your DB instances up to date. These versions can include bug fixes, security enhancements, and other improvements. When Amazon RDS for Oracle supports a new version, you can choose how and when […]
Best practices for upgrading Amazon RDS for Oracle database snapshots
Amazon Relational Database Service (Amazon RDS) for Oracle provides the option to take manual DB snapshots of your databases. These DB snapshots may have to be retained for regulatory purposes or just as backups taken before any major database or application activities like upgrades or releases. When you create a DB snapshot, the snapshot is […]
Implement Oracle GoldenGate high availability in the AWS Cloud
The need to move data from one location to another in an asynchronous manner is a goal for many enterprises. Use cases might include migrating data to a reporting database, moving applications from on premises to the cloud, storing a redundant copy in another data center, configuring active/active databases across geographic locations, and performing heterogeneous […]
Implement high availability for Oracle Enterprise Manager in the AWS Cloud
As you migrate Oracle workloads to AWS, you may want to implement Oracle Enterprise Manager (OEM) Cloud Control in AWS. OEM is Oracle’s management platform, which provides a single pane of glass for managing Oracle environments. In this post, we provide two solutions to implement OEM high availability in AWS. The first solution is Oracle’s […]
Load and unload data without permanently increasing storage space using Amazon RDS for Oracle read replicas
Generally, DBAs use Oracle Data Pump to move data around for activities like migrating existing data from Oracle on-premises to Amazon Relational Database Service (Amazon RDS) for Oracle or refreshing Oracle on-premises by exporting data from Amazon RDS for Oracle. As of this writing, after you create an RDS DB instance, you can’t decrease the […]
Implement Oracle Database Resident Connection Pool with Amazon RDS for Oracle
This post describes how to configure Oracle Database Resident Connection Pool (DRCP) in an Amazon Relational Database Service (Amazon RDS) for Oracle environment. You can use DRCP with application servers that can’t do middle-tier connection pooling. You can also use DRCP to manage hundreds or thousands of database connections from clients spread across multiple application […]