Skip to Content
0
Feb 11, 2010 at 06:43 AM

*** ERROR => CONNECT failed with sql error '12154'

1451 Views

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]