We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

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

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

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
  
Copyright © 2014 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
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.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language