disp_work.exe getting stopped

[Former Member]

Dear Gurus,

iam working with SAP 4.7, when iam starting the MMC the message server is getting started but disp_work.exe is getting stopped and the in the workprocess table all status showing ie ended..

please help me to solve this

The error i have seen in

\usr\sap\IDE\DVEBMGS00\work\dev_w0

Thu Mar 12 09:39:53 2009

C Starting user session (con_hdl=0,svchp=06D98ED8,srvhp=06D98CE4,usrhp=06DABB9C)

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

[dboci.c 3718]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPIDE/<pwd>@IDE on connection 0 ...

C Starting user session (con_hdl=0,svchp=06D98ED8,srvhp=06D98CE4,usrhp=06DABB9C)

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

[dboci.c 3718]

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

[dboci.c 9536]

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

B ***LOG BY2=> sql error 1034 performing CON [dblink#1 @ 419] [dblink 0419 ]

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

ORA-27101: shared memory realm does not exist [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxh

[tim_buchholz · Accepted solution]

Dear Venkat,

the work processes are not able to connect to the database. So please make sure that the

database is up and running. You might want to try

R3trans -d

to see if the database can be reached by the <SID>adm user (you will have to do this as

<SID>adm).

Regards,

Tim

[Former Member]

Hi,

Please check alert log file & listner service.

If your Oracle service is down, start it in Windows services.

Please check below link & SAP notes, it may help you.

Note 491174 - Composite SAP note for ORA-01034

Note 1183000 - Errors: "ORA-01034: ORACLE not available" and "ORA-27123

Thanks,

Sushil

[Former Member]

Hi

Check is your listner server is up and running or not

login as <sid>adm

sqlplus "/as sysdba"

>lsnrctl status

if it is not up start the service

>lsnrctl start

Regards

Uday

[former_member603052]

Hi Venkat,

Check the database is up and in read write mode.

SQL> select open_mode from v$database;

Regards,

Kalyan

[former_member187565]

Hi,

First do one thing Stop the DB.Stop all instances through MMC, Restart the machine,now start the instances thru MMC..

Now check whether its working or not.