Oracle Database Administration on AWS

by Tanveer A

Amazon Web Services (AWS) offers you the ability to run your Oracle Database in a cloud environment. Running Oracle Database in the AWS Cloud is very similar to running Oracle Database in your data center. To a database administrator or developer, there are no differences between the two environments. However, there are a number of AWS platform considerations relating to security, storage, compute configurations, management, and monitoring that will help you get the best out of your Oracle Database implementation on AWS. Amazon RDS for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale Oracle deployments in the cloud. Amazon RDS for Oracle Database is designed for developers or businesses who require the full features and capabilities of Oracle databases, or who wish to migrate existing applications and tools that utilize Oracle databases. Since Amazon RDS for Oracle Database provides you direct access to familiar Oracle Database software of the edition you have specified, your applications should connect seamlessly. Table of Contents Oracle Databases on AWS Amazon Relational Database Service (Amazon RDS) Oracle on Amazon RDS Administering your Oracle DB instance Performing common system tasks for Oracle DB instances Performing common log-related tasks for Oracle DB instances Performing common RMAN tasks for Oracle DB instances Performing common scheduling tasks for Oracle DB instances Performing common diagnostic tasks for Oracle DB instances Performing miscellaneous tasks for Oracle DB instances Importing data into Oracle on Amazon RDS Working with Oracle replicas for Amazon RDS Amazon S3 integration Creating an Oracle DB instance Connecting to your Oracle DB instance Managing an Amazon RDS DB instance Modifying an Amazon RDS DB instance Maintaining a DB instance Upgrading a DB instance engine version Upgrading the Oracle DB engine Upgrading an Oracle DB snapshot Renaming a DB instance Rebooting a DB instance Working with read replicas Working with storage for Amazon RDS DB instances Deleting a DB instance Relational Database Services (RDS) for Oracle – Step-by-Step Installation of Oracle on EC2 – Step-by-Step Oracle Application Express (APEX) Oracle Enterprise Manager Database Express Oracle Management Agent for Enterprise Manager Cloud Control Setting up Amazon RDS to host tools and third-party software for Oracle Using Oracle GoldenGate with Amazon RDS Using the Oracle Repository Creation Utility on Amazon RDS for Oracle Oracle database engine release notes Security in Amazon RDS Data protection in Amazon RDS Resilience in Amazon RDS Infrastructure security in Amazon RDS Amazon RDS API and interface VPC endpoints (AWS PrivateLink) Security best practices for Amazon RDS Master user account privileges Amazon Virtual Private Cloud VPCs and Amazon RDS Troubleshooting for Amazon RDS Best Practices for Running Oracle Database on AWS

516 pages, Kindle Edition

Published April 4, 2021