Home » RDBMS Server » Networking and Gateways » "ORA-03135: connection lost contact" when connect from same machine
"ORA-03135: connection lost contact" when connect from same machine [message #221276] Mon, 26 February 2007 02:43 Go to next message
thaidong
Messages: 2
Registered: February 2007
Junior Member
Hi all,

I have installed Oracle 10g(10.2.0.1.0) on AIX 5.3 machine and everything looks good.Until last monday, I don't know what happen.
Now we have an error "ORA-03135: connection lost contact" everytime I try to connect database from same machine(by using sqlplus or by jdbc). By command line , we can connect and select. But when we leave for a minute(1 minute), and select again .The result are folowing;


SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-03135: connection lost contact

First, we think because of listener or tnsnames configuration.
But we can use tnsnames to connect to other machine and from other machine can connect and using database on this machine without problem.

Please help me to find what can be posible to solve this problem.


thanks for any suggestion.
Thaidong.

Report message to a moderator

Re: "ORA-03135: connection lost contact" when connect from same machine [message #221328 is a reply to message #221276] Mon, 26 February 2007 05:54 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
Check the timeout parameters in sqlnet.ora.

Report message to a moderator

Re: "ORA-03135: connection lost contact" when connect from same machine [message #221458 is a reply to message #221276] Mon, 26 February 2007 22:01 Go to previous message
thaidong
Messages: 2
Registered: February 2007
Junior Member
Thanks tahpush for your help.

Now I add this parameter in sqlnet.ora


sqlnet.expire_time = 1


Connection doesn't lost.But I will try to find out what happen with us? We leave this parameter as default at the first time we installed. We don't have any problem until last monday.


Thanks again for recommendation.
Thaidong.

Report message to a moderator

Previous Topic: RE: ORA-03106: fatal two-task communication protocol error
Next Topic: ORA-12541: TNS:no listener oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 19:01:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.