Livecache database instance is not able to connect from DBMGUI

[Former Member]

Hello,

We are facing very critical problem. Livecache database instance is not able to connect from DBMGUI .

DB instace is down currently, i checked X_server is running. when i am trying to conect using DBMGUi its going on hang status, same way if i am trying to start using LC10, its going on hang..

Could anybody please help me out if faced this problem.

Earlier it was working fine. But now It 's not able to connect through DBM tool.

Any help would of great help..

Thanks.

Dinesh

please find xserver*.prt files as attached

Date Time PID Typ MsgID Label Message-Text

-

---

2009-06-12 03:10:43 2732 12902 XSERVER started, 'X64/SUN 7.6.04 Build 015-123-189-221'

2009-06-12 03:10:43 2732 12904 XSERVER Service port is 7210

2009-06-12 03:10:43 2732 12922 ENVIRON Command line arguments

2009-06-12 03:10:43 2732 12924 ENVIRON [1] start

2009-06-12 03:10:43 2732 12923 ENVIRON Command line argument dump completed

2009-06-12 03:10:43 2732 12898 ENVIRON Resource limit dump start

2009-06-12 03:10:43 2732 12898 ENVIRON Started by user id 58007 group id 1670

2009-06-12 03:10:43 2732 12898 ENVIRON Current user id 58007 effective id 58007

2009-06-12 03:10:43 2732 12898 ENVIRON Current group id 1670 effective id 1670

2009-06-12 03:10:43 2732 12898 ENVIRON cpu time unlimited

2009-06-12 03:10:43 2732 12898 ENVIRON number of processes 29995

2009-06-12 03:10:43 2732 12898 ENVIRON number of open files 2048

2009-06-12 03:10:43 2732 12898 ENVIRON core size unlimited

2009-06-12 03:10:43 2732 12898 ENVIRON file size unlimited

2009-06-12 03:10:43 2732 12898 ENVIRON heap memory size unlimited

2009-06-12 03:10:43 2732 12898 ENVIRON stack memory size 8192 KBytes

2009-06-12 03:10:43 2732 12898 ENVIRON virtual memory size unlimited

2009-06-12 03:10:43 2732 12898 ENVIRON Resource limit dump completed

2009-06-12 03:10:43 2732 12898 ENVIRON Environment dump start

2009-06-12 03:10:43 2732 12898 ENVIRON PATH=/usr/xpg4/bin:/usr/ccs/bin:/usr/bin

2009-06-12 03:10:43 2732 12898 ENVIRON :/opt/SUNWspro/bin

2009-06-12 03:10:43 2732 12898 ENVIRON IFS=

2009-06-12 03:10:43 0 0

2009-06-12 03:10:43 2732 12898 ENVIRON TZ=NZ

2009-06-12 03:10:43 2732 12898 ENVIRON TMP=/var/tmp

2009-06-12 03:10:43 2732 12898 ENVIRON TMPDIR=/var/tmp

2009-06-12 03:10:43 2732 12898 ENVIRON USER=sdb

2009-06-12 03:10:43 2732 12898 ENVIRON LOGNAME=sdb

2009-06-12 03:10:43 2732 12898 ENVIRON DBROOT=/sapdb/programs

2009-06-12 03:10:43 2732 12898 ENVIRON LD_LIBRARY_PATH=/sapdb/programs/lib

2009-06-12 03:10:43 2732 12898 ENVIRON Environment dump completed

-

---

end of startup -

---

2009-06-12 03:10:44 2732 WNG 12458 XSERVER NISSL Utility init: CDKLoadSAPCryptModule: 51

2009-06-12 07:54:23 2732 ERR 11379 CONNECT Error getting TCP/IP host by address: '10.115.104.42.'

2009-06-12 08:47:00 17388 ERR 11925 XSERVER Send packet, Ref:9 - connection closed (send:EPIPE)

-

---

current write position -

---

[Former Member · Accepted solution]

what files do you see in

drwxrwx--- 2 sdb sdba 512 Jan 23 2007 nzlsfn41

[Former Member]

Hello Dinesh,

1)

I am not aware of any specific files which should be in home directory fo sdb user

what exactly is in you other server in this directory ? what files ?

-> indeed you can have xuser data there but this should not cause the problems you have

2) x_cons command output ?????

Ivan

[Former Member]

I Ivan,

I checked with my server meintance team, they not have any backup for user home directory(sdb user),

is it any way i cab recreate everything in sdb home direcotyry, can i copy it from other live cache system

Thanks,

Dinesh

[Former Member]

Hi Ivan,

Thanks for the great help you provided,

I already raised the message to SAP and waiting for there reply and I also observerd that in my system in home directory of sdb user everying is missing as below

nzlsfn40:ltradm 22% ls -alt

total 8

drwxr-xr-x 2 root other 512 Jun 15 11:00 .

drwxrwxrwx 119 orabwr dba 2560 Jun 15 11:00 ..

nzlsfn40:ltradm 23%

I checked in my other system sdb user has some files

nzlsfn41:lpqadm> ls -alt

total 6

drwxr-xr-x 4 sdb sdba 512 Oct 9 2007 ..

drwxrwx--- 3 sdb sdba 512 Jan 23 2007 .

drwxrwx--- 2 sdb sdba 512 Jan 23 2007 nzlsfn41

nzlsfn41:lpqadm>

is this causing the issue? then i will ask my server team to restore it

Thanks,

Dinesh

[Former Member]

Hello Dinesh,

have you open SAP message already ?

Ivan

Edited by: Ivan Levrinc on Jun 12, 2009 5:28 PM

[Former Member]

Hello Dinesh,

have you run x_cons command I have alsed you ?

Ivan

[Former Member]

Hi Ivan,

After running the commands which you suggested me i am able to start the live cache(though it took 1 hour to start), but problem related to DBM Gui still persist, GUI is getting hang every time when i am trying to used it ,

it is only showing system details when i am clicking on cancel button, which is quite strange,

Thanks,

Dinesh

[Former Member]

Hello

1) if the issue is critical I would realy recommend SAP message

2) from x_server log it looks like some network issue, check the network between SAP an LC server

3) can you start liveCache instance from dbmcli command from liveCache server ?

try

dbmcli -d <SID> -u control,<password> db_state

dbmcli -d <SID> -u control,<password> db_admin

dbmcli -d <SID> -u control,<password> db_online

if the issue is related to x_server (and netwrok) , you should still be able to start/stop livecache from

local host with dbmcli

if you have problem to start/stop LC also from localhost(dbmcli) then forget about x_server log and check

knldiag logs

also try

x_cons <SID> sh ac

Regards

Ivan

[Former Member]

Hi Ivan,

thanks for the reply, i used the commands suggested by you.

nzlsfn40:ltradm 43% pwd

/sapdb/data/wrk

nzlsfn40:ltradm 44% dbmcli -d LTR -u control,control db_state

OK

State

OFFLINE

nzlsfn40:ltradm 45% dbmcli -d LTR -u control,control db_admin

OK

nzlsfn40:ltradm 46% nzlsfn40:ltradm 46%

nzlsfn40:ltradm 46% dbmcli -d LTR -u control,control db_online

db_online commands is running since long and in knldiag. i am continuously watching logs as below, can you have any idea

Dinesh

logs :-

2009-06-12 10:58:34 137 12929 TASKING Task T114 started

2009-06-12 10:58:34 137 11007 COMMUNIC wait for connection T114

2009-06-12 10:58:34 137 11561 COMMUNIC Connected T114 local 3966

2009-06-12 10:58:34 137 11509 COMMUNIC Connection broken by appl state 10 T114

2009-06-12 10:58:34 137 WNG 11824 COMMUNIC Releasing T114 connection aborted

2009-06-12 10:58:34 137 12827 COMMUNIC wait for connection T114

2009-06-12 10:58:35 11 11561 COMMUNIC Connecting T115 local 3966

2009-06-12 10:58:35 138 12929 TASKING Task T115 started

2009-06-12 10:58:35 138 11007 COMMUNIC wait for connection T115

2009-06-12 10:58:35 138 11561 COMMUNIC Connected T115 local 3966

2009-06-12 10:58:35 138 11509 COMMUNIC Connection broken by appl state 10 T115

2009-06-12 10:58:35 138 WNG 11824 COMMUNIC Releasing T115 connection aborted

2009-06-12 10:58:35 138 12827 COMMUNIC wait for connection T115

2009-06-12 10:58:36 11 11561 COMMUNIC Connecting T116 local 3966

2009-06-12 10:58:36 139 12929 TASKING Task T116 started

2009-06-12 10:58:36 139 11007 COMMUNIC wait for connection T116

2009-06-12 10:58:36 139 11561 COMMUNIC Connected T116 local 3966

2009-06-12 10:58:36 139 11509 COMMUNIC Connection broken by appl state 10 T116

2009-06-12 10:58:36 139 WNG 11824 COMMUNIC Releasing T116 connection aborted

2009-06-12 10:58:36 139 12827 COMMUNIC wait for connection T116