cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans not connecting. Return code 0012

Former Member
0 Kudos

Hi,

While trying to bring up SAP in our DR, we are not able to startsap. The R3trans is terminating with return code 0012. Please find below the logs from the trans.log file. Please suggest.

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

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/PRD/920_32 from environment

4 ETW000 442 0.010846

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 47 0.010893

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000 30 0.010923

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2536 0.013459

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 33 0.013492

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

4 ETW000 30 0.013522

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

4 ETW000 35 0.013557

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x959f9b0 0x95afc28 0x95af6c8

4 ETW000 54 0.013611

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 30 0.013641

4 ETW000 [dev trc ,00000] Allocating server context handle 25 0.013666

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x95af654,srvhp=0x95b183c)

4 ETW000 72 0.013738

4 ETW000 [dev trc ,00000] Assigning server context 0x95b183c to service context 0x95af654

4 ETW000 22638 0.036376

4 ETW000 [dev trc ,00000] Allocating user session handle 46 0.036422

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x95af654,srvhp=0x95b183c,usrhp=0x95ba3d0)

4 ETW000 41 0.036463

4 ETW000 [dev trc ,00000] Assigning user session 0x95ba3d0 to service context 0x95af654

4 ETW000 6851 0.043314

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 70 0.043384

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 179 0.043563

4 ETW000 [dev trc ,00000] Now '/@PRD' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1003 0.044566

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 38 0.044604

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 430 0.045034

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

4 ETW000 691 0.045725

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 28 0.045753

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 151 0.045904

4 ETW000 [dev trc ,00000] Rolling back transaction ... 37 0.045941

4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=0x95af654,usrhp=0x95ba3d0)

4 ETW000 230 0.046171

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 474 0.046645

4 ETW000 [dev trc ,00000] Try to connect with default password 28 0.046673

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

4 ETW000 31 0.046704

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

4 ETW000 31 0.046735

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x959f9b0 0x95afc28 0x95af6c8

4 ETW000 31 0.046766

4 ETW000 [dev trc ,00000] Assigning username to user session 0x95ba3d0 20 0.046786

4 ETW000 [dev trc ,00000] Assigning password to user session 0x95ba3d0 61 0.046847

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x95af654,srvhp=0x95b183c,usrhp=0x95ba3d0)

4 ETW000 33 0.046880

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 839 0.047719

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

4 ETW000 33 0.047752

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 20 0.047772

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 428]

4 ETW000 162 0.047934

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

4 ETW000 33 0.047967

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

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

Regards,

Varadharajan M

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi ,

Using sqlplus check that user sapsr3's account status is open or not.If not then unlock it.You are getting the error when you are retriving the password for sapsr3 .So plz check also that you are using <sid>adm user to fetch info.

For extra care you can check table sapuser also will that have any entry.?

then plz again reply after going through all above stage.

You can change the password of sapsr3 schema using brtools if still problem was there.

Hope it will help you to troubleshoot.

Regards,

Gagan Deep Kaushal

0 Kudos

Hi gagan,

Unfortunately your recommendations have nothing to do with the issue.

The problem, as mho (Michael) has stated is that the OPS$ user is not properly created/configured.

Nothing to do with sapsr3 account, between other things as the schema name is SAPPRD not the one you mentioned

Therefore, the solution is to check the mentioned note:

400241 - Problems with ops$ or sapr3 connect to Oracle

a very "quick" and very "dirty" solution is to change the password to the default one (that should not be posted here) and that way the second connection step would word.

Conclusion:

To the OP, to solve the problem follow the note

400241 - Problems with ops$ or sapr3 connect to Oracle

also, take a look at the note

562863 - FAQ: Logon mechanisms

for more information how a SAP ABAP instance connect to the oracle database

Former Member
0 Kudos

HI,

You need to start as User who belongs to DBA group, problem with user privilages, chek the note specified above.

Regards,

Raju.

Former Member
0 Kudos

R3trans tries to connect with the ops$user and fails to read the SAPUSER table:

4 ETW000 dev trc ,00000 SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 430 0.045034
4 ETW000 http://dbsloci. ,00000 *** ERROR => ORA-1403 when accessing table SAPUSER

You should start with: [400241 - Problems with ops$ or sapr3 connect to Oracle|https://service.sap.com/sap/bc/bsp/spn/sapnotes/index2.htm?numm=400241]

Best regards - Michael