Error: ORA-03113: end-of-file on communication channel

  • 26Views
  • Last Post 3 weeks ago
0
votes
Celine Bou Issa posted this 3 weeks ago

Dear, 

I am getting an error: ORA-03113: end-of-file on communication channel

Below are the IP’s that we have set as source.

13.86.253.112

40.118.246.204

52.190.252.0

0
votes
Serhii Muzyka posted this 3 weeks ago

Hi,

 

Thank you for contacting Skyvia Customer Support.

 

Yes, those are IPs that Skyvia uses to connect to your server.

After closer look at your package, we see that you are also getting ORA-12170: TNS:Connect timeout occurred error in your Oracle connection. The error might be caused by a small timeout limit in your connection.

Increase the "Command Timeout"/"Connection Timeout" values for your Oracle connection. For this, switch to the Connections page and find your Oracle connection.

Then click Edit, open Advanced Settings, and then set bigger values for both parameters or set 0 to have it without timeout.

Test your connection again by clicking “Test Connection” button. 

If the situation repeats, please follow this topic to see possible reasons and how to fix this error: https://www.tekstream.com/resource-center/ora-12170-tns-connect-timeout-occurred/#:~:text=There%20are%20several%20possible%20causes,invalid%2C%20among%20other%20possible%20causes.

Regarding ORA-03113: end-of-file on communication channel, you can find more information and advises how to fix it here: https://www.tekstream.com/resource-center/ora-03113-end-of-file-on-communication-channel/#:~:text=The%20source%20of%20an%20ORA,is%20similar%20to%20a%20timeout.

 

Should you have other questions, don't hesitate to reach out.

 

Best regards,

Serhii

Technical Support Engineer

Close