Skip to Content
0
Former Member
Feb 19, 2009 at 09:18 PM

ORA-27101: shared memory realm does not exist

2116 Views

Hi all

I have a problem related to sap xi-7.0 server.

when I start server than dispature is not started . and the trans file show these problem , i am past the this trans file ,

so plz solve this problem,

4 ETW000 R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 20.02.2009 - 01:11:50

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] Fri Feb 20 01:11:52 2009 3963 0.003963

4 ETW000 [dev trc ,00000] db_con_init called 710 0.004673

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 71 0.004932

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 74699 0.079631

4 ETW000 [dev trc ,00000] using "D:\usr\sap\D10\SYS\exe\uc\NTI386\dboraslib.dll"

4 ETW000 75 0.079706

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 19 0.079725

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

4 ETW000 22 0.079747

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

4 ETW000 5493 0.085240

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

4 ETW000 42 0.085282

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

4 ETW000 91 0.085373

4 ETW000 [dev trc ,00000] New connection 0 created 59 0.085432

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 32 0.085464

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

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

4 ETW000 17 0.085524

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 21 0.085545

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

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 9668 0.095213

4 ETW000 [dev trc ,00000] Fri Feb 20 01:11:54 2009 1849124 1.944337

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 58 1.944395

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 1.944418

4 ETW000 [dev trc ,00000] Fri Feb 20 01:11:55 2009 511982 2.456400

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 59 2.456459

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

4 ETW000 [dev trc ,00000] Connecting as /@D10 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 44 2.456521

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

4 ETW000 39103 2.495624

4 ETW000 [dev trc ,00000] 0 UTF8 1 0241DCB8 024231EC 02422A74

4 ETW000 31 2.495655

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

4 ETW000 [dev trc ,00000] Allocating server context handle 47 2.527404

4 ETW000 [dev trc ,00000] Attaching to DB Server D10 (con_hdl=0,svchp=024229C0,svrhp=02434234)

4 ETW000 230 2.527634

4 ETW000 [dev trc ,00000] Fri Feb 20 01:12:01 2009 5281432 7.809066

4 ETW000 [dev trc ,00000] Assigning server context 02434234 to service context 024229C0

4 ETW000 67 7.809133

4 ETW000 [dev trc ,00000] Allocating user session handle 56 7.809189

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=024229C0,srvhp=02434234,usrhp=0246F9C8)

4 ETW000 2370 7.811559

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 656067 8.467626

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=02434234) 16 8.467642

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=024229C0,srvhp=02434234)

4 ETW000 19 8.467661

4 ETW000 [dev trc ,00000] Deallocating server context handle 02434234 23932 8.491593

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

4 ETW000 64 8.491657

4 ETW000 [dev trc ,00000] Try to connect with default password 83 8.491740

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

4 ETW000 21 8.491761

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

4 ETW000 21 8.491782

4 ETW000 [dev trc ,00000] 0 UTF8 1 0241DCB8 024231EC 02422A74

4 ETW000 21 8.491803

4 ETW000 [dev trc ,00000] Allocating server context handle 48 8.491851

4 ETW000 [dev trc ,00000] Attaching to DB Server D10 (con_hdl=0,svchp=024229C0,svrhp=02434234)

4 ETW000 35 8.491886

4 ETW000 [dev trc ,00000] Fri Feb 20 01:12:02 2009 458152 8.950038

4 ETW000 [dev trc ,00000] Assigning server context 02434234 to service context 024229C0

4 ETW000 56 8.950094

4 ETW000 [dev trc ,00000] Assigning username to user session 0246F9C8 17 8.950111

4 ETW000 [dev trc ,00000] Assigning password to user session 0246F9C8 35 8.950146

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=024229C0,srvhp=02434234,usrhp=0246F9C8)

4 ETW000 24 8.950170

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 234917 9.185087

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=02434234) 799 9.185886

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=024229C0,srvhp=02434234)

4 ETW000 42 9.185928

4 ETW000 [dev trc ,00000] Deallocating server context handle 02434234 1364 9.187292

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

4 ETW000 61 9.187353

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

4 ETW000 10170 9.197523

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

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

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