Skip to Content

Disp +Work.EXE stopped

Hi All,

yesterday my system is suddenly shutdown and when i try to start from SAPMMC then the Work+Disp is first go on Running but Dialog Queue standstill, J2EE status is unvailable and then it stopped.

when i try to start SQLPLUS "/as Sysdba"

then i m receiving following message:

SQL> startup
ORACLE instance started.

Total System Global Area  679477248 bytes
Fixed Size                  2056000 bytes
Variable Size             348127424 bytes
Database Buffers          322961408 bytes
Redo Buffers                6332416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:\ORACLE\MDS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

while i have installed ECC6.0 SR3(JAVA+ABAP and MI & DI Usage Type) on Window 64 bit edition for MDSD.

how can i resolve this issue....

regards,

majamil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Dec 17, 2008 at 02:21 PM

    try this:

    sqlplus / as sysdba

    shutdown immediate;

    startup

    you should get error, now try:

    recover;

    if you get media recovery complete:

    alter database open;

    if it fails:

    recover using backup controlfile until cancel

    when finished:

    alter database open;

    now pray that it works. still failing? it's time to restore.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 09:56 AM

    please post error lines from dev_w0 from work directory

    (/usr/sap/sid/dvebmgs00/work)

    Add a comment
    10|10000 characters needed characters exceeded

    • hi Rahul,

      Dev_w0 log is

      ---------------------------------------------------
      trc file: "dev_w0", trc level: 1, release: "700"
      ---------------------------------------------------
      *
      *  ACTIVE TRACE LEVEL           1
      *  ACTIVE TRACE COMPONENTS      all, MJ
      *
      B  
      B Wed Dec 17 13:36:27 2008
      B  create_con (con_name=R/3)
      B  Loading DB library 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' ...
      B  Library 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' loaded
      B  Version of 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.144)
      B  New connection 0 created
      M sysno      00
      M sid        MDS
      M systemid   562 (PC with Windows NT)
      M relno      7000
      M patchlevel 0
      M patchno    144
      M intno      20050900
      M make:      multithreaded, Unicode, 64 bit, optimized
      M pid        2372
      M 
      M  kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)
      M  length of sys_adm_ext is 576 bytes
      M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2372) [dpxxdisp.c   1305]
      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)		25168	(1480)
      M  DpShMCreate: sizeof(tm_adm)		5652128	(28120)
      M  DpShMCreate: sizeof(wp_ca_adm)		24000	(80)
      M  DpShMCreate: sizeof(appc_ca_adm)	8000	(80)
      M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
      M  DpShMCreate: sizeof(comm_adm)		552080	(1088)
      M  DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
      M  DpShMCreate: sizeof(slock_adm)		0	(104)
      M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
      M  DpShMCreate: sizeof(file_adm)		0	(72)
      M  DpShMCreate: sizeof(vmc_adm)		0	(1864)
      M  DpShMCreate: sizeof(wall_adm)		(41664/36752/64/192)
      M  DpShMCreate: sizeof(gw_adm)	48
      M  DpShMCreate: SHM_DP_ADM_KEY		(addr: 0000000010E70050, size: 6348592)
      M  DpShMCreate: allocated sys_adm at 0000000010E70050
      M  DpShMCreate: allocated wp_adm at 0000000010E72150
      M  DpShMCreate: allocated tm_adm_list at 0000000010E783A0
      M  DpShMCreate: allocated tm_adm at 0000000010E78400
      M  DpShMCreate: allocated wp_ca_adm at 00000000113DC2A0
      M  DpShMCreate: allocated appc_ca_adm at 00000000113E2060
      M  DpShMCreate: allocated comm_adm at 00000000113E3FA0
      M  DpShMCreate: system runs without slock table
      M  DpShMCreate: system runs without file table
      M  DpShMCreate: allocated vmc_adm_list at 000000001146AC30
      M  DpShMCreate: allocated gw_adm at 000000001146ACB0
      M  DpShMCreate: system runs without vmc_adm
      M  DpShMCreate: allocated ca_info at 000000001146ACE0
      M  DpShMCreate: allocated wall_adm at 000000001146ACF0
      M  ThTaskStatus: rdisp/reset_online_during_debug 0
      X  EmInit: MmSetImplementation( 2 ).
      X  MM global diagnostic options set: 0
      X  <ES> client 0 initializing ....
      X  Using implementation view
      X  <EsNT> Using memory model view.
      M  <EsNT> Memory Reset disabled as NT default
      X  ES initialized.
      M  
      M Wed Dec 17 13:36:28 2008
      M  ThInit: running on host sapmdsd
      M  
      M Wed Dec 17 13:36:29 2008
      M  calling db_connect ...
      C  Prepending F:\usr\sap\MDS\DVEBMGS00\exe to Path.
      C  
      C Wed Dec 17 13:36:30 2008
      C  Oracle Client Version: '10.2.0.2.0'
      C  Client NLS settings: AMERICAN_AMERICA.UTF8
      C  Logon as OPS$-user to get SAPSR3's password
      C  Connecting as /@MDS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
      C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
      C    0 UTF8                                                      1 00000000138DFFA0 000000000A7FE2D0 0000000013903948
      C  Attaching to DB Server MDS (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
      C  Starting user session (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38,usrhp=000000000A7FEAE8)
      C  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
       [dboci.c      4532]
      C  Detaching from DB Server (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
      C  *** ERROR => CONNECT failed with sql error '1033'
       [dbsloci.c    11044]
      C  Try to connect with default password
      C  Connecting as SAPSR3/<pwd>@MDS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
      C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
      C    0 UTF8                                                      1 00000000138DFFA0 000000000A7FE2D0 0000000013903948
      C  Attaching to DB Server MDS (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
      C  
      C Wed Dec 17 13:36:31 2008
      C  Starting user session (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38,usrhp=000000000A7FEAE8)
      C  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
       [dboci.c      4532]
      C  Detaching from DB Server (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
      C  *** ERROR => CONNECT failed with sql error '1033'
       [dbsloci.c    11044]
      B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]
      B  ***LOG BY2=> sql error 1033   performing CON [dblink#5 @ 431] [dblink  0431 ]
      B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431] [dblink  0431 ]
      M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1440]
      M  in_ThErrHandle: 1
      M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10468]
      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    mode_cleaned_counter = 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    attachedVm = no VM
      M  
      M  *****************************************************************************
      M  *
      M  *  LOCATION    SAP-Server sapmdsd_MDS_00 on host sapmdsd (wp 0)
      M  *  ERROR       ThInit: db_connect
      M  *
      M  *  TIME        Wed Dec 17 13:36:31 2008
      M  *  RELEASE     700
      M  *  COMPONENT   Taskhandler
      M  *  VERSION     1
      M  *  RC          13
      M  *  MODULE      thxxhead.c
      M  *  LINE        10688
      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   724]
      M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  261]
      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  ***LOG Q02=> wp_halt, WPStop (Workproc 0 2372) [dpnttool.c   327]

      regards,

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 10:00 AM

    please check with the following Note 13789 - Recovery on error ORA-1113

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2008 at 01:39 PM

    The disp+work.exe canĀ“t start because your database is not coming up.

    Please check the note suggested. You may need to recover the database from a backup.

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.