on 10-23-2013 11:38 AM
Hello,
I have installed Oracle databse 11.2.0.3 and SAP EHP6
After installation system started successfully but next day when I check the system , it dont start.
My database is Up and running.
I have upgraded my kernel to the latest Patch
R3trans -d fails
4 ETW000 r3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 23.10.2013 - 12:16:17
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] Wed Oct 23 12:16:18 2013 100 0.000100
4 ETW000 [ dev trc,00000] db_con_init called 38 0.000138
4 ETW000 [ dev trc,00000] set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used 41 0.000179
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 30 0.000209
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 18 0.000227
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ... 36 0.000263
4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dboraslib.dll"), hdl 0, addr 000007FEEB940000
4 ETW000 525 0.000788
4 ETW000 [ dev trc,00000] using "D:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dboraslib.dll" 17 0.000805
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded 18 0.000823
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dboraslib.dll 18 0.000841
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "720.00", patchlevel (0.327) 150 0.000991
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dboraslib.dll 24 0.001015
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dboraslib.dll 34 0.001049
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000 183 0.001232
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 20 0.001252
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 19 0.001271
4 ETW000 [ dev trc,00000] New connection 0 created 15 0.001286
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 38 0.001324
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 21 0.001345
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 14 0.001359
4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000 24 0.001383
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 15 0.001398
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 34 0.001432
4 ETW000 [ dev trc,00000] -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000 106 0.001538
4 ETW000 [ dev trc,00000] DIR_CLIENT_ORAHOME is not set as profile nor env. parameter. 210 0.001748
4 ETW000 Assuming using instant client with unspecified location.
4 ETW000 [ dev trc,00000] Register application info. 73 0.001821
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, (dbsl 720 291112, UNICODE[2]) 8939 0.010760
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available. 38 0.010798
4 ETW000 [ dev trc,00000] Default connection: tnsname ='DEV' 21 0.010819
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000 41 0.010860
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 23059 0.033919
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=03B4B478) 57 0.033976
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=03B4C708) 39 0.034015
4 ETW000 [ dev trc,00000] NLS env. settings: lang=41004D00450052004900430041004E00 93 0.034108
4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 25 0.034133
4 ETW000 [ dev trc,00000] char=55005400460031003600 20 0.034153
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 28 0.034181
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 18 0.034199
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 28 0.034227
4 ETW000 [ dev trc,00000] Connecting as /@DEV on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])
4 ETW000 30 0.034257
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=03B52520) 29 0.034286
4 ETW000 [ dev trc,00000] Allocating server context handle 21 0.034307
4 ETW000 [ dev trc,00000] Attaching to database server DEV (con=0, svchp=03B52520, srvhp=03B526C0)
4 ETW000 49 0.034356
4 ETW000 [ dev trc,00000] Wed Oct 23 12:16:39 2013 21141091 21.175447
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 31 21.175478
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12170: 154 21.175632
4 ETW000 [ dev trc,00000] ORA-12170: TNS:Connect timeout occurred
4 ETW000 38 21.175670
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '12170' 30 21.175700
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 12170 21 21.175721
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12170) 18 21.175739
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 12170 95 21.175834
4 ETW000 [ dev trc,00000] ORA-12170: TNS:Connect timeout occurred
4 ETW000 38 21.175872
4 ETW000 [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=12170. 24 21.175896
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 20 21.175916
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 12170 performing CON 49 21.175965
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-12170: TNS:Connect timeout occurred 22 21.175987
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 24 21.176011
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 25 21.176036
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 19 21.176055
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 54 21.176109
4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 20 21.176129
4 ETW000 [ dev trc,00000] -> 'OCI_11201_SHARE, 11.2.0.3.0' 19 21.176148
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 31 21.175478
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12170: 154 21.175632
4 ETW000 [ dev trc,00000] ORA-12170: TNS:Connect timeout occurred
4 ETW000 38 21.175670
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '12170'
Check whether the sqlnet.ora is configured properly.
1911531 - ORA-12170 or TNS-12535 during connecting to Oracle
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jigar,
Please check this SAP KBA 1911531 - ORA-12170 or TNS-12535 during connecting to Oracle
regards
kartik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.