RDS S3 integration

0

My RDS has S3_INTEGRATION in option group, still I am receiving below error when I try to download files in RDS Data_Pump_dir.

The DB instance doesn't have credentials to access the specified Amazon S3 bucket.To grant access, add the S3_INTEGRATION role to the DB instance.

Thanks.

vs224
질문됨 5년 전2040회 조회
2개 답변
1

Hi there,

Enabling the new S3 Integration feature involves two actions against your RDS Oracle instance:

  1. attach an IAM role containing a policy that allows access to your S3 bucket(s), and
  2. add the S3_INTEGRATION option to your option group.

If you have only added the S3_INTEGRATION option, you will still need to create an IAM policy with S3 access privileges, create an IAM role that includes the policy, and then add the IAM role to your RDS instance. Instructions for doing this using the AWS console or CLI can be found in the "Prerequisites for Amazon RDS Oracle Integration with Amazon S3" section of the RDS user guide.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html#oracle-s3-integration.preparing

Hope that helps. Thanks!
Michael

AWS
답변함 5년 전
0

Hello,

We are using an RDS Oracle instance in GovCloud.

The existing roles are Service-Linked Roles.

According to the documentation on the following page, AWS creates the service-linked role for you when you create a DB instance and RDS does not allow you to edit the service-linked role.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAM.ServiceLinkedRoles.html

So, I was able to create the IAM policy as described earlier in this thread, but cannot attach that policy to the existing role. How is this supposed to be done with a service-linked role?

Thanks
Morgan

Edited by: MorganNajjar on Aug 2, 2019 6:07 AM

답변함 5년 전

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

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

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