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. We have come across a situation where we need to use the local timezone in the RDS Oracle database. We need to set it to Jamaica Timezone which is America/Jamaica.
Jamaica's time zone is...
1
answers
0
votes
333
views
asked 2 years agolg...
How can I remove files from the Oracle RDS DATA_PUMP_DIR that fail when using the UTL_FILE.FREMOVE package?
e.g.
SQL> EXEC UTL_FILE.FREMOVE('DATA_PUMP_DIR','test.dmp');
BEGIN...
4
answers
0
votes
859
views
asked 2 years agolg...
Hello.
At this moment, i have an Oracle Database on-premisse (licensed; Enterprise Edition) and i´m planning a Disaster Recovery strategy on cloud using Data Guard.
In this scenario, i´m gonna keep...
1
answers
0
votes
1593
views
asked 2 years agolg...
I am migrating data from Oracle materialized view to PostgreSQL using DMS CDC. Initial load completed successfully. I do not see the changes are replicating. Is any one has performed this type of...
2
answers
0
votes
1481
views
asked 2 years agolg...
Hello
Continuous_mine functionality from logminer is getting desupported. Does DMS requires this to continuous mine operation in Oracle 19 RDS servers?
Im hoping it can handle the log switching...
3
answers
0
votes
557
views
asked 2 years agolg...
I want to increase the RDS Oracle instance limit (currently 10) . But there is only a option to increase the total number of RDS instance limit (currently 40). Is there a way to specifically increase...
3
answers
1
votes
891
views
asked 2 years agolg...
Error from Glue joblg...
I got the below error from glue job
Jul 19, 2022, 9:45:00 PM Pending execution
2022-07-20 01:45:13,382 main WARN JNDI lookup class is not available because this JRE does not support JNDI. JNDI string...
1
answers
0
votes
332
views
asked 2 years agolg...
Hello,
We are using AWS DMS and we run into an issue.
We are using DMS engine version 3.4.6 with Oracle 11.2.0.4 as source and PostgreSQL 13.3 destination.
At some point during the on-going...
1
answers
0
votes
695
views
asked 2 years agolg...
Good Day Everyone,
We are trying to capture CDC from the On-Prem Oracle Database using AWS DMS and using Oracle REDO logs for capturing the changed data (as there is no timestamp field available in...
1
answers
0
votes
369
views
asked 2 years agolg...
I have created an RDS for Oracle databases solely for personal learning purposes. No any intention for production/profit/business purposes, and I am the only person who has access to the...
1
answers
0
votes
1178
views
asked 2 years agolg...
Deploy OEM13c on AWSlg...
Hi Everyone,
We are considering in moving our on-premises OEM environment to AWS. We would like to find out if it is possible to have our OMS running on an EC2 instance and our OEM Repository (OMR)...
1
answers
0
votes
444
views
asked 2 years agolg...
In an RDS Oracle 19c database, we try to give a user permissions to sys.dbms_xa with the admin user and it tells us "insufficient privileges"
Command "GRANT EXECUTE ON SYS.DBMS_XA TO USER"
Can you...
1
answers
0
votes
394
views
asked 2 years agolg...