Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from kalpeshyerunkar on Nov 5 at 6:28 AM Hi Mahindra, Kindly paste SAPVIEW.log' file. Meanwhile do the following steps. Note: DON'T STOP THE INSTALLATION. If you do so it will create XXXX.TSK.BCK files at installation directory which will Create more problem to you. Let it finish the installation and pop-up you to stop or retry. You must stop the installation. 1 log-off with current user & log-in with DBAADM. go to cmd - type (IN Capital) "SQLPLUS /NOLOG" press enter then type "CONNECT /SYSDBA" press enter then type "STARTUP" this will startup database Note: the last line should be " Database Opened" after that check lisner service at window services. if it is not running kindly start the same. Then go to C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS in this directory find sapinst.exe. Doule click this file it will automatically start your old installation. Let me know what happens. Regards
| | | ---------------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. __.____._ | _.____.__ |