ORA-27101: shared memory realm does not exist

[Former Member]

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

[JPReyes · Accepted solution]

This can happen when the ORACLE_SID is not defined or incorrectly defined in the env variables.

Check all the Oracle related variables and let us know.

Regards

Juan

[Former Member]

Hello Pankaj,

Try starting Oracle database from SQL plus using orasid as user and then start SAP

Refer to Note 491174 and perform all the tests as mentioned

You will be able to solve it

Let me know if it helps

Rohit