Problem: When trying to upload a file on an AWS RDS instance to an S3 bucket I was getting this error: SELECT rdsadmin.rdsadmin_s3_tasks.upload_to_s3( p_bucket_name    =>  ‘db-bucket’, p_directory_name =>  ‘DATA_PUMP_DIR’, p_prefix         =>  ‘EXPORT_SCHEMAS.dmp’) AS TASK_ID FROM DUAL; ORA-06553: PLS-306: wrong number or types of arguments in call to ‘UPLOAD_TO_S3’ 06553. 00000 –  “PLS-%s: %s” *Cause: *Action: […]

Some Oracle database administration tasks are really challenging to perform on AWS RDS, this is because AWS doesn’t provide you a full DBA account to use, but provides a master account that can perform most of DBA tasks but with some restriction; restrictions include the direct execution of the following commands: – ALTER DATABASE – […]

As you know, there are two types of cloud services AWS provides (EC2 & RDS) while EC2 let you have the full control over the Operating System OS including root access, RDS doesn’t give you any kind of OS access. Because RDS instance is managed by AWS they provide you a master admin user , […]