Skip to Content
author's profile photo Former Member
Former Member

Livecache database instance is not able to connect from DBMGUI

Posted on Jun 11, 2009 at 09:19 PM 29 Views

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 -

SAP MaxDB
Add comment
10|10000 characters needed characters exceeded

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2009 at 08:30 AM

    what files do you see in

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2009 at 09:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 11, 2009 at 11:03 PM

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 02:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 03:27 PM

    Hello Dinesh,

    have you run x_cons command I have alsed you ?

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 03:28 PM

    Hello Dinesh,

    have you open SAP message already ?

    Ivan

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2009 at 11:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2009 at 12:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2009 at 08:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded