Oracle RDS missing package rdsadmin_s3_tasks

Question

In my RDS Oracle (19c Oracle Standard Edition Two) there is no package rds_admin.rdsadmin_s3_tasks. Tried querying with DBA_SOURCE and DBA_OBJECTS as well and there is no such object. How to get this package installed?

Thanks!

munsidd · Accepted Answer

Add the Amazon S3 integration option as mentioned in the document https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.preparing.option-group.html

anish_g · Answer

Hi,

Please make sure you have added the S3 integration using the options group to the RDS for Oracle 19c standard edition (SE2) version database.

Additionally, the RDS database should have appropriate permission to read and write to the S3 bucket and the DB instance and Amazon S3 bucket must be in the same AWS Region.

Please refer to the AWS documentation which has detailed steps regarding enabling S3 integration with RDS for Oracle - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html

Sharing a sample output from RDS for Oracle Standard Edition 2 database as reference,

```
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

SQL> select name,open_mode,database_role,edition from v$database,v$instance;

NAME      OPEN_MODE            DATABASE_ROLE    EDITION
--------- -------------------- ---------------- -------
DB01      READ WRITE           PRIMARY          SE2

SQL> desc rdsadmin.rdsadmin_s3_tasks
FUNCTION DOWNLOAD_FROM_S3 RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_BUCKET_NAME                  VARCHAR2                IN
 P_DIRECTORY_NAME               VARCHAR2                IN
 P_S3_PREFIX                    VARCHAR2                IN     DEFAULT
 P_DECOMPRESSION_FORMAT         VARCHAR2                IN     DEFAULT
 P_ERROR_ON_ZERO_DOWNLOADS      VARCHAR2                IN     DEFAULT
FUNCTION RDS_VERSION RETURNS VARCHAR2
FUNCTION UPLOAD_TO_S3 RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_BUCKET_NAME                  VARCHAR2                IN

- - - - - - - - - - -
- - - - - - - - - - -
- - - - - - - - - - -
```

Also, sharing troubleshooting guide as well - https://repost.aws/knowledge-center/rds-oracle-s3-integration.

Oracle RDS missing package rdsadmin_s3_tasks

Relevant content