| weird problem of ORA-03135: connection lost contact [message #415866] |
Wed, 29 July 2009 10:22  |
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 #415912 is a reply to message #415907] |
Wed, 29 July 2009 14:36  |
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 |
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 #415924 is a reply to message #415921] |
Wed, 29 July 2009 15:18 |
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 #415928 is a reply to message #415925] |
Wed, 29 July 2009 16:04 |
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 |
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 |
ThomasG
Messages: 3211
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
