Dispatcher stopped due to shared memory realm does not exist in Oracle 10g

[Former Member]

Hi Gurus,

Suddenly my Message server stopped, i have checked R3trans -d its givign following message

D:\>R3trans -d

This is R3trans version 6.14 (release 700 - 12.12.08 - 14:04:00).

unicode enabled version

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

R3trans finished (0012).

So i have restarted the server, now message server started then Dispatcher has been stopped again error is same here i am pasting trans.log file

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

4 ETW000 44375 1.224660

4 ETW000 dev trc ,00000 server_detach(con_hdl=0,stale=1,svrhp=02F07EDC) 23 1.224683

4 ETW000 dev trc ,00000 Detaching from DB Server (con_hdl=0,svchp=02EF47E8,srvhp=02F07EDC)

4 ETW000 32 1.224715

4 ETW000 dev trc ,00000 Deallocating server context handle 02F07EDC 688 1.225403

4 ETW000 http://dbsloci. ,00000 *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 49 1.225452

4 ETW000 dev trc ,00000 set_ocica() -> OCI or SQL return code 1034 25 1.225477

4 ETW000 dev trc ,00000 Try to connect with default password 74 1.225551

4 ETW000 dev trc ,00000 Connecting as SAPSR3/<pwd>@CHE on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 62 1.225613

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

4 ETW000 37 1.225650

4 ETW000 dev trc ,00000 0 UTF8 1 02EEF9E0 02EF5014 02EF489C

4 ETW000 38 1.225688

4 ETW000 dev trc ,00000 Allocating server context handle 19 1.225707

4 ETW000 dev trc ,00000 Attaching to DB Server CHE (con_hdl=0,svchp=02EF47E8,srvhp=02F07EDC)

4 ETW000 43 1.225750

4 ETW000 dev trc ,00000 Assigning server context 02F07EDC to service context 02EF47E8

4 ETW000 14810 1.240560

4 ETW000 dev trc ,00000 Assigning username to user session 02F1BC88 28 1.240588

4 ETW000 dev trc ,00000 Assigning password to user session 02F1BC88 29 1.240617

4 ETW000 dev trc ,00000 Starting user session (con_hdl=0,svchp=02EF47E8,srvhp=02F07EDC,usrhp=02F1BC88)

4 ETW000 38 1.240655

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

4 ETW000 49161 1.289816

4 ETW000 dev trc ,00000 server_detach(con_hdl=0,stale=1,svrhp=02F07EDC) 30 1.289846

4 ETW000 dev trc ,00000 Detaching from DB Server (con_hdl=0,svchp=02EF47E8,srvhp=02F07EDC)

4 ETW000 73 1.289919

4 ETW000 dev trc ,00000 Deallocating server context handle 02F07EDC 828 1.290747

4 ETW000 http://dbsloci. ,00000 *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 108 1.290855

4 ETW000 dev trc ,00000 set_ocica() -> OCI or SQL return code 1034 22 1.290877

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

4 ETW000 21113 1.311990

4 ETW000 dblink ,00431 ***LOG BY0=>ORA-01034: ORACLE not available 30 1.312020

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

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

[Former Member]

I have solved this problem, by decreasing parameter shared_pool_size value in init<SID>.ora file and restart the database then it has been started

Regards

Chandra

[Former Member]

Is this your system ABAP+JAVA?

As i'm too getting this problem in AS Java, R3trans -d does fail with RC-12.

But all other my applications are running fine, So need to know the exact reason for same, so any help in this will be appreciated.

[Former Member]

Hi Chndra

I am facing the sam problem, nd i have seen your ans , I an decreasing parameter shared_pool_size value , but dispatcher is not started, it is stoped??

so plz help me

[Former Member]

hey can you paste the dispatcher and message server logs mostly the lines containin errors.

Regards,

ram