RE:[sap-basis] DbSl Trace: ORA-3113 Occurred When Executing SQL Statement (Parse Error Offset=0)

Posted by Admin at

Share this post:

0 Comments

Reply from kalpeshyerunkar on Nov 6 at 1:54 AM

Hi Mahendra,

I have provided you the steps so follow them & let me know what happens

kalpesh

---------------Original Message---------------
From: kalpesh yerunkar
Sent: Sunday, November 02, 2014 6:34 PM
Subject: DbSl Trace: ORA-3113 Occurred When Executing SQL Statement (Parse Error Offset=0)

Hi All,

I have stuck in installation of ECC6SR2 IDES. Kindly check below logs & give solution ASAP.
I appreciate your help in advance.

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201031194800
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAPC:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]Compiled Sep 1 2006 00:38:35C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.ex e -ctf I Z:\SAP\51032413_1\EXP1\DATA\SAPAPPL0.STR C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\DD LORA.TPL SAPAPPL0.TSK ORA -l SAPAPPL0.log
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job completedC:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.e xe: END OF LOG: 20201031194833
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201031194838
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAPC:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]Compiled Sep 1 2006 00:38:35C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.ex e -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8(DB) INFO: /1CN/CPASAP00001 created #20201031200836
(IMP) INFO: import of /1CN/CPASAP00001 completed (0 rows) #20201031200836
(DB) INFO: /1CN/CPASAP00001~0 created #20201031200836
(DB) INFO: /1CN/CPASAP00001SC created #20201031200836
(DB) INFO: /1CN/CPNSAP00001 created #20201031200836
(IMP) INFO: import of /1CN/CPNSAP00001 completed (0 rows) #20201031200836
(DB) INFO: /1CN/CPNSAP00001~0 created #20201031200836
(DB) INFO: /1CN/CPNSAP00001SC created #20201031200836
(DB) INFO: /1CN/CPTSAP00001 created #20201031200836
(IMP) INFO: import of /1CN/CPTSAP00001 completed (0 rows) #20201031200836
(DB) INFO: /1CN/CPTSAP00001~0 created #20201031200836
(DB) INFO: /1CN/CPTSAP00001SC created #20201031200836
(DB) INFO: /1CN/CPTSAP00004 created #20201031200837
(IMP) INFO: import of /1CN/CPTSAP00004 completed (0 rows) #2020

(DB) INFO: AGR_FLAGSB~0 created #20201031224003

(DB) INFO: AGR_HIERT created #20201031224003

(IMP) INFO: import of AGR_HIERT completed (16034437 rows) #20201031231546

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

(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "AGR_HIERT~0" ON "AGR_HIERT" ( "MANDT", "AGR_NAME", "SPRAS", "OBJECT_ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1527582812 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 3113)
error message returned by DbSl:
ORA-03113: end-of-file on communication channel
(DB) INFO: disconnected from DB

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201031231805

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101023754

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP INDEX "AGR_HIERT~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: ORA-3113 occurred when executing SQL statement (parse error offset=11)

(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "AGR_HIERT~0" ON "AGR_HIERT" ( "MANDT", "AGR_NAME", "SPRAS", "OBJECT_ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1527582812 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 3113)
error message returned by DbSl:
ORA-03113: end-of-file on communication channel
(DB) INFO: disconnected from DB

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101031849

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101033035

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101033036

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101041703

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101041704

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101042502

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101042504

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101045413

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101045414

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101174952

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101174957

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101175843

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101175844

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201101180734

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP INDEX "AGR_HIERT~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: ORA-3113 occurred when executing SQL statement (parse error offset=11)

(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "AGR_HIERT~0" ON "AGR_HIERT" ( "MANDT", "AGR_NAME", "SPRAS", "OBJECT_ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1527582812 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 3113)
error message returned by DbSl:
ORA-03113: end-of-file on communication channel
(DB) INFO: disconnected from DB

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201101181749

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201102011554

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP INDEX "AGR_HIERT~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201102013308

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201102013310

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20201102042359

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) ERROR: DDL statement failed
(DROP INDEX "AGR_HIERT~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: ORA-3113 occurred when executing SQL statement (parse error offset=11)

(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "AGR_HIERT~0" ON "AGR_HIERT" ( "MANDT", "AGR_NAME", "SPRAS", "OBJECT_ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1527582812 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 3113)
error message returned by DbSl:
ORA-03113: end-of-file on communication channel
(DB) INFO: disconnected from DB

C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\VJY\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20201102042650

Regards,
Kalpesh

Reply to this email to post your response.

__.____._

Manage Settings | Unsubscribe | Create FAQ | Send Feedback

kalpeshyerunkar

	Mark as helpful
	View this online
	Ask a new question

In the Spotlight

Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

SAP Library - Find your answers

Grab this WidgetYou can show more than 5 recent posts using this simple blogger widget by Nitesh KOthari at Wolverine Hakcs.

Click on more Feeds rss Most Popular

More ?This is SAP books Best Buy section. Click on the pics below to check more on the best SAP books.

Click on more to know more about such productsSAP Chat Room

More ?These are the Recommended products from SAP OSS Notes Team

Click on more to see more such downloadsRecommended