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 Respuesta
2
Respuesta aceptada

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
EXPERTO
respondido hace un mes
profile picture
EXPERTO
Artem
revisado hace 23 días
profile picture
EXPERTO
revisado hace un mes
  • 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!

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas