Unable to create Views

[Former Member]

Hi ,

I hope you people are doing well.

I don't know this is the right forum to post my problem in SAP-Installation or not.

While i am installing i got problem like unable to create the view.

Here i am posting my error log.

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: START OF LOG: 20100921222136

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

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: version R6.20/V1.2

D:\usr\sap\ERP\SYS\exe\run/R3load.exe -ctf I E:\DUMP\3\db3\EXPORT3/DATA/SAPVIEW.STR C:\SAPinst ORACLE KERNEL/DDLORA.TPL C:\SAPinst ORACLE KERNEL/SAPVIEW.TSK ORA -l C:\SAPinst ORACLE KERNEL/SAPVIEW.log -o D

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: job completed

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: END OF LOG: 20100921222137

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: START OF LOG: 20100922093836

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

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server ERP (con_hdl=0,svchp=0027D430,svrhp=0027D23C)

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

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=0027D430,usrhp=00291BEC)

DbSl Trace: Now I'm disconnected from ORACLE

DbSl Trace: Try to connect with default password

DbSl Trace: Connecting as SAPERP/<pwd>@ERP on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

DbSl Trace: Now I'm connected to ORACLE

DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC

DbSl Trace: Database instance erp is running on SOFTWARE with ORACLE version 8.1.7.0.0 since 20100921

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

(CREATE VIEW "APOUPD" ( "MANDT" , "MATNR" , "WERKS" , "APOKZ" ) AS SELECT T0001."MANDT", T0001."MATNR", T0001."WERKS", T0001."APOKZ" FROM "MARC" 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=0027D430,usrhp=00291BEC)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0027D430,srvhp=0027D23C)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

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

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: END OF LOG: 20100922093843

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: START OF LOG: 20100630105809

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

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: version R6.20/V1.2

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

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

DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

DbSl Trace: Attaching to DB Server ERP (con_hdl=0,svchp=0027D430,svrhp=0027D23C)

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

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 SAPERP/<pwd>@ERP on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

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

DbSl Trace: CONNECT failed with sql error '1034'

Wed Jun 30 10:58:12 2010

***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 SAPERP's password

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

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

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 SAPERP/<pwd>@ERP on connection 0 ...

DbSl Trace: Starting user session (con_hdl=0,svchp=0027D430,srvhp=0027D23C,usrhp=00291BEC)

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

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

D:\usr\sap\ERP\SYS\exe\run/R3load.exe: END OF LOG: 20100630105812

Thanks in Advance.

Venkat.

[markus_doehr2]

Oracle 8i is not supported on Windows 2003 - you need to use at least Oracle 9.2

Markus

[Former Member]

Hi,

I am not able to get the thing.Can u explain clearly.

Thanks in Advance.

Regards,

Venkat.

[Former Member]

Hello,

The problem is clear from the message.ORA-00942: table or view does not exist

The underlying table for the view is not created.Please check if table exists,check

the log of table creation in TSK file.It is possible that the table is not created when

the installation is stopped abnormally and the error is coming when the installation

restarted.