cancel
Showing results for 
Search instead for 
Did you mean: 

db is not up,,,wp ended, how to resolve it.....

Former Member
0 Kudos

hi to all,...thanks in advance...i have ecc6 ides on won 2003 with ora10g.....normally i started MMC, in that abapWP is showing ENDED....and DB is not UP, i try to enter SQLPLUS, itz showing error lik,C:\Documents and Settings\Administrator>sqlplus

'sqlplus' is not recognized as an internal or external command,,,operable program or batch file.........anybody can resolve this pblm.......i provided dev_disp details below.......

-


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

sysno 03

sid PID

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 52

intno 20050900

make: multithreaded, Unicode, optimized

pid 3024

Fri Dec 18 11:04:04 2009

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

length of sys_adm_ext is 572 bytes

      • SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (03 3024) [dpxxdisp.c 1231]

shared lib "dw_xml.dll" version 52 successfully loaded

shared lib "dw_xtc.dll" version 52 successfully loaded

shared lib "dw_stl.dll" version 52 successfully loaded

shared lib "dw_gui.dll" version 52 successfully loaded

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

use internal message server connection to port 3903

Fri Dec 18 11:04:09 2009

      • 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 5233]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >tern_PID_03 <

DpShMCreate: sizeof(wp_adm) 18304 (1408)

DpShMCreate: sizeof(tm_adm) 3954072 (19672)

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)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1452)

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

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 05E00040, size: 4613144)

DpShMCreate: allocated sys_adm at 05E00040

DpShMCreate: allocated wp_adm at 05E01E28

DpShMCreate: allocated tm_adm_list at 05E065A8

DpShMCreate: allocated tm_adm at 05E065D8

DpShMCreate: allocated wp_ca_adm at 061CBB70

DpShMCreate: allocated appc_ca_adm at 061D1930

DpShMCreate: allocated comm_adm at 061D3870

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 06254730

DpShMCreate: allocated gw_adm at 06254770

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 062547A0

DpShMCreate: allocated wall_adm at 062547A8

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

MM diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

J2EE server info

start = TRUE

state = STARTED

pid = 3840

argv[0] = D:\usr\sap\PID\DVEBMGS03\exe\jcontrol.EXE

argv[1] = D:\usr\sap\PID\DVEBMGS03\exe\jcontrol.EXE

argv[2] = pf=D:\usr\sap\PID\SYS\profile\PID_DVEBMGS03_tern

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=2370

argv[5] = -DSAPSYSTEM=03

argv[6] = -DSAPSYSTEMNAME=PID

argv[7] = -DSAPMYNAME=tern_PID_03

argv[8] = -DSAPPROFILE=D:\usr\sap\PID\SYS\profile\PID_DVEBMGS03_tern

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

rdisp/http_min_wait_dia_wp : 1 -> 1

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

***LOG Q0K=> DpMsAttach, mscon ( tern) [dpxxdisp.c 11414]

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

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 52

Release check o.K.

DpJ2eeLogin: j2ee state = CONNECTED

Fri Dec 18 11:04:13 2009

***LOG Q0I=> NiIRead: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4235]

      • ERROR => NiIRead: SiRecv failed for hdl 4 / sock 1500

(SI_ECONN_BROKEN; I4; ST; 127.0.0.1:2373) [nixxi.cpp 4235]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=3840)

      • ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Fri Dec 18 11:04:49 2009

      • ERROR => W0 (pid 3720) died [dpxxdisp.c 14021]

      • ERROR => W1 (pid 3572) died [dpxxdisp.c 14021]

      • ERROR => W2 (pid 1040) died [dpxxdisp.c 14021]

      • ERROR => W3 (pid 2324) died [dpxxdisp.c 14021]

      • ERROR => W4 (pid 3068) died [dpxxdisp.c 14021]

      • ERROR => W5 (pid 3116) died [dpxxdisp.c 14021]

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

      • ERROR => W6 (pid 784) died [dpxxdisp.c 14021]

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

      • ERROR => W7 (pid 2720) died [dpxxdisp.c 14021]

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

      • ERROR => W8 (pid 3224) died [dpxxdisp.c 14021]

      • ERROR => W9 (pid 3404) died [dpxxdisp.c 14021]

      • ERROR => W10 (pid 2456) died [dpxxdisp.c 14021]

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

      • ERROR => W11 (pid 2436) died [dpxxdisp.c 14021]

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

      • ERROR => W12 (pid 2508) died [dpxxdisp.c 14021]

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=1629

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri Dec 18 11:04:59 2009

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Fri Dec 18 05:34:59 2009

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

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-


0 DIA 3720 Ended no 1 0 0

1 DIA 3572 Ended no 1 0 0

2 DIA 1040 Ended no 1 0 0

3 DIA 2324 Ended no 1 0 0

4 DIA 3068 Ended no 1 0 0

5 DIA 3116 Ended no 1 0 0

6 UPD 784 Ended no 1 0 0

7 ENQ 2720 Ended no 1 0 0

8 BTC 3224 Ended no 1 0 0

9 BTC 3404 Ended no 1 0 0

10 BTC 2456 Ended no 1 0 0

11 SPO 2436 Ended no 1 0 0

12 UP2 2508 Ended no 1 0 0

Dispatcher Queue Statistics Fri Dec 18 05:34:59 2009

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

--------


+
+

+

+
--


+

Typ

now

high

max

writes

reads

--------


+
+

+

+
--


+

NOWP

0

2

2000

6

6

--------


+
+

+

+
--


+

DIA

4

4

2000

4

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 11

wake_evt_udp_now 0

wake events total 7, udp 6 ( 85%), shm 1 ( 14%)

since last update total 7, udp 6 ( 85%), shm 1 ( 14%)

Dump of tm_adm structure: Fri Dec 18 05:34:59 2009

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

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

Workprocess Comm. Area Blocks Fri Dec 18 05:34:59 2009

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

Slots: 300, Used: 1, Max: 0

--------


+
+
--


+

id

owner

pid

eyecatcher

--------


+
+
--


+

0

DISPATCHER

-1

WPCAAD000

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1629

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Fri Dec 18 11:05:04 2009

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >tern_PID_03 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

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 3 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 3

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 3 recv would block (errno=EAGAIN)

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

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 3 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 3 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 3 (r)

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

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 3

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 3 recv would block (errno=EAGAIN)

Fri Dec 18 11:05:12 2009

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

NiIRead: read for hdl 3 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 11698]

NiBufSend starting

NiIWrite: hdl 3 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 3 in set0

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

NiBufISelRemove: remove hdl 3 from set0

SiSelNRemove: removed sock 1528 (pos=3)

SiSelNRemove: removed sock 1528

NiSelIRemove: removed hdl 3

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 14)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 3 / sock 1528

NiBufIClose: clear extension for hdl 3

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 3024) [dpxxdisp.c 10087]

Good Bye .....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Before starting the database first check the Listner with ora<sid> user. after starting successfully go on oracle home directory and write satrtup mount command on sql prompt.if ur database is mounted successfuly then type alter database open;

if it is not started the check the alertlog file where u can get exect oracle error. it possible then write me exec database error.

Thanks

Presu

Answers (5)

Answers (5)

Former Member
0 Kudos

thanks

Former Member
0 Kudos

For now: run sqlplus from the drive, where you have installed your Oracle

Permanent: Add full path of this Oracle home directory in PATH environment varialble

Regards

Nick Loy

Former Member
0 Kudos

Hello,

Check as per Markus post, also try to start sqlplus from $ORACLE_HOME/bin

Example: /oracle/<SID>/102_64/bin

If the environmental variable is not set then you cannot start it from C:\

Regards,

Yoganand.V

Former Member
0 Kudos

i already set the environmental variable too...

peter_dzurov
Contributor
0 Kudos

do you have complete path to sqlplus in PATH environment variable?

former_member220071
Active Participant
0 Kudos

Dear Ranjith ,

First of all check in which partation you have installed oracle . Go to that partation from command prompt then go to oracle then try sulplus/nolog.

Then - connect /as sysdba

After that try to start your database.

Abhijeet

Edited by: Abhijeet Siras on Dec 24, 2009 10:22 AM

markus_doehr2
Active Contributor
0 Kudos

>

> hi to all,...thanks in advance...i have ecc6 ides on won 2003 with ora10g.....normally i started MMC, in that abapWP is showing ENDED....and DB is not UP, i try to enter SQLPLUS, itz showing error lik,C:\Documents and Settings\Administrator>sqlplus

> 'sqlplus' is not recognized as an internal or external command,,,operable program or batch file.........anybody can resolve this pblm.......i provided dev_disp details below.......

Did you start sqlplus as <sid>adm?

Markus

Former Member
0 Kudos

yes, i startrd SQLPLUS from SIDADM, but itz shoeing error lik "SQLPLUSis not recognised"...

Former Member
0 Kudos

Paste Error lines from dev_w0 logfile.

before that check whether database is up and running (sql level)..and try to start the database from sql.

If you are able to start database from sql level then we can see the issue (in starting sap)

Regards

Nick Loy