Home » RDBMS Server » Networking and Gateways » weird problem of ORA-03135: connection lost contact (Oracle 11g 11.1.0.6 (windows 2003 SBS Standard version 64-bit))
weird problem of ORA-03135: connection lost contact [message #415866] Wed, 29 July 2009 10:22 Go to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
I encounter a weird problem of ORA-03135: connection lost contact:

My RDBMS is Oracle 11g 11.1.0.6 on a 64-bit windows 2003 SBS standard version. The server is remotely administered via Checkpoint VPN and RDP. My desktop is winXP 32-bit SP3.

Create table testX (abstracts_id number primary key, testX clob, testS nvarchar2(2000));

From my desktop:
SQL> insert into testX (abstracts_id, testS) values (1,'Conexions');
insert into testX (abstracts_id, testS) values (1, 'Conexions')
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 3364
Session ID: 101 Serial number: 20286

The same insert statement succeeds if I run it on the server locally.

If the inserted string doesn't contain the word "Conexion", then there is no problem.

SQL> insert into testX (abstracts_id, testS) values (11,'Conecxions');

1 row created.


Furthermore, if the clob column (testX) contains the magic word "Conexion", a select statement will fail.

From my desktop:

SQL> select testX from testX;
ERROR:
ORA-03135: connection lost contact
Process ID: 4016
Session ID: 96 Serial number: 22190

If run it from the server locally,

SQL> select testX from testX;

TESTX
------------------------------------------

Conexion

I tried the same situation against my old server (9i on windows2000 enterprise server), there was no problem whatever.





Re: weird problem of ORA-03135: connection lost contact [message #415873 is a reply to message #415866] Wed, 29 July 2009 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Regards
Michel
Re: weird problem of ORA-03135: connection lost contact [message #415899 is a reply to message #415873] Wed, 29 July 2009 12:56 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
thanks for your "googled" answer.

I wish to know why it only happened to the magic word "Conexion" and how to debug it. Please be specific.
Re: weird problem of ORA-03135: connection lost contact [message #415900 is a reply to message #415899] Wed, 29 July 2009 13:25 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, what use would specific things be if you don't even check the standard things mentioned in the Oracle error description.

You also never mentioned your client version.
Re: weird problem of ORA-03135: connection lost contact [message #415901 is a reply to message #415899] Wed, 29 July 2009 13:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Compatibility matrices and differences between editions

Regards
Michel
Re: weird problem of ORA-03135: connection lost contact [message #415902 is a reply to message #415866] Wed, 29 July 2009 13:34 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I wish to know why it only happened to the magic word "Conexion" and how to debug it.
Yes, what you describe is unusual.
However, 1 data point does not make a line.
Does any other string generate the error? Provide proof.
Does the error occur on any other client system? Provide proof.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: weird problem of ORA-03135: connection lost contact [message #415907 is a reply to message #415902] Wed, 29 July 2009 14:15 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post your SQLNET.ORA details.
Re: weird problem of ORA-03135: connection lost contact [message #415912 is a reply to message #415907] Wed, 29 July 2009 14:36 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
gentlebabu wrote on Wed, 29 July 2009 14:15

Post your SQLNET.ORA details.



# sqlnet.ora Network Configuration File: D:\oracle\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)
Re: weird problem of ORA-03135: connection lost contact [message #415917 is a reply to message #415902] Wed, 29 July 2009 14:47 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
BlackSwan wrote on Wed, 29 July 2009 13:34
>I wish to know why it only happened to the magic word "Conexion" and how to debug it.
Yes, what you describe is unusual.
However, 1 data point does not make a line.
Does any other string generate the error? Provide proof.
Does the error occur on any other client system? Provide proof.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


> Does any other string generate the error? Provide proof.
Yes or no. Depends on whether the string inserted contains "Conexion" or not.

SQL> insert into testX (abstracts_id, testS) values (12,'I like Conexions');
insert into testX (abstracts_id, testS) values (12,'I like Conexions')
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 3360
Session ID: 129 Serial number: 40030

SQL> insert into testX (abstracts_id, testS) values (12,'I like Cone xions'); <-- please notice the space inserted

1 row created.


> Does the error occur on any other client system? Provide proof.
My coworker got the same result from his Vista laptop. Sorry no photo to show you.

Re: weird problem of ORA-03135: connection lost contact [message #415920 is a reply to message #415917] Wed, 29 July 2009 15:01 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Is that the client or server SQLNET.ORA?

If it's the server one we still don't know the client version. And even if it's the client one we still don't know the client version down to 4 decimals.

Also, "SQLNET.ORA details" means INCLUDING the configured TNSNAMES.

[Updated on: Wed, 29 July 2009 15:02]

Report message to a moderator

Re: weird problem of ORA-03135: connection lost contact [message #415921 is a reply to message #415920] Wed, 29 July 2009 15:06 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The easiest thing would probably be for you to post a COMPLETE SQL*Plus command line session, so that we see the client AND server banners.
Re: weird problem of ORA-03135: connection lost contact [message #415924 is a reply to message #415921] Wed, 29 July 2009 15:18 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
ThomasG wrote on Wed, 29 July 2009 15:06
The easiest thing would probably be for you to post a COMPLETE SQL*Plus command line session, so that we see the client AND server banners.


C:\app\oracle\product\11.1.0\db_1\BIN>sqlplus tagg1/******@ogam-ora02

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 29 16:09:03 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


The password was masked.
Re: weird problem of ORA-03135: connection lost contact [message #415925 is a reply to message #415924] Wed, 29 July 2009 15:41 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
So you have a SQLNET.ORA in D:\oracle\product

And an sqlplus in C:\app\oracle\product

Which is the client and which is the server?
Re: weird problem of ORA-03135: connection lost contact [message #415928 is a reply to message #415925] Wed, 29 July 2009 16:04 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
ThomasG wrote on Wed, 29 July 2009 15:41
So you have a SQLNET.ORA in D:\oracle\product

And an sqlplus in C:\app\oracle\product

Which is the client and which is the server?


The sqlnet.ora I gave before is a server side one.

The sqlplus is in C:\app\oracle\product\11.1.0\db_1\BIN folder on my desktop.
Re: weird problem of ORA-03135: connection lost contact [message #415930 is a reply to message #415866] Wed, 29 July 2009 16:14 Go to previous messageGo to next message
cnnbull
Messages: 7
Registered: May 2007
Junior Member
sorry, guys, I did another test against my old Oracle9i server. The same insertion problem happened.

C:\app\oracle\product\11.1.0\db_1\BIN>sqlplus tagg1/****@hhstagg1

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 29 16:53:28 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> insert into testX (abstracts_id,testX, testS) values (1,'I like Conexions', 'Conexions');
insert into testX (abstracts_id,testX, testS) values (1,'I like Conexions', 'Conexions')
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 21 Serial number: 9521


SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

Then I run the insert statement on the backend. It succeeded.
So I run a Select statement on my desktop.


C:\app\oracle\product\11.1.0\db_1\BIN>sqlplus tagg1/****@hhstagg1

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 29 16:53:51 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL> set long 2000
SQL> set pagesize 20
SQL> col testX format a25
SQL> col testS format a25
SQL> select * from testX;

ABSTRACTS_ID TESTX TESTS
------------ ------------------------- -------------------------
11 I like Conexion Conexion

SQL>

The difference between 9i and 11g backends is that the Select statement doesn't work against the 11g backend.

C:\app\oracle\product\11.1.0\db_1\BIN>sqlplus tagg1/****@ogam-ora02

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 29 16:57:20 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from testX;
ERROR:
ORA-03135: connection lost contact
Process ID: 708
Session ID: 105 Serial number: 56387



SQL>

So, I guess there is something weird happening in my VPN connection, which is beyond the scope of this forum. Sorry for the confusion and thanks for your help.
Re: weird problem of ORA-03135: connection lost contact [message #415932 is a reply to message #415930] Wed, 29 July 2009 16:26 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Ah, OK. then it's definitely a network problem. The versions you have should work. Until now I was suspecting a X64 bug that some specific versions have, but when it also happens with the 9.X connection that can't be it.

While it might be beyond the scope of the forum here, I once had a similar problem with a WLAN. There it was a problem with at too big MTU that fragmented the packages.
Previous Topic: ORA-12170: TNS: Connect timeout occurred
Next Topic: Interchainging the TNS NAMES
Goto Forum:
  


Current Time: Thu Dec 08 16:40:33 CST 2016

Total time taken to generate the page: 0.08408 seconds