R3trans -d finished with RC 12, R3trans -x is OK

[Former Member]

Hello

R3trans can't connect to the database, when i execute R3trans:

C:\r3trans -x

This is r3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

r3trans finished (0000).

***********

C:\r3trans -d

This is r3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

r3trans finished (0012).

*********************************

i checked the Note 534765 - db connect fails because of wrong db schema

in environment, which describes the same Symptom: it talks about

dbs_ora_schema envirnment variable, but it is well configured:

dbs_ora_schema=sapsr3 (also dbs_ora_schema=SAPSR3 tested)

Help please

[Former Member]

Hi all

Just want to share what was wrong in my case (got exactly this issue). I experienced this error when performing a pre-requisite step for upgrading. I needed to configure SSFS in our Q system (that is a copy from production). And I made a mistake in the configuration of SSFS leading to this issue.

Here is what I did wrong (in bold) - this is my BW test system

On O/S level for the SSFS part:
#vi .sapenv_SID.sh
export RSEC_SSFS_DATAPATH=/usr/sap/BAQ/SYS/global/security/rsecssfs/data
export RSEC_SSFS_KEYPATH=/usr/sap/BAQ/SYS/global/security/rsecssfs/key
rsdb_ssfs_connect=1; export rsdb_ssfs_connect

Then executed as SIDadm
rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPBAQ -plain
rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD [my_password]

And this gave me this exact issue since I did not pay attention to that the schema owner is in fact SAPBAP (since the systemcopy).

Anyway, I solved it by re-executing:
rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPBAP -plain

R3trans now gives me [0000] and SAP instance started just fine.

Maybe this helps someone other :

Cheers

Oh, by the way, R3trans error in specifc I got was:

baqadm> R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

R3trans finished (0012).

[cengiz]

Hi Pelle,

your solution solved my problem. I had the same issue.

Many Thanks !!

Regards

Cengiz Köseoglu

[former_member189546]

Hello,

Could you please make sure both the Listener Service

(Oracle<SID***>TNSListener) and Oracle Service (OracleService<SID>) are

running under the same user?

Please check note 556232 and make sure all the Environment settings

are correct.

regards,

John Feely

[Former Member]

Thank's,

but Environment variables are correct,

the last oracle client which is installed DVD Mat# 51041742

Regards

[JPReyes]

ORA-00942: table or view does not exist 

That could be related to the OPS$ users

Check,

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

and

Note 50088 - Creating OPS$ users on Windows NT/Oracle

Regards

Juan

[Former Member]

Hi

Can you post, trans.log file generated in your C drive, after executing, R3trans -d ?

R3trans -d : Will test if it can read the SAP Database.

R3trans -x : DB connect, without access to SAP Table.

So, I believe, there could be some authorization issue, while accessing the SAP schema. Check the roles or permission, granted to that OPS$<SID>adm user. May, be that trans.log will help.

Check this SAP Note 400241 Problems with ops$ or sapr3 connect to oracle

Regds,

Rajesh

[Former Member]

Hi,

Can you please paste the trans.log, after testing the R3trans -d .

regards,

balaram

[Former Member]

Hi

Thank's all for you reply, please find out the trans.log:

....

4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=2FBE970, errhp=2FBF19C): [dur. 0,000s] 39 0.541150

4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 1059 0.542209

4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 50 0.542259

4 ETW000 [dev trc ,00000] Got SAPSR3's password from OPS$-user 410 0.542669

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 50 0.542719

4 ETW000 [dev trc ,00000] Rolling back transaction 51 0.542770

4 ETW000 [dev trc ,00000] Closing user session (con=0, svc=2FBE970, usr=2FCC4B8) 794 0.543564

4 ETW000 [dev trc ,00000] Disconnected (con=0) from ORACLE. 1011 0.544575

4 ETW000 [dev trc ,00000] Connect as 'SAPSR3' with password from table SAPUSER 144 0.544719

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@DES on connection 0 (nls 0) ... (dbsl 720 090112, non-unicode)

4 ETW000 59 0.544778

4 ETW000 [dev trc ,00000] Assigning username to user session: con=0, usrhp= 2FCC4B8 38 0.544816

4 ETW000 [dev trc ,00000] Assigning password to user session: con=0, usrhp=2FCC4B8 47 0.544863

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=2FBE970, srv=2FC03D4, usr=2FCC4B8)

4 ETW000 297 0.545160

4 ETW000 [dev trc ,00000] Assigning user session 2FCC4B8 to service context 2FBE970 13128 0.558288

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 not connected 101 0.558389

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con=0,len=39,stp=2FC82E0) 40 0.558429

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 52 0.558481

4 ETW000 [dev trc ,00000] - oci_define ( 0: SQLT_INT , l= 4, con=0, stp=2FC82E0, pv=228F558, in=228F554,rl=0000NULL,rc=0000NULL)

4 ETW000 75 0.558556

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 not connected, new transaction 52 0.558608

4 ETW000 [dev trc ,00000] -->oci_execute_stmt(#4: con=0,stp=2FC82E0,itr=1,off=0,bat=0) 38 0.558646

4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=2FBE970, errhp=2FBF19C): [dur. 0,000s] 347 0.558993

4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 1096 0.560089

4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 52 0.560141

4 ETW000 [dev trc ,00000] Now 'SAPSR3/<pwd>@DES' is connected: con=0, nls=0, session=150, time='2012-02-29 13:02:06'

4 ETW000 208 0.560349

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 not connected 58 0.560407..

.....

[Former Member]

...

4 ETW000 [dev trc ,00000] stmt=SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 10151 0.653659

4 ETW000 [dev trc ,00000] STID: ssp=228AD18 ->stp=NULL 41 0.653700

4 ETW000 [dev trc ,00000] Out 00: DBSL_DATA_INTEGER_2 (len=2, max=2, dec=0) 72 0.653772

4 ETW000 [dev trc ,00000] Out 01: DBSL_DATA_INTEGER_2 (len=2, max=2, dec=0) 36 0.653808

4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input variables, col=0 34 0.653842

4 ETW000 [dev trc ,00000] bind_type_and_length(): 2 output variables 109 0.653951

4 ETW000 [dev trc ,00000] 0: DBSL_DATA_INTEGER_2 , len=2, max=2, dec=0 36 0.653987

4 ETW000 [dev trc ,00000] 1: DBSL_DATA_INTEGER_2 , len=2, max=2, dec=0 33 0.654020

4 ETW000 [dev trc ,00000] bind_ind_and_values(OUT,con=0,arr=5416,col=2,rc=0,rl=0,flt=0,int=2,sh=0,uc=0)

4 ETW000 55 0.654075

4 ETW000 [dev trc ,00000] - oci_define ( 0: SQLT_INT , l= 4, con=0, stp=2FC7ED4, pv=2FF2938, in=2FFD278,rl=0000NULL,rc=0000NULL)

4 ETW000 55 0.654130

4 ETW000 [dev trc ,00000] - oci_define ( 1: SQLT_INT , l= 4, con=0, stp=2FC7ED4, pv=2FF7DD8, in=2FFFCC8,rl=0000NULL,rc=0000NULL)

4 ETW000 69 0.654199

4 ETW000 [dev trc ,00000] DbSlBegRead(#0) --> 0=DBSL_ERR_OK 37 0.654236

4 ETW000 [dev trc ,00000] -->DbSlExeRead(#1: con=0, ss_p=228AD18, da_p=228ACBC) 36 0.654272

4 ETW000 [dev trc ,00000] AppInf(5)->1; mod='',act='',usr='DBSL: con=0, no client_id',ta='',mp=''

4 ETW000 60 0.654332

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 connected, new transaction 43 0.654375

4 ETW000 [dev trc ,00000] -->oci_execute_stmt(#14: con=0,stp=2FC7ED4,itr=1,off=0,bat=0); AI='..DBSL: con=0, no client_id.'

4 ETW000 364 0.654739

4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=2FBE970, errhp=2FBF19C): [dur. 0,000s] 43 0.654782

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

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

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

4 ETW000 52 0.664801

4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,016s] 40 0.664841

4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=942, rows processed 0, iters-errors = 1-0) [dur. 0,016s]

4 ETW000 49 0.664890

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

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con=0, rc=942) 40 0.665288

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 942 39 0.665327

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

4 ETW000 49 0.665376

4 ETW000 [dev trc ,00000] stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN 34 0.665410

4 ETW000 [dev trc ,00000] DbSlExeRead(#1) --> 103=DBSL_ERR_DBOBJECT_UNKNOWN 34 0.665444

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 42 0.665486

4 ETW000 [dev trc ,00000] -->DbSlPrepare(con=0, ss_p=228AD18, op=DBSL_SELECT, da_p=228ACBC), stp=228AD30, stid=0000NULL

4 ETW000 52 0.665538

4 ETW000 [dev trc ,00000] AppInf(210)->1; mod='DBSL: con=0, unknown ABAP',act='0',usr='DBSL: con=0, no client_id',ta='',mp=''

4 ETW000 10118 0.675656

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 connected 49 0.675705

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con=0,len=51,stp=2FC6264); AI=DBSL: con=0, unknown ABAP.0.DBSL: con=0, no client_id.DBSL: con=0, no client_info

4 ETW000 56 0.675761

4 ETW000 [dev trc ,00000] SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000 49 0.675810

4 ETW000 [dev trc ,00000] DbSlPrepare(lit=0, lob=0, fae=0, col=0, mrk=0, sch=2FA00E8, scp=2FA4BE8, tab='DDNTT') -> 0=DBSL_ERR_OK

4 ETW000 71 0.675881

4 ETW000 [dev trc ,00000] -->DbSlBegRead(#0: con=0, ssp=228AD18, dap=228ACBC), In=0, Out=1, sch=2FA00E8, scp=2FA4BE8, tab='DDNTT'

4 ETW000 58 0.675939

4 ETW000 [dev trc ,00000] stmt=SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

[Former Member]

4 ETW000 [dev trc ,00000] stmt=SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000 10602 0.819547

4 ETW000 [dev trc ,00000] STID: ssp=228AD30 ->stp=NULL 39 0.819586

4 ETW000 [dev trc ,00000] Out 00: DBSL_DATA_SHORT_CHAR (len=1, max=1, dec=0) 38 0.819624

4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input variables, col=0 150 0.819774

4 ETW000 [dev trc ,00000] bind_type_and_length(): 1 output variables 36 0.819810

4 ETW000 [dev trc ,00000] 0: DBSL_DATA_SHORT_CHAR , len=1, max=1, dec=0 33 0.819843

4 ETW000 [dev trc ,00000] bind_ind_and_values(OUT,con=0,arr=21666,col=1,rc=0,rl=0,flt=0,int=0,sh=0,uc=1)

4 ETW000 54 0.819897

4 ETW000 [dev trc ,00000] - oci_define ( 0: SQLT_CHR , l= 1, con=0, stp=3005D44, pv=2FFD27C, in=2FF2938,rl=0000NULL,rc=0000NULL)

4 ETW000 54 0.819951

4 ETW000 [dev trc ,00000] DbSlBegRead(#0) --> 0=DBSL_ERR_OK 46 0.819997

4 ETW000 [dev trc ,00000] -->DbSlExeRead(#1: con=0, ss_p=228AD30, da_p=228ACD4) 37 0.820034

4 ETW000 [dev trc ,00000] AppInf(5)->1; mod='',act='',usr='DBSL: con=0, no client_id',ta='',mp=''

4 ETW000 60 0.820094

4 ETW000 [dev trc ,00000] time 2012-02-29 13:02:06, con=0 connected, new transaction 43 0.820137

4 ETW000 [dev trc ,00000] -->oci_execute_stmt(#29: con=0,stp=3005D44,itr=1,off=0,bat=0); AI='..DBSL: con=0, no client_id.'

4 ETW000 51 0.820188

4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=2FBE970, errhp=2FBF19C): [dur. 0,000s] 38 0.820226

4 ETW000 [dev trc ,00000] Wed Feb 29 13:02:07 2012 9562 0.829788

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

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

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

4 ETW000 49 0.829912

4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,016s] 39 0.829951

4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=942, rows processed 0, iters-errors = 1-0) [dur. 0,016s]

4 ETW000 48 0.829999

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

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con=0, rc=942) 30 0.830062

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 942 33 0.830095

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

4 ETW000 47 0.830142

4 ETW000 [dev trc ,00000] stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN 34 0.830176

4 ETW000 [dev trc ,00000] DbSlExeRead(#1) --> 103=DBSL_ERR_DBOBJECT_UNKNOWN 34 0.830210

4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000 53 0.830263

4 ETW000 [dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 43 0.830306

4 ETW000 [dev trc ,00000] NTAB: db_ntab(): init_ntab failed, returning 2 412 0.830718

2EETW000 sap_dext called with msgnr "2":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 6992 0.837710

4 ETW000 [dev trc ,00000] ->DbSlRollback(con=0, NOFORCE), after 29 stmts executed) 259 0.837969

4 ETW000 [dev trc ,00000] all LL freed, no memory used for LL storage 42 0.838011

[Former Member]

Hi,

please , any idea

Regards

[Former Member]

Hello Nabil,

Please update R3trans patch and give a try.

Thanks,

Siva Kumar

[Former Member]

Hi Siva,

thank's for your reply, the last patch is installed:

C:\>R3trans -v

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

-

---

R3trans information

-

---

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_10201_SHARE,

DBSL shared library version 720.00

compiled on NT 5.2 3790 S x86 MS VC++ 14.00 for NTI386

compilation mode Non-Unicode

compile time Feb 20 2012 14:04:53

update level 0

[naveen_kumar1]

Hi,

Please check the below SAP note

932779 - Unicode conversion - analysis of nametab problems

449669 - Memory overwrite in R3trans

19466 - Downloading kernel patches

Regards,

Naveen.