Questions tagged with Oracle Migrations
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
cant find automatic statistics collection ow AWS RDS Oracle.
Hello Currently working on Oracle19c I cant find either the automatic table data statistics enable both ways - DBA_AUTOTASK_CLIENT auto optimizer_stats_collection is set to disabled - DBA_SCHEDULED_JOBS there is no entry for GATHER_STATISTICS_JOB Neither i can find a concise documentation in the guides for RDS standard tasks for such important recurrent task Is there a reason for none of them is activated? Does the statistics collection obey the maintenance windows set in the AWS console and not in Oracle schedulers? Thanks Alexandre
Read Oracle CDC without timestamp information
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 the tables). Is there a better or different way to capture the CDC from on-prem Oracle DB (Obviously we cannot change anything/Schema on source side i.e. Oracle) ?
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle. We see SCT is useful to move Source Schema (Eg: Oracle ) to Target Schema DB (Eg: Aurora Postgres) and other limited DB combinations. Now requirement is to migrate from On-premise Oracle to MS SQL Server in AWS Cloud. Please let me know if anyone has worked on this task.
DMS for Replicating Data in Oracle Application Container
Does AWS DMS support using Oracle Application Container Database ( Application root and application PDB ) as a source ? If so, are there differences in the way replication setup is configured to replicate data from application root ( common data) and data from application container PDB ?
DMS CDC task (Oracle->S3, binary reader) "hangs" without failing, misses changes
We're running DMS on an on-prem Oracle database, with a destination to S3 (which we then load to Snowflake outside of DMS). We're finding the replication task will, seemingly at random times after working fine for a few hours, simply stop processing Oracle log files and so will report no source CDC changes, and will report zero latency (whereas the source latency generally fluctuates between 1 and 5s). Cloudwatch logs continue to show the heartbeat message (but few other messages do): ```[SORTER ]I: Task is running (sorter.c:736)``` After turning on DEBUG logging, we're seeing the following messages that appear to be related to this problem: ``` 2021-12-27T16:39:50:430405 [TASK_MANAGER ]D: There are 284 swap files of total size 1 Mb. Left to process 5 of size 1 Mb (replicationtask_cmd.c:1639) ``` And this error, which seemingly pops up much more frequently, so including it here, but not sure if it's related: ``` 2021-12-27T16:43:01:094411 [DATA_STRUCTURE ]E: SQLite general error. Code <19>, Message <UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage>.  (at_sqlite.c:475) ``` We're running a dms.r5.large, and can't otherwise find any patterns about when/why the issue appears (again, without any warnings, other errors, etc.). Restarting the task (stopping the task takes an unusually long time) fixes the problem and causes the task to "catch up" to where the updates stalled. Our current workaround is to set an alert looking for too-long a time of zero latency, and then having a lambda function stop and restart the task.