on 11-08-2012 12:56 PM
Hello team,
I change the sys password and then stopsap all successfully ,then use the startsap all to start it show me the error.
Could you pls help me to resolve it?
Thanks,
Neil
linux-neil:cjcadm 55> startsap all
Checking NEL Database
Database is not available via R3trans
-------------------------------------------
Trying to start NEL database ...
Log file: /home/cjcadm/startdb.log
/usr/sap/CJC/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
please send the tracefile /home/cjcadm/startsap.trc to support
linux-neil:cjcadm 56> R3trans -x
This is R3trans version 6.22 (release 720 - 19.08.11 - 15:45:00).
unicode enabled version
2EETW152 Cannot open file "trans.log".
: Permission denied
R3trans finished (0012).
linux-neil:cjcadm 57>
Please attach the trans.log file from directory which you run R3trans from.
Regards,
Roman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
4 ETW000 R3trans version 6.22 (release 720 - 19.08.11 - 15:45:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 08.11.2012 - 21:42:59
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Thu Nov 8 21:42:59 2012 14567 0.014567
4 ETW000 [ dev trc,00000] db_con_init called 200 0.014767
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 28 0.014795
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 28 0.014823
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 13 0.014836
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/CJC/SYS/exe/run/dboraslib.so' ... 60 0.014896
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/CJC/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 7765 0.022661
4 ETW000 [ dev trc,00000] Library '/usr/sap/CJC/SYS/exe/run/dboraslib.so' loaded 20 0.022681
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/CJC/SYS/exe/run/dboraslib.so
4 ETW000 25 0.022706
4 ETW000 [ dev trc,00000] Version of '/usr/sap/CJC/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.102)
4 ETW000 59 0.022765
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/CJC/SYS/exe/run/dboraslib.so
4 ETW000 24 0.022789
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/CJC/SYS/exe/run/dboraslib.so
4 ETW000 49 0.022838
4 ETW000 [ dev trc,00000] New connection 0 created 16 0.022854
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 32 0.022886
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 14 0.022900
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 18 0.022918
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 11 0.022929
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 24 0.022953
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', userid='[default usr]')
4 ETW000 92 0.023045
4 ETW000 [ dev trc,00000] Register application info. 7031 0.030076
4 ETW000 [ dev trc,00000] Oracle client version: 10.2.0.5.0, V2, default build, (dbsl 720 260811, UNICODE[2])
4 ETW000 1672 0.031748
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 50 0.031798
4 ETW000 [ dev trc,00000] # Patch 9445675 : Created on 17 Jun 2011, 12:52:27 hrs PST8PDT
4 ETW000 30 0.031828
4 ETW000 [ dev trc,00000] # Patch 12419392 : Created on 29 May 2011, 22:29:59 hrs PST8PDT
4 ETW000 27 0.031855
4 ETW000 [ dev trc,00000] # Patch 11799748 : Created on 23 Feb 2011, 09:18:13 hrs CET 51 0.031906
4 ETW000 [ dev trc,00000] # Patch 10431010 : Created on 14 Jan 2011, 14:57:58 hrs PST8PDT
4 ETW000 26 0.031932
4 ETW000 [ dev trc,00000] # Patch 10144882 : Created on 29 Mar 2011, 22:35:43 hrs PST8PDT
4 ETW000 30 0.031962
4 ETW000 [ dev trc,00000] Default connection: tnsname ='NEL' 20 0.031982
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16'),uc_ln=2 31 0.032013
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 2290 0.034303
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=2e4fe18) 41 0.034344
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=2e650c8) 36 0.034380
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 122 0.034502
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 42 0.034544
4 ETW000 [ dev trc,00000] char=55005400460031003600 26 0.034570
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 25 0.034595
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 15 0.034610
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 33 0.034643
4 ETW000 [ dev trc,00000] Connecting as /@NEL on connection 0 (nls 0) ... (dbsl 720 260811, UNICODE[2])
4 ETW000 28 0.034671
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=2e4fd48) 37 0.034708
4 ETW000 [ dev trc,00000] Allocating server context handle 18 0.034726
4 ETW000 [ dev trc,00000] Attaching to database server NEL (con=0, svchp=2e4fd48, srvhp=2e687c8)
4 ETW000 58 0.034784
4 ETW000 [ dev trc,00000] Assigning server context 2e687c8 to service context 2e4fd48 29150 0.063934
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=2e9de90) 68 0.064002
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=2e4fd48, srv=2e687c8, usr=2e9de90)
4 ETW000 23 0.064025
4 ETW000 [ dev trc,00000] Assigning user session 2e9de90 to service context 2e4fd48 14955 0.078980
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:42:59, con=0 not connected 709 0.079689
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=39,stp=2e73408) 33 0.079722
4 ETW000 [ dev trc,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 20 0.079742
4 ETW000 [ dev trc,00000] - oci_define ( 0: SQLT_INT , l= 4, con=0, stp=2e73408, pv=7fffdd3dea88, in=7fffdd3dea8e,rl=0000NULL,rc=0000NULL)
4 ETW000 86 0.079828
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:42:59, con=0 not connected, new transaction 47 0.079875
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#1: con=0,stp=2e73408,itr=1,off=0,bat=0) 15 0.079890
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=2e4fd48, errhp=2e4fe18): [dur. 0,000s] 15 0.079905
4 ETW000 [ dev trc,00000] Thu Nov 8 21:43:00 2012 775 0.080680
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,001s] 21 0.080701
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,001s] 14 0.080715
4 ETW000 [ dev trc,00000] Now '/@NEL' is connected: con=0, nls=0, session_id=18. 40 0.080755
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:43:00, con=0 not connected 31 0.080786
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=33,stp=2e72380) 15 0.080801
4 ETW000 [ dev trc,00000] ALTER SESSION SET NLS_SORT=BINARY
4 ETW000 16 0.080817
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:43:00, con=0 not connected, new transaction 30 0.080847
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#2: con=0,stp=2e72380,itr=1,off=0,bat=0) 15 0.080862
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=2e4fd48, errhp=2e4fe18): [dur. 0,000s] 13 0.080875
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 241 0.081116
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 22 0.081138
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:43:00, con=0 not connected 32 0.081170
4 ETW000 [ dev trc,00000] -->oci_prepare_stmt(con=0,len=59,stp=2e72380) 15 0.081185
4 ETW000 [ dev trc,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)
4 ETW000 16 0.081201
4 ETW000 [ dev trc,00000] - oci_bind ( 0: SQLT_STR , l=256, con=0, stp=2e72380, pv=7fffdd3e06c0, in=0000NULL,rl=0000NULL,rc=0000NULL)
4 ETW000 50 0.081251
4 ETW000 [ dev trc,00000] - oci_bind ( 1: SQLT_STR , l=256, con=0, stp=2e72380, pv=7fffdd3def20, in=0000NULL,rl=0000NULL,rc=0000NULL)
4 ETW000 46 0.081297
4 ETW000 [ dev trc,00000] - oci_define ( 0: SQLT_STR , l=512, con=0, stp=2e72380, pv=7fffdd3ded20, in=7fffdd3df39e,rl=0000NULL,rc=0000NULL)
4 ETW000 25 0.081322
4 ETW000 [ dev trc,00000] - oci_define ( 1: SQLT_AFC , l=512, con=0, stp=2e72380, pv=7fffdd3deb20, in=7fffdd3df39c,rl=0000NULL,rc=0000NULL)
4 ETW000 46 0.081368
4 ETW000 [ dev trc,00000] time 2012.11.08. 21:43:00, con=0 not connected, new transaction 23 0.081391
4 ETW000 [ dev trc,00000] -->oci_execute_stmt(#3: con=0,stp=2e72380,itr=1,off=0,bat=0) 15 0.081406
4 ETW000 [ dev trc,00000] before OCIStmtExecute(svchp=2e4fd48, errhp=2e4fe18): [dur. 0,000s] 12 0.081418
4 ETW000 [ dev trc,00000] after OCIStmtExecute(rpc=0): [dur. 0,000s] 422 0.081840
4 ETW000 [ dev trc,00000] <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,000s] 22 0.081862
4 ETW000 [ dev trc,00000] Got SAPSR3's password from OPS$-user 135 0.081997
4 ETW000 [ dev trc,00000] Disconnecting from connection 0 ... 14 0.082011
4 ETW000 [ dev trc,00000] Rolling back transaction 18 0.082029
4 ETW000 [ dev trc,00000] Closing user session (con=0, svc=2e4fd48, usr=2e9de90) 1341 0.083370
4 ETW000 [ dev trc,00000] Disconnected (con=0) from ORACLE. 540 0.083910
4 ETW000 [ dev trc,00000] Connect as 'SAPSR3' with found password from table SAPUSER 20 0.083930
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@NEL on connection 0 (nls 0) ... (dbsl 720 260811, UNICODE[2])
4 ETW000 21 0.083951
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 2e9de90 12 0.083963
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=2e9de90 28 0.083991
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=2e4fd48, srv=2e687c8, usr=2e9de90)
4 ETW000 264 0.084255
4 ETW000 [ dev trc,00000] Thu Nov 8 21:43:02 2012 2010660 2.094915
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 92 2.095007
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 346 2.095353
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 83 2.095436
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 164 2.095600
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 84 2.095684
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 49 2.095733
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 222 2.095955
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 70 2.096025
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 59 2.096084
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 132 2.096216
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 51 2.096267
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'NEL'"
Please change the password for SAPSR3 user (SAP must be stopped) with:
> brconnect -u system/<password> -f chpass -o SAPSR3 -p <password>
For more info please read Note 400241 - Problems with ops$ or sapr3 connect to Oracle and 1576837 - ORA-01017: invalid username/password;
Regards,
Roman
linux-neil:cjcadm 93> brconnect -u system/12345 -f chpass -o sapsr3 -p 12345 ;
BR0801I BRCONNECT 7.20 (23)
BR0280I BRCONNECT time stamp: 2012-11-08 22.50.38
BR0828I Changing password for database user SAPSR3
BR0280I BRCONNECT time stamp: 2012-11-08 22.50.38
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
c
BR0280I BRCONNECT time stamp: 2012-11-08 22.50.58
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRCONNECT time stamp: 2012-11-08 22.50.59
BR0829I Password changed successfully in database for user SAPSR3
BR0830I Password changed successfully in table OPS$CJCADM.SAPUSER for user SAPSR3
BR0280I BRCONNECT time stamp: 2012-11-08 22.50.59
BR0802I BRCONNECT completed successfully
issue resolved.thanks a lot!
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.