cancel
Showing results for 
Search instead for 
Did you mean: 

work+disp stopped 1033 - dp_Fatal_error

Former Member
0 Kudos

Hi,

have a big problem. Starting the SAP System. This morning I tried to logon to the SAp System and it does not work. after starting the server disp+work will be stopped after about one minute.

I stopped the database and restarted it successfully. The error message remains.

The Problem occured after an admin has created an image from a harddrive. I read that my error can come from renaming the harddisk. I cannot exclude that possibility completely - the problem is I do not know the original name of the drive and teh admin is not sure about nothing ....

Any idea how we could possibly get the system running again. here the error logs of dev_disp, dev_rd and dev_w0

********************************************************************DEV_DISP**************

-


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

-


Tue Apr 22 13:00:33 2008

kernel runs with dp version 6(ext=1) (@(#) DPLIB-INT-VERSION-6)

length of sys_adm_ext is 304 bytes

systemid 560 (PC with Windows NT)

relno 6200

patchlevel 0

patchno 1027

intno 20020600

pid 3284

***LOG Q00=> DpSapEnvInit, DPStart (00 3284) [dpxxdisp.c 1006]

shared lib "dw_xml.dll" version 1027 successfully loaded

shared lib "dw_xtc.dll" version 1027 successfully loaded

shared lib "dw_stl.dll" version 1027 successfully loaded

Tue Apr 22 13:00:38 2008

      • WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3426]

MtxInit: -2 0 0

DpShMCreate: sizeof(wp_adm) 6048 (756)

DpShMCreate: sizeof(tm_adm) 1691616 (8416)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 192000 (384)

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

DpShMCreate: SHM_DP_ADM_KEY (addr: 05FE0040, size: 1972096)

DpShMCreate: allocated sys_adm at 05FE0040

DpShMCreate: allocated wp_adm at 05FE0630

DpShMCreate: allocated tm_adm_list at 05FE1DD0

DpShMCreate: allocated tm_adm at 05FE1DF8

DpShMCreate: allocated wp_ca_adm at 0617EDD8

DpShMCreate: allocated appc_ca_adm at 06183428

DpShMCreate: allocated comm_adm_list at 06184B98

DpShMCreate: allocated comm_adm at 06184BB0

DpShMCreate: allocated ca_info at 061B39B0

DpShMCreate: allocated wall_adm at 061B39B8

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation std

<EsNT> Memory Reset enabled as NT default

<EsNT> EsIUnamFileMapInit: Initialize the memory 600 MB

<ES> 599 blocks reserved for free list.

ES initialized.

***LOG Q0K=> DpMsAttach, mscon ( hjmuellersap) [dpxxdisp.c 9222]

3012: CCMS: Initalizing shared memory of size 20000000 for monitoring segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6200, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 941]

DpMsgAdmin: Set patchno for this platform to 1027

Release check o.K.

Tue Apr 22 13:01:18 2008

      • ERROR => W0 (pid 3092) died [dpxxdisp.c 11608]

      • ERROR => W1 (pid 3068) died [dpxxdisp.c 11608]

      • ERROR => W2 (pid 3084) died [dpxxdisp.c 11608]

      • ERROR => W3 (pid 3096) died [dpxxdisp.c 11608]

      • ERROR => W4 (pid 3500) died [dpxxdisp.c 11608]

      • ERROR => W5 (pid 3244) died [dpxxdisp.c 11608]

      • ERROR => W6 (pid 3528) died [dpxxdisp.c 11608]

      • ERROR => W7 (pid 3388) died [dpxxdisp.c 11608]

my types changed after wp death/restart 0xbf --> 0x80

      • DP_FATAL_ERROR => DpEnvCheck: no more work processes

      • DISPATCHER EMERGENCY SHUTDOWN ***

DpModState: change server state from STARTING to SHUTDOWN

Tue Apr 22 13:01:26 2008

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9448]

MBUF state OFF

MBUF component DOWN

***LOG Q05=> DpHalt, DPStop ( 3284) [dpxxdisp.c 7982]

***************************************************************************DEV_RD *****************************

-


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

-


Tue Apr 22 13:00:39 2008

***LOG S00=> GwInitReader, gateway started ( 2596) [gwxxrd.c 1592]

relno 6200

patchlevel 0

patchno 863

intno 20020600

pid 2596

Tue Apr 22 13:00:43 2008

Bind service sapgw00 to datagramm port 3300

Bind service sapgw00 (normal) to port 3300

Tue Apr 22 13:00:45 2008

GwPrintMyHostAddr: my host addresses are :

1 : [10.1.1.79] hjmuellersap (HOSTNAME)

2 : [127.0.0.1] localhost (LOCALHOST)

MtxInit: -2 0 0

DpShMCreate: sizeof(wp_adm) 6048 (756)

DpShMCreate: sizeof(tm_adm) 1691616 (8416)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 192000 (384)

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

DpShMCreate: SHM_DP_ADM_KEY (addr: 00180040, size: 1972096)

DpShMCreate: allocated sys_adm at 00180040

DpShMCreate: allocated wp_adm at 00180630

DpShMCreate: allocated tm_adm_list at 00181DD0

DpShMCreate: allocated tm_adm at 00181DF8

DpShMCreate: allocated appc_ca_adm at 00323428

DpShMCreate: allocated comm_adm_list at 00324B98

DpShMCreate: allocated comm_adm at 00324BB0

DpShMCreate: allocated ca_info at 003539B0

Tue Apr 22 13:01:18 2008

***LOG S30=> GwStopGateway, gateway stopped () [gwxxrd.c 12516]

************************************************************************DEV_W0 ************************************

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Apr 22 13:00:40 2008

B create_con (con_name=R/3)

B Loading DB library '\usr\sap\R47\SYS\exe\run\dboraslib.dll' ...

B Library '\usr\sap\R47\SYS\exe\run\dboraslib.dll' loaded

B Version of '\usr\sap\R47\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.876)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 1027

M intno 20020600

M pid 3092

M

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

I MtxInit: -2 0 0

M DpShMCreate: sizeof(wp_adm) 6048 (756)

M DpShMCreate: sizeof(tm_adm) 1691616 (8416)

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: 067A0040, size: 1972096)

M DpShMCreate: allocated sys_adm at 067A0040

M DpShMCreate: allocated wp_adm at 067A0630

M DpShMCreate: allocated tm_adm_list at 067A1DD0

M DpShMCreate: allocated tm_adm at 067A1DF8

M DpShMCreate: allocated wp_ca_adm at 0693EDD8

M DpShMCreate: allocated appc_ca_adm at 06943428

M DpShMCreate: allocated comm_adm_list at 06944B98

M DpShMCreate: allocated comm_adm at 06944BB0

M DpShMCreate: allocated ca_info at 069739B0

M DpShMCreate: allocated wall_adm at 069739B8

X

X Tue Apr 22 13:00:44 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Tue Apr 22 13:00:45 2008

M calling db_connect ...

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

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server R47 (con_hdl=0,svchp=041EC344,svrhp=07F2AA74)

C

C Tue Apr 22 13:00:48 2008

C Starting user session (con_hdl=0,svchp=041EC344,srvhp=07F2AA74,usrhp=07F3329C)

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

[dboci.c 3733]

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

[dboci.c 9643]

C Try to connect with default password

C Connecting as SAPR47/<pwd>@R47 on connection 0 ...

C Starting user session (con_hdl=0,svchp=041EC344,srvhp=07F2AA74,usrhp=07F3329C)

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

[dboci.c 3733]

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

[dboci.c 9643]

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 1119]

M in_ThErrHandle: 1

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

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 int_checked_resource = 0

M ext_checked_resource = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server hjmuellersap_R47_00 on host hjmuellersap (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Tue Apr 22 13:00:48 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8666

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 238]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

I need your help so badly. Any Idea what I could possibly do, without reinstalling it??

Thanks

Torsten

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

ORA-01033: ORACLE initialization or shutdown in progress

This means that you tried to start the system while the DB is still shutting down or in the process of starting...

Be carefull an make sure the DB is shutdown safely before starting the system again...

Regards

Juan

Former Member
0 Kudos

stutdown the db directly. started the sap server again, and after trying to connect the disp-work changed to "stopped"

Any other idea?

Torsten

JPReyes
Active Contributor
0 Kudos

can you post dev_w0? please also check that the Oracle DB and Listener are running.

Regards

Juan

Former Member
0 Kudos

Here is my dev_w0 log.

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

*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Apr 22 13:00:40 2008

B create_con (con_name=R/3)

B Loading DB library '\usr\sap\R47\SYS\exe\run\dboraslib.dll' ...

B Library '\usr\sap\R47\SYS\exe\run\dboraslib.dll' loaded

B Version of '\usr\sap\R47\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.876)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 1027

M intno 20020600

M pid 3092

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3092) http://dpxxdisp.c 1057

I MtxInit: -2 0 0

M DpShMCreate: sizeof(wp_adm) 6048 (756)

M DpShMCreate: sizeof(tm_adm) 1691616 (8416)

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: 067A0040, size: 1972096)

M DpShMCreate: allocated sys_adm at 067A0040

M DpShMCreate: allocated wp_adm at 067A0630

M DpShMCreate: allocated tm_adm_list at 067A1DD0

M DpShMCreate: allocated tm_adm at 067A1DF8

M DpShMCreate: allocated wp_ca_adm at 0693EDD8

M DpShMCreate: allocated appc_ca_adm at 06943428

M DpShMCreate: allocated comm_adm_list at 06944B98

M DpShMCreate: allocated comm_adm at 06944BB0

M DpShMCreate: allocated ca_info at 069739B0

M DpShMCreate: allocated wall_adm at 069739B8

X

X Tue Apr 22 13:00:44 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Tue Apr 22 13:00:45 2008

M calling db_connect ...

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

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server R47 (con_hdl=0,svchp=041EC344,svrhp=07F2AA74)

C

C Tue Apr 22 13:00:48 2008

C Starting user session (con_hdl=0,svchp=041EC344,srvhp=07F2AA74,usrhp=07F3329C)

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

http://dboci.c 3733

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

http://dboci.c 9643

C Try to connect with default password

C Connecting as SAPR47/<pwd>@R47 on connection 0 ...

C Starting user session (con_hdl=0,svchp=041EC344,srvhp=07F2AA74,usrhp=07F3329C)

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

http://dboci.c 3733

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

http://dboci.c 9643

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) http://thxxhead.c 1119

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) http://thxxhead.c 8534

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 int_checked_resource = 0

M ext_checked_resource = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server hjmuellersap_R47_00 on host hjmuellersap (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Tue Apr 22 13:00:48 2008

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8666

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 http://thxxrun1.c 672

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed http://thxxtool3.c 238

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3092) http://dpnttool.c 346

How do check whether Oracle DB and Listener are running services are all up

Thanks Torsten

JPReyes
Active Contributor
0 Kudos

Again you DB is not ONLINE... your db is in the process of starting or shutting down..

Try to stop the DB and restart it.

commands...

sqlplus "/as sysdba"

to stop the db type "shutdown immediate" at the SQL prompt

ro start the db type "startup" at the prompt

If the DB is busy either starting or shutting down you'll see the error message...

If the DB is hanging you can force it to stop using command "shutdown abort" but this can cause irreparable damage to the DB depending on the circunstances the DB hang... if you don't know what you're doing consult an expert

Regards

Juan

Former Member
0 Kudos

Hi,

I proceeded exactly as you said. shutdown adn startup went fine. Starting the SAP Serverr provoked the same logging as stated before. Any other idea?

Thanks Torsten

JPReyes
Active Contributor
0 Kudos

Read SAP Note 655240 - Composite SAP note: ORA-01033

regards

Juan

former_member186775
Contributor
0 Kudos

hi

try to do in this way..

goto start --->run in tat type services.msc

then in standard >select oracle listener>rightclick

in that go for option stop.

after tat press CTRLALTDELETE in appliocations

kill service manager .now restart the server

hope this helps

Former Member
0 Kudos

Make sure the permissions on the hard drive is not changed. Also verify kernel directory have enough permissions.

Answers (0)