Compatibility of s3 with oracle 19c standard edtition

Hi,

Yes, the S3 integration works with RDS for Oracle 19c standard edition (SE2) as well similar to Enterprise Edition.

Make sure you follow the pre-requisite for enabling S3 integration with RDS for Oracle. 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. Again, as confirmed it works for both 19c EE and SE2 versions.

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 upload to S3 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,version,edition from v$database,v$instance;
NAME	  VERSION	    EDITION
--------- ----------------- -------
DB01	  19.0.0.0.0	    SE2

SQL> SELECT filename FROM table(rdsadmin.rds_file_util.listdir('DATA_PUMP_DIR')) where filename like '%expdp%' order by mtime;
FILENAME
-------------------------------------------------------------------
expdp_DMS_SAMPLE_8Sep24.log
expdp_DMS_SAMPLE_8Sep24_01.dmp

SQL> SELECT rdsadmin.rdsadmin_s3_tasks.upload_to_s3(
              p_bucket_name    => 'testbackupxxxxxxx', 
              p_prefix         => 'expdp_DMS_SAMPLE_8Sep24', 
              p_s3_prefix      => '', 
              p_directory_name => 'DATA_PUMP_DIR') 
          AS TASK_ID FROM DUAL; 
TASK_ID
---------------------------------------------------
1725852013547-36

You can check the status of the upload using the command,

select text FROM table(rdsadmin.rds_file_util.read_text_file('BDUMP','dbtask-1725852013547-36.log'));
TEXT
------------------------------------------------------------------------------------------------------------------
2024-09-09 03:21:23.460 UTC [INFO ] The file /rdsdbdata/datapump/expdp_DMS_SAMPLE_8Sep24.log was uploaded to Amazon S3 with bucket name testbackupxxxxxxx and key expdp_DMS_SAMPLE_8Sep24.log.
2024-09-09 03:21:23.462 UTC [INFO ] The task finished successfully.

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

Please let me know in case you run into any issues.

If the above answer clarifies your query, I would appreciate if the answer can be accepted so that community can benefit for clarity when searching for similar queries in Repost, thank you!

S3 Integration works with 19c standard edition. Please make sure the pre-requisites are in place https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html for troubleshooting you can use https://repost.aws/en/knowledge-center/rds-oracle-s3-integration