R3trans on Netweaver AS Java

[former_member193294]

Hi,

I have an issue with my R3trans which I am trying to run from my application server as java (running on Linux) . The database od the java instance resides on another server (AIX) .

The error message in the trans log is :

4 ETW000 [dev trc ,00000] Try to connect with default password 21 0.064349

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@Q77 on connection 0 (nls_hdl 0) ... (dbsl 700 251109)

4 ETW000 32 0.064381

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 28 0.064409

4 ETW000 [dev trc ,00000] 0 UTF8 0xf7037e0 0xf70b230 0xf71bd48

4 ETW000 28 0.064437

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0xf70ba48 19 0.064456

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0xf70ba48 32 0.064488

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=0xf71bc78, srvhp=0xf71f3f8, usrhp=0xf70ba48)

4 ETW000 33 0.064521

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 2481 0.067002

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 65 0.067067

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 28 0.067095

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 21 0.067116

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 29 0.067145

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 19 0.067164

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 59 0.067223

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 27 0.067250

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#8 @ 433] 52 0.067302

4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#8 @ 433]

4 ETW000 29 0.067331

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'Q77'"

Apparently the SAPR3 user doesn't exist.

SQL> select username from dba_users;

USERNAME

-

---

OPS$SR3ADM

MGMT_VIEW

OPS$Q77ADM

OPS$ORAQ77

SYS

SYSTEM

DBSNMP

SYSMAN

SAPSR3DB

OUTLN

TSMSYS

USERNAME

-

---

DIP

ORACLE_OCM

13 rows selected.

Do I need to create it?

If I am not wrong, I read in a SAP Note that by default the SAPR3 user is not created on a java stuck installation.

Brdgs,

Loukas

[Former Member · Accepted solution]

Hi Loukas,

SAPR3 will not be created if it is only a JAVA stack installation.By default, SAPSR3DB will be created. SAPR3 (SAPSR3 for recent versions) will be created if its an ABAP stack installation.

For the error above, please chech SAP Note 400241.

Cheers...,

Raghu

[former_member227283]

Hi,

R3trans will never run succesful in java system.

Reason :- Java system in oracle uses instance client to connect database and this is 1 reason why R3trans fails in as java system.

And if you have see the communication between as java and database is succesful or not , then you have to start configtool.

If configtool connection database without any error, then it mean you application is communicating properly with your database.

Thanks

Anil

[former_member193294]

Thanks both of you for the responses.

The issue is clarified.

Brgds,

Loukas