Migrate on-prem Oracle 12c Database to AWS RDS 19c instance

Name: Migrate on-prem Oracle 12c Database to AWS RDS 19c instance
Rating: 4.4 (25 reviews)

Learn step-by-step how to migrate Oracle 12c to AWS RDS 19c using Data Pump export/import

Created byHamid Ozair

Last updated 5/2025

English

English [Auto],

What you'll learn

Understand the key differences between Oracle 12c on-premises and AWS RDS 19c.
Prepare an Oracle 12c database environment for migration.
Perform an AWS RDS setup and configure the target Oracle 19c instance.
Use Oracle Data Pump expdp/impdp effectively for database migration.
Handle pre-migration tasks such as user management, schema analysis, and object dependencies.
Ensure data integrity and validate the post-migration Oracle RDS environment.
Understand the S3 integration in RDS instance
Understand the Parameter and Option groups

Course content

1 section • 17 lectures • 1h 10m total length

Course Overview2:49
Review the on-prem Oracle 12c database to identify open schemas and their tablespaces; prepare the AWS RDS 19c target by creating needed tablespaces before import, then verify object parity.
Create s3 Bucket1:22
create an s3 bucket in the aws console to host export dump files, using a general purpose bucket with a unique name such as hamid-dash-rds-s3.
Create s3 Bucket Policy2:52
Create an s3 bucket policy in the aws iam console to grant list, get object, and put object access for all objects in the bucket using arn and a wildcard.
Create IAM Role1:40
Create an IAM role and attach an S3 bucket policy, then choose add role to database and assign the relevant policies, creating the role named Hamid Dash S3 dash role.
Create RDS Parameter Group1:37
Create a custom parameter group for the BTS Oracle 19c instance to modify SGA, cursor sharing, and other parameters, since default groups cannot be modified.
Create RDS Option Group1:24
Create AWS RDS 19c instance31:03
Learn how to create an Oracle 19c AWS RDS instance from the console, configuring storage, instance class, public access, and enterprise edition options for a cost-conscious dev/test setup.
Attach IAM Role to RDS Instance1:16
Attach the IAM role to the RDS instance to enable S3 integration for data pump export and import operations, using the Hamid S3 role as the external storage.
Connect RDS instance with TNS service name4:02
Connect an on-premises Linux server to an AWS RDS 19c instance via a DNS service by configuring environment variables and using the RDS endpoint hostname.
Connect RDS Instance directory without TNS service name1:24
Connect an on-prem linux server to an AWS RDS Oracle 19c instance without DNS service, using a direct connect string with the RDS endpoint, port 1521, and the admin login.
Export on-prem Oracle 12c with Data Pump5:06
Export the on-prem Oracle 12c database with data pump, creating a Linux directory, a database directory, and running a parallel schema export that produces four dump files and a log.
Install AWSCLI on the Linux server to run AWS commands1:27
Install the aws cli on the Linux server to run aws commands and verify the installation by checking the cli version.
Upload Data Pump dump files to s3 Bucket3:41
Upload data pump dump files to an S3 bucket by configuring AWS access keys in the bash profile, and verify the bucket is empty before running AWS S3 cp --recursive.
Download Data Pump Dump files from s3 Bucket into RDS instance1:35
Download data pump export dump files from the S3 bucket into the RDS instance data pump directory and verify completion by checking the task ID, status, and log file.
Create Tablespaces in RDS instance before running import1:55
Create all necessary tablespaces in the RDS instance prior to data pump import, expanding from five to 31 tablespaces and verifying 32 TB data files and four open schemas.
Import Data into RDS using Data Pump import3:24
Perform data pump import to bring all on prem database objects into the RDS 19c instance, observing schema counts rise from 24 to 51 and confirming a successful import.
Perform RDS database Validation by comparing with on-perm database3:49
Validate the AWS RDS 19c database by comparing objects with the on-prem Oracle 12c database using data pump export import for cross-version migration, complemented by automated shell scripts.

Requirements

Basic understanding of Oracle Database
Basic understanding of AWS RDS instance
Account in AWS
A 64-bit Windows PC with 12GB of memory and 80GB of free disk space

Description

Are you looking to migrate your on-premise Oracle 12c database to the cloud using Amazon RDS 19c? This hands-on course provides a complete, step-by-step guide to successfully perform the migration process using Oracle Data Pump expdp/impdp

Whether you're a Database Administrator (DBA), Cloud Engineer, or IT professional exploring AWS, this course walks you through the practical details and best practices of cloud migration using real-world scenarios.

We’ll cover everything from setting up your AWS RDS instance to exporting and importing data, handling schema-level migration, and validating post-migration integrity.

No prior AWS experience is required, but a basic understanding of Oracle databases and Linux command line is recommended. By the end of the course, you'll be able to confidently migrate Oracle databases to AWS RDS using data pump for future migrations.

What You Will Learn

Key differences between Oracle 12c (on-prem) and Oracle 19c in AWS RDS
Setting up AWS RDS for Oracle 19c
Preparing Oracle 12c for migration
Exporting data using Oracle Data Pump (expdp)
Importing data into AWS RDS 19c (impdp)
Perform an AWS RDS setup and configure the target Oracle 19c instance.
Handling pre- and post-migration validation
Monitoring, troubleshooting, and performance tuning
Creating a par file from the Data export
Crating a par file for the data pump import

Who this course is for:

Students who want to learn how to migrate Oracle database into AWS RDS
Students who want to learn how to upload and down objects from s3 bucket
Students who want to learn how AWS Roles and Poplices work