SAP 4.7 IDES Install Error on Oracle 8.1.6

[Former Member]

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: START OF LOG: 20070228150927

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#5 $ SAP

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: version R6.20/V1.2

J:\usr\sap\DVP\SYS\exe\run/R3load.exe -ctf I K:\sap\db3\EXPORT3/DATA/SAPVIEW.STR D:\SAPinst ORACLE KERNEL/DDLORA.TPL D:\SAPinst ORACLE KERNEL/SAPVIEW.TSK ORA -l D:\SAPinst ORACLE KERNEL/SAPVIEW.log -o D

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: job completed

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: END OF LOG: 20070228150928

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: START OF LOG: 20070301041552

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#5 $ SAP

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: version R6.20/V1.2

J:\usr\sap\DVP\SYS\exe\run/R3load.exe -dbcodepage 1100 -i D:\SAPinst ORACLE KERNEL/SAPVIEW.cmd -l D:\SAPinst ORACLE KERNEL/SAPVIEW.log -stop_on_error

DbSl Trace: Got ORACLE_HOME=J:\oracle\ora81 from environment

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Logon as OPS$-user to get SAPDVP's password

DbSl Trace: Connecting as /@DVP on connection 0 ...

DbSl Trace: Attaching to DB Server DVP (con_hdl=0,svchp=0026DA28,svrhp=0026D834)

DbSl Trace: Starting user session (con_hdl=0,svchp=0026DA28,srvhp=0026D834,usrhp=002AF724)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: Disconnecting from connection 0 ...

DbSl Trace: Closing user session (con_hdl=0,svchp=0026DA28,usrhp=002AF724)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPDVP/<pwd>@DVP on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=0026DA28,srvhp=0026D834,usrhp=002AF724)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance dvp is running on BASSVR with ORACLE version 8.1.7.0.0 since 20070228

(DB) INFO: connected to DB

(DB) INFO: /SAPTRX/A_CONDF4 created

(DB) INFO: /SAPTRX/VDASFEV created

(DB) INFO: /SAPTRX/VDASFPAR created

(DB) INFO: /SAPTRX/VD_AOMIL created

(DB) INFO: /SAPTRX/VD_AOPAC created

(DB) INFO: /SAPTRX/VD_AOPAE created

(DB) INFO: /SAPTRX/VD_AOPAI created

(DB) INFO: /SAPTRX/VD_AOPAR created

(DB) INFO: /SAPTRX/VD_AOTD1 created

(DB) INFO: /SAPTRX/VD_AOTD2 created

(DB) INFO: /SAPTRX/VD_AOTDD created

(DB) INFO: /SAPTRX/VD_AOTYP created

(DB) INFO: /SAPTRX/VD_ASPAR created

(DB) INFO: /SAPTRX/VD_CONDL created

(DB) INFO: /SAPTRX/V_AODD02 created

(DB) INFO: /SAPTRX/V_DD03 created

(DB) INFO: /SAPTRX/V_DD03X created

(DB) INFO: /SDF/SMODICOMP created

(DB) INFO: /SDF/SMODIDEVC created

(DB) INFO: /SDF/UMOD_COMP created

(DB) INFO: ACEPSOIT_UPD created

(DB) INFO: ADJV_TRANS_DIF created

(DB) INFO: AFFWV0 created

(DB) INFO: AFKO_LAUFN created

(DB) INFO: AFSPLIT created

(DB) INFO: AFVCP created

(DB) INFO: ALM_ME_T003O_IS created

(DB) INFO: ALM_ME_T350I created

(DB) INFO: ALM_ME_TQ80_T created

(DB) INFO: ANEKPV created

(DB) INFO: APOUPD created

(DB) INFO: APPL_DEVC created

(DB) INFO: APPL_DIAL created

(DB) INFO: APPL_DOMA created

(DB) INFO: APPL_DTEL created

(DB) INFO: APPL_ENQU created

(DB) INFO: APPL_FUGR created

(DB) INFO: APPL_FUGRG created

(DB) INFO: APPL_FUNC created

(DB) INFO: APPL_INDX created

(DB) INFO: APPL_MCOB created

(DB) INFO: APPL_MENU created

(DB) INFO: APPL_MODS created

(DB) INFO: APPL_MSAG created

(DB) INFO: APPL_PARA created

(DB) INFO: APPL_PROG created

(DB) INFO: APPL_SCAT created

(DB) INFO: APPL_SOBJ created

(DB) INFO: APPL_STRU created

(DB) INFO: APPL_SUSO created

(DB) INFO: APPL_TABL created

(DB) INFO: APPL_TITLE created

(DB) INFO: APPL_TRAN created

(DB) INFO: APPL_UDMO created

(DB) INFO: APPL_UENA created

(DB) INFO: APPL_UENO created

(DB) INFO: APPL_VIEW created

(DB) INFO: AP_ORD_PRV created

(DB) INFO: ARBPL_AFVC created

(DB) INFO: ARBPL_DT_AFVC created

(DB) INFO: ASSOB_HR created

(DB) INFO: ATP_AFPO created

(DB) INFO: ATP_EBAN created

(DB) INFO: ATP_EBUB created

(DB) INFO: ATP_EKES created

(DB) INFO: ATP_EKET created

(DB) INFO: ATP_EKUB created

(DB) INFO: ATP_PLAF created

(DB) INFO: ATP_PLPW created

(DB) INFO: ATP_RESB created

(DB) INFO: ATP_VBBE created

(DB) INFO: AUFKV created

(DB) INFO: AUFK_DT_V created

(DB) INFO: AUSPC_V1 created

(DB) INFO: AUSPC_V2 created

(DB) INFO: AUSPC_V3 created

(DB) INFO: AUSPN_V1 created

(DB) INFO: AUSPN_V2 created

(DB) INFO: AUSPN_V3 created

(DB) INFO: AUSPN_V4 created

(DB) INFO: AWU_V_LIS_F1 created

(DB) INFO: BADI_DATA created

(DB) INFO: BBP_INBD_PO_VIEW created

(DB) INFO: BBP_INBD_V created

(DB) INFO: BDALECUSTG created

(DB) INFO: BDCPV created

(DB) INFO: BIW_ACTET created

(DB) INFO: BIW_ACTE_V created

(DB) INFO: BIW_ACTYT created

(DB) INFO: BIW_ACTY_V created

(DB) INFO: BIW_AFVCT created

(DB) INFO: BIW_AFVC_V created

(DB) INFO: BIW_AFVV_V created

(DB) INFO: BIW_ANKT created

(DB) INFO: BIW_ANLHT created

(DB) INFO: BIW_ANLT created

(DB) INFO: BIW_ASMD created

(DB) INFO: BIW_ASMDT created

(DB) INFO: BIW_AUARTT created

(DB) INFO: BIW_AUFK created

(DB) INFO: BIW_AUFKT created

(DB) INFO: BIW_CBPR created

(DB) INFO: BIW_CBPT created

(DB) INFO: BIW_CEPC created

(DB) INFO: BIW_CEPCT created

(DB) INFO: BIW_CLAIM created

(DB) INFO: BIW_CLAIMT created

(DB) INFO: BIW_CLAIM_SEL created

(DB) INFO: BIW_CLASS created

(DB) INFO: BIW_CMP_NP created

(DB) INFO: BIW_CMP_NV created

(DB) INFO: BIW_CSKB created

(DB) INFO: BIW_CSKS created

(DB) INFO: BIW_CSKT created

(DB) INFO: BIW_CSLA created

(DB) INFO: BIW_CSLT created

(DB) INFO: BIW_DEPAR created

(DB) INFO: BIW_DEPAR2 created

(DB) INFO: BIW_DV_WBS created

(DB) INFO: BIW_EINAT created

(DB) INFO: BIW_EQKT created

(DB) INFO: BIW_EQUI created

(DB) INFO: BIW_FLOWTYPEST created

(DB) INFO: BIW_IFLOALTX created

(DB) INFO: BIW_IFLOS created

(DB) INFO: BIW_IFLOT created

(DB) INFO: BIW_IFLOTX created

(DB) INFO: BIW_JV_COOR created

(DB) INFO: BIW_JV_CSKS created

(DB) INFO: BIW_JV_PROJ created

(DB) INFO: BIW_JV_PRPS created

(DB) INFO: BIW_JV_T8J9C created

(DB) INFO: BIW_JV_T8JF created

(DB) INFO: BIW_JV_T8JFT created

(DB) INFO: BIW_JV_T8JJ created

(DB) INFO: BIW_JV_T8JJT created

(DB) INFO: BIW_JV_T8JV created

(DB) INFO: BIW_KNA1 created

(DB) INFO: BIW_KNA1T created

(DB) INFO: BIW_KNA1T_CONS created

(DB) INFO: BIW_KNB1T created

(DB) INFO: BIW_KNVVT created

(DB) INFO: BIW_LFA1 created

(DB) INFO: BIW_LFA1T created

(DB) INFO: BIW_LFB1T created

(DB) INFO: BIW_LFM1T created

(DB) INFO: BIW_LQPOST created

(DB) INFO: BIW_MAKT created

(DB) INFO: BIW_MARA_V created

(DB) INFO: BIW_MARCT created

(DB) INFO: BIW_MARDT created

(DB) INFO: BIW_MKALT created

(DB) INFO: BIW_MLSTDT created

(DB) INFO: BIW_MLSTUS created

(DB) INFO: BIW_MLSTVP created

(DB) INFO: BIW_MLSTVV created

(DB) INFO: BIW_MLST_USE created

(DB) INFO: BIW_MLS_P_VS created

(DB) INFO: BIW_MLS_V created

(DB) INFO: BIW_MLS_V_VS created

(DB) INFO: BIW_MLTXV created

(DB) INFO: BIW_MVKET created

(DB) INFO: BIW_NAE created

(DB) INFO: BIW_NAE_D created

(DB) INFO: BIW_NETDAT created

(DB) INFO: BIW_NETW_V created

(DB) INFO: BIW_NTW created

(DB) INFO: BIW_NWA created

(DB) INFO: BIW_NWA_D created

(DB) INFO: BIW_PRHI_V created

(DB) INFO: BIW_PROJT created

(DB) INFO: BIW_PRPST created

(DB) INFO: BIW_PRPS_V created

(DB) INFO: BIW_PRTE created

(DB) INFO: BIW_PS24 created

(DB) INFO: BIW_QALS created

(DB) INFO: BIW_QALS_T created

(DB) INFO: BIW_QMEL created

(DB) INFO: BIW_QMEL_T created

(DB) INFO: BIW_QPCT created

(DB) INFO: BIW_QPGT created

(DB) INFO: BIW_RDB_JBRRHT created

(DB) INFO: BIW_RESBNP created

(DB) INFO: BIW_R_MARA created

(DB) INFO: BIW_R_T001W created

(DB) INFO: BIW_SKA1 created

(DB) INFO: BIW_SKA1T created

(DB) INFO: BIW_T001 created

(DB) INFO: BIW_T001L created

(DB) INFO: BIW_T001T created

(DB) INFO: BIW_T001WT created

(DB) INFO: BIW_T005T created

(DB) INFO: BIW_T014 created

(DB) INFO: BIW_T014T created

(DB) INFO: BIW_T023T created

(DB) INFO: BIW_T024DT created

(DB) INFO: BIW_T024ET created

(DB) INFO: BIW_T024I created

(DB) INFO: BIW_T024T created

(DB) INFO: BIW_T026T created

(DB) INFO: BIW_T035 created

(DB) INFO: BIW_T035D created

(DB) INFO: BIW_T035DT created

(DB) INFO: BIW_T035T created

(DB) INFO: BIW_T036 created

(DB) INFO: BIW_T036T created

(DB) INFO: BIW_T038T created

(DB) INFO: BIW_T039T created

(DB) INFO: BIW_T053R created

(DB) INFO: BIW_T053S created

(DB) INFO: BIW_T087S created

(DB) INFO: BIW_T087T_1 created

(DB) INFO: BIW_T087T_2 created

(DB) INFO: BIW_T087T_3 created

(DB) INFO: BIW_T087T_4 created

(DB) INFO: BIW_T087V created

(DB) INFO: BIW_T090T created

(DB) INFO: BIW_T093T1 created

(DB) INFO: BIW_T147B created

(DB) INFO: BIW_T147D created

(DB) INFO: BIW_T300T created

(DB) INFO: BIW_T301T created

(DB) INFO: BIW_T302T created

(DB) INFO: BIW_T307T created

(DB) INFO: BIW_T333T created

(DB) INFO: BIW_T438T created

(DB) INFO: BIW_T499S created

(DB) INFO: BIW_T6WP1T created

(DB) INFO: BIW_T6WP2T created

(DB) INFO: BIW_T6WST created

(DB) INFO: BIW_T856T created

(DB) INFO: BIW_T880 created

(DB) INFO: BIW_T880T created

(DB) INFO: BIW_T8JV created

(DB) INFO: BIW_TABWR created

(DB) INFO: BIW_TABWT created

(DB) INFO: BIW_TCJ04 created

(DB) INFO: BIW_TCJ04T created

(DB) INFO: BIW_TCK04 created

(DB) INFO: BIW_TCKH1 created

(DB) INFO: BIW_TCKH3 created

(DB) INFO: BIW_TCKH6 created

(DB) INFO: BIW_TCKH9 created

(DB) INFO: BIW_TCN07 created

(DB) INFO: BIW_TFKB created

(DB) INFO: BIW_TFKBT created

(DB) INFO: BIW_TGSB created

(DB) INFO: BIW_TGSBT created

(DB) INFO: BIW_TKA01 created

(DB) INFO: BIW_TKA03 created

(DB) INFO: BIW_TKT03 created

(DB) INFO: BIW_TMCWWT created

(DB) INFO: BIW_TQ15T created

(DB) INFO: BIW_TQ17T created

(DB) INFO: BIW_TQ30T created

(DB) INFO: BIW_TRANST created

(DB) INFO: BIW_TSABT created

(DB) INFO: BIW_TWATT created

(DB) INFO: BIW_TWBNT created

(DB) INFO: BIW_TWPTT created

(DB) INFO: BIW_TWSGT created

(DB) INFO: BIW_TWTYT created

(DB) INFO: BIW_V_BC_T created

(DB) INFO: BIW_V_ID created

(DB) INFO: BIW_V_ID_T created

(DB) INFO: BIW_V_IO created

(DB) INFO: BIW_V_IP_T created

(DB) INFO: BIW_V_IQIP created

(DB) INFO: BIW_V_IQ_S created

(DB) INFO: BIW_V_IQ_T created

(DB) INFO: BIW_V_ORIP created

(DB) INFO: BIW_V_ORIP_IQ created

(DB) INFO: BIW_V_PRIP created

(DB) INFO: BIW_V_PRIP_IQ created

(DB) INFO: BIW_V_T087L created

(DB) INFO: BIW_V_TAIF5T created

(DB) INFO: BIW_WAKT created

(DB) INFO: BIW_WRST created

(DB) ERROR: DDL statement failed

(CREATE VIEW "BIW_WWMIT" ( "MANDT" , "WMINR" , "SPRAS" , "WMITX" ) AS SELECT T0001."MANDT", T0001."WMINR", T0001."SPRAS", T0001."WMITX" FROM "WWMIT" T0001)

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

DbSl Trace: Disconnecting from connection 0 ...

DbSl Trace: Closing user session (con_hdl=0,svchp=0026DA28,usrhp=002AF724)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0026DA28,srvhp=0026D834)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: job finished with 1 error(s)

J:\usr\sap\DVP\SYS\exe\run/R3load.exe: END OF LOG: 20070301041608

===========================================================

Any help on this is highly appreciated.

Thanks and regards

Veeresh Babu

[Former Member · Accepted solution]

Hi Veeresh,

What OS do you installed this SAP 4.7 ? Oracle 8i is not supported on Windows 2003. Use Oracle 9i.

ardhian

[Former Member · Accepted solution]

Hi Ardhian

Thanks for your prompt reply. As you guessed I am using Windows 2003 SP1.

and the oracle version is 8.1.7.0.0

Could you please guide me where I can download Oracle 9i? (I do have login credentials for Service Market Place)

Could you please confirm that the error message I got is not due to bad exports or dump, is it? because Installing Oracle 9i may not help if the exports are bad.

Thanks and regards

Veeresh Babu

[andreas_herzog · Accepted solution]

a) download oracle 9.2

SAPNet -> Alias SWDC -> Installations and Upgrades -> SAP Application Components -> SAP R/3 ENTERPRISE -> SAP R/3 ENTERPRISE 47X200 -> ORACLE -> Windows Server -> CD 51030122_1, CD 51030122_2 and CD 51030122_4

b) error situation

you came across an ORA924 error, meaning that the import process r3load is trying to load a table which does not exist (CREATE VIEW "BIW_WWMIT" does not succeed)...in order to succesfully complete load process sapview you either have to provide table BIW_WWMIT or you can edit the sapview related files sapview.tsk and sapview.str and delete the relevant entries concerning the above mentioned table...when done restart the installation using sapinst...

c) ides and export?

why are you not using the standard ides export cds for your installation?

d) oracle 8i and win2k3

either way you will have to use oracle 9i as you will get no support on ora 8i/win2k3 combination...you should even think about 10g as 9i will be de-supported by the end of june this year...

GreetZ, AH