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

[Former Member]

Hi,

Disp+work.exe has been stopped so iam not able to log in.I run the command R3trans -d then i get the

2EETW169 no connect possible: "DBMS=ORACLE ---dbs_ora_tnsname='VMD'" the this message. i stopped the SAP through MMC and stopped DB also and i tried so many times it is not working .

Please advice.

Regards,

Asif

[Former Member · Accepted solution]

ORA-27101: shared memory realm does not exist,

Are you trying reboot whole server ? Regards.

[Former Member · Accepted solution]

Hi,

Yes, i reboot the system it is working now. Iam facing the problem when i try to take back up from DB13.

for this reason iam not able to take back from last one month.

Regards,

Asif

[Former Member · Accepted solution]

Are you do the offline backup or online ? The OS are 32 or 64 bit ? How you implement backup parameters in initSID.sap ? If your first question are answered close this thread and open with correct question.

Regards.

[former_member185031]

Where is the trans.log file ? Make sure that your listner is running.

Regards,

Subhash

[Former Member]

Hi,

Listner is in running status only.

trc file: "dev_ms", trc level: 1, release: "700"

-

---

[Thr 2840] Thu Jun 11 11:39:11 2009

[Thr 2840] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 94

intno 20050900

make: multithreaded, Unicode, optimized

pid 4376

[Thr 2840] Thu Jun 11 11:39:12 2009

[Thr 2840] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 4376) [msxxserv.c 1824]

[Thr 2840] Thu Jun 11 11:39:13 2009

[Thr 2840] load acl file = E:\usr\sap\VMD\SYS\global\ms_acl_info.DAT

[Thr 2840] MsGetOwnIpAddr: my host addresses are :

[Thr 2840] 1 : [10.10.3.155] blrsap002.vmoksha.com (HOSTNAME)

[Thr 2840] 2 : [127.0.0.1] blrsap002.vmoksha.com (LOCALHOST)

[Thr 2840] MsHttpInit: full qualified hostname = blrsap002.vmoksha.com

[Thr 2840] Thu Jun 11 11:39:14 2009

[Thr 2840] HTTP logging is switch off

[Thr 2840] set HTTP state to LISTEN

[Thr 2840] MsHttpOwnDomain: own domain[1] = vmoksha.com

[Thr 2840] ms/icf_info_server : deleted

[Thr 2840] *** I listen to port sapmsVMD (3600) ***

[Thr 2840] *** I listen to internal port 3900 (3900) ***

[Thr 2840] *** HTTP port 8100 state LISTEN ***

[Thr 2840] CUSTOMER KEY: >G1790336528<

[Thr 2840] Thu Jun 11 11:40:42 2009

[Thr 2840] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from blrsap002_VMD_00 [msxxserv.c 4679]

[Thr 2840] Thu Jun 11 11:51:03 2009

[Thr 2840] *** ERROR => MsSCheckConnections: no response from client C0 (10.10.3.155) after 300 secs received [msxxserv.c 3165]

[Thr 2840] *** ERROR => MsSCheckConnections: disconnect now [10.10.3.155] [msxxserv.c 3169]

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Thu Jun 11 11:39:34 2009

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\VMD\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'E:\usr\sap\VMD\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'E:\usr\sap\VMD\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.92)

B New connection 0 created

M sysno 00

M sid VMD

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 95

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 12948

M

M kernel runs with dp version 224000(ext=109000) (@(#) DPLIB-INT-VERSION-224000-UC)

M length of sys_adm_ext is 572 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 12948) [dpxxdisp.c 1301]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 18616 (1432)

M DpShMCreate: sizeof(tm_adm) 4232256 (21056)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (96)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1520)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06060040, size: 4891728)

M DpShMCreate: allocated sys_adm at 06060040

M DpShMCreate: allocated wp_adm at 06061E80

M DpShMCreate: allocated tm_adm_list at 06066738

M DpShMCreate: allocated tm_adm at 06066768

M DpShMCreate: allocated wp_ca_adm at 0646FBA8

M DpShMCreate: allocated appc_ca_adm at 06475968

M DpShMCreate: allocated comm_adm at 064778A8

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 064F8768

M DpShMCreate: allocated gw_adm at 064F87A8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 064F87D8

M DpShMCreate: allocated wall_adm at 064F87E0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu Jun 11 11:39:35 2009

M ThInit: running on host blrsap002

M

M Thu Jun 11 11:39:36 2009

M calling db_connect ...

C Prepending E:\usr\sap\VMD\DVEBMGS00\exe to Path.

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@VMD on connection 0 (nls_hdl 0) ... (dbsl 700 030107)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05D09338 05D0E8D4 05D0E15C

C Attaching to DB Server VMD (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974)

C

C Thu Jun 11 11:39:37 2009

C Starting user session (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974,usrhp=0AAE1B48)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c 4500]

C Detaching from DB Server (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974)

C *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c 10948]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@VMD on connection 0 (nls_hdl 0) ... (dbsl 700 030107)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05D09338 05D0E8D4 05D0E15C

C Attaching to DB Server VMD (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974)

C Starting user session (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974,usrhp=0AAE1B48)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c 4500]

C Detaching from DB Server (con_hdl=0,svchp=05D0E0A8,srvhp=05D1F974)

C *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c 10948]

B ***LOG BV3=> severe db error 1034 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]

B ***LOG BY2=> sql error 1034 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01034: ORACLE not available

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

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10240]

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M vm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server blrsap002_VMD_00 on host blrsap002 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Jun 11 11:39:37 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10439

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M

M Thu Jun 11 11:39:38 2009

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 12948) [dpnttool.c 327]

[former_member185031]

Check this SAP Note 491174 : Composite SAP note for ORA-01034

Regards,

Subhash