Skip to Content

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

R3trans returns 0 for <sid>adm and 12 for ora<sid>

Hi,

R3trans -d returns different codes. When i run it as <sid>adm it returns 0. But, when i run it as ora<sid> it returns 12 with the below error in the trans.log

+4 ETW000 [ dev trc,00000] OCIStmtExecute() failed with -1=OCI_ERROR+

+597 0.307842+

+4 ETW000 [ dev trc,00000] SQL error 942:+

+12 0.307854+

+4 ETW000 [ dev trc,00000] ORA-00942: table or view does not exist+

+4 ETW000+

+14 0.307868+

+4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=942, iters-errors = 1-0) [time 0,001+

+s] 10 0.307878+

+4 ETW000 [ dbsloci.,00000] *** ERROR => ORA-942 when accessing table SAPUSER+

+14 0.307892+

+4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 942+

I checked the permissions of the users OPS$<SID>ADM and OPS$ORA<SID> and both of them have DBA, CONNECT, RESOURCE and SAPDBA roles. I also checked the ownership on the sapuser table and OPS$<SID>ADM is the owner.

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OPS$<SID>ADM

We are using ECC6 or oracle with 7.01 kernel. Please help to fix this issue.

Regards,

Vijay

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