Re: Problem for experts: disconnection to server

sqlnet.ora of my PC, in directory $ORACLE_HOME\NET80\ADMIN is: TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE) names.directory_path = (TNSNAMES, HOSTNAME) names.default_domain = world
name.default_zone = world
automatic_ipc = off

There isn't a SQLNET.EXPIRE_TIME parameter... Bye, Gabriele.

Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<qntE9.51$Ln5.6678698_at_newssvr21.news.prodigy.com>...
> G.B. wrote:
> > After about 30 minutes, application (Centura, Microsoft Query, SQL
> > Plus...) linked to Oracle Server 8.1.7 (on AIX) in remote lan, get
> > down with error ORA-03114.
> > Then I close those application and restart again and it's OK.
> > So, if I go away from PC for 30 minutes, when I return on PC, I must
> > restart application previously opened (because that error ORA-03114).
> > I have a lan splitted in 2 (172.30.x.y and 172.19.x.y), with between a
> > firewall.
> > But this isn't the problem: in fact, application linked to another
> > server (SQL Server 7) are OK.
> > Moreover, If I use application in the same LAN of server, application
> > never go down with this error.
> > It seems that application linked to remote Oracle Server, after about
> > 30 minutes go down.
> > Is there anyone that has solve that problem?
> > Thank you.
> > Gabriele.
> Don't know if this is the problem, but...
>
> You can set a "dead connection" timeout in Oracle (not enabled by
> default, but might be set on your system). Check your sqlnet.ora
> (default in $ORACLE_HOME/network/admin) for a SQLNET.EXPIRE_TIME parameter.
Received on Tue Nov 26 2002 - 18:43:16 CET