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.