on 08-13-2014 6:30 AM
Hi,
R3trans -dx finished with (0012)
Platform HP- UX 11.31 Service Guard Cluster
Sap Netweaver PI7.3 SPS008 Kernel 720 Patch 500
Oracle 11.2.0 is up and all users are open
4 ETW000 R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 13.08.2014 - 10:28:10
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -dx
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Wed Aug 13 10:28:10 2014 633 0.000633
4 ETW000 [ dev trc,00000] db_con_init called 28 0.000661
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
4 ETW000 168 0.000829
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 37 0.000866
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 47 0.000913
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/UPP/SYS/exe/run/dboraslib.so' ... 119 0.001032
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/UPP/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 63338 0.064370
4 ETW000 [ dev trc,00000] Library '/usr/sap/UPP/SYS/exe/run/dboraslib.so' loaded 49 0.064419
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 245 0.064664
4 ETW000 [ dev trc,00000] Version of '/usr/sap/UPP/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.425)
4 ETW000 956 0.065620
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 65 0.065685
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 235 0.065920
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 94 0.066014
4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 51 0.066065
4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 51 0.066116
4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/UPP/SYS/exe/run/dboraslib.so
4 ETW000 49 0.066165
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 91 0.066256
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 30 0.066286
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 30 0.066316
4 ETW000 [ dev trc,00000] New connection 0 created 25 0.066341
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 240 0.066581
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 35 0.066616
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 25 0.066641
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 35 0.066676
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 23 0.066699
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 54 0.066753
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 31 0.066784
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0
4 ETW000 79 0.066863
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 34 0.066897
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 41 0.066938
4 ETW000 ==> Using default key set to get connect info from ssfs
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 45 0.066983
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 77 0.067060
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 7072 0.074132
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/UPP/SYS/global/security/rsecssfs/data/SSFS_UPP.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 1433 0.075565
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/UPP/SYS/global/security/rsecssfs/key/SSFS_UPP.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 622 0.076187
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]
4 ETW000 394 0.076581
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs
4 ETW000 37 0.076618
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 25 0.076643
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 33 0.076676
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 31 0.076707
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 112 0.076819
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/UPP/SYS/global/security/rsecssfs/data/SSFS_UPP.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 402 0.077221
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/UPP/SYS/global/security/rsecssfs/key/SSFS_UPP.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 271 0.077492
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message available>) [rsecssfs.c 915]
4 ETW000 240 0.077732
4 ETW000 [ dev trc,00000] read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs
4 ETW000 117 0.077849
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 23 0.077872
4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2
4 ETW000 34 0.077906
4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 858] 31 0.077937
4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 3998]
4 ETW000 76 0.078013
4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/UPP/SYS/global/security/rsecssfs/data/SSFS_UPP.DAT" opened for read [rsecssfs.c 2359]
4 ETW000 402 0.078415
4 ETW000 [ dev trc,00000] RSecSSFs: Key file "/usr/sap/UPP/SYS/global/security/rsecssfs/key/SSFS_UPP.KEY" not found, using default key [rsecssfs.c 1279]
4 ETW000 252 0.078667
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
4 ETW000 68 0.078735
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage) [rsecssfs.c 915]
4 ETW000 218 0.078953
4 ETW000 [ dev trc,00000] read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 : Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage
4 ETW000 42 0.078995
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 23 0.079018
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=0, type=0, env='[default env]', usr='SAPSR3', kernel dbsl='720')
4 ETW000 1468 0.080486
4 ETW000 [ dev trc,00000] Register application info. 412 0.080898
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.2.0, V1, default build, (dbsl 720 090813, UNICODE[2])
4 ETW000 265 0.081163
4 ETW000 [ dev trc,00000] Installed Oracle client patches: 130 0.081293
4 ETW000 [ dev trc,00000] # Patch 9930315 : Created on 3 Nov 2010, 01:32:38 hrs PST8PDT
4 ETW000 42 0.081335
4 ETW000 [ dev trc,00000] # Patch 10302309 : Created on 23 Nov 2010, 12:10:03 hrs CET 35 0.081370
4 ETW000 [ dev trc,00000] Default connection: tnsname ='UPP' 32 0.081402
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 110 0.081512
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 115440 0.196952
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=6000000002387888) 183 0.197135
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=60000000023ac348) 38 0.197173
4 ETW000 [ dev trc,00000] NLS env. settings: lang=0041004D00450052004900430041004E 429 0.197602
4 ETW000 [ dev trc,00000] terr=0041004D00450052004900430041 51 0.197653
4 ETW000 [ dev trc,00000] char=00550054004600310036 45 0.197698
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 44 0.197742
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 30 0.197772
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@UPP on connection 0 (nls 0) ... (dbsl 720 090813, UNICODE[2])
4 ETW000 103 0.197875
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=60000000023877a8) 159 0.198034
4 ETW000 [ dev trc,00000] Allocating server context handle 34 0.198068
4 ETW000 [ dev trc,00000] Attaching to database server UPP (con=0, svchp=60000000023877a8, srvhp=60000000023ad6f0)
4 ETW000 115 0.198183
4 ETW000 [ dev trc,00000] Assigning server context 60000000023ad6f0 to service context 60000000023877a8
4 ETW000 92091 0.290274
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=6000000002483fb0) 257 0.290531
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=6000000002483fb0 39 0.290570
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=6000000002483fb0 69 0.290639
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=60000000023877a8, srv=60000000023ad6f0, usr=6000000002483fb0)
4 ETW000 1386 0.292025
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 12483 0.304508
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 245 0.304753
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 89 0.304842
4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,srvhp=60000000023ad6f0) 167 0.305009
4 ETW000 [ dev trc,00000] Server handle (con=0,svchp=60000000023877a8,srvhp=60000000023ad6f0) detached
4 ETW000 842 0.305851
4 ETW000 [ dev trc,00000] Free server handle srvhp=60000000023ad6f0 of con=0 30 0.305881
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 126 0.306007
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 56 0.306063
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 31 0.306094
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 108 0.306202
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 45 0.306247
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=1017, 99=DBSL_ERR_DB 40 0.306287
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 169 0.306456
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 37 0.306493
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 88 0.306581
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 36 0.306617
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 31 0.306648
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 89 0.306737
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 64 0.306801
4 ETW000 [ dev trc,00000] -> 'OCI_102, 11.2.0.2.0, V1, default build' 34 0.306835
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'UPP'"
Thansks & Regards
Yogesh Parthe
Thanks All of you,
Currently I disable ssf mechanism. Issue resolved.
Thanks & Regards
Yogesh Parthe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yogesh.
According to the trans.log SSFS is used:
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information
BUT DB_CON_ENV is empty.
4 ETW000 [ dev trc,00000] RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [rsecssfs.c 2381]
ALSO there is a problem with the user password maintained there.
Use 'rsecssfx list' to get the content of the SecureStorage and change the values to the ones that maintained in the database.
Note can help you further:
1639578 SSFS as password storage for primary database connect
Regards,
János
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Any Kernel update/Oracle client update took place?
Check the status of schema owner and try to connect using sqlplus (Using Id/Password).
Take a look at SAP Notes 400241 an 50088.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yogesh,
Since the SSFS is implemented in the system, it seems like the password saved in the secure file is not correct.
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 126 0.306007
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 56 0.306063
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 31 0.306094
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 108 0.306202
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
In case you are aware of the password kindly change the password of the database user using the following command:
rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD ********
Also, kindly check the SSFS configuration using the below blog:
Regards,
Meenu Hans
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
check you may connect to wrong database
check your ORACLE_HOME
check your envernamental variable ORACLE_SID
check your java_version upgrade it
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
follow this link
your user may get lock unlock the user
select username,account_status from dba_users;
there you some user locked unlock that by
alter system user(lockuser) unlock;
http://www.dba-oracle.com/t_ora_01017.htm
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.