on 09-19-2011 3:40 PM
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 ,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sachin
is your DBSL library updated?
can you alsoo post here sidadm enviroment?
Thanks
Stanislav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.