Browse through the questions and answers listed below or filter and sort to narrow down your results.
Is it possible to give all privileges of a specific user to a specific user in aws rds oracle?
There are users who want to keep accessing tables created by a specific user in the future. So is it possible to give full access to a specific user's table to another specific user? And can you give the user admin privileges?
When will APEX 21.2 or 22.1 be available in RDS Oracle?
When will APEX 21.2 or 22.1 be available in RDS Oracle? Are there now permanent hinderances to Apex on RDS Oracle that I should be looking at alternatives for Apex development? Is it a specific feature that is problematic? I understand the strengths of RDS Oracle, but if one of the weaknesses is now going to be that Apex versioning is so far behind then I will have to make other accommodations. Previously, for example, Apex 21.1 was available in RDS 5 months after it was available for download from Oracle. It's now 10 months since Apex 21.2 has been released and no word on when this will be available. Thank you,
Oracle RDS GRANT ISSUE for java.protocol.handler.pkgs
Error while when executing exec dbms_java.grant_permission('myschema','SYS:java.util.PropertyPermission','java.protocol.handler.pkgs','write'); Error Details : ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException: policy table update SYS:java.util.PropertyPermission, java.protocol.handler.pkgs ORA-06512: at "SYS.DBMS_JAVA", line 705 ORA-06512: at line 1 29532. 00000 - "Java call terminated by uncaught Java exception: %s" *Cause: A Java exception or error was signaled and could not be resolved by the Java code.
Requesting AWS to add a RDS (Oracle) Time zone which is missing
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 different from the rest of the region. It is currently not available in AWS as we checked here [https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.Timezone.html#Appendix.Oracle.Options.Timezone.Zones] Using other nearby timezones or central or eastern timezones is not feasible as DST is observed there. There are some timezones e.g. Bogota and Lima which are the same as Jamaica and could be an option to use but there is a risk due to the following ; 1. The countries might all of a sudden start to observe DST. Although they have not done it in the past 15 to 20 years. 2. We cannot change the timezone in RDS more than once. One Workaround is to use America/Lima or Bogota timezone which is exactly the same as Jamaica, but in the worst case, there is a chance that they start observing DST someday. (may be next month or after 10 years). Please suggest, how we can request AWS to add America/Jamaica which has the below properties. ``` Time Zone: America/Jamaica Current Date and Time in America/Jamaica: Thu 11-Aug-2022 04:41 P.M. Country: Jamaica Daylight Saving Time (DST) in effect? : No Most Recent DST Transition: DST ended on Sun 30-Oct-1983 at 02:00:00 A.M. when local clocks were set backward 1 hour Next Scheduled DST Transition: There are no future Daylight Saving Time rules for this time zone ```
Oracle RDS UTL_FILE.FREMOVE cannot open file
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 UTL_FILE.FREMOVE('DATA_PUMP_DIR','test.dmp'); END; ERROR at line 1: ORA-29283: invalid file operation: cannot open file  ORA-06512: at "SYS.UTL_FILE", line 251 ORA-06512: at "SYS.UTL_FILE", line 1230 ORA-06512: at line 1 The dump file was copied to the DATA_PUMP_DIR using rdsadmin.rdsadmin_s3_tasks.download_from_s3 package with p_decompression_format => 'GZIP' parameter. The extracted dump file is readable by the Data Pump utilities but cannot be deleted by UTL_FILE.FREMOVE. This problem does not occur when using an uncompressed dump file in the S3 bucket. e.g. SELECT rdsadmin.rdsadmin_s3_tasks.download_from_s3( p_bucket_name => 'oracle-rds-s3-test', p_s3_prefix => 'test.dmp.gz', p_directory_name => 'DATA_PUMP_DIR', p_decompression_format => 'GZIP') AS TASK_ID FROM DUAL; Engine version: Oracle Standard Edition Two 18.104.22.168.ru-2022-01.rur-2022-01.r1 Any help is appreciated. Thank you.
Data Guard - primary on-premise / standby at RDS
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 the **primay instance on-premise** and the **standby instance on AWS Cloud**. Considerations: 1- Using EC2 as my standby - I´m gonna have to license standby vCPUs on AWS (BYOL, Enterprise Edition) , according to Oracle policies (https://www.oracle.com/assets/cloud-licensing-070579.pdf). After this, i install Linux and Oracle and configure Data Guard between the two instances, right? 2- Using RDS as my standby- Is it possible ?? I mean, i know i´m gonna have to license my RDS instance as well (BYOL, Enterprise Edidion), but how does this work? AWS team would help me configuring the standby/RDS?
Oracle materialized view replication to postgres using DMS CDC
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 migration? If Yes please share the details/document.
Requirement for continuous_mine functionality for Oracle 19 DMS as source
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 process in the same way as debezium does, handling the log switching task as the same way as debezium does https://franckpachot.medium.com/ideas-for-event-sourcing-in-oracle-d4e016e90af6