on 12-18-2009 7:05 AM
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 .....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.