Informatica job on Azure VM failing because of connection time out

Question

Hi, We have an Informatica powercenter app hosted on an Azure VM .There is daily nightly batch of Informatic jobs running on the server which connects to different databases hosted on different Azure VMs in same and different subscriptions.. Some days some of the jobs fails when it tries to write data to the database hosted in different subscription. In Informatica session logs the message is the Oracle error "ORA-03113: end-of-file on communication channel", but the process waits around 15 minutes after starting the WRITER operation before existing with the above error. We have checked the network logs and activity logs of Azure VMs and nothing suspicious there. Please throw some light into this.

Answer 1

Hello Liss

Welcome to Microsoft Q&A Platform, thanks for posting your query here.

The "ORA-03113: end-of-file on communication channel" error message indicates that the connection between the client and server process was broken unexpectedly.

Try to check below and see if that helps: -It's possible that the network bandwidth is insufficient to handle the volume of data being transferred. Check the network bandwidth usage during the time when the jobs are running and see if it is reaching the maximum capacity.

-Check the database configuration settings to ensure that the maximum number of connections is not exceeded.

-Check the Oracle database logs to see if there are any errors or warnings related to the connection issue.

-The issue could be related to the performance of the database itself. Check the performance of the database and see if there are any bottlenecks or performance issues that could be causing the problem.

-Ensure that the database is up and running, and the network connection between the Informatica server and the database is stable. You can try to ping the database server from the Informatica server to ensure network connectivity. You can also try to connect to the database from the Informatica server using SQL*Plus or any other database client to check if you are able to connect and perform basic operations.

Hope this helps.

If the suggested response helped you resolve your issue, please 'Accept as answer', so that it can help others in the community looking for help on similar topics.