Skip to Content
author's profile photo Former Member
Former Member

Work process is in Run status , unable to login to SAP

Dear All,

Suddenly my Dev server went down,

Workprocess turn to status Run , and dispatcher status says,Running But Dialog Queue Stand Still ; J2EE : sysnchronizing Binary.

It is unable to attach the database,

Database displays connected.

Please see the dev_wo file..

===========================================================================

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Mon Dec 24 18:27:26 2007

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.102)

B New connection 0 created

M sysno 00

M sid DEV

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 102

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 2300

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 2300) [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) 17184 (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: 060B0040, size: 4890296)

M DpShMCreate: allocated sys_adm at 060B0040

M DpShMCreate: allocated wp_adm at 060B1E80

M DpShMCreate: allocated tm_adm_list at 060B61A0

M DpShMCreate: allocated tm_adm at 060B61D0

M DpShMCreate: allocated wp_ca_adm at 064BF610

M DpShMCreate: allocated appc_ca_adm at 064C53D0

M DpShMCreate: allocated comm_adm at 064C7310

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 065481D0

M DpShMCreate: allocated gw_adm at 06548210

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06548240

M DpShMCreate: allocated wall_adm at 06548248

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 Mon Dec 24 18:27:27 2007

M ThInit: running on host ECC6DEV

M

M Mon Dec 24 18:27:28 2007

M calling db_connect ...

C Prepending C:\usr\sap\DEV\DVEBMGS00\exe to Path.

C

C Mon Dec 24 18:27:29 2007

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 /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 010307)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05DF7758 05DFCCF4 05DFC57C

C Attaching to DB Server DEV (con_hdl=0,svchp=05DFC4C8,srvhp=05E0BE94)

==========================================================================================================================================================

Please advice which is very urgent ,

Regards,

SM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 24, 2007 at 03:53 PM

    Hello,

    >> It is unable to attach the database, Database displays connected.

    What do you mean with database displays connected?

    Are you able to login by SQLPLUS over SQLNET - please try the following as sap or oracle user:

    >sqlplus SAPSR3@DEV

    Please post the last lines from the alert.log.

    If i understand you right.. your sap system ran and it crashed. Now you try to restart it and you stuck at this point, right?

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Ulrich,

      as he wrote at his beginning thread and as we already figured out there is a problem with SQLNET. A sqlplus over ethernet is also not working. So no need to have a look at the disp+work processes.

      BTW. the work process is not getting any connection to the database much less the password for SAPSR3 .. i quote the corresponding lines from the beginning post.

      >>C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 010307)

      >>C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

      >>C 0 UTF8 1 05DF7758 05DFCCF4 05DFC57C

      >>C Attaching to DB Server DEV (con_hdl=0,svchp=05DFC4C8,srvhp=05E0BE94)

      As i already said... we need the listener and the client traces otherwise i am not able to help you.

      Regards

      Stefan

  • Posted on Dec 26, 2007 at 12:10 PM

    Hi,

    most times when I have seen such a problem it is an archiver stuck. Can you refer to your ORACLE Alert file and check for write failure in the archive processes?

    Check the filesystem for ORACLE Archive logs. If this happens, all changeing transactions will be hanging until this archiver stuck is fixed.

    Regrads Ulrich

    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.