Symfony Oracle DB Connection Lost or network error – ORA-03113

After searching for days i hope that someone here can help me.

I’ve a dockerfile for php with nginx, oracle client and supervisord. This image is based on “php:7.4-fpm” and “oracle-instantclient19.5”.

When i try to start a long running sql script (example: “BEGIN sys.DBMS_LOCK.sleep(600); END;”) through a symfony command, then i’ll get after ~300 seconds an ORA-03113 which points me to some kind of timeout or network error.

I’ve install sqlplus and have the same problem.

Things i’ve tried:

  • php max_execution_time is set to 1800
  • db admins cannot see a problem
  • have searched for symfony timeouts and debian timeouts but could not find anything

Can someone point me to a solution? Thanks!

Source: Symfony Questions

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *