AWS Database Blog

Category: RDS for Oracle

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 […]

Read More

Use Oracle Real Application Testing features with Amazon RDS for Oracle

Customers running databases in a self-managed environment face many challenges, such as scalability, performance, maintenance overhead, and reliability. To help increase resiliency, performance, and scalability, AWS has become the new norm for companies. AWS offers the widest variety of databases that are purpose-built for different types of applications so you can choose the right tool […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

Automate post-database creation scripts or steps in an Amazon RDS for Oracle database

In some cases, Database Administrators (DBAs) need to run post-database creation steps such as running SQL statements for creating users and database objects, resetting passwords, or standardizing Oracle database builds. This is mainly done during the database creation phase of new application deployment or during database refreshes that occur in non-production environments. AWS CloudFormation gives […]

Read More

Validate Native Network Encryption on Amazon RDS for Oracle

Many organizations go through auditing, and have to meet auditing compliance policies that require data to be encrypted over the network from application servers to the database server. Oracle Database provides two types of network security encryption methods: native network encryption (NNE) and Secure Sockets Layer (SSL). Amazon Relational Database Service (Amazon RDS) for Oracle […]

Read More