cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-03106 SAP Export

Former Member
0 Kudos
341

Hi ,

We are performing test for NW 7.3 system copy ,

SAP NW PI 7.3 , Oracle 11 , Sun Solaris SPARC

While SAP export we are getting fallowing error,

SAPPOOL.log



/usr/sap/PI1/SYS/exe/uc/sun_64/R3load: START OF LOG: 20110919195047

/usr/sap/PI1/SYS/exe/uc/sun_64/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/PI1/SYS/exe/uc/sun_64/R3load: version R7.20/V1.4 [UNICODE]
Compiled Sep 10 2011 04:27:46
/usr/sap/PI1/SYS/exe/uc/sun_64/R3load -e SAPPOOL.cmd -datacodepage 4102 -l SAPPOOL.log -stop_on_error 

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: Export without hintfile
(GSI) INFO: dbname   = "PI120110914090918                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "edssap01                                                        "
(GSI) INFO: sysname  = "SunOS"
(GSI) INFO: nodename = "edssap01"
(GSI) INFO: release  = "5.10"
(GSI) INFO: version  = "Generic_127127-11"
(GSI) INFO: machine  = "sun4v"
(GSI) INFO: instno   = "0000000000"


(RTF) ########## WARNING ###########
	Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 3106 in stmt_fetch() from oci_execute_stmt(), orpc=191

DbSl Trace: ORA-03106 occurred when executing SQL stmt (parse error offset=0)

(EXP) ERROR: DbSlExeRead failed
  rc = 99, table "ATAB"
  (SQL error 3106)
  error message returned by DbSl:
ORA-03106: fatal two-task communication protocol error
(DB) INFO: disconnected from DB

/usr/sap/PI1/SYS/exe/uc/sun_64/R3load: job finished with 1 error(s)
/usr/sap/PI1/SYS/exe/uc/sun_64/R3load: END OF LOG: 20110919195048

Please help me ,

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi, the problem is solved. It was a bug problem. After applying interim patch 9952216 that fix bug 9531984, export finished succesfully.

bug 9531984 ORA-3106 can occur while fetching empty/NULL SecureFiles

I've also applied patch bundle to avoid further errors.

Best regards.

Answers (5)

Answers (5)

0 Kudos

Hi, I am getting this error too, Is identical. Can you please tell me how to solve it?.

/usr/sap/PID/SYS/exe/uc/linuxx86_64/R3load: version R7.11/V1.4 [UNICODE]

Compiled Oct 10 2010 20:38:19

/usr/sap/PID/SYS/exe/uc/linuxx86_64/R3load -e SAPPOOL.cmd -datacodepage 4103 -l SAPPOOL.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Export without hintfile

(GSI) INFO: dbname = "PID20110613110616

"

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "crexell "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "crexell"

(GSI) INFO: release = "2.6.18-238.5.1.el5"

(GSI) INFO: version = "#1 SMP Mon Feb 21 05:52:39 EST 2011"

(GSI) INFO: machine = "x86_64"

(BEK) WARNING: SECUDIR not in environment

(BEK) INFO: trying SlicGetInstallationNo()

(GSI) INFO: instno = "INITIAL "

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 3106 in stmt_fetch() from oci_execute_stmt(), orpc=191

DbSl Trace: ORA-03106 occurred when executing SQL stmt (parse error offset=0)

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "ATAB"

(SQL error 3106)

error message returned by DbSl:

ORA-03106: fatal two-task communication protocol error

(DB) INFO: disconnected from DB

/usr/sap/PID/SYS/exe/uc/linuxx86_64/R3load: job finished with 1 error(s)

/usr/sap/PID/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20120213125055

Thanks in advance.

Best Regards.

Former Member
0 Kudos

Hi Sachin

is your DBSL library updated?

can you alsoo post here sidadm enviroment?

Thanks

Stanislav

former_member188883
Active Contributor
0 Kudos

Hi,

Please have a look into below mentioned SAP notes for the issue you are facing.

1005758 ORA 3106 in Oracle 10.2.0.2

820062 - Oracle Database 10g: Patch sets/patches for 10.1.0

1185647- "ORA-03106: fatal two-task communication protocol error State" when attempting

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

I have tried these options but no luck , this is 11g.

former_member189725
Active Contributor
0 Kudos

Can you please update the DBSL. Use a current version of DBSL and R3load .

former_member188883
Active Contributor
0 Kudos

Hi,

Whats the oracle 11g version ?

If its 11.2.0.2 , have you applied the latest bundle patches ?

Regards,

Deepak Kori

nicholas_chang
Active Contributor
0 Kudos

Please ensure Oracle Database Software is probably installed and patch to latest SBP. Run R3trans -d, make sure result is 0000.

Please check database and listerner is up and running.

Thanks,

nicholas Chang

Edited by: Nicholas Chang on Nov 21, 2011 10:09 PM

Former Member
0 Kudos

Did you get a chance to apply Oracle latest Patch sets and SBP's.

Also the weird part is Installation Number = "0000000000"

Thanks

Srikanth Mandalapu

former_member189725
Active Contributor
0 Kudos

Please check if the database is up and running.

Restart the export again.