Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "End of TNS Data Channel" with Oracle Text problem

Re: "End of TNS Data Channel" with Oracle Text problem

From: <l.maestri_at_mimesi.com>
Date: Tue, 04 Feb 2003 13:43:21 GMT
Message-ID: <3e3fc197.19176384@news.inet.it>


On Tue, 04 Feb 2003 05:22:43 -0700, Ron Reidy <rereidy_at_indra.com> wrote:

>Did you check the instance alert log? What was the error number (i.e.
>ORA-nnnnn: <text>)?
>
>--
>Ron Reidy
>Oracle DBA
>
>l.maestri_at_mimesi.com wrote:
>> Hi everybody.
>>
>> I have a problem with a query using multiple instances of the
>> "contains" operator.
>> It's something like this: "select field1,field2 from table1 where
>> contains(fieldx,'something1',1)>0 and
>> contains(fieldx,'something2',2)>0"
>>
>> This query is executed from inside an EJB (WebSphere 3.5.4) through a
>> thin connection.
>> My Java code terminates with an exception on the executeQuery line:
>> "End of TNS Data Channel". This exception is dued to an Oracle crash
>> (core dump of Oracle 9i - 9.0.1.0.1 - ACCESS VIO).
>>
>> The same query with only ONE "contains" operator or executed through
>> an OCI connection runs without errors.
>>
>> The Oracle Text indexed field is a BLOB field.
>>
>> Any ideas?
>>
>> Thanks for your help.
>>
>>
>

The alert log (bdump directory) contains the following lines:

---Begin AlertLog
Tue Feb 04 14:33:10 2003
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Tue Feb 04 14:33:10 2003
found dead shared server 'S000', pid = (8, 249) Tue Feb 04 14:33:44 2003
found dead shared server 'S000', pid = (8, 250) ---End AlertLog

The core dump (cdump directory) is :

Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production Process Id: 0x00000784 Thread Id : 0x00000318 Time : Tue Feb 04 14:33:19
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

0x03ecca6c 01259d0a 00000024 00000000 00000013 00000000 _druodcur+7

0x03eccb2c 60b2fcaf 1b7eb580 2196abb0 2196ab6c 2196aa80 _drexrstart+30a
0x03eccb7c 60ad7004 03eccc04 00000012 1b7eb420 03eccbd4 _spefcpfa+3ef

0x03eccbc0 60a4002d 00000000 29e4a750 2da922c4 03eccc04 _spefmccallstd+224
0x03eccbe0 60a46da8 00000000 29e4a750 2da922c4 03eccc04 _pextproc+5d

0x03eccc70 60a46c94 1b87ce60 03ecce60 03eccd6c 00000000 _pgmcetc_execute_tru
0x03eccc94 60a18c79 2e2a8880 2e2a9c0c 1b986f14 1b87ce60 _pgmccc_call_c+b4
0x03eccd10 008fe8b7 03eccd6c 2e26b81c 1b986f14 1b87ce60 _pciccc_call_c+99
0x03ecce84 603b1bd7 0ce2b948 2e26b81c 1b986f14 1b87ce60 _kkxmcexe+187

0x03eccea8 00646246 03ecd270 2c2ca928 0ce2b7c0 2f26e068 _kgmexcb+27

0x03ecd178 008fc54f 2f26e068 00000020 2c2ca928 00000002 _rpiswu2+226

0x03ecd220 603b13b0 0ce2b948 00000020 2c2ca928 2c2ca8f8 _kkxmswu+af

0x03ecd2f8 603b1044 0ce2b948 00000001 03ecd40c 2e26b81c _kgmexwi+310

0x03ecd354 008cd24d 0ce20009 00000001 03ecd40c 290f9948 _kgmexec+534

0x03ecd434 008d2ff1 2e279a28 0000189c 2e279a28 0ce2b7c0 _evapls+2fd

0x03ecd518 009019d9 2e279a28 2c2cb404 2e27abec 2c2cb406 _evaopn2+551

0x03ecd5bc 00e8f5ec 2e279a28 000074ce 000000c0 03ecd60a _qximeop+1c9

0x03ecd600 010f7c4b 2e27abec 00000001 0ce2b7c0 2d973964 _qeroiStart+19c
0x03ecd634 010d846e 2e27ab9c 00000001 2e27b3c8 2d9738c4 _qersoStart+3eb
0x03ecd654 010d9242 2e27b3c8 00000001 0ce2b7c0 2d9735f0 _qerbtStart+2de
0x03ecd674 010d8487 2e27b394 00000001 2ab90d64 2e27b334 _qerboStart+52

0x03ecd694 010ec502 2e27b334 00000001 2e27b1fc 00000003 _qerbtStart+2f7
0x03ecd6c8 010db64d 1db20013 00000001 2321e74c 0ce2b7c0 _qertbStart+642
0x03ecd6f0 00fc0202 ffffb1fc 00fc0ed0 03ecd8b0 0000000a _qerpaFetch+12d
0x03ecd914 00fc5d03 00000089 00000005 03ecd96c 00000000 _opifch2+10d2

0x03ecdb08 00fc48d0 0000003e 00000022 03ecdb4c 03ecf048 _opiall0+d03

0x03ecdc00 00648369 00000047 0000000f 03ecf048 00000000 _opial7+150

0x03ecdd70 605352c6 00000047 0000000f 03ecf048 00000007 _opiodr+549

0x03ece1e0 0064974a 01e2faa4 00000047 03ecf048 00000000 _ttcpip+1066

0x03ecf1c0 00b6c934 00000000 00000000 014e76d0 0000003c _opitsk+74a

0x03ecf2a4 00648369 0000003c 00000004 03ecf450 02e7a75c _opiino+554

0x03ecf414 00647b38 0000003c 00000004 03ecf450 00000000 _opiodr+549

0x03ecfcfc 0041589c 00000032 00000000 00000000 0137602c _opirip+2b8

0x03ecfd88 0040920e 00000032 00000000 00000000 00000000 _opidrv+41c

0x03ecfda0 00401166 03ecfe24 00000032 00000000 00000000 _sou2o+1e

0x03ecfe38 004013f7 00000003 03ecff78 0324ec94 78016a60 _opimai+166

0x03ecffb4 77e8758a 051a0db8 0324ec94 78016a60 051a0db8 _BackgroundThreadSta
0x03ecffec 00000000 004012d0 051a0db8 00000000 00000000 0x77e8758a

These are the only files generated with the error .....

Thanks

        Lorenzo Received on Tue Feb 04 2003 - 07:43:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US