on 10-28-2008 3:32 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
HI,
You need to start as User who belongs to DBA group, problem with user privilages, chek the note specified above.
Regards,
Raju.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.