Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!
All Content tagged with RDS Custom for SQL Oracle
Amazon RDS for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale Oracle deployments in the cloud
Content language: English
Select tags to filter
Sort by most recent
45 results
Hi
If I create an Oracle RDS based on CDB architecture.
I assume oracle creates a root container CDB and PDB.
Would I be able to connect to container and create users at that level or not?
Is connec...
HI all,
is it possibile to use a local smtp server to send mail via utl_smtp package through port 25 or there are some kind of restriction and it not possibile use the port 25?
Many thanks.
Hello,
Which oracle dynamic views (if any) that can answer the following questions about RDS:
1) Is the oracle 19c database on-premise or AWS Cloud database?
2) Is the cloud oracle database basd on R...
Oracle RDS v$archived_log growing fast, it's consuming about 3000GB
Retention time is already at 0
I use this query to check it:
SELECT
ROUND(SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 / 1024, 2) AS...
My RDS Oracle instance is running out of storage due to archived redo logs.
I have already set the archivelog retention hours to 0 using:
sql
Copy
Edit
BEGIN
rdsadmin.rdsadmin_util.set_configuratio...
Per the documentation, https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html, "For each AWS account, you can copy up to 20 DB snapshots at a time from one AWS Region to another...
Is it possible to create a second master account in ORACLE RDS with same DBA permissions?
If not, can I create a regular oracle account and assign it a DBA role or privileges similar to master RDS acc...
Hi
When I create an RDS for Oracle 19c, does AWS create a container DB (CDB) and PDB in the database (multitenant architecture)
or one standalone instance (no container CDB)?
Hi
Is there a way (i.e using RDSADMIN_UTIL package) or workaround to grant these two privileges/roles to an account in oracle RDS?
GRANT ANY PRIVILEGE
GRANT ANY ROLE
I have a pl/sql application tha...
Hi,
We have Oracle multitenant architecture on RDS and have DB snapshots taken from time to time. How can I know , what all PDB's are present in a DB snapshot? Also, is it possible to restore a single...
Hi, I have region 1 with an Oracle RDS instance configured with automated backups to region 2
is it possible to use CLI to restore to the "latest time" in the region 2?
![Enter image description he...
I'm trying to copy a RDS snapshot to a different region using AWS Backup and it throws "The snapshot requires a target option group with the following options: [Timezone]" there is already an option g...