Reply from D. Caddick on Jul 17 at 4:11 AM Hi Satish,
When you did the restore did you use the System copy guide?
Regards
| | | ---------------Original Message---------------
From: Satish Ahirkar
Sent: Thursday, July 17, 2014 3:01 AM
Subject: ORA-01017: Invalid Username/Password; Logon Denied
Dear all,
I restore the data successfully from Production to Development. The database is OPEN mode. SAPMMC is not starting. I reset the password of SAPSR3 but problem not solved.
I check the R3TRANS -d
"C:\Users\ecpadm>r3trans -d
This is r3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
unicode enabled version
R3trans=>sapparam(1c): No Profile used.
R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'ECP'"
r3trans finished (0012).:
The trans.log file
4 ETW000 r3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).
4 ETW000 unicode enabled version
4 ETW000 ===
4 ETW000
4 ETW000 date&time : 17.07.2014 - 09:28:16
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 Jul 17 09:28:16 2014 15726 0.015726
4 ETW000 [ dev trc,00000] db_con_init called 44 0.015770
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 71 0.015841
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 33 0.015874
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 22 0.015896
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 70 0.015966
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEEFD30000
4 ETW000 31790 0.047756
4 ETW000 [ dev trc,00000] using "D:\usr\sap\ECP\SYS\exe\uc\NTAMD64\dboraslib.d ll" 33 0.047789
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 29 0.047818
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 34 0.047852
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "720.00", patchlevel (0.522) 4531 0.052383
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 55 0.052438
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 202 0.052640
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 610 0.053250
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 30 0.053280
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 24 0.053304
4 ETW000 [ dev trc,00000] New connection 0 created 20 0.053324
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 43 0.053367
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 31 0.053398
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 18 0.053416
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 27 0.053443
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 20 0.053463
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 38 0.053501
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000 444 0.053945
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 1245 0.055190
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [ dev trc,00000] Register application info. 420 0.055610
4 ETW000 [ dev trc,00000] Thu Jul 17 09:28:17 2014 109435 0.165045
4 ETW000 [ dev trc,00000] Oracle client version: 10.2.0.5.0, (dbsl 720 030114, UNICODE[2]) 41 0.165086
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 27 0.165113
4 ETW000 [ dev trc,00000] Default connection: tnsname ='ECP' 23 0.165136
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 367 0.165503
4 ETW000 [ dev trc,00000] (-) OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 38962 0.204465
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=027F8578) 110 0.204575
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=027F9A18) 73 0.204648
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 3300 0.207948
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 61 0.208009
4 ETW000 [ dev trc,00000] char=55005400460031003600 28 0.208037
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 34 0.208071
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 25 0.208096
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 752 0.208848
4 ETW000 [ dev trc,00000] Connecting as /@ECP on connection 0 (nls 0) ... (dbsl 720 030114, UNICODE[2])
4 ETW000 71 0.208919
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=027F8438) 320 0.209239
4 ETW000 [ dev trc,00000] Allocating server context handle 52 0.209291
4 ETW000 [ dev trc,00000] Attaching to database server ECP (con=0, svchp=027F8438, srvhp=027FE148)
4 ETW000 96 0.209387
4 ETW000 [ dev trc,00000] Assigning server context 027FE148 to service context 027F8438 162104 0.371491
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=0280AD30) 351 0.371842
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/', svc=027F8438, srv=027FE148, usr=0280AD30)
4 ETW000 59 0.371901
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 56028 0.427929
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 242 0.428171
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 41 0.428212
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=027FE148) 39 0.428251
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=027F8438,srvhp=027FE148) detached 1665 0.429916
4 ETW000 [ dev trc,00000] Free server handle srvhp=027FE148 of con=0 46 0.429962
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '1017' 505 0.430467
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 44 0.430511
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 1017 197 0.430708
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 39 0.430747
4 ETW000 [ dev trc,00000] ocica() -> SQL error code 1017,1017 32 0.430779
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000 37 0.430816
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/
<pwd>@ECP on connection 0 (nls 0) ... (dbsl 720 030114, UNICODE[2])
4 ETW000 38 0.430854
4 ETW000 [ dev trc,00000] Allocating server context handle 24 0.430878
4 ETW000 [ dev trc,00000] Attaching to database server ECP (con=0, svchp=027F8438, srvhp=027FE148)
4 ETW000 52 0.430930
4 ETW000 [ dev trc,00000] Assigning server context 027FE148 to service context 027F8438 25206 0.456136
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=0280AD30 72 0.456208
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=0280AD30 44 0.456252
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=027F8438, srv=027FE148, usr=0280AD30)
4 ETW000 64439 0.520691
4 ETW000 [ dev trc,00000] Thu Jul 17 09:28:27 2014 10091127 10.611818
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 38 10.611856
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 197 10.612053
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 40 10.612093
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=027FE148) 31 10.612124
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=027F8438,srvhp=027FE148) detached 1274 10.613398
4 ETW000 [ dev trc,00000] Free server handle srvhp=027FE148 of con=0 41 10.613439
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '1017' 48 10.613487
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 24 10.613511
4 ETW000 [ dev trc,00000] OCIErrorGet() -> SQL error code: 1017 182 10.613693
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 42 10.613735
4 ETW000 [ dev trc,00000] ocica() -> SQL error code 1017,1017 28 10.613763
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=1017, 99=DBSL_ERR_DB 26 10.613789
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 365 10.614154
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 36 10.614190
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 250 10.614440
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 48 10.614488
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 26 10.614514
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 111 10.614625
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 27 10.614652
4 ETW000 [ dev trc,00000] -> 'OCI_10201_SHARE, 10.2.0.5.0' 24 10.614676
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ECP'"
Thanks & Best Regards,
Satish |
| Reply to this email to post your response. __.____._ |   _.____.__ |
