ORA-03113 error
434046Dec 3 2004 — edited Jan 20 2005I have an asp.net application using odp.net which is accessing an Oracle 9i database running on Unix across a LAN. The application was working fine on a development machine but when I deployed onto live I start to get intermittent errors with the message
"ORA-03113: end-of-file on communication channel" The error normally occurs the first time a page is accessed but if I refresh my browser the same page loads ok. The main difference between the development machine and the live machine is that the development machine is a lower specification and Windows 2000 whereas the development machine is a higher specification Windows 2003 machine. I did get this error occasionally on the development machine but much more frequently on the live machine. My guess is that it is maybe some sort of failure in the network link when the application first initialises. I thought about changing the connection timeout in the database connection string but it is already set to 15s and the error seems to occur in only 3-4s. Any ideas?