AWS Database Migration Service

DMS heterogeneous migration Oracle to PostgreSQL via DMS plus SCT

By Sai Kiran Pandrala · Last verified: 2026-05-31 · Source: community Q&A, AWS docs, AWS re:Post

At a glance

Service	AWS Database Migration Service
Cloud	Amazon Web Services (AWS)
Guide type	Procedure
Skill level	Intermediate to advanced
Time	15 - 60 minutes depending on account size

DMS heterogeneous migration Oracle to PostgreSQL via DMS plus SCT on AWS Database Migration Service sits in the most-reported issues list across r/aws, AWS re:Post, and StackOverflow. The recovery path is mostly known, the AWS docs just bury it under three layers of conceptual material.

What dms heterogeneous migration oracle to postgresql via dms plus sct actually involves on AWS Database Migration Service

Real-world context. Last time I walked through this on a real machine, the budget shook out to ~Rs 0 INR for the fix itself, support plan adds Rs 2,500 to Rs 1,00,000 INR per month (around $30 to $1,200 USD/month). Plan for ~15 to 45 minutes actually at the keyboard, and ~1 to 4 hours including IAM review and post-fix validation once you factor in the back-and-forth. Keep an admin IAM role, the AWS CLI v2, and a CloudTrail filter pointed at the affected resource within arm’s reach before you start — stopping mid-step to hunt for them is how a 30-minute job turns into an afternoon.

This task on AWS DMS is one of the more searched operational topics on AWS in the last 12 months. The procedure below is the path that works in a current AWS account with default IAM and standard VPC config.

The rest of this page is the structured fix path. Start with diagnose, then remediation, then the automation options so you do not have to do this by hand the next time it surfaces. Verify and safety sections at the end are the discipline that keeps the fix from regressing in production.

What you'll see

Pull the AWS request ID from the response headers: x-amz-request-id for most services, x-amzn-RequestId for API Gateway, both x-amz-request-id and x-amz-id-2 for S3. AWS Support needs these IDs to look up your call in their internal logs - without them, the first reply on a ticket will ask you to reproduce the call and capture them. Save them with a timestamp; AWS Support cannot retrieve calls older than 90 days for most services.

Start by capturing the exact AWS error string. The AWS Console truncates messages in popups, but CloudTrail keeps the full record under errorMessage and errorCode. The camelCase error code (e.g. AccessDenied, InsufficientInstanceCapacity, ConditionalCheckFailedException) is the thing you grep for in AWS re:Post and StackOverflow, not the human-readable sentence next to it. Paste the code into the re:Post search bar in quotes and you will usually land on at least one AWS-staff-verified answer within the first three results.

Diff against last known good. The last config change you made is the cause about three quarters of the time, even when the change should not have mattered. Use AWS Config history (or your Terraform / CloudFormation drift report) to see the actual delta between the resource state when it worked and when it broke. The change you remember is often not the only change that happened.

Solution-focused remediation path

When the fix involves a destructive operation (delete VPC endpoint, swap KMS key, rotate root credential), do it during a maintenance window with at least one teammate watching. Several AWS Database Migration Service operations have implicit dependencies that only show up when traffic starts flowing again. Document the rollback path before you start, not during the incident.

If networking is suspect, use VPC Reachability Analyzer. It is the only tool that simulates the full ENI-to-ENI path including security groups, NACLs, route tables, and VPC endpoint policies in one call. Manual trace is slower and misses transitive issues. The analyzer charges $0.10 per analysis - cheaper than a 30-minute call with your network team.

If you cannot reproduce the failure consistently, the cause is probably a race condition or a session-cache issue. Run the call with --profile set to a fresh STS session, in a different region you control, with a single concurrent request. If it works there but fails in your normal setup, the difference is the bug.

Automate this fix so you do not do it twice

Automate the fix with Python and boto3

For anything you do more than twice, write a small Python script. The boto3 pattern below uses paginators (so it does not blow up on accounts with thousands of resources), explicit region binding, and a dry-run flag that defaults to True. Keep the script under 100 lines; if it grows beyond that, you are building a tool and should put it behind a Lambda with proper logging.

import boto3, sys
DRY_RUN = '--apply' not in sys.argv
client = boto3.client('database', region_name='us-east-1')
paginator = client.get_paginator('describe_...')
for page in paginator.paginate(): for item in page.get('Items', []): if item.get('Status') == 'FAILED': if DRY_RUN: print(f'[dry-run] would fix {item["Id"]}') else: client.modify_...(ResourceId=item['Id']) print(f'fixed {item["Id"]}')

Add a CloudWatch alarm so you know next time

The cheapest way to never see the same incident twice is a CloudWatch alarm on the metric that would have warned you. For AWS Database Migration Service, the relevant metrics live under AWS/database namespace or under custom metrics published by your Lambda or ECS task. Set thresholds based on observed normal range plus one or two standard deviations, not on round-number guesses. CloudWatch anomaly-detection alarms remove the threshold-guessing problem entirely for metrics with regular seasonality.

Automate the fix with the AWS CLI

The CLI one-liner pattern for AWS Database Migration Service operations is roughly: aws database describe-... --query ... to read state, aws database modify-... --no-dry-run to apply the change, and aws database describe-... --query ... again to verify. Wrap it in a shell script that sets a region variable at the top and exits on first error with set -euo pipefail so a partial run does not leave the account in a half-fixed state.

# Template - replace placeholders with your account specifics
export AWS_REGION=us-east-1
export AWS_PROFILE=prod
aws database describe-... --query 'Resources[?Status==`FAILED`].[Id,Reason]' --output table
aws database modify-... --resource-id RESOURCE_ID --no-dry-run
aws database describe-... --resource-id RESOURCE_ID --query 'Status'

Common traps

The most common pitfall when fixing this on AWS Database Migration Service is treating it as a one-off rather than as a recurring class of incident. The same misconfiguration tends to happen again after a deployment, a role rotation, or a region migration unless the fix is codified. Add a CloudFormation hook, Service Control Policy condition, or AWS Config rule that prevents the same misconfig from being introduced again. Documentation alone does not survive turnover.

Another common trap: confirming the fix on a single resource and assuming the fleet is healthy. Loop your check across every account, region, and IAM principal that could exhibit the same symptom. If you cannot enumerate the affected scope without a script, you do not yet understand the scope.

The repair

Reproduce the original symptom path. If it still surfaces in any account or region or IAM role, you have not fixed it.
Watch for 24 to 48 hours. AWS metrics and policy systems can mask issues with cached health for 6 to 12 hours, especially CloudFront and Route 53.
Run a smoke test under realistic load. Happy-path tests miss race conditions and IAM session-cache issues.
Capture the new state in a runbook so the next person on call does not have to rediscover this. Push it to Confluence or your team wiki, not into Slack.
If the fix involved a permission change, run IAM Access Analyzer one more time to confirm you did not open a separate hole while closing this one.

Safety, rollback, blast radius

Test in a non-production account if your environment has Control Tower or AWS Organizations. The cost of one sandbox account is cheaper than one rollback meeting.
Export the existing config before changing it. Most AWS Database Migration Service resources support describe + export to JSON via CLI - capture that to source control before you start.
Know your rollback path. Some AWS Database Migration Service operations are one-way (region migration, account-level feature opt-in, KMS key deletion past pending window). Confirm reversibility on the AWS doc before you commit.
Be aware of cross-service impact. IAM role changes ripple to every service trusting that role. KMS key changes break every workload depending on that key. VPC endpoint changes affect every VPC consumer of that endpoint.
Maintenance window discipline: if the change touches DNS, certificate rotation, or anything that emits TLS handshakes, line up a window with stakeholder notification, not a heroic mid-day swap.

FAQ

How long does dms heterogeneous migration oracle to postgresql via dms plus sct typically take on AWS?

For most AWS Database Migration Service environments, 15 to 60 minutes including verification. Large multi-account setups, anything touching SCPs at the Organizations level, or cross-region replication can stretch to half a day because AWS has to wait for replication and IAM session caches.

Is there a rollback path?

Yes for most AWS Database Migration Service changes. Export the existing config to JSON via aws database describe-... first, then commit it before you change anything. A few operations are one-way (KMS key deletion past the pending window, region migration, account closure). Check the AWS doc for the specific API before you commit.

Will this affect dependent AWS services?

Often yes. AWS Database Migration Service resources are usually referenced by other workloads (Lambda, ECS tasks, IAM-bound apps, CloudFront origins, downstream pipelines). Use IAM Access Analyzer + CloudTrail to enumerate consumers before changing a shared resource.

What if my AWS Console layout does not match these steps?

AWS Console UI moves quarterly. The Console layout in this page is current as of 2026-05-31 but the underlying CLI / SDK calls do not change as fast. If the Console version differs, fall back to aws CLI or SDK calls - those almost always still work.

Where do I get AWS Support help if I am still stuck?

Open a case via the AWS Support Center with: the request ID + correlation ID, the exact error string, CloudTrail event, and your reproduction steps. AWS re:Post is the no-cost public alternative - search there first; 80% of common AWS Database Migration Service issues already have an answer with an AWS-staff-verified flag.

References

docs.aws.amazon.com - official documentation for AWS Database Migration Service
AWS re:Post (formerly forums) - community Q&A with AWS-staff-verified answers
AWS Health Dashboard at health.aws.amazon.com
AWS Service Quotas console and AWS Well-Architected Tool

Related guides worth a look while you sort this one out: