Re: ORA-3136 Inbound Connection Time out
Date: Wed, 23 Feb 2011 07:58:33 -0800
Message-ID: <AANLkTike+3DO31Nz_UJYH8mmTx-jO-tZJODORFRVDt_7_at_mail.gmail.com>
I have seen this happen on our 11.1.0.7 databases that supports ebiz. I tried playing with the sqlnet.ora parameters that control timeout but you still get these messages. What I noticed is , the volume of these messages increases when there are lot of connections from the application server (like lot of jdbc connections in case of application patches - big patches) - like 60 jdbc connections at the same time (almost) trying to spawn 60 processes. I think the connection fails for the first job (during apps patching) but gets it in the next try and was really not harmful.
- kumar
On Wed, Feb 23, 2011 at 6:24 AM, KRISHNA MOORTHY <krish33moorthy_at_gmail.com>wrote:
> Hi
>
> We are getting frequently the following error in alert log files of
> production server.It was running fine for last 3 months.There is no
> changes in listener configuration.
>
> WARNING: inbound connection timed out (ORA-3136)
>
> In Sqlnet.log file the following error is getting displayed.
>
> TNS-12535: TNS:operation timed out
> nt main err code: 0
> nt secondary err code: 0
> nt secondary err code: 0
> nt OS err code: 0
> nt OS err code: 0
> ns secondary err code: 12606
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
> TNS-12535: TNS:operation timed out
> ns secondary err code: 12606
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
> TNS-12535: TNS:operation timed out
> ns secondary err code: 12606
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
>
> When i searched on the net,they are telling that it might be an network
> issue.But when i asked the network team , they said there is no firewall
> /port block issues.Please help me to resolve the issues.
>
> Regards
> Krishna
> 9585354917
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 23 2011 - 09:58:33 CST