cancel
Showing results for 
Search instead for 
Did you mean: 

disp+work fails

jsanghvi
Participant
0 Kudos

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'"

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

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

jsanghvi
Participant
0 Kudos

Hello,

It was an issue with the entries maintained in the /etc/hosts file.

I maintained it correctly then restarted, and it started in Green.

Thanks

Answers (1)

Answers (1)

karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Jigar,

Please check this SAP KBA 1911531  - ORA-12170 or TNS-12535 during connecting to Oracle

regards

kartik