Tag: Oracle

In this post, we dive into the various architecture patterns and options available for both compute and storage layers while configuring your self-managed Oracle databases on HAQM EC2 to comply with your HA and DR requirements.

Customers use semi-structured or unstructured data storage for various business use cases, which is schema-less and flexible in nature. One such type of semi-structured data is JavaScript Object Notation (JSON). JSON stores data in the form of KEY, VALUE, LIST, and ARRAY formats. Oracle Database stores JSON object data in CLOB data type columns. PostgreSQL […]

HAQM Relational Database Service (HAQM RDS) Custom is a managed database service for legacy, custom, and packaged applications that require access to the underlying OS and DB environment. With RDS Custom for Oracle, you can now access and customize your database server host and operating system, for example by applying special patches and changing the […]

In this post, we advance the architecture that was discussed in Implement active-active replication with RDS Custom for Oracle: Part 1 – High Availability, where we implemented an HAQM RDS Custom for Oracle solution with multi-master and high availability. This post will show you how to add high availability (HA) and disaster recovery (DR) using Oracle […]

To migrate an Oracle database to HAQM Aurora with PostgreSQL compatibility, you usually need to perform both automated and manual tasks. The automated tasks involve schema conversion using AWS Schema Conversion Tool (AWS SCT) and data migration using AWS Database Migration Service (AWS DMS). The manual tasks involve post-AWS SCT migration touch-ups for certain database […]

HAQM Relational Database Service (HAQM RDS) for Oracle provides newer versions of databases so you can keep your DB instances up-to-date. These versions can include bug fixes, security enhancements, and other improvements. When HAQM RDS for Oracle supports a new version, you can choose how and when to upgrade your DB instances. As you may […]

In today’s world, every organization uses a centralized location to store and manage user credentials. The most commonly used service for this is Microsoft Active Directory (AD). Organizations use LDAP protocol to authenticate users to their peripheral devices, but fewer companies use this centralized credential store to allow users to log in to their databases. […]

Many AWS users are taking advantage of the managed database offerings in the HAQM Relational Database Service (HAQM RDS) portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. With HAQM RDS for Oracle, users can significantly reduce the administrative overhead of managing and maintaining an Oracle database. HAQM RDS for Oracle […]

July 2023: This post was reviewed for accuracy. An Oracle to PostgreSQL migration in the AWS Cloud can be a complex, multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. For more information about the migration process, see Database Migration—What Do You Need to Know Before You […]

AWS Database Migration Service (DMS) helps you migrate databases to AWS securely. It supports homogeneous and heterogeneous migrations between different database platforms, such as Oracle to HAQM Aurora. AWS DMS supports continuous data replication while maintaining high availability and has been widely adopted for database migrations because it is easy to configure. For more information, […]