Questions tagged with 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

Browse through the questions and answers listed below or filter and sort to narrow down your results.

240 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
30
views
asked 4 days ago
I am currently working with an Oracle RDS instance and have encountered an issue related to the database character set. By default, my Oracle RDS instance is using the AL32UTF8 character set. However,...
3
answers
0
votes
53
views
asked 18 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
39
views
asked 18 days ago
We want to reduce the current storage sized of an RDS Oracle DB. Can I use a snapshot, or will that not work?
2
answers
0
votes
91
views
asked a month ago
Hi all, in term of Oracle Database licensing, a db.r6i.large.tpc1.mem2x instance is equal to an db.r6i.large instance? They have the same number of vCPU but the first one has only 1 thread per core. I...
1
answers
0
votes
40
views
asked a month 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
54
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
64
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
45
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
64
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
81
views
asked 2 months ago
Hi all, I found on the official documentation at this link https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-read-replicas.overview.html that read replicas are available only for the singl...
2
answers
0
votes
109
views
asked 2 months ago
We recently migrated our existing Oracle RDS from the 1 region to the another region. We took a manual snapshot of the source Oracle RDS and moved it to the target region, and then used the snapshot t...
1
answers
0
votes
51
views
asked 2 months ago