ORA-00942: table or view does not exist

[Former Member]

Hi

I am trying to install sap with oracle 10g on windows 2003 it throws up the error at a particular stage:

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "/1SAP1/CNV_A0017")

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 "/1SAP1/CNV_A0017" ( "MANDANT" , "KEYGUID" , "OBJECTCLAS" , "OBJECTID" , "TABNAME" , "TABKEY" ) AS SELECT T0001."MANDANT", T0001."KEYGUID", T0001."OBJECTCLAS", T0001."OBJECTID", T0001."TABNAME", T0001."TABKEY" FROM "CDPOS_UID" T0001)

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20150606151913

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20150606152200

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Apr 2 2006 23:26:45

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

Please could you let me know what it relates to and how to rectify this.

[Former Member]

Hi Sathish Kumar,

Ckeck if oracle is runing.

Open a command prompt and execute command

sqlplus "/as sysdba"

startup

Also check logfile sapview.log

In that file you will find the views created will be flaged with ok and views with error will be flaged as err just change it ro req in the file and run the installation.

It may work.

Regards

Ashok

[Former Member]

Please refer the oss notes

361641 - Creating OPS$ users on UNIX

50088 - Creating OPS$ users on Windows NT/Oracle

Please check apply the proper patch set also.

10.2.0.2 or 10.2.0.4 shall be installed.

Thanks

Amit

[Former Member]

SAPUSR tables stores the user and password for SCHEMA ID

i.e SAPR3 or SIDADM.

It is called as a OPS$ mechanism where work processes gets connected with database using schema id and the authentication is provided through sapuser table .

Is your DB started?Can you check the sapuser table created in DB?

Search note on ops$ mechanism.You will get good notes on it.

Regarding your problem,try to use the latest sapinst or control.xml .

Thanks

Amit