Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a task to replicate data from Oracle to SQL server (1 table now, for testing). I get the below error. Can someone plz help me resolve this error.
Stream component 'st_0_Oracle' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_Oracle'.
Good day!
If using Oracle as a source, you need to enable supplemental logging:
SELECT supplemental_log_data_min FROM v$database;
The returned result should be YES or IMPLICIT.
Enable supplemental logging by executing the following query:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
Please refer to the Replicat eUser Guide for a complete steps on Setting up supplemental logging
Thanks,
Lyka
Good day!
If using Oracle as a source, you need to enable supplemental logging:
SELECT supplemental_log_data_min FROM v$database;
The returned result should be YES or IMPLICIT.
Enable supplemental logging by executing the following query:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
Please refer to the Replicat eUser Guide for a complete steps on Setting up supplemental logging
Thanks,
Lyka
Thanks @lyka . I got rid of the error for supplemental logging. Can you confirm if Archivelog too must be enabled? coz i get that as a warning.
I am also still not able to get through the task execution because of the following error.
Hello,
You need to specify in the oracle source endpoint in "Archived redo logs destination ID:" . If you are using more than 1 desyination id, then you define it in "Alternate archived redo logs destination ID:" (starting Replicate 7) or add an internal parameter called additionalArchivedLogDestId and set the value
Thanks,
Lyka
Thank you @lyka . i set up both the logs as per your instructions and my tasks are executing fine.