OraFAQ Forum: Server Administration » ORA-03135: connection lost contact

Home » RDBMS Server » Server Administration » ORA-03135: connection lost contact (AIX 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03135: connection lost contact [message #478606]

Mon, 11 October 2010 05:14

mukeshkaushal
Messages: 4
Registered: October 2010
Location: Mumbai

Junior Member

Hi All

My application is using "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and Oracle 11g client v11.1.0.6.0.
My application server runs continuously and checks for new requests. But problem occurs when I do not send any request to my server for 40-45 minutes i.e. server is idle or doing nothing except checking new incoming requests for those 40-45 minutes. After that if I try to connect my server by sending some request, it shows following error message and my server crashes:

Message String: ORA-03135: connection lost contact
Process ID: 7586034
Session ID: 61

Thanks in advance.

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478609 is a reply to message #478606]

Mon, 11 October 2010 05:32

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As this is your very first message here, I don't know whether you just wanted to test how it works (and posted a "dummy" message), or do you really have a problem. Because, Test forum is not a place for asking "real" questions. Would you like it to be moved elsewhere?

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478612 is a reply to message #478609]

Mon, 11 October 2010 05:37

mukeshkaushal
Messages: 4
Registered: October 2010
Location: Mumbai

Junior Member

First of all thanks for reply.

Yes I am a newbie here and to ORACLE as well. Please let me know which one is the proper forum to post my problem mentioned in my first post.

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478615 is a reply to message #478612]

Mon, 11 October 2010 05:43

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says:
Quote:

ORA-03135: connection lost contact

Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.

Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478622 is a reply to message #478615]

Mon, 11 October 2010 05:54

mukeshkaushal
Messages: 4
Registered: October 2010
Location: Mumbai

Junior Member

Littlefoot,

I have also seen this description on many websites but in my case whats going wrong. My sqlnet.ora contains:

# sqlnet.ora Network Configuration File: /oracle/app/product/11.1.0.6.0client/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Now there is no timeout parameter. My application runs fine if there is a time gap of 30-40 minutes in two requests. If this gap increases then I got ORA-03135 error in application trace. So do you think that this time out variable can affect my application ? If yes then how can I set this value as it does not exist in my sqlnet.ora.

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478626 is a reply to message #478622]

Mon, 11 October 2010 06:01

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, I wouldn't know - I'm not a DBA. Hopefully, someone else will be able to provide assistance.

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478627 is a reply to message #478626]

Mon, 11 October 2010 06:04

mukeshkaushal
Messages: 4
Registered: October 2010
Location: Mumbai

Junior Member

Well thanks anyway. Let me know if this is the correct forum to post such problems ?

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478629 is a reply to message #478627]

Mon, 11 October 2010 06:06

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes, people will see it and answer your question. Just be patient. There's no need to post it again on another place (not on OraFAQ Forum, that is).

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478637 is a reply to message #478629]

Mon, 11 October 2010 06:51

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

@ mukesh ....
1) Do you have profile configured for the user?
2) can you post you listener.log file contents which may give some clues....
3) at server side what are your sqlnet.ora file parameters configured?
4) Did you configured your server properly.........

sriram

Report message to a moderator

Re: ORA-03135: connection lost contact [message #478647 is a reply to message #478637]

Mon, 11 October 2010 07:22

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://www.oracle-base.com/forums/viewtopic.php?f=1&p=19139

Report message to a moderator

Previous Topic:	Issues with component--11.2.0.2 upgrade
Next Topic:	CREATE ONE MORE DATABASE ON SAME SERVER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 17:33:21 CDT 2024