on 02-18-2013 12:38 PM
Hello Folks,
We have system where dual stack is installed
Now ABAP system is working fine but JAVA is down.
When i checked R3trans -d from SIDADM(javasidadm) user i am RC=12.
Here is log
4 ETW000 R3trans version 6.19 (release 720 - 06.04.10 - 16:31:00 with UA1430.1 / prepared for CSN 1287305).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 18.02.2013 - 05:57:47
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Feb 18 05:57:47 2013 5308 0.005308
4 ETW000 [dev trc ,00000] db_con_init called 741 0.006049
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 8555 0.014604
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 19 0.014623
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 749 0.015372
4 ETW000 [dev trc ,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEEE9A0000
4 ETW000 26683 0.042055
4 ETW000 [dev trc ,00000] using "E:\usr\sap\CSJ\SYS\exe\uc\NTAMD64\dboraslib.dll" 17 0.042072
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 12 0.042084
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll 14 0.042098
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "720.00", patchlevel (0.34) 11499 0.053597
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll 26 0.053623
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll 489 0.054112
4 ETW000 [dev trc ,00000] New connection 0 created 537 0.054649
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 720 0.055369
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 26 0.055395
4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 16 0.055411
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection: 10 0.055421
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000 20 0.055441
4 ETW000 [dev trc ,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 10437 0.065878
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [dev trc ,00000] oci_init1(ArrayBufSize=130000) 270 0.066148
4 ETW000 [dev trc ,00000] Mon Feb 18 05:57:48 2013 173128 0.239276
4 ETW000 [dev trc ,00000] Oracle Client Version: 10.2.0.4.0 4262 0.243538
4 ETW000 [dev trc ,00000] Detailed Oracle client and patch info not available. 25 0.243563
4 ETW000 [dev trc ,00000] Default connection: tnsname ='CH2' 14 0.243577
4 ETW000 [dev trc ,00000] -->oci_initialize(con=0, char='', nchar='') 48 0.243625
4 ETW000 [dev trc ,00000] application info callback registered 16 0.243641
4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 93548 0.337189
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0000000003B6AAD0) 33 0.337222
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0000000003B6C288) 19 0.337241
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 18653 0.355894
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0, 'AMERICAN_AMERICA.UTF8'
4 ETW000 36 0.355930
4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 11 0.355941
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 204 0.356145
4 ETW000 [dev trc ,00000] Connecting as /@CH2 on connection 0 (nls_hdl 0) ... (dbsl 720 280110)
4 ETW000 51 0.356196
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet Env Err ErrBt
4 ETW000 27 0.356223
4 ETW000 [dev trc ,00000] 0 UTF8 0000000003B62FE0 0000000003B6AAD0 0000000003B6C288
4 ETW000 20 0.356243
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=0000000003B6C148) 1427 0.357670
4 ETW000 [dev trc ,00000] Allocating server context handle 20 0.357690
4 ETW000 [dev trc ,00000] Attaching to database server CH2 (con=0, svchp=0000000003B6C148, srvhp=0000000003B72DD8)
4 ETW000 35 0.357725
4 ETW000 [dev trc ,00000] Assigning server context 0000000003B72DD8 to service context 0000000003B6C148
4 ETW000 86107 0.443832
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=0000000003B7F9C0) 2187 0.446019
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con=0, usr='/',svc=0000000003B6C148, srv=0000000003B72DD8, usr=0000000003B7F9C0)
4 ETW000 29 0.446048
4 ETW000 [dev trc ,00000] Assigning user session 0000000003B7F9C0 to service context 0000000003B6C148
4 ETW000 64062 0.510110
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 18199 0.528309
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con=0, len=39, stp=0000000003B7D870); AI=,0,, 21 0.528330
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 20 0.528350
4 ETW000 [dev trc ,00000] - oci_define ( 0: SQLT_INT , l= 4, con=0, stp=0000000003B7D870, vp=000000000202EA00,ip=000000000202EA04,rlp=0000000000000000,rcp=0000000000000000)
4 ETW000 5316 0.533666
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 625 0.534291
4 ETW000 [dev trc ,00000] -->oci_execute_stmt(con=0, stp=0000000003B7D870, iters=1, rowoff=0, dml_batch_err=0)
4 ETW000 25 0.534316
4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=0000000003B6C148, errhp=0000000003B6AAD0): [dur. 0,000s]
4 ETW000 19 0.534335
4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 4921 0.539256
4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 22 0.539278
4 ETW000 [dev trc ,00000] Connected to session 160. 20 0.539298
4 ETW000 [dev trc ,00000] Now '/@CH2' is connected: con=0, nls=0, session_id=160. 14 0.539312
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 24 0.539336
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con=0, len=33, stp=0000000003B7D870); AI=,0,, 15 0.539351
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT=BINARY
4 ETW000 19 0.539370
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 22 0.539392
4 ETW000 [dev trc ,00000] -->oci_execute_stmt(con=0, stp=0000000003B7D870, iters=1, rowoff=0, dml_batch_err=0)
4 ETW000 20 0.539412
4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=0000000003B6C148, errhp=0000000003B6AAD0): [dur. 0,000s]
4 ETW000 18 0.539430
4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 196 0.539626
4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 21 0.539647
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 33 0.539680
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con=0, len=59, stp=0000000003B7D870); AI=,0,, 17 0.539697
4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)
4 ETW000 19 0.539716
4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR , l=256, con=0, stp=0000000003B7D870, progv=000007FEEED1DF76, indp=0000000000000000,rlen=0000000000000000,rcode=0000000000000000)
4 ETW000 37 0.539753
4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR , l=256, con=0, stp=0000000003B7D870, progv=000000000202E880, indp=0000000000000000,rlen=0000000000000000,rcode=0000000000000000)
4 ETW000 5335 0.545088
4 ETW000 [dev trc ,00000] - oci_define ( 0: SQLT_STR , l=512, con=0, stp=0000000003B7D870, vp=000000000202EA80,ip=000000000202E3D8,rlp=0000000000000000,rcp=0000000000000000)
4 ETW000 31 0.545119
4 ETW000 [dev trc ,00000] - oci_define ( 1: SQLT_AFC , l=512, con=0, stp=0000000003B7D870, vp=000000000202E680,ip=000000000202E3DC,rlp=0000000000000000,rcp=0000000000000000)
4 ETW000 29 0.545148
4 ETW000 [dev trc ,00000] time 2013.02.18. 05:57:48 19 0.545167
4 ETW000 [dev trc ,00000] -->oci_execute_stmt(con=0, stp=0000000003B7D870, iters=1, rowoff=0, dml_batch_err=0)
4 ETW000 19 0.545186
4 ETW000 [dev trc ,00000] before OCIStmtExecute(svchp=0000000003B6C148, errhp=0000000003B6AAD0): [dur. 0,000s]
4 ETW000 18 0.545204
4 ETW000 [dev trc ,00000] OCIStmtExecute() failed with -1=OCI_ERROR 1174 0.546378
4 ETW000 [dev trc ,00000] SQL error 942: 19 0.546397
4 ETW000 [dev trc ,00000] ORA-00942: table or view does not exist
4 ETW000 19 0.546416
4 ETW000 [dev trc ,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 13 0.546429
4 ETW000 [dev trc ,00000] <--oci_execute_stmt(rc=942, iters-errors = 1-0) [dur. 0,000s] 13 0.546442
4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER 732 0.547174
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 942 32 0.547206
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con=0, rc=942) 12 0.547218
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 942 32 0.547250
4 ETW000 [dev trc ,00000] ORA-00942: table or view does not exist
4 ETW000 21 0.547271
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 11 0.547282
4 ETW000 [dev trc ,00000] Rolling back transaction ... 13 0.547295
4 ETW000 [dev trc ,00000] Closing user session (con=0, svc=0000000003B6C148, usr=0000000003B7F9C0)
4 ETW000 3278 0.550573
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 944 0.551517
4 ETW000 [dev trc ,00000] Info: 99=DBSL_ERR_DB, oerr=942, try to connect with default password.
4 ETW000 25 0.551542
4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@CH2 on connection 0 (nls_hdl 0) ... (dbsl 720 280110)
4 ETW000 18 0.551560
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet Env Err ErrBt
4 ETW000 20 0.551580
4 ETW000 [dev trc ,00000] 0 UTF8 0000000003B62FE0 0000000003B6AAD0 0000000003B6C288
4 ETW000 20 0.551600
4 ETW000 [dev trc ,00000] Assigning username to user session: con=0, usrhp= 0000000003B7F9C0 19 0.551619
4 ETW000 [dev trc ,00000] Assigning password to user session: con=0, usrhp=0000000003B7F9C0 20 0.551639
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con=0, usr='SAPR3', svc=0000000003B6C148, srv=0000000003B72DD8, usr=0000000003B7F9C0)
4 ETW000 19324 0.570963
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 8232 0.579195
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 43 0.579238
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 22 0.579260
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 15 0.579275
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 11 0.579286
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con=0, rc=1017) 11 0.579297
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 29 0.579326
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 19 0.579345
4 ETW000 [dev trc ,00000] DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB 12 0.579357
4 ETW000 [dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 33 0.579390
4 ETW000 [dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 13 0.579403
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CH2'"
i have changed password of SAPSR3 through brtools but noluck.
Please suggest.
Regards
Mano
Hello
It looks like a Logon group issue to me.
Check whether there is Logon group called PUBLIC defined in Tx SMLG.
Open Config tool and check whether the value for the parameter ume.r3.connection.master.group is PUBLIC.
Reference link:
http://help.sap.com/saphelp_nw70/helpdata/en/84/10594aecd3e1408845e66c432b955e/content.htm
Regarding the password change:
You need to update the password for the Java schema user under the secure store area in the config tool.
There are two password fields present:
One is for the admin user connecting to the ABAP stack mainly J2EE_ADMIN and the other is for the SAPSR3DB user.
Make sure you update the passwords in the right fields.
Cheers
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manojar,
To make sure your java stack schema password is updated, you should change it directly at the database level, and update the new one in the configTool. You can use the steps bellow:
- on the database server as <sid>adm or ora<sid> (for UNIX/Linux):
sqlplus / as sysdba
alter user SAPSR3DB identified by <new_passwd>;
exit;
Then update the configTool with the newly updated password.
Best regards,
Thiago
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mano,
you cannot check the availability of a Java DB with R3trans. Try "startsap check" instead (executed as javasidadm).
Regards,
Werner
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Werner,
My ABAP stack is running fine.
But Java server process is down.
[Thr 12680] Mon Feb 18 08:18:15 2013
[Thr 12680] JHVM_RegisterNatives: com.sap.mw.rfc.driver.CpicDriver
[Thr 12680] *** ERROR => JRFC> Error jrfc_lg LgGroup failed(-6) [jrfclg.c 384]
[Thr 12680] *** ERROR => mshost: cscsdcsap17, msserv: sapmsCH2, r_group: PUBLIC [jrfclg.c 385]
[Thr 12368] JLaunchIExitJava: exit hook is called (rc = -11113)
[Thr 12368] **********************************************************************
[Thr 12368] *** ERROR => The Java VM terminated with a non-zero exit code.
[Thr 12368] *** Please see SAP Note 943602 , section 'J2EE Engine exit codes'
[Thr 12368] *** for additional information and trouble shooting.
[Thr 12368] **********************************************************************
[Thr 12368] JLaunchCloseProgram: good bye (exitcode = -11113)
Regards
Mano
Hi,
For SAP Java, you need to check the DB connection using Configtool. Go to /usr/sap/<SID>/<instance>/j2ee/configtool -> execute ./consoleconfig.sh and post the result.
If the issue is with the password credentials then update it in the Secure storage of configtool.
Hope it helps.
Regards,
Mudasir.
Hi Mano,
SAPnote 943602 is mentioned in your error text, and this note leads to 940893. SAPnote 940893 says that in case of "The Java VM terminated with a non-zero exit code", you have to send the complete content of the working directory of the respective node to SAP support - for example, \usr\sap\SID\inst<No>\j2ee\cluster\server0\log\system\server0.log.
Bad luck, I think.
Regards,
Werner
Hi,
Your return code 1113 states that your username and password is invalid.
Please perform the following actions and check whether it works.
1. Please login to your ABAP system and check whether the user J2ee_admin or SAPJSF is locked. if it is locked, please unlock it and try again.
2. Have you changed the password for your java schema SAPSR3DB, then you need to update the new password in your config tool.
You can verify whether the passowrd is the issue, please open the config tool and there you can see only the secstore option.. If yes, then it is 99% password wrong update in your config tool.. Update the new password and try to start the Ssytem ... It will work.
Please check and provide your feedback.
Thanks and Regards,
Vimal
Hi Mano,
> i have changed password of SAPSR3 through brtools but noluck.
.. ok that's nice, but useless because R3trans still uses the ABAP schema owner SAPR3 (works as designed).
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con=0, usr='SAPR3', svc=0000000003B6C148, srv=0000000003B72DD8, usr=0000000003B7F9C0)
...
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
> Now ABAP system is working fine but JAVA is down.
> When i checked R3trans -d from SIDADM(javasidadm) user i am RC=12.
The Java connect mechanism works completely different. It uses a Secure Storage.
http://help.sap.com/saphelp_nw70ehp2/helpdata/de/cd/14c93ec2f7df6ae10000000a114084/content.htm
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.