我安装到第17步 import abap最后提示
“Import Monitor jobs: running 0, waiting 1, completed 101, failed 1, total 103.”
经检查发现是SAPAPPL1_12时出现问题
SAPAPPL1_12.LOG相关错误信息如下:
========
DbSl Trace: Error 8103 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-8103 occurred when executing SQL stmt (parse error offset=29)
(DB) ERROR: DDL statement failed
(CREATE INDEX "ZZSL01A~4" ON "ZZSL01A" ( "RACCT" , "RCNTR" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 10636520 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 8103)
error message returned by DbSl:
ORA-08103: object no longer exists
(DB) INFO: disconnected from DB
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20290222165634
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20290222214325
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 23:04:42
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL1_12.cmd -dbcodepage 4103 -l SAPAPPL1_12.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 "ZZSL01A~4")
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
=========
retry了以后,“Loading of 'SAPAPPL1_12' import package: OK”
LOG显示“(DB) INFO: ZZSL01A~4 created #20290222214332”
但是同时,多了一个问题 【'SAPVIEW' 】
Import Monitor jobs: running 1, waiting 1, completed 101, failed 0, total 103.
Loading of 'SAPAPPL1_12' import package: OK
Import Monitor jobs: running 0, waiting 1, completed 102, failed 0, total 103.
Import Monitor jobs: running 1, waiting 0, completed 102, failed 0, total 103.
Loading of 'SAPVIEW' import package: ERROR
Import Monitor jobs: running 0, waiting 0, completed 102, failed 1, total 103.
检查相关LOG,显示如下:
=========
(DB) ERROR: DDL statement failed
(CREATE VIEW "APPL_PROG" ( "PROG" , "R3STATE" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "REPOSRC" T0001, "TADIR" T0002 WHERE T0001."PROGNAME" = T0002."OBJ_NAME" AND T0001."R3STATE" = 'A' AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'PROG' AND ( T0001."SUBC" = '1' OR T0001."SUBC" = 'M' OR T0001."SUBC" = 'S' ))
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB
=========
重试sapinst.exe多次无果。
检查过源文件SAPVIEW.STR,也和以前的SR2版本的SAPVIEW.STR文件比对过——可以排除源文件错误。
根据相关错误提示——可以排除oracle共享池大小问题。
根据错误消息ORA-00942,不得问题原因出处,不知各位大仙有何好的建议大家一起探讨,谢谢!:)
“Import Monitor jobs: running 0, waiting 1, completed 101, failed 1, total 103.”
经检查发现是SAPAPPL1_12时出现问题
SAPAPPL1_12.LOG相关错误信息如下:
========
DbSl Trace: Error 8103 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-8103 occurred when executing SQL stmt (parse error offset=29)
(DB) ERROR: DDL statement failed
(CREATE INDEX "ZZSL01A~4" ON "ZZSL01A" ( "RACCT" , "RCNTR" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 10636520 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 8103)
error message returned by DbSl:
ORA-08103: object no longer exists
(DB) INFO: disconnected from DB
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20290222165634
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20290222214325
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe: version R7.01/V1.4 [UNICODE]
Compiled Feb 24 2009 23:04:42
C:\usr\sap\ZHF\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL1_12.cmd -dbcodepage 4103 -l SAPAPPL1_12.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 "ZZSL01A~4")
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
=========
retry了以后,“Loading of 'SAPAPPL1_12' import package: OK”
LOG显示“(DB) INFO: ZZSL01A~4 created #20290222214332”
但是同时,多了一个问题 【'SAPVIEW' 】
Import Monitor jobs: running 1, waiting 1, completed 101, failed 0, total 103.
Loading of 'SAPAPPL1_12' import package: OK
Import Monitor jobs: running 0, waiting 1, completed 102, failed 0, total 103.
Import Monitor jobs: running 1, waiting 0, completed 102, failed 0, total 103.
Loading of 'SAPVIEW' import package: ERROR
Import Monitor jobs: running 0, waiting 0, completed 102, failed 1, total 103.
检查相关LOG,显示如下:
=========
(DB) ERROR: DDL statement failed
(CREATE VIEW "APPL_PROG" ( "PROG" , "R3STATE" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."PROGNAME", T0001."R3STATE", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "REPOSRC" T0001, "TADIR" T0002 WHERE T0001."PROGNAME" = T0002."OBJ_NAME" AND T0001."R3STATE" = 'A' AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'PROG' AND ( T0001."SUBC" = '1' OR T0001."SUBC" = 'M' OR T0001."SUBC" = 'S' ))
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB
=========
重试sapinst.exe多次无果。
检查过源文件SAPVIEW.STR,也和以前的SR2版本的SAPVIEW.STR文件比对过——可以排除源文件错误。
根据相关错误提示——可以排除oracle共享池大小问题。
根据错误消息ORA-00942,不得问题原因出处,不知各位大仙有何好的建议大家一起探讨,谢谢!:)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9650632/viewspace-627579/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9650632/viewspace-627579/