none
Ora 03113 error while copying records from azure sql database to Oracle

    Question

  • While executing the pipeline that copies data from Azure SQL database and Oracle, i am getting the below error.

    Copy activity encountered a user error: Integration Runtime (Self-hosted) Node Name=EC2AMAZ-7BRBODH,ErrorCode=UserErrorFailedOracleDatabaseOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Operation failed in Oracle Database with the following error: 'ORA-03113: end-of-file on communication channel Process ID: 16819 Session ID: 1362 Serial number: 12747'.,Source=,''Type=Oracle.DataAccess.Client.OracleException,Message=ORA-03113: end-of-file on communication channel Process ID: 16819 Session ID: 1362 Serial number: 12747,Source=Oracle Data Provider for .NET,'.

    Can someone help me on this?

    Sunday, April 29, 2018 5:10 AM

All replies

  • This seems to be your oracle server problem. Please take a look at this page. It seems like it wasn't able to connect to the oracle server, please make sure if your oracle server is up and running

    -------------------------------------------------------------------------------------------------------

    Please "Mark it as answer" if you find the answer useful.


    Wednesday, May 2, 2018 7:53 PM
    Moderator