Re: ORA-3136 Inbound Connection Time out
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: krish33moorthy@xxxxxxxxx
- Date: Wed, 23 Feb 2011 07:58:33 -0800
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@xxxxxxxxx>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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
