Skip to Content
0
Oct 23, 2013 at 10:38 AM

disp+work fails

227 Views

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