ORA-03106: fatal two-task communication protocol e

[Former Member]

Hi Experts

I am upgrading my system to Ehp3. When i am doing the upgrade i am getting a error

SQL error 3106 accessing T100S: ORA-03106: fatal two-task communication protocol

-

---

error----

---

Log File:
MEL-SRV-SAP3\sapmnt\trans\log\SAPI-603DTINSAPAPPL.RID

Start import R3TRTABUT100S ...

1 entry for T100S updated (8A 014).

1 entry for T100S updated (8A 015).

1 entry for T100S updated (8B 526).

1 entry for T100S updated (AA 816).

1 entry for T100S updated (FAGL_ORG_UNITS 011).

1 entry for T100S updated (FF 785).

1 entry for T100S updated (FF 788).

1 entry for T100S updated (FIPAY_GTS 001).

1 entry for T100S updated (FIPAY_GTS 002).

1 entry for T100S updated (FIPAY_GTS 003).

1 entry for T100S updated (GA 572).

[dev trc ,00000] Sun May 10 14:34:29 2009 16918558 17.094935

[dev trc ,00000] OCI-call failed with -1=OCI_ERROR 22 17.094957

[dev trc ,00000] SQL error 3106: 'ORA-03106: fatal two-task communication protocol error'

30 17.094987

[dbsloci. ,00000] *** ERROR => Error 3106 in stmt_fetch() from oci_execute_stmt(), orpc=1

46 17.095033

[dbsloci. ,00000] *** ERROR => ORA-3106 occurred when executing SQL stmt (parse error offset=0)

32 17.095065

[dev trc ,00000] sc_p=0000000000297990,no=96,idc_p=0000000000000000,con=0,act=1,slen=137,smax=256,#vars=2,stmt=0000000006662F

43 17.095108

[dev trc ,00000] SELECT /*+ FIRST_ROWS (1) */ TABNAME , VARKEY , DATALN , VARDATA FROM ATAB WHERE TABNAME\

30 17.095138

[dev trc ,00000] = :A0 AND VARKEY = :A1 FOR UPDATE; 16 17.095154

[dev trc ,00000] SELECT /*+ FIRST_ROWS (1) */ TABNAME , VARKEY , DATALN , VARDATA FROM ATAB WHERE TABNAME\

29 17.095424

[dev trc ,00000] = :A0 AND VARKEY = :A1 FOR UPDATE; 16 17.095440

[dbtran ,07512] ***LOG BY4=>sql error 3106 performing SEL on table ATAB [dbtran#11 @ 7512]

5833 17.101273

[dbtran ,07512] ***LOG BY0=>ORA-03106: fatal two-task communication protocol error [dbtran#11 @ 7512]

33 17.101306

[dev trc ,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' 39 17.101345

RSLT: {dbsl=99, tran=1}

FHDR: {tab='ATAB', fcode=33, mode=2, bpb=0, dbcnt=0, crsr=0,

hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,

init:p=0000000000000000, init:#=0, wa:p=0X00000000014CC570, wa:#=15000}

[dev trc ,00000] dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' 80 17.101425

STMT:

CRSR: {tab='', id=0, hold=0, prop=0x88000, max.in@0=1, fae:blk=0,

con:id=0, con:vndr=5, val=2,

key:#=2, xfer=0, xin:#=0, row:#=0, upto=1, wa:p=0X00000000014CC570}

SQL error 3106 accessing T100S: ORA-03106: fatal two-task communication protocol e

52718 9059062

0 entries from T100S (GLT0 300) deleted.

Please help to resolve the issue

Thanks in Advance

[Former Member]

i know it was too long ago but i have the same ERROR how did u solve that please it would be helpfull

[Former Member]

Hi,

check any log in alert log/user trace file as wll as sql net trace file.

it might be problm in shared memory,semaphores ..

Check NLS compatibility.

If u upgraded database also then first time login through single more and run u*...sql as given in read me file.

surendra jain

[Former Member]

Note 534729 - Oracle errors due to network problems

and check R3trans -d and trans.log file