work processes could not start
Hello
The Application Server for dispatcher work processes could not start .
Here is the dev_w0 log file:
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "640"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, M
*
M sysno 00
M sid CCP
M systemid 273 (HP/9000 (PA-RISC) with HP-UX)
M relno 6400
M patchlevel 0
M patchno 101
M intno 20020600
M make: single threaded, ASCII, 64 bit
M pid 23279
M
M
M Wed Apr 5 21:19:35 2006
M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 23279) [thxxhead.c 1143]
M calling db_connect ...
C Got ORACLE_HOME=/oracle/CCP/920_64 from environment
C got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPCRM's password
C Connecting as /@CCP on connection 0 (nls_hdl 0) ... (dbsl 640 310805)
C Nls CharacterSet NationalCharSet C EnvHp
ErrHp ErrHpBatch
C 0 WE8DEC 1 8000000103697
630 80000001036a0908 80000001036a0318
C Attaching to DB Server CCP (con_hdl=0,svchp=80000001036a0248,svrhp=8000000103
6a2638)
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
[dboci.c 4149]
C *** ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 10507]
C Try to connect with default password
C Connecting as SAPCRM/<pwd>@CCP on connection 0 (nls_hdl 0) ... (dbsl 640 3108
05)
ONNECT failed with sql error '12154'
C 0 WE8DEC 1 8000000103697
630 80000001036a0908 80000001036a0318
C Detaching from DB Server (con_hdl=0,svchp=80000001036a0248,srvhp=80000001036a
2638)
C Attaching to DB Server CCP (con_hdl=0,svchp=80000001036a0248,svrhp=8000000103
6a2638)
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
[dboci.c 4149]
C *** ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 10507]
B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh#3 @ 11
98] [dbsh 1198 ]
B ***LOG BY2=> sql error 12154 performing CON [dblink#2 @ 419] [dblink 0419 ]
B ***LOG BY0=> ORA-12154: TNS:could not resolve service name [dblink#2 @ 419] [
dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1276]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [
thxxhead.c 9548]
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 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 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUM
P failed [thxxtool3.c 252]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 23279) [dpuxtool.c 317]
Can please advise me?
Thanks & Regards
SAPFORSAP
Hello
Could please advise ASAP...?
R3trans -d
This is R3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CCP'"
R3trans finished (0012).
hi!
please check TNSNAMES.ORA file for syntax errors or if it exists.
_________________
maktub!
sapbc_ph
TNSNAMES.ora file exists.
Here is the TNSNAMES.ora:
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
################
CCP.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = camcrp01)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = CCP)
(GLOBAL_NAME = CCP.WORLD)
)
)
inprora.world =
(Description =
(Address = (Protocol = TCP)(Host = ims)(Port = 1521))
(Connect_Data = (SID = inprora))
)
imsdev.world =
(Description =
(Address = (Protocol = TCP)(Host = ims)(Port = 1521))
(Connect_Data = (SID = inprora))
Can you please advise wot could causing the problem as per the Logs.
Thanks & regards
SAPFORSAP
Is the number of the listener port on your central instance also 1527..
Can you try tnsping SID
Regards,
Mark
yes. Listner Port is 1527.
But Now i am getting different error in dev_disp:
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "640"
---------------------------------------------------
Thu Apr 6 10:12:16 2006
kernel runs with dp version 130(ext=102) (@(#) DPLIB-INT-VERSION-130)
length of sys_adm_ext is 312 bytes
sysno 00
sid CCP
systemid 273 (HP/9000 (PA-RISC) with HP-UX)
relno 6400
patchlevel 0
patchno 101
intno 20020600
make: single threaded, ASCII, 64 bit
pid 1794
***LOG Q00=> DpSapEnvInit, DPStart (00 1794) [dpxxdisp.c 1094]
shared lib "dw_xml.sl" version 101 successfully loaded
shared lib "dw_xtc.sl" version 101 successfully loaded
shared lib "dw_stl.sl" version 101 successfully loaded
shared lib "dw_gui.sl" version 101 successfully loaded
shared lib "dw_mdm.sl" version 101 successfully loaded
MtxInit: -2 0 0
DpSysAdmExtInit: ABAP is active
DpShMCreate: sizeof(wp_adm) 22680 (840)
DpShMCreate: sizeof(tm_adm) 38355336 (15336)
DpShMCreate: sizeof(wp_ca_adm) 76000 (76)
DpShMCreate: sizeof(appc_ca_adm) 152000 (76)
DpShMCreate: sizeof(comm_adm) 864000 (432)
DpShMCreate: sizeof(vmc_adm) 0 (480)
DpShMCreate: sizeof(wall_adm) (280040/432312/72/104)
DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000c8000000, size: 40188848)
DpShMCreate: allocated sys_adm at 00000000c8000000
DpShMCreate: allocated wp_adm at 00000000c8001898
DpShMCreate: allocated tm_adm_list at 00000000c8007130
DpShMCreate: allocated tm_adm at 00000000c8007158
DpShMCreate: allocated wp_ca_adm at 00000000ca49b2e0
DpShMCreate: allocated appc_ca_adm at 00000000ca4adbc0
DpShMCreate: allocated comm_adm_list at 00000000ca4d2d80
DpShMCreate: allocated comm_adm at 00000000ca4d2d98
DpShMCreate: allocated vmc_adm_list at 00000000ca5a5c98
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 00000000ca5a5cc0
DpShMCreate: allocated wall_adm at 00000000ca5a5cc8
MBUF state OFF
EmInit: MmSetImplementation( 2 ).
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation std
EsIUnamFileMapInit: ES base = 0xc000000085000000
EsStdInit: Extended Memory 8192 MB allocated
<ES> 8191 blocks reserved for free list.
ES initialized.
Thu Apr 6 10:12:18 2006
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( camcrp01) [dpxxdisp.c 9819]
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: start to initalize 3.X shared alert area (first segment).
*** ERROR => W0 (pid 1798) died [dpxxdisp.c 12270]
*** ERROR => W1 (pid 1799) died [dpxxdisp.c 12270]
*** ERROR => W2 (pid 1800) died [dpxxdisp.c 12270]
*** ERROR => W3 (pid 1801) died [dpxxdisp.c 12270]
*** ERROR => W4 (pid 1802) died [dpxxdisp.c 12270]
*** ERROR => W5 (pid 1803) died [dpxxdisp.c 12270]
*** ERROR => W6 (pid 1804) died [dpxxdisp.c 12270]
*** ERROR => W7 (pid 1805) died [dpxxdisp.c 12270]
*** ERROR => W8 (pid 1806) died [dpxxdisp.c 12270]
*** ERROR => W9 (pid 1807) died [dpxxdisp.c 12270]
*** ERROR => W10 (pid 1808) died [dpxxdisp.c 12270]
*** ERROR => W11 (pid 1809) died [dpxxdisp.c 12270]
*** ERROR => W12 (pid 1810) died [dpxxdisp.c 12270]
*** ERROR => W13 (pid 1811) died [dpxxdisp.c 12270]
*** ERROR => W14 (pid 1812) died [dpxxdisp.c 12270]
*** ERROR => W15 (pid 1813) died [dpxxdisp.c 12270]
my types changed after wp death/restart 0xbb --> 0xba
*** ERROR => W16 (pid 1814) died [dpxxdisp.c 12270]
*** ERROR => W17 (pid 1815) died [dpxxdisp.c 12270]
*** ERROR => W18 (pid 1816) died [dpxxdisp.c 12270]
my types changed after wp death/restart 0xba --> 0xb8
*** ERROR => W19 (pid 1817) died [dpxxdisp.c 12270]
*** ERROR => W20 (pid 1818) died [dpxxdisp.c 12270]
*** ERROR => W21 (pid 1819) died [dpxxdisp.c 12270]
*** ERROR => W22 (pid 1820) died [dpxxdisp.c 12270]
*** ERROR => W23 (pid 1821) died [dpxxdisp.c 12270]
my types changed after wp death/restart 0xb8 --> 0xb0
*** ERROR => W24 (pid 1822) died [dpxxdisp.c 12270]
my types changed after wp death/restart 0xb0 --> 0xa0
*** ERROR => W25 (pid 1823) died [dpxxdisp.c 12270]
Release check o.K.
MBUF state PREPARED
MBUF component UP
*** ERROR => W26 (pid 1825) died [dpxxdisp.c 12270]
my types changed after wp death/restart 0xa0 --> 0x80
*** DP_FATAL_ERROR => DpWPCheck: no more work processes
*** DISPATCHER EMERGENCY SHUTDOWN ***
increase tracelevel of WPs
killing W0-1798 (SIGUSR2)
*** ERROR => DpWpKill(1798, SIGUSR2) failed [dpxxtool.c 2493]
killing W1-1799 (SIGUSR2)
*** ERROR => DpWpKill(1799, SIGUSR2) failed [dpxxtool.c 2493]
killing W2-1800 (SIGUSR2)
*** ERROR => DpWpKill(1800, SIGUSR2) failed [dpxxtool.c 2493]
killing W3-1801 (SIGUSR2)
*** ERROR => DpWpKill(1801, SIGUSR2) failed [dpxxtool.c 2493]
killing W4-1802 (SIGUSR2)
*** ERROR => DpWpKill(1802, SIGUSR2) failed [dpxxtool.c 2493]
killing W5-1803 (SIGUSR2)
*** ERROR => DpWpKill(1803, SIGUSR2) failed [dpxxtool.c 2493]
killing W6-1804 (SIGUSR2)
*** ERROR => DpWpKill(1804, SIGUSR2) failed [dpxxtool.c 2493]
killing W7-1805 (SIGUSR2)
*** ERROR => DpWpKill(1805, SIGUSR2) failed [dpxxtool.c 2493]
killing W8-1806 (SIGUSR2)
*** ERROR => DpWpKill(1806, SIGUSR2) failed [dpxxtool.c 2493]
killing W9-1807 (SIGUSR2)
*** ERROR => DpWpKill(1807, SIGUSR2) failed [dpxxtool.c 2493]
killing W10-1808 (SIGUSR2)
*** ERROR => DpWpKill(1808, SIGUSR2) failed [dpxxtool.c 2493]
killing W11-1809 (SIGUSR2)
*** ERROR => DpWpKill(1809, SIGUSR2) failed [dpxxtool.c 2493]
killing W12-1810 (SIGUSR2)
*** ERROR => DpWpKill(1810, SIGUSR2) failed [dpxxtool.c 2493]
killing W13-1811 (SIGUSR2)
*** ERROR => DpWpKill(1811, SIGUSR2) failed [dpxxtool.c 2493]
killing W14-1812 (SIGUSR2)
*** ERROR => DpWpKill(1812, SIGUSR2) failed [dpxxtool.c 2493]
killing W15-1813 (SIGUSR2)
*** ERROR => DpWpKill(1813, SIGUSR2) failed [dpxxtool.c 2493]
killing W16-1814 (SIGUSR2)
*** ERROR => DpWpKill(1814, SIGUSR2) failed [dpxxtool.c 2493]
killing W17-1815 (SIGUSR2)
*** ERROR => DpWpKill(1815, SIGUSR2) failed [dpxxtool.c 2493]
killing W18-1816 (SIGUSR2)
*** ERROR => DpWpKill(1816, SIGUSR2) failed [dpxxtool.c 2493]
killing W19-1817 (SIGUSR2)
*** ERROR => DpWpKill(1817, SIGUSR2) failed [dpxxtool.c 2493]
killing W20-1818 (SIGUSR2)
*** ERROR => DpWpKill(1818, SIGUSR2) failed [dpxxtool.c 2493]
killing W21-1819 (SIGUSR2)
*** ERROR => DpWpKill(1819, SIGUSR2) failed [dpxxtool.c 2493]
killing W22-1820 (SIGUSR2)
*** ERROR => DpWpKill(1820, SIGUSR2) failed [dpxxtool.c 2493]
killing W23-1821 (SIGUSR2)
*** ERROR => DpWpKill(1821, SIGUSR2) failed [dpxxtool.c 2493]
killing W24-1822 (SIGUSR2)
*** ERROR => DpWpKill(1822, SIGUSR2) failed [dpxxtool.c 2493]
killing W25-1823 (SIGUSR2)
*** ERROR => DpWpKill(1823, SIGUSR2) failed [dpxxtool.c 2493]
killing W26-1825 (SIGUSR2)
*** ERROR => DpWpKill(1825, SIGUSR2) failed [dpxxtool.c 2493]
NiWait: sleep (10000 msecs) ...
NiISelect: timeout 10000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:28 2006
NiISelect: TIMEOUT occured (10000 ms)
dump system status
Workprocess Table (long) Thu Apr 6 14:12:28 2006
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-----------------------------------------------------------------------------------------------------------------------
0 DIA 1798 Ended no 1 0 0
1 DIA 1799 Ended no 1 0 0
2 DIA 1800 Ended no 1 0 0
3 DIA 1801 Ended no 1 0 0
4 DIA 1802 Ended no 1 0 0
5 DIA 1803 Ended no 1 0 0
6 DIA 1804 Ended no 1 0 0
7 DIA 1805 Ended no 1 0 0
8 DIA 1806 Ended no 1 0 0
9 DIA 1807 Ended no 1 0 0
10 DIA 1808 Ended no 1 0 0
11 DIA 1809 Ended no 1 0 0
12 DIA 1810 Ended no 1 0 0
13 DIA 1811 Ended no 1 0 0
14 DIA 1812 Ended no 1 0 0
15 DIA 1813 Ended no 1 0 0
16 UPD 1814 Ended no 1 0 0
17 UPD 1815 Ended no 1 0 0
18 UPD 1816 Ended no 1 0 0
19 BTC 1817 Ended no 1 0 0
20 BTC 1818 Ended no 1 0 0
21 BTC 1819 Ended no 1 0 0
22 BTC 1820 Ended no 1 0 0
23 BTC 1821 Ended no 1 0 0
24 SPO 1822 Ended no 1 0 0
25 UP2 1823 Ended no 1 0 0
26 UP2 1825 Ended no 1 0 0
Dispatcher Queue Statistics Thu Apr 6 14:12:28 2006
===========================
+------+--------+--------+--------+--------+--------+
| Typ | now | high | max | writes | reads |
+------+--------+--------+--------+--------+--------+
| NOWP | 7 | 7 | 2000 | 8 | 1 |
+------+--------+--------+--------+--------+--------+
| DIA | 3 | 3 | 2000 | 3 | 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 13
wake_evt_udp_now 1
wake events total 10, udp 2 ( 20%), shm 8 ( 80%)
since last update total 10, udp 2 ( 20%), shm 8 ( 80%)
Dump of tm_adm structure: Thu Apr 6 14:12:28 2006
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Thu Apr 6 14:12:28 2006
=============================
Slots: 1000, Used: 1, Max: 0
+------+--------------+----------+-------------+
| id | owner | pid | eyecatcher |
+------+--------------+----------+-------------+
| 0 | DISPATCHER | -1 | *WPCAAD000* |
NiWait: sleep (5000 msecs) ...
NiISelect: timeout 5000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:33 2006
NiISelect: TIMEOUT occured (5000 ms)
Shutdown server ...
DpJ2eeDisableRestart
DpModState: buffer in state MBUF_PREPARED
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete
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 proc (1796) (SOFT_KILL)
Stop icman
killing proc (1797) (SOFT_KILL)
Terminate gui connections
kill(1796,0) successful -> process alive
waiting for termination of gateway
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
child process 1796 died: 0
Thu Apr 6 10:12:34 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1796,0) -> ESRCH: process died
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:35 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:36 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:37 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:38 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:39 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:40 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:41 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:42 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:43 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) successful -> process alive
waiting for termination of icman
NiWait: sleep (1000 msecs) ...
NiISelect: timeout 1000 ms
NiISelect: maximum fd=13
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Apr 6 10:12:44 2006
child process 1797 died: 0
Thu Apr 6 10:12:45 2006
NiISelect: TIMEOUT occured (1000 ms)
kill(1797,0) -> ESRCH: process died
DpHalt: cancel all lcom connections
MPI CancelAll 2 -> 0
MPI DeleteAll 2 -> 0
NiIMyHostName: hostname = 'camxit01'
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 = 163 bytes
NiBufSend starting
NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete
MsINiWrite: sent 562 bytes
send msg (len 110+452) to name -, type 4, key -
detach from message server
***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 10045]
NiBufSend starting
NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete
MsINiWrite: sent 110 bytes
MsIDetach: send logout to msg_server
MsIDetach: call exit function
DpMsShutdownHook called
NiSelClear: removed hdl 3 from selectset
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/1000/27
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 24)
MBUF component DOWN
NiBufClose: clear extensions for hdl 3
NiBufSetStat: bufstat of hdl 3 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 3 / socket 11
MsIDetach: detach MS-system
EsCleanup ....
ShmDelete( 13 )
ShmDelete( 10 )
cleanup event management
cleanup shared memory/semaphores
ShmCleanup SHM_SYS_ADM_KEY
ShmCleanup( 1 )
ShmCreate( 1, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 1, 3 )
ShmCreate( 1, 0, 2, -> 0x00000000c024b000 )
ShmCleanup SHM_DP_ADM_KEY
ShmCleanup( 2 )
ShmCreate( 2, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 2, 3 )
ShmCreate( 2, 0, 2, -> 0x00000000c8000000 )
ShmCleanup SHM_DP_CA_KEY
ShmCleanup( 3 )
ShmCreate( 3, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 3, 3 )
ShmCreate( 3, 0, 2, -> 0x00000000cb000000 )
ShmCleanup SHM_PF_KEY
ShmCleanup( 4 )
ShmCreate( 4, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 4 ) = 0740 (octal)
ShmCleanup SHM_PRES_BUF
ShmCleanup( 14 )
ShmCreate( 14, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 14 ) = 0740 (octal)
ShmCleanup SHM_CALI_BUFFER
ShmCleanup( 11 )
ShmCreate( 11, 0, 2, 0x800003fffaff1d60 )
ShmGet( 10, 11, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 10, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 10 ) = 0740 (octal)
ShmCleanup SHM_DB_TBUFF
ShmCleanup( 19 )
ShmCreate( 19, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 19 ) = 0740 (octal)
ShmCleanup SHM_DB_TBUFF_P
ShmCleanup( 33 )
ShmCreate( 33, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 33 ) = 0740 (octal)
ShmCleanup SHM_DB_STBUFF
ShmCleanup( 41 )
ShmCreate( 41, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 41 ) = 0740 (octal)
ShmCleanup SHM_DB_TTBUFF
ShmCleanup( 42 )
ShmCreate( 42, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 42, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_FTBUFF
ShmCleanup( 43 )
ShmCreate( 43, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 43, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_SNTBUFF
ShmCleanup( 45 )
ShmCreate( 45, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 45, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_IRBUFF
ShmCleanup( 44 )
ShmCreate( 44, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 44, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_OBJ_BUFFER
ShmCleanup( 54 )
ShmCreate( 54, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 54 ) = 0740 (octal)
ShmCleanup SHM_DB_SYNC
ShmCleanup( 46 )
ShmCreate( 46, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 46, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_CUA_BUFFER
ShmCleanup( 47 )
ShmCreate( 47, 0, 2, 0x800003fffaff1d60 )
ShmGet( 40, 47, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 40, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_DB_OTR_BUFFER
ShmCleanup( 64 )
ShmCreate( 64, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 64 ) = 0740 (octal)
ShmCleanup SHM_DB_ESM_BUFFER
ShmCleanup( 65 )
ShmCreate( 65, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 65 ) = 0740 (octal)
ShmCleanup SHM_ROLL_AREA_KEY
ShmCleanup( 9 )
ShmCreate( 9, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 9 ) = 0740 (octal)
ShmCleanup SHM_PAGING_AREA_KEY
ShmCleanup( 8 )
ShmCreate( 8, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 8 ) = 0740 (octal)
ShmCleanup SHM_ROLL_ADM_KEY
ShmCleanup( 17 )
ShmCreate( 17, 0, 2, 0x800003fffaff1d60 )
ShmGet( 10, 17, 0, 2, 0x800003fffaff1ec8 )
ShmCreate( 10, 0, 2, 0x800003fffaff2160 )
ShmKeyPermission( 10 ) = 0740 (octal)
ShmCleanup SHM_PAGING_ADM_KEY
ShmCleanup( 18 )
ShmCreate( 18, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 18 ) = 0740 (octal)
ShmCleanup SHM_PXA_KEY
ShmCleanup( 6 )
ShmCreate( 6, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 6 ) = 0740 (octal)
ShmCleanup SHM_ENQ_TABLE_KEY
ShmCleanup( 34 )
ShmCreate( 34, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 34 ) = 0740 (octal)
ShmCleanup SHM_ENQID_KEY
ShmCleanup( 58 )
ShmCreate( 58, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 58 ) = 0740 (octal)
ShmCleanup SHM_VB_ADM_KEY
ShmCleanup( 7 )
ShmCreate( 7, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 7 ) = 0740 (octal)
ShmCleanup SHM_DB_POOL
ShmCleanup( 40 )
ShmCreate( 40, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 40 ) = 0740 (octal)
ShmCleanup SHM_EM_ADM
ShmCleanup( 51 )
ShmCreate( 51, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 51, 3 )
ShmCreate( 51, 0, 2, -> 0xc000000005000000 )
ShmCleanup SHM_MSBUF
ShmCleanup( 52 )
ShmCreate( 52, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 52, 3 )
ShmCreate( 52, 0, 2, -> 0x00000000c20d8000 )
ShmCleanup SHM_THRUN_ADM_KEY(th run adm)
ShmCleanup( 30 )
ShmCreate( 30, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 30 ) = 0740 (octal)
ShmCleanup SHM_JAVA
ShmCleanup( 70 )
ShmCreate( 70, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 70 ) = 0740 (octal)
ShmCleanup SHM_PF_AS_KEY(Appl.Statistics)
ShmCleanup( 56 )
ShmCreate( 56, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 56 ) = 0740 (octal)
ShmCleanup SHM_POOL_0
ShmCleanup( 10 )
ShmCreate( 10, 0, 2, 0x800003fffaff1d60 )
ShmKeyPermission( 10 ) = 0740 (octal)
ShmCleanup SHM_PROFILE
ShmCleanup( 57 )
ShmCreate( 57, 0, 2, 0x800003fffaff1d60 )
ShmProtect( 57, 3 )
ShmCreate( 57, 0, 2, -> 0xc000000000680000 )
MiCleanup:
ShmCleanup( 62 )
ShmCreate( 62, 0, 2, 0x800003fffaff1e10 )
ShmProtect( 62, 3 )
ShmCreate( 62, 0, 2, -> 0x00000000d2000000 )
MpiCleanup() -> 0
removing Semaphore-Management
removing request queue
ShmCleanup( 31 )
ShmCreate( 31, 0, 2, 0x800003fffaff1df0 )
ShmProtect( 31, 3 )
ShmCreate( 31, 0, 2, -> 0x00000000c7700000 )
closing connect handles (dgm + tcp)
DpDelSocketInfo: del info for socket 1 (type=2)
NiICloseHandle: shutdown and close hdl 1 / socket 8
DpDelSocketInfo: del info for socket 2 (type=1)
NiBufClose: clear extensions for hdl 2
NiBufSetStat: bufstat of hdl 2 changed from OK to OFF
NiICloseHandle: shutdown and close hdl 2 / socket 9
***LOG Q05=> DpHalt, DPStop ( 1794) [dpxxdisp.c 8790]
*** shutdown completed - server stopped ***
Good Bye .....
This is something related to Network Interface Timeout ...
Can you please Advise ASAP.
Thanks & Regards
SAPFORSAP
Hello
When I do. tnsping from Central Host, it is OK.
camcrp01:oraccp> tnsping CCP
TNS Ping Utility for HPUX: Version 9.2.0.7.0 - Production on 06-APR-2006 12:17:54
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oracle/CCP/920_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = camcrp01) (PORT = 1527))) (CONNECT_DATA = (SID = CCP) (GLOBAL_NAME = CCP.WORLD)))
OK (0 msec)
When I do tnsping from Application Server, it says :
camxit01:oraccp> tnsping CCP
ksh: tnsping: not found
Also When I try R3trans -d:
camcrp01:oraccp> R3trans -d
This is R3trans version 6.13 (release 640 - 21.10.05 - 15:04:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CCP'"
R3trans finished (0012).
Please Advise ASAP..
Thanks & Regards
SAPFORSAP
Check if the contents of tnsnames on the app server is the sames as on your central instance
post the trans.log (logfile created by R3trans -d)
Are you using tcp_invited_nodes in your sqlnet.ora on your central instance? If so, is the hostname of your application server added to this parameter?
Have you made any changes to your hosts file? (central instance or app server)
Please restart the listener on your central instance and try agian..
That's it for the moment.......
Good luck!