- Newest
- Most votes
- Most comments
Hi, You may want to follow section of "Resolve native database errors" of https://repost.aws/knowledge-center/dms-endpoint-connectivity-failures to investigate your issue.
Additionally, your select seems to show that your grantee doesn't have full auth on the db schema to be migrated. I would start by allowing the grantee to do any action on (test) database and then tighten the auths to a minimum set by restricting them incrementally to finally reach the minimum set.
And maybe, before doing that, I would follow best practice: check that I have proper end-to-end connectivity (routing, sec groups) between the vpc on which the DMS replication instance and my source database, which seems to be remote in your use case.
Best,
Didier
Thanks, I realized was missing GRANT SELECT ON V_$CONTAINERS TO db_user;
This is required for pluggable databases.
Hi, Can you provide all the grants as per this documentation and test the endpoint
Relevant content
- Accepted Answerasked a year ago
- asked 10 months ago
- Accepted Answerasked 9 days ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago