Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unable to create Views

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question