Reply from govardhanreddy70 on Mar 9 at 2:06 AM HI Experts,
I have checked in the database the user itself is not present in the database and when I am trying to change the password.
| | | ---------------Original Message---------------
From: govardhanreddy70
Sent: Friday, March 06, 2015 4:08 AM
Subject: Java Portal Central Instance is Down
Hi Team,
We have Netweaver 7.2 standalone Java portal with Oracle 11.* database server in Windows 2008 R2 server OS.
We have an issue with the central instance of the java portal when which is not getting bring up and i have done the below work around.
>Database up and running fine
>Dialog instance and other portal system which is connected to same database are running fine.
>I have run the R3trans -d and found the below trans.log details.
4 ETW000 r3trans version 6.24 (release 721 - 08.05.14 - 16:50:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 05.03.2015 - 10:33:45
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] Thu Mar 05 10:33:46 2015 176 0.000176
4 ETW000 [ dev trc,00000] db_con_init called 85 0.000261
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 86 0.000347
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 146 0.000493
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 35 0.000528
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 67 0.000595
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEDA670000
4 ETW000 45776 0.046371
4 ETW000 [ dev trc,00000] using "F:\usr\sap\NJE\SYS\exe\uc\NTAMD64\dboraslib.d ll" 23 0.046394
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 25 0.046419
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 22 0.046441
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "721.02", patchlevel (0.224) 160 0.046601
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 33 0.046634
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 48 0.046682
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 457 0.047139
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 29 0.047168
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 23 0.047191
4 ETW000 [ dev trc,00000] New connection 0 created 17 0.047208
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 47 0.047255
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 105 0.047360
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 23 0.047383
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 28 0.047411
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 19 0.047430
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 39 0.047469
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='721')
4 ETW000 121 0.047590
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 424 0.048014
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [ dev trc,00000] Register application info. 185 0.048199
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, (dbsl 721 140314, UNICODE[2]) 93766 0.141965
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 43 0.142008
4 ETW000 [ dev trc,00000] Default connection: tnsname ='NJE' 23 0.142031
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 41 0.142072
4 ETW000 [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 51694 0.193766
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=025DB0B8) 91 0.193857
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=025DC348) 62 0.193919
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 139 0.194058
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 38 0.194096
4 ETW000 [ dev trc,00000] char=55005400460031003600 25 0.194121
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 32 0.194153
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 26 0.194179
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPR3's password 225 0.194404
4 ETW000 [ dev trc,00000] Connecting as /@NJE on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])
4 ETW000 47 0.194451
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=025E2160) 46 0.194497
4 ETW000 [ dev trc,00000] Allocating server context handle 28 0.194525
4 ETW000 [ dev trc,00000] Attaching to database server NJE (con=0, svchp=025E2160, srvhp=025E2300)
4 ETW000 88 0.194613
4 ETW000 [ dev trc,00000] Thu Mar 05 10:34:17 2015 31134679 31.329292
4 ETW000 [ dev trc,00000] Assigning server context 025E2300 to service context 025E2160 46 31.329338
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=025F1200) 104 31.329442
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=025E2160, srv=025E2300, usr=025F1200)
4 ETW000 42 31.329484
4 ETW000 [ dev trc,00000] Assigning user session usrhp=025F1200 to service context svchp=025E2160
4 ETW000 29676 31.359160
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected 77 31.359237
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=39,stp=025EF198) 27 31.359264
4 ETW000 [ dev trc,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 167 31.359431
4 ETW000 [ dev trc,00000] - oci_define ( 0: SQLT_INT , l= 4, con=0, stp=025EF198, pv=0217E6D0, in=0217E6D4,rl=,rc=)
4 ETW000 126 31.359557
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected, new transaction 89 31.359646
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#1: con=0,stp=025EF198,itr=1,off=0,bat=0) 29 31.359675
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=025E2160, errhp=025DB0B8): [dur. 0,000s]
4 ETW000 34 31.359709
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,001s] 1529 31.361238
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,001s] 53 31.361291
4 ETW000 [ dev trc,00000] Now '/@NJE' is connected: con=0, nls=0, session=597, time='2015-03-05 10:34:17'
4 ETW000 75 31.361366
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected 37 31.361403
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=33,stp=025EF198) 23 31.361426
4 ETW000 [ dev trc,00000] ALTER SESSION SET NLS_SORT=BINARY
4 ETW000 34 31.361460
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected, new transaction 45 31.361505
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#2: con=0,stp=025EF198,itr=1,off=0,bat=0) 25 31.361530
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=025E2160, errhp=025DB0B8): [dur. 0,000s]
4 ETW000 56 31.361586
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,001s] 911 31.362497
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,001s] 47 31.362544
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected 77 31.362621
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=59,stp=025EF198) 30 31.362651
4 ETW000 [ dev trc,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)
4 ETW000 35 31.362686
4 ETW000 [ dev trc,00000] - oci_bind ( 0: SQLT_STR , l=256, con=0, stp=025EF198, pv=0217EB10, in=,rl=,rc=)
4 ETW000 79 31.362765
4 ETW000 [ dev trc,00000] - oci_bind ( 1: SQLT_STR , l=256, con=0, stp=025EF198, pv=0217E540, in=,rl=,rc=)
4 ETW000 88 31.362853
4 ETW000 [ dev trc,00000] - oci_define ( 0: SQLT_STR , l=514, con=0, stp=025EF198, pv=0217E750, in=0217E098,rl=,rc=)
4 ETW000 48 31.362901
4 ETW000 [ dev trc,00000] - oci_define ( 1: SQLT_AFC , l=514, con=0, stp=025EF198, pv=0217E330, in=0217E094,rl=,rc=)
4 ETW000 54 31.362955
4 ETW000 [ dev trc,00000] time 2015-03-05 10:34:17, con=0 not connected, new transaction 37 31.362992
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#3: con=0,stp=025EF198,itr=1,off=0,bat=0) 24 31.363016
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=025E2160, errhp=025DB0B8): [dur. 0,000s]
4 ETW000 32 31.363048
4 ETW000 [ dev trc,00000] OCIStmtExecute() failed with -1=OCI_ERROR 1997 31.365045
4 ETW000 [ dev trc,00000] SQL error 942: 41 31.365086
4 ETW000 [ dev trc,00000] ORA-00942: table or view does not exist
4 ETW000 38 31.365124
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,002s] 23 31.365147
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=942, iters-errors = 1-0) [dur. 0,002s] 24 31.365171
4 ETW000 [dbsloci.c ,00000] *** ERROR => ORA-942 when accessing table SAPUSER 39 31.365210
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=942) 26 31.365236
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 942 142 31.365378
4 ETW000 [ dev trc,00000] ORA-00942: table or view does not exist
4 ETW000 41 31.365419
4 ETW000 [ dev trc,00000] ocica() -> SQL error code 942,942 22 31.365441
4 ETW000 [ dev trc,00000] Disconnecting from connection 0 ... 21 31.365462
4 ETW000 [ dev trc,00000] Rolling back transaction 25 31.365487
4 ETW000 [ dev trc,00000] Closing user session (con=0, svc=025E2160, usr=025F1200) 551 31.366038
4 ETW000 [ dev trc,00000] Disconnected (con=0) from ORACLE. 856 31.366894
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=942, try to connect with default password.
4 ETW000 56 31.366950
4 ETW000 [ dev trc,00000] Connecting as SAPR3/<pwd>@NJE on connection 0 (nls 0) ... (dbsl 721 140314, UNICODE[2])
4 ETW000 36 31.366986
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=025F1200 28 31.367014
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=025F1200 60 31.367074
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPR3', svc=025E2160, srv=025E2300, usr=025F1200)
4 ETW000 219 31.367293
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 8848 31.376141
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 155 31.376296
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 38 31.376334
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=025E2300) 105 31.376439
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=025E2160,srvhp=025E2300) detached 1161 31.377600
4 ETW000 [ dev trc,00000] Free server handle srvhp=025E2300 of con=0 45 31.377645
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '1017' 45 31.377690
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 21 31.377711
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 1017 128 31.377839
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 37 31.377876
4 ETW000 [ dev trc,00000] ocica() -> SQL error code 1017,1017 21 31.377897
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=1017, 99=DBSL_ERR_DB 22 31.377919
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 53 31.377972
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 27 31.377999
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 24 31.378023
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 21 31.378044
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 22 31.378066
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 54 31.378120
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 22 31.378142
4 ETW000 [ dev trc,00000] -> 'OCI_10201_SHARE, 11.2.0.3.0' 21 31.378163
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'NJE'"
It seems SAPR3 user is getting access denied so I have checked in the database but it is not available in dba_users.
Please suggest here. the system has been down for 2 days.
Regards
Govardhan |
| Reply to this email to post your response. __.____._ |   _.____.__ |
