Automate your RDS Custom for Oracle deployment using the provided AWS CloudFormation template. Complete the following prerequisites before deploying the resources.
Prerequisites Download required Oracle filesYou need specific Oracle installation files before you can create the AWS CloudFormationtemplate. Download these files before you deploy.
Navigate to Oracle Database 19c (19.3)
Locate and download the file LINUX.X64_193000_db_home.zip
Rename the file toV982063-01.zip
Download the remaining patches, selecting Platform or Language as Linux x86-64
Database PSU & RU Patches
Additional Required Patches
April 2023 PSU PatchesDatabase PSU & RU Patches
Additional Required Patches
Amazon S3 bucket setupCreate an Amazon S3 bucket in your AWS account, or choose an existing bucket.
Create a folder structure in the bucket similar to example below.
<bucket-name>/
âââ oracle_cev/
âââ V982063-01.zip
âââ p6880880_190000_Linux-x86-64.zip
âââ p34765931_190000_Linux-x86-64.zip
âââ p34786990_190000_Linux-x86-64.zip
âââ p35099667_190000_Linux-x86-64.zip
âââ p35099674_190000_Generic.zip
âââ p28730253_190000_Linux-x86-64.zip
âââ p29213893_1918000DBRU_Generic.zip
âââ p35012866_1918000DBRU_Linux-x86-64.zip
âââ p35042068_190000_Linux-x86-64.zip
âââ p35050341_190000_Linux-x86-64.zip
âââ p29213893_1919000DBRU_Generic.zip
âââ p33125873_1919000DBRU_Linux-x86-64.zip
âââ p35220732_190000_Linux-x86-64.zip
âââ p35239280_190000_Generic.zip
Upload all of Oracle files that you previously downloaded to the appropriate folders.
Before you can deploy RDS Custom for Oracle, you need to download and configure the AWS CloudFormation template that creates the necessary prerequisites.
Copy and save the template
Launch the stack in the AWS console
Open the AWS Console and navigate to AWS CloudFormation
Choose Create stack > With new resources (standard)
Select Choose an existing template
Select Upload a template file > Choose file
Select the template file you previously downloaded
Keep the default parameter values
Select Next to create the stack
Alternative: Using AWS CLI
Instead of using the console, you can create the stack using the AWS CLI:
aws cloudformation create-stack \
--stack-name rds-custom-oracle \
--template-body file://rds-custom-oracle-prereqs.yaml \
--capabilities CAPABILITY_NAMED_IAM
Step 2: Create the Custom Engine Versions (CEVs) and Amazon RDS instances
Copy and save the template
Step 3: Deploy using the AWS consoleOpen the AWS Console and navigate to AWS CloudFormation
Choose Create stack > With new resources (standard)
Select Choose an existing template
Select Upload a template file > Choose file
Select the template file you previously downloaded
Leave the parameters as default values
Fill in the parameters as follows:
BucketName: rds-custom-id
CEVS3Prefix: oracle_cev
CEVCreation: Yes
Review the configuration and select Next to create the stack
Optional: Deploy Using AWS CLI
aws cloudformation create-stack \
--stack-name rds-custom-oracle \
--template-body file://rds-custom-oracle.yaml \
--parameters \
ParameterKey=BucketName,ParameterValue=rds-custom-id \
ParameterKey=CEVS3Prefix,ParameterValue=oracle_cev \
ParameterKey=CEVCreation,ParameterValue=Yes \
--capabilities CAPABILITY_NAMED_IAM
Deployment resources created
The template creates the following resources:
Amazon VPC with public and private subnets
Security groups
Amazon VPC endpoints
IAM roles and policies
AWS KMS key for encryption
Custom Engine Versions (CEVs)
RDS Custom for Oracle instances for both single-AZ and multi-AZ configurations
After you create the AWS CloudFormation stack, monitor its progress to ensure successful deployment. The deployment process includes creating Custom Engine Versions (CEVs) and RDS instances.
To monitor deployment progress:
Open the AWS CloudFormation console.
Choose your stack name.
Choose the Events tab to view progress and identify any errors.
CEV creation typically requires 2-3 hours. After CEV creation completes successfully, Amazon RDS automatically begins creating the Amazon RDS instance.
Post-DeploymentAfter the stack creation process completes, perform the following post-deployment verification and configuration steps:
From the Amazon RDS console page, navigate to Custom engine versions to verify CEV creation.
Confirm Amazon RDS instances are created and available
Test connectivity to the Amazon RDS instances
Set up monitoring and backup strategies as needed
To remove all resources, run the following AWS CLI command:
aws cloudformation delete-stack --stack-name rds-custom-oracle
Troubleshooting
If you encounter issues during deployment, use the following solutions to resolve common problems.
Verify all required patches are uploaded to Amazon S3
Check IAM permissions
Verify the patch versions are correct; see the Prerequisites for the list of required patches.
Check VPC/subnet configurations
Verify security group rules
Confirm CEV is available
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4