cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in R/3 4.7E installation - in Load Database (post processin)

Former Member
0 Kudos

Hi everyone,

I am trying to install SAP 4.7E on Windows 2003 Server with Oracle version 8.1.7.4.1.

I am getting a error and SAPVIEW.log says:

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080218140053

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: job completed

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080218140054

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219021519

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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=002BD470,usrhp=0030501C)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance kha is running on KHALID with ORACLE version 8.1.7.4.1 since 20080219

(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) ERROR: DDL statement failed

(CREATE VIEW "AFSPLIT" ( "MANDT" , "C_AUFNR" , "SPLCNT" , "P_AUFNR" , "L_AUFNR" , "SPLQ" , "QUNIT" , "SDATE" , "STIME" , "SUSER" , "APLZL" , "APLFL" ) AS SELECT T0001."MANDT", T0001."C_AUFNR", T0001."SPLCNT", T0001."P_AUFNR", T0001."L_AUFNR", T0001."SPLQ", T0001."QUNIT", T0001."SDATE", T0001."STIME", T0001."SUSER", T0002."APLZL", T0002."APLFL" FROM "AFSPREL" T0001, "AFSPOPR" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."C_AUFNR" = T0002."C_AUFNR")

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=002BD470,usrhp=0030501C)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=002BD470,srvhp=002BD27C)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080219021525

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219022921

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

Tue Feb 19 02:29:24 2008

***LOG BY2=> sql error 1034 performing CON [dblink#1 @ 419] [dblink 0419 ]

***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink#1 @ 419] [dblink 0419 ]

(DB) ERROR: db_connect rc = 256

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

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

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080219022924

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219024027

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

Tue Feb 19 02:40:30 2008

***LOG BY2=> sql error 1034 performing CON [dblink#1 @ 419] [dblink 0419 ]

***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink#1 @ 419] [dblink 0419 ]

(DB) ERROR: db_connect rc = 256

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

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

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080219024030

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219102410

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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=002BD470,usrhp=0030501C)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance kha is running on KHALID with ORACLE version 8.1.7.4.1 since 20080219

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "AFSPLIT")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "AFSPLIT" ( "MANDT" , "C_AUFNR" , "SPLCNT" , "P_AUFNR" , "L_AUFNR" , "SPLQ" , "QUNIT" , "SDATE" , "STIME" , "SUSER" , "APLZL" , "APLFL" ) AS SELECT T0001."MANDT", T0001."C_AUFNR", T0001."SPLCNT", T0001."P_AUFNR", T0001."L_AUFNR", T0001."SPLQ", T0001."QUNIT", T0001."SDATE", T0001."STIME", T0001."SUSER", T0002."APLZL", T0002."APLFL" FROM "AFSPREL" T0001, "AFSPOPR" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."C_AUFNR" = T0002."C_AUFNR")

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=002BD470,usrhp=0030501C)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=002BD470,srvhp=002BD27C)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080219102413

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219113039

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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=002BD470,usrhp=0030501C)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance kha is running on KHALID with ORACLE version 8.1.7.4.1 since 20080219

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

(DROP VIEW "AFSPLIT")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "AFSPLIT" ( "MANDT" , "C_AUFNR" , "SPLCNT" , "P_AUFNR" , "L_AUFNR" , "SPLQ" , "QUNIT" , "SDATE" , "STIME" , "SUSER" , "APLZL" , "APLFL" ) AS SELECT T0001."MANDT", T0001."C_AUFNR", T0001."SPLCNT", T0001."P_AUFNR", T0001."L_AUFNR", T0001."SPLQ", T0001."QUNIT", T0001."SDATE", T0001."STIME", T0001."SUSER", T0002."APLZL", T0002."APLFL" FROM "AFSPREL" T0001, "AFSPOPR" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."C_AUFNR" = T0002."C_AUFNR")

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=002BD470,usrhp=0030501C)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=002BD470,srvhp=002BD27C)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: END OF LOG: 20080219113042

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: START OF LOG: 20080219114922

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

F:\usr\sap\KHA\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server KHA (con_hdl=0,svchp=002BD470,svrhp=002BD27C)

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPKHA/<pwd>@KHA on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=002BD470,srvhp=002BD27C,usrhp=0030501C)

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

DbSl Trace: CONNECT failed with sql error '1034'

Please help me in this regard.

Thanking you,

Abdul

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

You can install 4.7EE with Oracle 8i in Windows 2003 server.

I used to install 4.7EE in Windows 2003 server with Oracle 8i.

Same problem I have faced many times.

Please check the logs.

Please check the network connection( ping ). If you are using standalone system then choose Microsoft Loop Back adapter.

Give the Proper host name and IP address.

Check the database is up or not.

Regards,

Arjun.

Former Member
0 Kudos

Hi,

You can install 4.7EE with Oracle 8i in Windows 2003 server.

I used to install 4.7EE in Windows 2003 server with Oracle 8i.

Same problem I have faced many times.

Please check the logs.

Please check the network connection( ping ). If you are using standalone system then choose Microsoft Loop Back adapter.

Give the Proper host name and IP address.

Check the database is up or not.

Regards,

Arjun.

andreas_herzog
Active Contributor
0 Kudos

You can install 4.7EE with Oracle 8i in Windows 2003 server.

you might succeed but still - it's not supported...so when you run into problems, there will be no support unless you use ora 9.2

GreetZ, AH

Former Member
0 Kudos

Hi Arjun,

Thanks for your reply. Basically I am a Abaper, so I don't know much about installation.

I am using Loop back adaptor. Let me know, 1) how to check whether the database is up or not. 2) I have specified the IP address and host name only once, do I need to specify these at multiple places?

Regards,

Abdul

Former Member
0 Kudos

Thanks!

former_member204746
Active Contributor
0 Kudos

ORAcle 8 is not supported on Windows 2003... so, you are out of luck.