r/3 server work process error

[Former Member]

hi!

i have 4.7e and oracle 8i in my machine. and i was used past 5 months.

now when i start sap server, the work process will show 'ended'. why?

and following error message will created.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Thu Apr 12 13:42:56 2007

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' ...

B

B Thu Apr 12 13:43:02 2007

B Library 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\ABC\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)

B New connection 0 created

M

M Thu Apr 12 13:43:03 2007

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 674

M intno 20020600

M pid 2372

M

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

I MtxInit: -2 0 0

M

M Thu Apr 12 13:43:05 2007

M DpShMCreate: sizeof(wp_adm) 9776 (752)

M DpShMCreate: sizeof(tm_adm) 1690816 (8412)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 001E0040, size: 1974816)

M DpShMCreate: allocated sys_adm at 001E0040

M DpShMCreate: allocated wp_adm at 001E0560

M DpShMCreate: allocated tm_adm_list at 001E2B90

M DpShMCreate: allocated tm_adm at 001E2BB8

M DpShMCreate: allocated wp_ca_adm at 0037F878

M DpShMCreate: allocated appc_ca_adm at 00383EC8

M DpShMCreate: allocated comm_adm_list at 00385638

M DpShMCreate: allocated comm_adm at 00385650

M DpShMCreate: allocated ca_info at 003B4450

M DpShMCreate: allocated wall_adm at 003B4458

X

X Thu Apr 12 13:43:08 2007

X EmInit: MmSetImplementation( 2 ).

X

X Thu Apr 12 13:43:23 2007

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C

C Thu Apr 12 13:43:34 2007

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C

C Thu Apr 12 13:47:05 2007

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C

C Thu Apr 12 13:47:07 2007

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

C Connecting as /@ABC on connection 0 ...

C Attaching to DB Server ABC (con_hdl=0,svchp=0401CE1C,svrhp=06D74A54)

C

C Thu Apr 12 13:47:52 2007

C Starting user session (con_hdl=0,svchp=0401CE1C,srvhp=06D74A54,usrhp=06D7D22C)

C

C Thu Apr 12 13:47:55 2007

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

[dboci.c 3718]

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

[dboci.c 9601]

C Try to connect with default password

C Connecting as SAPABC/<pwd>@ABC on connection 0 ...

C Starting user session (con_hdl=0,svchp=0401CE1C,srvhp=06D74A54,usrhp=06D7D22C)

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

[dboci.c 3718]

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

[dboci.c 9601]

B

B Thu Apr 12 13:47:56 2007

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

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

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server abc_ABC_00 on host abc (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Thu Apr 12 13:47:56 2007

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8569

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M

M Thu Apr 12 13:47:57 2007

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

kindly give me solution.

thanks and regards

raghubalan

[Former Member]

Hi

Does the memory settings wrong which leads to it.

Do you have enough disk space and memory to have those many work processess.

hope these question helps you to decide the error.