Re: session timeout in 10g

so I found the following in the alert log:

WARNING: inbound connection timed out (ORA-3136)

...not much of anything on metastink or google.

no profiles are set and the machine is on the same network.

any ideas on what could be causing this? ...or how to find out what is causing this? :)

On 8/30/05, Paul Drake <bdbafh_at_gmail.com> wrote:
>
> On 8/30/05, Chris Stephens <cstephens16_at_gmail.com> wrote:
>
> > I recently installed 10gR2 on red hat 3. i am getting disconnected through toad and isqlpus. i haven't determined the exact lenght of time this takes to occur yet.
> >
> > i looked in sqlnet.ora for a timeout setting but there is nothing there. is this default behavior? if so how do i change it?
> >
> > thanks,
> > chris
> >
>
> Chris,
>
> Unless your DBA has set profiles that limit connect time, this is most likely a networking issue. Even with a resource limit of connect_time, it would still just "snipe" the session, not kill it itself until another call is made.
>
> Is the oracle client on the same LAN as the oracle server - meaning, do you traverse a router or firewall where NAT/IP masquerading is involved?
>
> An easy way to tell is if a netstat (from the client desktop) returns a high port and an IP address different than that of the oracle server.
>
> You might consider enabling keep_alive settings in the oracle network configuration files.
> Metalink has various notes covering this, as well as the Networking guide available via OTN.
>
> As far as iSqlplus, I haven't a clue. Never used it. Knew that there was an exploit for itearly on, so I never installed it.
>
> hth.
>
> Paul
>
>
>
>
>
> --
> #/etc/init.d/init.cssd stop
> # f=ma, divide by 1, convert to moles.

--
http://www.freelists.org/webpage/oracle-l