Oracle Database Discussions

Hi ALl,

I am having one problem. I have two servers one application server and second database server. There is a firewall in betwene these two servers even though both are at same network. Each time in between 10 to 40 minutes oracle connection is breaking with an error ORA-03113 end-of-file on communication channel. Our network team has increased timeout at firewall and I have put SQLNET.EXPIRE_TIME to 10 value in the sqlnet.net file at both server and client machines. Since then connection is not broken.

Before that our second database server is connected with above database server without any firewall. DB1 server is fine and stable in connectivity with DB2 server as there is no firewall.

What would you suggest about using SQLNET.EXPIRE_TIME parameter in the sqlnet.ora file; what are the impacts of this and what exactly this parameter does while keeping alive connection between client and server of the database.

We are using Oracle 9i Release 9.2.0.1.0 on Windows 2003 OS.

Thanks