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.
To Connect to AWSRDS Oracle I usually type sqlplus on the EC2 instance and I get a prompt user-name and I enter all the connection string and can connected
Example
[oracle@ip-xx-xx-xx-xx eeop]$...
2
answers
0
votes
493
views
asked a year agolg...
Hi,
I have a some AWS Lambda functions which connect to a Postgres SQL database hosted on EC2 and and Oracle DB hosted out of AWS. I have been facing some intermittent connectivity challenges in...
3
answers
1
votes
12026
views
asked a year agolg...
I am trying to execute a SQL script from AWS RDS Oracle instance.
The steps I followed
1) CREATE D A Directory and GRANTED READ WRITE
EXEC rdsadmin.rdsadmin_util.create_directory(p_directory_name...
3
answers
0
votes
1941
views
asked a year agolg...
Hello ,
I am looking for solution on deleting multiple files at a time from Oracle RDS DATA_PUMP_DIR.
I can see that more than 100 files present in one of my RDS DATA_PUMP_DIR and for cleanup activity...
1
answers
0
votes
3238
views
asked a year agolg...
Amazon RDS M4/R4 instances will enter End of Support for your Oracle databases from March 27, 2023.
We will replace all existing M4/R4 instances with better performing R5/M5 instances which will...
0
answers
0
votes
340
views
asked a year agolg...
Dear guys
I checked the document, it looks like it requires the downtime when we upgrade RDS Oracle.
Do we have any solutions to avoid the downtime when we upgrade DB?
1
answers
0
votes
543
views
asked a year agolg...
unable to access or list DATA_PUMP_DIR in RDS (Oracle-SE2):
DATA_PUMP_DIR is default oracle DIR and generally we use this to copy /move dumps of the DB, while list DATA_PUMP_DIR today I got this error...
1
answers
1
votes
982
views
asked a year agolg...
Considering the end of support is 2024, how will the migration process go?
I don't see an option to create v21 database for license included versions.
1
answers
0
votes
311
views
asked a year agolg...
I've noted that CPU/IO increaces in a frequency of 5 minutes, degrading performance.
It is in sync with de redo log switch, fixed on 300 seconds with the paramter ARCHIVE_LAG_TARGET.
It cannot be...
2
answers
0
votes
474
views
asked a year agolg...
Hello friends.
I have created a new RDS instance for my Oracle database.
It is an instance of homologation.
I backed up my production database by exporting datapump.
DBMS_DATAPUMP.open( operation =>...
2
answers
0
votes
684
views
asked a year agolg...
How do I automate the below RDS database tasks whenever a minor version upgrade is available?
1. Stop the DB instance
2. Take a snapshot
3. Upgrade the minor version
4. Start the database
2
answers
0
votes
446
views
asked a year agolg...
Hi,
I need to migrate and create bi-directional replication from on-prem Oracle to Oracle RDS.
I have used SCT for DMS migration assessment.
How do I start the migration using AWS DMS is the...
3
answers
0
votes
1070
views
asked 2 years agolg...