Questions tagged with Oracle
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hello,
Attempting to lock expired users in AWS Oracle RDS using a created procedure faces an "insufficient privileges" error. The procedure, designed to execute ALTER USER commands, encounters...
1
answers
0
votes
680
views
asked 4 months agolg...
I am importing the data dump file that I have downloaded from S3.
```
-----load schema
DECLARE
v_hdnl NUMBER;
BEGIN
v_hdnl := DBMS_DATAPUMP.OPEN(operation => 'IMPORT', job_mode => 'SCHEMA',...
1
answers
0
votes
986
views
asked 4 months agolg...
Is it possible having a read replica of an Oracle RDS instance in a different account and different VPC using VPC Endpoints?
2
answers
0
votes
765
views
Data replicationlg...
Which is the cheapest AWS service for data replication between two AWS accounts?
I am using Oracle DB for this experiment.
3
answers
0
votes
604
views
asked 5 months agolg...
Hi
I migrated an oracle 19c DB from on-premise to RDS using data pump exp/imp.
I noticed one application schema failed to be granted a permission "grant any role".
I used the RDS master account for...
2
answers
0
votes
580
views
asked 5 months agolg...
Hi,
I have an AWS cloud account with many EC2 and RDS servers running.
I need to run a monthly script to count the number of EC2 and RDS instances that are running an oracle EE or SE engine...
2
answers
0
votes
349
views
asked 5 months agolg...
Hello everyone.
I'm new into AWS configuration, and I started an Oracle RDS test instance, and need to access it just only once. In the instance configuration, I turned on "Publicly accessible", but...
Accepted AnswerOracle
1
answers
0
votes
411
views
asked 6 months agolg...
Restored database snapshot to perform some testing. For reasons unknown, after restoring the snapshot the SPATIAL option had to be removed/reapplied to enable Spatial features as all the Spatial...
0
answers
0
votes
333
views
asked 7 months agolg...
Hi
I've already configured and running S3 integration on a RDS Oracle, but when I try to add EFS integration the option group shows error. It's resolved removing the EFS option.
Can both...
1
answers
0
votes
535
views
asked 7 months agolg...
Hello
I'm following the doc to enable the AWR generation from a RO replica, in an Oracle RDS environment. I've already did it for the primary and works...
3
answers
0
votes
758
views
asked 7 months agolg...
RDS Master Accountlg...
Hi
I have an oracle 19c RDS in AWS.
I created a DBA account and granted the DBA role to it.
Is there anymore grants that I can do to make account with similar permission to the RDS master account...
1
answers
2
votes
443
views
asked 7 months agolg...
Hi
I have an oracle 19c running on RDS in AWS.
I need to setup some monitoring alarms in case DB goes down, CPU utilization goes over 80%, RDS deletion, etc. and received an email alert.
I noticed...
1
answers
0
votes
692
views
asked 7 months agolg...