I was ok making suggestions within Oracle. Now I'm going to step outside
my knowledge and offer a suggestion about networking. When you say your
Oracle server is "remote", is it possible that the firewall is dropping
the connection after 30 minutes of inactivity (no "keep alive" packets
received)? I'm not a network person ... so if anyone has a better
explanation of what the firewall does, please jump in here.
G.B. wrote:
> 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 - 11:51:32 CST
