cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP EHP 1 for SAP Solution Manager 7.0---Event Viewer --Application Error

prasad_shetty2
Explorer

on ‎01-14-2011 11:06 AM

0 Kudos

Hi Guru's,

My system which is SAP EHP 1 for SAP Solution Manager 7.0 has few Errors . I would like to highlight the Application Error :

ERROR :

Faulting application dispwork.EXE, version 7010.117.18.21287, faulting module dispwork.EXE, version 7010.117.18.21287, fault address 0x000000000034efba.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I want a path forward / approach to solve ths issue.

I would like to post my trans - d logs and dev logs for reference :

Fri Jan 14 10:25:42 2011

A ABAP ShmAdm attached (addr=000007DFDEDB7000 leng=20955136 end=000007DFE01B3000)

A >> Shm MMADM area (addr=000007DFDF25FF00 leng=247168 end=000007DFDF29C480)

A >> Shm MMDAT area (addr=000007DFDF29D000 leng=15818752 end=000007DFE01B3000)

A RFC Destination> destination q4de3gsy051_SM1_00 host q4de3gsy051 system SM1 systnr 0 (q4de3gsy051_SM1_00)

A RFC Options> H=q4de3gsy051,S=00,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 35354 bytes at 000000000FFC0050

N SsfSapSecin: putenv(SECUDIR=D:\usr\sap\SM1\DVEBMGS00\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF library is D:\usr\sap\SM1\DVEBMGS00\exe\sapsecu.dll .

N ===...SSF default hash algorithm is SHA1 .

N ===...SSF default symmetric encryption algorithm is DES-CBC .

N ===...SECUDIR="D:\usr\sap\SM1\DVEBMGS00\sec"

N ===...loading of Security Toolkit successfully completed.

N === SAPSECULIB Version 5.4.28M-6

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 701, [7010.0.117.20020600]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [24]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E Enqueue Info: rdisp/wp_no_enq=1, rdisp/enqname=<empty>, assume q4de3gsy051_SM1_00

E Profile-Parameter: enque/deque_wait_answer = FALSE

E Profile-Parameter: enque/sync_dequeall = 0

E

E Fri Jan 14 10:25:44 2011

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

A

A Fri Jan 14 10:25:45 2011

A **GENER Trace switched off ***

M SecAudit(RsauShmInit): WP attached to existing shared memory.

M SecAudit(RsauShmInit): addr of SCSA........... = 0000000002F60050

M SecAudit(RsauShmInit): addr of RSAUSHM........ = 0000000002F607C0

M SecAudit(RsauShmInit): addr of RSAUSLOTINFO... = 0000000002F60800

M SecAudit(RsauShmInit): addr of RSAUSLOTS...... = 0000000002F6080C

M

M Fri Jan 14 10:25:47 2011

M SosICreateNewAnchorArray: sos_search_anchor_semantics = 1

B

B Fri Jan 14 10:25:50 2011

B table logging switched off for all clients

B

B Fri Jan 14 10:26:13 2011

B dbmyclu : info : my major identification is 170021928, minor one 0.

B dbmyclu : info : Time Reference is 1.12.2001 00:00:00h GMT.

B dbmyclu : info : my initial uuid is E01FC0508D01E3F19F69005056952F2B.

B dbmyclu : info : current optimistic cluster level: 0

B dbmyclu : info : pessimistic reads set to 2.

M

M Fri Jan 14 10:26:34 2011

M rdisp/rb_cleaned_rfc = 0

M Deactivate ASTAT hyper index locking

A

A Fri Jan 14 10:26:56 2011

A RFC FRFC> fallback on the central gateway q4de3gsy051.m1.sl-si.com sapgw00 activ

M

M Fri Jan 14 10:28:05 2011

M ThEMsgArrived: sysmsg_for_rfc = 0

M

M Fri Jan 14 10:28:35 2011

M ThIUsrDel: th_rollback_usrdelentry = 1

S

S Fri Jan 14 10:29:52 2011

S found spool memory service RSPO-ACTIONS at 0000000028E7A350

Edited by: prasad shetty on Jan 14, 2011 12:06 PM

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

prasad_shetty2
Explorer
‎02-02-2011 11:55 AM
0 Kudos

Hi,

We were using the latest Kernel,just followed n-1 kernel method . One level less now its working fine.

Regards,

Prasad Shetty

Show replies
Show replies
prasad_shetty2
Explorer
‎01-14-2011 1:37 PM
0 Kudos

Hi,

yes i can connect to databse manually

Show replies
Show replies
JPReyes
Active Contributor
‎01-14-2011 3:17 PM
0 Kudos

This sounds weird, do you have more than 1 system in the box?... does the user you logged on with has the env variables pointing to the right DB SID?...

Regards

Juan

prasad_shetty2
Explorer
‎01-14-2011 12:55 PM
0 Kudos

Hi Markus,

Wow..

No my Databse is working fine so is my system no issues.

Its only this event viewer is showing this error and its troubling me with so much errors.

Regards,

Prasad Shetty

Show replies
Show replies
Former Member
‎01-14-2011 1:31 PM
0 Kudos

Are you able to connect to oracle manually with sqlplus?

prasad_shetty2
Explorer
‎01-14-2011 11:10 AM
0 Kudos

My r3trans - d o/p is :

4 ETW000 r3trans version 6.14 (release 701 - 05.03.09 - 08:28:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 09.02.2010 - 11:06:40

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] Tue Feb 09 11:06:43 2010 12913 0.012913

4 ETW000 [dev trc ,00000] db_con_init called 75 0.012988

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 1054 0.014042

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 94 0.014136

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0, addr 0000000186C70000 29566 0.043702

4 ETW000 [dev trc ,00000] using "D:\usr\sap\SM1\SYS\exe\uc\NTAMD64\dboraslib.dll" 76 0.043778

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 23 0.043801

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll 46 0.043847

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.38) 409 0.044256

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll 20 0.044276

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll 87 0.044363

4 ETW000 [dev trc ,00000] New connection 0 created 81 0.044444

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 40 0.044484

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 120 0.044604

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 19 0.044623

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 35 0.044658

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or 21915 0.066573

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 327664 0.394237

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 74 0.394311

4 ETW000 [dev trc ,00000] application info callback registered 20 0.394331

4 ETW000 [dev trc ,00000] Tue Feb 09 11:06:44 2010 273970 0.668301

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 42 0.668343

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 25903 0.694246

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 46 0.694292

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 19 0.694311

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 171 0.694482

4 ETW000 [dev trc ,00000] Connecting as /@SM1 on connection 0 (nls_hdl 0) ... (dbsl 701 270309)

4 ETW000 75 0.694557

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 8585 0.703142

4 ETW000 [dev trc ,00000] 0 UTF8 0000000005C74E00 0000000005C7D030 0000000005C7E7F8

4 ETW000 37 0.703179

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 979 0.704158

4 ETW000 [dev trc ,00000] Allocating server context handle 4583 0.708741

4 ETW000 [dev trc ,00000] Attaching to DB Server SM1 (con_hdl=0,svchp=0000000005C7E6B8,srvhp=0000000005C7EF38)

4 ETW000 163 0.708904

4 ETW000 [dev trc ,00000] Assigning server context 0000000005C7EF38 to service context 0000000005C7E6B8

4 ETW000 384946 1.093850

4 ETW000 [dev trc ,00000] Allocating user session handle 12642 1.106492

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000005C7E6B8, srvhp=0000000005C7EF38, usrhp=0000000005C7D848)

4 ETW000 144 1.106636

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 87291 1.193927

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 212 1.194139

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 157 1.194296

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0000000005C7EF38) 33 1.194329

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000005C7E6B8,srvhp=0000000005C7EF38)

4 ETW000 48 1.194377

4 ETW000 [dev trc ,00000] Deallocating server context handle 0000000005C7EF38 from con_hdl=0 2258 1.196635

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034' 206 1.196841

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1034 6292 1.203133

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1034) 55 1.203188

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1034 105 1.203293

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 32 1.203325

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 [dev trc ,00000] Try to connect with default password 39 1.203364

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@SM1 on connection 0 (nls_hdl 0) ... (dbsl 701 270309)

4 ETW000 40 1.203404

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 67 1.203471

4 ETW000 [dev trc ,00000] 0 UTF8 0000000005C74E00 0000000005C7D030 0000000005C7E7F8

4 ETW000 38 1.203509

4 ETW000 [dev trc ,00000] Allocating server context handle 53 1.203562

4 ETW000 [dev trc ,00000] Attaching to DB Server SM1 (con_hdl=0,svchp=0000000005C7E6B8,srvhp=0000000005C7EF38)

4 ETW000 61 1.203623

4 ETW000 [dev trc ,00000] Assigning server context 0000000005C7EF38 to service context 0000000005C7E6B8

4 ETW000 71203 1.274826

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0000000005C7D848

4 ETW000 47 1.274873

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0000000005C7D848

4 ETW000 80 1.274953

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000005C7E6B8, srvhp=0000000005C7EF38, usrhp=0000000005C7D848)

4 ETW000 118 1.275071

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 45508 1.320579

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 119 1.320698

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 26 1.320724

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0000000005C7EF38) 30 1.320754

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000005C7E6B8,srvhp=0000000005C7EF38)

4 ETW000 30 1.320784

4 ETW000 [dev trc ,00000] Deallocating server context handle 0000000005C7EF38 from con_hdl=0 2098 1.322882

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034' 96 1.322978

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1034 31 1.323009

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1034) 152 1.323161

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1034 162 1.323323

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 32 1.323355

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 431] 16924 1.340279

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 66 1.340345

4 ETW000 ORA-27101: shared memory realm does not exist [dblink#3 @ 431]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SM1'"

Show replies
Show replies
markus_doehr2
Active Contributor
‎01-14-2011 11:17 AM
0 Kudos

> 4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 157 1.194296

Your database is not started - or crashed.

Check the Oracle alert<SID>.log

Markus

Former Member
‎01-14-2011 12:38 PM
0 Kudos

Check Oracle listener service started or not

Ask a Question