cancel
Showing results for 
Search instead for 
Did you mean: 

DB Connect failed --1033,Disp+work.exe stopped

former_member186775
Contributor
0 Kudos

Hi team

As I said in subject I restarted the server and in MMC I observed the error called disp+work.exe stopped.In the

event log I checked and found the errors as--

In Syslog these are the errors found.

SAP-Basis System:Message Server Disconnected.

SAP-Basis System:Initialization DB connect failed,Return code 000256

Database:Database error 1033 at con

-


Also checked with R3trans -d and this is the output

I got is (0012). to this I have posted dev_w0,dev_disp and

developer trace.

please if any one knows the right solution plz do help.dont just

type one line answers which are not upto the mark.

-


-


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

-


sysno 00

sid DPM

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 111

intno 20050900

make: multithreaded, Unicode, optimized

pid 236

kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)

length of sys_adm_ext is 576 bytes

      • SWITCH TRC-HIDE on ***

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

shared lib "dw_xml.dll" version 111 successfully loaded

shared lib "dw_xtc.dll" version 111 successfully loaded

shared lib "dw_stl.dll" version 111 successfully loaded

shared lib "dw_gui.dll" version 111 successfully loaded

shared lib "dw_mdm.dll" version 111 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3900

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >curosysdev_DPM_00 <

DpShMCreate: sizeof(wp_adm) 18672 (1436)

DpShMCreate: sizeof(tm_adm) 4232256 (21056)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm) 528064 (1048)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (96)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1536)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 06000040, size: 4892312)

DpShMCreate: allocated sys_adm at 06000040

DpShMCreate: allocated wp_adm at 06002090

DpShMCreate: allocated tm_adm_list at 06006980

DpShMCreate: allocated tm_adm at 060069B0

DpShMCreate: allocated wp_ca_adm at 0640FDF0

DpShMCreate: allocated appc_ca_adm at 06415BB0

DpShMCreate: allocated comm_adm at 06417AF0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 064989B0

DpShMCreate: allocated gw_adm at 064989F0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 06498A20

DpShMCreate: allocated wall_adm at 06498A28

MBUF state OFF

DpCommInitTable: init table for 500 entries

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1629]

***LOG Q0K=> DpMsAttach, mscon ( curosysdev) [dpxxdisp.c 11753]

DpStartStopMsg: send start message (myname is >curosysdev_DPM_00 <)

DpStartStopMsg: start msg sent

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

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

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 111

Release check o.K.

Fri May 23 12:29:48 2008

      • ERROR => W0 (pid 808) died [dpxxdisp.c 14441]

      • ERROR => W1 (pid 2668) died [dpxxdisp.c 14441]

      • ERROR => W2 (pid 2192) died [dpxxdisp.c 14441]

      • ERROR => W3 (pid 2808) died [dpxxdisp.c 14441]

      • ERROR => W4 (pid 3588) died [dpxxdisp.c 14441]

      • ERROR => W5 (pid 2720) died [dpxxdisp.c 14441]

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

      • ERROR => W6 (pid 412) died [dpxxdisp.c 14441]

my types changed after wp death/restart 0xbe --> 0xbc

      • ERROR => W7 (pid 2188) died [dpxxdisp.c 14441]

my types changed after wp death/restart 0xbc --> 0xb8

      • ERROR => W8 (pid 2792) died [dpxxdisp.c 14441]

      • ERROR => W9 (pid 1740) died [dpxxdisp.c 14441]

      • ERROR => W10 (pid 2796) died [dpxxdisp.c 14441]

my types changed after wp death/restart 0xb8 --> 0xb0

      • ERROR => W11 (pid 380) died [dpxxdisp.c 14441]

my types changed after wp death/restart 0xb0 --> 0xa0

      • ERROR => W12 (pid 2956) died [dpxxdisp.c 14441]

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

      • DP_FATAL_ERROR => DpWPCheck: no more work processes

      • DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:29:58 2008

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Fri May 23 06:59:58 2008

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

Dispatcher Queue Statistics Fri May 23 06:59:58 2008

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

--------


+
+

+

+
--


+

Typ

now

high

max

writes

reads

--------


+
+

+

+
--


+

NOWP

0

2

2000

6

6

--------


+
+

+

+
--


+

DIA

5

5

2000

5

0

--------


+
+

+

+
--


+

UPD

0

0

2000

0

0

--------


+
+

+

+
--


+

ENQ

0

0

2000

0

0

--------


+
+

+

+
--


+

BTC

0

0

2000

0

0

--------


+
+

+

+
--


+

SPO

0

0

2000

0

0

--------


+
+

+

+
--


+

UP2

0

0

2000

0

0

--------


+
+

+

+
--


+

max_rq_id 12

wake_evt_udp_now 0

wake events total 8, udp 7 ( 87%), shm 1 ( 12%)

since last update total 8, udp 7 ( 87%), shm 1 ( 12%)

Dump of tm_adm structure: Fri May 23 06:59:58 2008

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

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Fri May 23 06:59:58 2008

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

Slots: 300, Used: 1, Max: 0

--------


+
+
--


+

id

owner

pid

eyecatcher

--------


+
+
--


+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:03 2008

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >curosysdev_DPM_00 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes

Stop gateway

killing process (3976) (SOFT_KILL)

Stop icman

killing process (180) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:3976 HANDLE:1580)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:04 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:3976 HANDLE:1580)

wait for end of icman

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:05 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:06 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:07 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:08 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:09 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:10 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:11 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:12 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:13 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:14 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process lives (PID:180 HANDLE:1588)

waiting for termination of icman ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1609

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri May 23 12:30:15 2008

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:180 HANDLE:1588)

DpStartStopMsg: send stop message (myname is >curosysdev_DPM_00 <)

NiIMyHostName: hostname = 'systemdev'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 2 (r)

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Fri May 23 12:30:16 2008

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

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

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 1520 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 1520 (pos=2)

SiSelNRemove: removed sock 1520

NiSelIRemove: removed hdl 2

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/13

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 1520

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 236) [dpxxdisp.c 10371]

-


dev_w0 trace file

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Fri May 23 12:29:09 2008

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\MPD\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.107)

B New connection 0 created

M sysno 00

M sid DPM

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 808

M

M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 808) [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) 18672 (1436)

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 (1536)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06000040, size: 4892312)

M DpShMCreate: allocated sys_adm at 06000040

M DpShMCreate: allocated wp_adm at 06002090

M DpShMCreate: allocated tm_adm_list at 06006980

M DpShMCreate: allocated tm_adm at 060069B0

M DpShMCreate: allocated wp_ca_adm at 0640FDF0

M DpShMCreate: allocated appc_ca_adm at 06415BB0

M DpShMCreate: allocated comm_adm at 06417AF0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 064989B0

M DpShMCreate: allocated gw_adm at 064989F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 06498A20

M DpShMCreate: allocated wall_adm at 06498A28

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 Fri May 23 12:29:10 2008

M ThInit: running on host systemdev

M

M Fri May 23 12:29:11 2008

M calling db_connect ...

C Prepending D:\usr\sap\DPM\DVEBMGS00\exe to Path.

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 08C50EE8 08C56484 08C55D0C

C Attaching to DB Server DPM (con_hdl=0,svchp=08C55C58,srvhp=08C67854)

C Starting user session (con_hdl=0,svchp=08C55C58,srvhp=08C67854,usrhp=08C7C598)

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=08C55C58,srvhp=08C67854)

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

[dbsloci.c 11042]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@DPM on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 08C50EE8 08C56484 08C55D0C

C Attaching to DB Server DPM (con_hdl=0,svchp=08C55C58,srvhp=08C67854)

C Starting user session (con_hdl=0,svchp=08C55C58,srvhp=08C67854,usrhp=08C7C598)

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

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=08C55C58,srvhp=08C67854)

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

[dbsloci.c 11042]

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#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

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 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 req.vm = no VM

M attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server systemdev_DPM_00 on host systemdev (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Fri May 23 12:29:11 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

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

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

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 808) [dpnttool.c 327]

-


Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

ORA-01033 stands out when database connect attempt is made while oracle is starting up or shutting down.

Try connect to oracle as sysdba and do shutdown immediate and try starting SAP again.

Hope this helps.

Regards

Rahul

Former Member
0 Kudos

Hi manjula,

Please check your listner services .if it is manul than make it to automatic . Did you change the parameter of sap.

Former Member
0 Kudos

Hi. Are you loged under "sid"adm ? If go to start-->run --> cmd -->

sqlplus "/as sysdba"

shutdown

startup.

If database up after start sap in MMC. Also check logs in trans.log file (find him and check) also check oracle services are started ?. Regards.

Edited by: Sergo Beradze on May 23, 2008 12:04 PM

former_member186775
Contributor
0 Kudos

I am posting trans.log file

-


4 ETW000 r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.05.2008 - 19:16:34

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu May 22 19:16:37 2008 6740 0.006740

4 ETW000 [dev trc ,00000] db_con_init called 28 0.006768

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 47 0.006815

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 34 0.006849

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 76286 0.083135

4 ETW000 [dev trc ,00000] using "D:\usr\sap\MPD\SYS\exe\uc\NTI386\dboraslib.dll"

4 ETW000 34 0.083169

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 18 0.083187

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 30 0.083217

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.107)

4 ETW000 47578 0.130795

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 30 0.130825

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 42 0.130867

4 ETW000 [dev trc ,00000] New connection 0 created 28 0.130895

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 42 0.130937

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 23 0.130960

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 28 0.130988

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 39 0.131027

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 8178 0.139205

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 74378 0.213583

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 35 0.213618

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2658 0.216276

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 28 0.216304

4 ETW000 [dev trc ,00000] Connecting as /@MPD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 37 0.216341

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 277 0.216618

4 ETW000 [dev trc ,00000] 0 UTF8 1 0247DD60 02483294 02482B1C

4 ETW000 115 0.216733

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 6948 0.223681

4 ETW000 [dev trc ,00000] Allocating server context handle 184 0.223865

4 ETW000 [dev trc ,00000] Attaching to DB Server MPD (con_hdl=0,svchp=02482A68,srvhp=024942DC)

4 ETW000 59 0.223924

4 ETW000 [dev trc ,00000] Thu May 22 19:16:39 2008 2257608 2.481532

4 ETW000 [dev trc ,00000] Assigning server context 024942DC to service context 02482A68

4 ETW000 44 2.481576

4 ETW000 [dev trc ,00000] Allocating user session handle 33 2.481609

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02482A68,srvhp=024942DC,usrhp=024CFA20)

4 ETW000 51 2.481660

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033

4 ETW000 32994 2.514654

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=024942DC) 22 2.514676

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02482A68,srvhp=024942DC)

4 ETW000 31 2.514707

4 ETW000 [dev trc ,00000] Deallocating server context handle 024942DC 473 2.515180

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'

4 ETW000 46 2.515226

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 26 2.515252

4 ETW000 [dev trc ,00000] Try to connect with default password 168 2.515420

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@MPD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 36 2.515456

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 36 2.515492

4 ETW000 [dev trc ,00000] 0 UTF8 1 0247DD60 02483294 02482B1C

4 ETW000 37 2.515529

4 ETW000 [dev trc ,00000] Allocating server context handle 20 2.515549

4 ETW000 [dev trc ,00000] Attaching to DB Server MPD (con_hdl=0,svchp=02482A68,srvhp=024942DC)

4 ETW000 52 2.515601

4 ETW000 [dev trc ,00000] Assigning server context 024942DC to service context 02482A68

4 ETW000 11841 2.527442

4 ETW000 [dev trc ,00000] Assigning username to user session 024CFA20 26 2.527468

4 ETW000 [dev trc ,00000] Assigning password to user session 024CFA20 27 2.527495

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02482A68,srvhp=024942DC,usrhp=024CFA20)

4 ETW000 37 2.527532

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033

4 ETW000 31376 2.558908

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=024942DC) 21 2.558929

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02482A68,srvhp=024942DC)

4 ETW000 43 2.558972

4 ETW000 [dev trc ,00000] Deallocating server context handle 024942DC 550 2.559522

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'

4 ETW000 60 2.559582

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 20 2.559602

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1033 performing CON [dblink#3 @ 431]

4 ETW000 1028 2.560630

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431]

4 ETW000 34 2.560664

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'MPD'"

-


I checked all this but i am not able to reach up to the mark ...could you guide me Sergo Beradze

Former Member
0 Kudos

Hi,

Have a glance on this notes

Note 655240 - Composite SAP note: ORA-01033

Note 903904

Regards,

Vamshi.

Former Member
0 Kudos

Hi frds, i m facing a problem of DB connection as similar to U manjula.

CONSOLE MMC .

the instance turns green and turns yellow again

bcz dispatcher is stopping

R/3 Basis System: Initialization DB-Connect Failed, Return Code 000256

R/3 Basis System: Message server disconnected

Database:Database error 1033 at con

need help regarding this

im posting the dev_w0 file , as i m not able to fine the trans.log

______________________________________________________________dev_wo____________________-

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

*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Sun May 25 15:43:58 2008

B create_con (con_name=R/3)

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

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

B Version of 'C:\usr\sap\ECC\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.6)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 10

M intno 20020600

M make: multithreaded, ASCII

M pid 3016

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 12424 (828)

M DpShMCreate: sizeof(tm_adm) 2083168 (10364)

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(vmc_adm) 0 (320)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 05EC0040, size: 2374536)

M DpShMCreate: allocated sys_adm at 05EC0040

M DpShMCreate: allocated wp_adm at 05EC17A8

M DpShMCreate: allocated tm_adm_list at 05EC4830

M DpShMCreate: allocated tm_adm at 05EC4858

M DpShMCreate: allocated wp_ca_adm at 060C11B8

M DpShMCreate: allocated appc_ca_adm at 060C5808

M DpShMCreate: allocated comm_adm_list at 060C6F78

M DpShMCreate: allocated comm_adm at 060C6F90

M DpShMCreate: allocated vmc_adm_list at 060F5D90

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 060F5DB8

M DpShMCreate: allocated wall_adm at 060F5DC0

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 Sun May 25 15:43:59 2008

M calling db_connect ...

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

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server ECC (con_hdl=0,svchp=077DAC64,svrhp=036C26F4)

C

C Sun May 25 15:44:26 2008

C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=036C26F4,usrhp=036CAF08)

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

http://dboci.c 3721

C Detaching from DB Server (con_hdl=0,svchp=077DAC64,srvhp=036C26F4)

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

http://dbsloci.c 9750

C Try to connect with default password

C Connecting as SAPECC/<pwd>@ECC on connection 0 ...

C Attaching to DB Server ECC (con_hdl=0,svchp=077DAC64,svrhp=036C26F4)

C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=036C26F4,usrhp=036CAF08)

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

http://dboci.c 3721

C Detaching from DB Server (con_hdl=0,svchp=077DAC64,srvhp=036C26F4)

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

http://dbsloci.c 9750

B ***LOG BV3=> severe db error 1033 ; work process is stopped dbsh#1 @ 1195 dbsh 1195

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 1270

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 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

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

M *

M * LOCATION SAP-Server starecc_ECC_00 on host starecc (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sun May 25 15:44:26 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9553

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

_________________________________________________

regards.

have a good day.

ajay

Edited by: ajay babu on May 25, 2008 8:07 PM