on 02-11-2010 6:43 AM
Hi,
My system landscape consits of one production server and one application server with dialog instance only for load balancing.
Up to yesterday this was working perfectly.Todat I restart the application server and when I start SAP service the dispatcher is getting stopped after some time. Yesterday I tried to configure the data guard in the production server with another stanby database server and accordingly I have changed some settings in TNSNAMES.ora and LISTENER.ora. It was not successful and revert back the changes in the TNSNAMES.ora and LISTENER.
The dev_disp file output is given below
-
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 00
sid GTP
systemid 562 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 52
intno 20050900
make: multithreaded, ASCII, 64 bit, optimized
pid 3756
Thu Feb 11 11:50:20 2010
kernel runs with dp version 210(ext=109) (@(#) DPLIB-INT-VERSION-210)
length of sys_adm_ext is 360 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 3756) [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 3900
Thu Feb 11 11:50:24 2010
WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 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 >gtnprd1_GTP_00 <
DpShMCreate: sizeof(wp_adm) 13440 (896)
DpShMCreate: sizeof(tm_adm) 4629440 (23032)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552048/552064
DpShMCreate: sizeof(comm_adm) 552064 (1088)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1512)
DpShMCreate: sizeof(wall_adm) (25648/36736/64/104)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000D880050, size: 5288400)
DpShMCreate: allocated sys_adm at 000000000D880050
DpShMCreate: allocated wp_adm at 000000000D881A90
DpShMCreate: allocated tm_adm_list at 000000000D884F10
DpShMCreate: allocated tm_adm at 000000000D884F70
DpShMCreate: allocated wp_ca_adm at 000000000DCEF330
DpShMCreate: allocated appc_ca_adm at 000000000DCF3980
DpShMCreate: allocated comm_adm at 000000000DCF50F0
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 000000000DD7BD70
DpShMCreate: allocated gw_adm at 000000000DD7BDF0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 000000000DD7BE20
DpShMCreate: allocated wall_adm at 000000000DD7BE30
MBUF state OFF
Thu Feb 11 11:50:25 2010
EmInit: MmSetImplementation( 2 ).
MM diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 4096 kByte.
Using implementation flat
<EsNT> Memory Reset disabled as NT default
<ES> 127 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( gtnprdn) [dpxxdisp.c 11414]
DpStartStopMsg: send start message (myname is >gtnprd1_GTP_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 40000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
Release check o.K.
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]
Thu Feb 11 11:51:05 2010
ERROR => W0 (pid 3932) died [dpxxdisp.c 14021]
ERROR => W1 (pid 5104) died [dpxxdisp.c 14021]
ERROR => W2 (pid 5056) died [dpxxdisp.c 14021]
ERROR => W3 (pid 3724) died [dpxxdisp.c 14021]
ERROR => W4 (pid 1828) died [dpxxdisp.c 14021]
ERROR => W5 (pid 3376) died [dpxxdisp.c 14021]
ERROR => W6 (pid 4864) died [dpxxdisp.c 14021]
ERROR => W7 (pid 3540) died [dpxxdisp.c 14021]
ERROR => W8 (pid 4888) died [dpxxdisp.c 14021]
ERROR => W9 (pid 4900) died [dpxxdisp.c 14021]
my types changed after wp death/restart 0x89 --> 0x88
ERROR => W10 (pid 4936) died [dpxxdisp.c 14021]
ERROR => W11 (pid 416) died [dpxxdisp.c 14021]
ERROR => W12 (pid 4852) died [dpxxdisp.c 14021]
ERROR => W13 (pid 4948) died [dpxxdisp.c 14021]
ERROR => W14 (pid 3804) died [dpxxdisp.c 14021]
my types changed after wp death/restart 0x88 --> 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=501
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Feb 11 11:51:15 2010
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Thu Feb 11 06:21:15 2010
========================
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=501
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Thu Feb 11 11:51:20 2010
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >gtnprd1_GTP_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 (1792) (SOFT_KILL)
Stop icman
killing process (1400) (SOFT_KILL)
Terminate gui connections
send SHUTDOWN to REM TM 15
blks_in_queue/wp_ca_blk_no/wp_max_no = 2/300/15
LOCK WP ca_blk 2
return errno (-17) to T15
errormsg without overhead: take mode 0
NiBufIAlloc: malloc NiBufadm, to 0 bytes
try to send 14 to M0
Good Bye .....
THE DEV_W0 is as shown below
M Thu Feb 11 11:50:26 2010
M ThInit: running on host gtnprd1
M
M Thu Feb 11 11:50:27 2010
M calling db_connect ...
C Prepending D:\usr\sap\GTP\D00\exe to Path.
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPDAT's password
C Connecting as /@GTP on connection 0 (nls_hdl 0) ... (dbsl 700 240106)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 00000000131D50B0 0000000009725EA0 0000000009728FE8
C Attaching to DB Server GTP (con_hdl=0,svchp=0000000009728EA8,svrhp=00000000131E5108)
C
C Thu Feb 11 11:50:36 2010
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
[dboci.c 4126]
C *** ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 10704]
C Try to connect with default password
C Connecting as SAPDAT/<pwd>@GTP on connection 0 (nls_hdl 0) ... (dbsl 700 240106)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 00000000131D50B0 0000000009725EA0 0000000009728FE8
C Detaching from DB Server (con_hdl=0,svchp=0000000009728EA8,srvhp=00000000131E5108)
C Attaching to DB Server GTP (con_hdl=0,svchp=0000000009728EA8,svrhp=00000000131E5108)
C
C Thu Feb 11 11:50:45 2010
C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
[dboci.c 4126]
C *** ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 10704]
B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]
B ***LOG BY2=> sql error 12154 performing CON [dblink#3 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink#3 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1403]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10019]
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 semaphore = 0
M act_cs_count = 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 vm = V-1
M
M *****************************************************************************
M *
M * LOCATION SAP-Server gtnprd1_GTP_00 on host gtnprd1 (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Thu Feb 11 11:50:45 2010
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10204
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 3932) [dpnttool.c 327]
Hi
BY0=> ORA-12154: TNS:could not resolve the connect identifier specified
Is your coding correct in the tnsnames.ora (make sure you open brackets mathes your closed ones)
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
ERROR => CONNECT failed with sql error '12154'
[dbsloci.c 10704] B ***LOG BV3=> severe db error 12154 ; work process is stopped
[dbsh#2 @ 1199] [dbsh 1199 ] B ***LOG BY2=> sql error 12154 performing CON [dblink#3 @ 431] [dblink 0431 ] B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified
Make a connectivity test with: "R3trans -d" and supply trans.log along with dev_w0 and dev_w1 traces.
Please refer Note 443867 - ORA-12154 Collective SAP note and correct your TNSNAME.ora and LISTENER.ORA entries.
Also see Note 34479 - Collective note for problems with SQL-Net V2 ORACLE.
Regards,
Bhavik g. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.