AWS DMS: unable to select the RDS for engine Oracle

0

In DMS, when creating either a Data Provider or Endpoint (source), my Oracle RDS (19c, Standard Two, CDB) is not visible as a choice. A different RDS (Postgres) from same VPC, same subnets (private), same security groups, same AZ (eu-central-1), is visible and accessible. If I enter the connection manually, then DMS still fails to connect during Schema Conversion. What else I tried without success: explicit IAM policy/role for DMS & DB's ARN; editing the security group (for all IPv4 TCP and my custom port).

  • I didn't try yet to access it from the desktop SCT client because even if it works there, I won't be able to create the endpoint and migration task for the data.

1개 답변
2
수락된 답변

It works for me.

AWS DMS supports the following Oracle database editions:

  • Oracle Enterprise Edition
  • Oracle Standard Edition
  • Oracle Express Edition
  • Oracle Personal Edition

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html

Enter image description here Enter image description here Enter image description here

profile picture
전문가
답변함 한 달 전
profile picture
전문가
Artem
검토됨 23일 전
profile picture
전문가
검토됨 한 달 전
  • Mine is "Oracle Standard Edition Two (CDB)", but still, "Single-tenant configuration". I will try with a normal DB

  • Made a new DB, not CDB this time, this one is visible in both sections. And I also changed the port to default 1521 to be sure. Thx!

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠