R3trans returns 0 for adm and 12 for ora

[Former Member]

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

[AplicacionesSAP]

Hello everyone,

In my case,, I have exactly the same message, and is not a problem the part of "SQL error 942". I will try to explain you why... the SAP product is a Enterprise portal on Java, it's a productive system 5 years ago; and this is working on very good... As well, I use R3trans command with -x option to testing the connection on DB server (because is a distributed installation) and the tail of trans.log file show 0000,

I recommended to you run script file [sapdba_role.sql / sapconn_role.sql (depend of your versions)] to grant the access permissions necessaries for write the table(s).

I show you part of my log trans.log and the end show the rigth output '0000', the log show query to access "SELECT VERSION FROM SVERS"

4 ETW000 [ dev trc,00000] Now 'SAPSR3DB/<pwd>@SID' is connected: con=0, nls=0, session=4, time='2021-04-07 22:46:04'
4 ETW000 [ dev trc,00000] DB instance CPC2 is running on amcprdnbi01 with ORACLE version 12.1.0.2.0 since NOV 08, 2020, 10:41:44.
4 ETW000 [ dev trc,00000] con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8
4 ETW000 [ dev trc,00000] # CharacterSet NCharSet envhp errhp er2hp bathp
4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 3ab6a00 3ac16d8 3ac2758 3ac37d8
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0)
4 ETW000 [ dev trc,00000] check2: OCIStmtExecute() failed with -1=OCI_ERROR
4 ETW000 [ dev trc,00000] SQL error 942:
4 ETW000 [ dev trc,00000] statement for table 'SVERS ':
4 ETW000 [ dev trc,00000] SELECT VERSION FROM SVERS

4 ETW000 [ dev trc,00000] stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN
4 ETW000 [ dblink ,00000] ***LOG BZA=>table SVERS does not exist on database
4 ETW000 Connected to database.
4 ETW000 [ dev trc,00000] Disconnecting from ALL connections:
4 ETW000 [ dev trc,00000] dbcon[db_con_disconnect_all]: disconnecting from connection 0 ...
4 ETW000 [ dev trc,00000] Disconnecting con=0
4 ETW000 [ dev trc,00000] OCISessionEnd(con=0, svc=3ac36f8, srv=3ac5f60='SID'): Close session usr=3b10180, rc=0
4 ETW000 [ dev trc,00000] OCIServerDetach(stale1 con=0, svc=3ac36f8, srv=3ac5f60='SID') successfully detached
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=3ac36f8): Server handle srv=3ac5f60 freed
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service hdl. svc=3ac36f8 freed.
4 ETW000 [ dev trc,00000] dbcon[db_con_disconnect_all]: disconnected from connection 0
4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=0, com_tx=0)
4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 07.04.2021 - 22:46:04

[former_member208104]

Hi,

This is because of environmnet variables set same environment variables as <sid?>adm to other users it will work.

in my case i am able to do R3trans from user db2<sid> as well and I belive this will be the case in Service<sid> user in oracle.

-Sanjay

[markus_doehr2]

<ora>sid is not used to run R3trans, it's not necessary.

Markus