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
44 results
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.
2
answers
0
votes
34
views
asked 10 days ago
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...
2
answers
0
votes
42
views
asked 24 days ago
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...
1
answers
0
votes
59
views
asked 2 months ago
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...
1
answers
0
votes
68
views
asked 2 months ago
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...
1
answers
0
votes
55
views
asked 2 months ago
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...
1
answers
0
votes
46
views
asked 2 months ago
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)?
1
answers
0
votes
66
views
asked 2 months ago
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...
1
answers
0
votes
91
views
asked 2 months ago
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...
2
answers
0
votes
303
views
asked 9 months ago
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...
4
answers
0
votes
497
views
asked a year ago
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...
2
answers
0
votes
1.2K
views
asked a year ago
Hi, I'm trying to implement a DR for an Oracle RDS, for testing, we are copying the backups to a different region, I'm creating a PITR but is taking too long to create the new instance, it has been on...
2
answers
0
votes
323
views
asked a year ago