Database failed Mini SAP

[Former Member]

Hello,

till afternoon I was working with the Mini SAP Netweaver 2004S (SP 12) with no problem. Now during the night I just can get the database started. I´m getting the following error message:

bsa0048:l0madm 72> dbmcli -d -u control,PWD db_state

Error! Connection failed to node (local) for database SID:

-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

-24832,ERR_SHMNOTAVAILABLE: Shared memory not available

-24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory

-24711,ERR_SHMEXADRESS (0XBA00F3) of exits variable for linetype 0 out of scope

Error: error while calling dbmcli

c:sapdbprogramspgmdbmcli" -d NSP -u , db_online

I read one post here with a similar problem but it is not working for me.

What should I do ??

Thanks

[former_member229109 · Accepted solution]

Hello Jorge,

-> Please update with additional information :

• What is the version of the database?

• Please run the following commands & update with output:

sdbregview -l

xinstinfo NSP

dbmcli inst_enum

dbmcli db_enum

dbmcli -d NSP -u control,PWD db_state

dbmcli -d NSP -n <servername> -u control,PWD db_state

• Please post errors in dbmsrv_< server name> .prt

located in <independent_data_path>/wrk

< <independent_data_path> & <dependent_programs_path> you will see with 'xinstinfo' command >

• Check if there are any permissions issues for the files located in <independent_data_path>, <independent_data_path>/wrk.

• Did you get this error, when you are connecting locally (local communication) with the OS user l0madm?

-> Please copy the files first::

<independent_data_path>/wrk/NSP.dbm.shi

<independent_data_path>/wrk/NSP.dbm.shm

• As a workaround, try UNLOCK/DELETE the current DBM Shared Memory using the dbmshm tool::

After that please run the following commands & update with the results:

< 'xinstinfo NSP' < to see the 'InstallationPath' >>

<InstallationPath>/pgm/dbmshm UNLOCK <independent_data_path> NSP

dbmcli -d NSP -u control,PWD

<enter>

If you still got 'ERR_SHMNOCLEANUP' error, reset DBM Server Shared Memory by executing

the following command:

<<InstallationPath>/pgm/dbmshm DELETE <indep_datapath> NSP

After that run:

dbmcli -d NSP -u control,PWD

<enter>

-> If you have further questions/problems with MAXDB database, please post the question at MAXDB/liveCache forum

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Klaus,

yes, both services are running.

-

-

---

Hello Nathalia,

I didn´t understand your instructions. I assume I have to use the "SQL command line interface" and if so, I get an error message after the first instruction (sdbregview):

Connection failed (RTE database name is missing).

Where do I check the version ??

[former_member229109 · Accepted solution]

Hello Jorge,

Please run the following 5 commands:

c:\sapdb\programs\pgm\dbmcli -s inst_enum

c:\sapdb\programs\pgm\dbmcli -s db_enum

c:\sapdb\programs\bin\sdbregview -l

c:\sapdb\programs\bin\xinstinfo

c:\sapdb\programs\bin\xinstinfo NSP

and post your results in the thread.

*****

For example, on my local PC:

1) dbmcli db_enum

OK

TEST c:\sapdb\nlk\db 7.7.00.15 fast offline

TEST c:\sapdb\nlk\db 7.7.00.15 slow offline

MAXDB1 C:\sapdb\maxdb\db 7.6.03.08 fast offline

MAXDB1 C:\sapdb\maxdb\db 7.6.03.08 slow offline

< I have two database instances TEST & MAXDB1 of the versions 7.7.00.15 & 7.6.03.08 .

Run 'dbmcli explain db_enum' to see more information about 'db_enum' command. >

2) xinstinfo MAXDB1

IndepData : C:\sapdb\data

IndepPrograms : C:\sapdb\programs

InstallationPath : C:\sapdb\maxdb\db

Rundirectory : c:\sapdb\data\wrk\MAXDB1

The vestion of the database instance could be checked also in the knldiag file located in the Rundirectory.

< search for "KERNELVERSION" parameter value or "version" string. For examle in the knldiag

file of the MAXDB1 on my PC:

...

2007-11-26 15:49:05 0xC3C 19600 VERSION 'Kernel 7.6.03 Build 008-123-159-187'

2007-11-26 15:49:05 0xC3C 19600 VERSION 'W32/INTEL 7.6.03 Build 008-123-159-187'

… >

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

this is what I get after running those commands:

<b>1) dbmcli -s inst_enum</b>

OK

7.6.02.14 c:\sapdb\NSP\db

<b>2) dbmcli -s db_enum</b>

OK

NSP c:\sapdb\NSP\db 7.6.02.14 fast running

NSP c:\sapdb\NSP\db 7.6.02.14 quick offline

NSP c:\sapdb\NSP\db 7.6.02.14 slow offline

NSP c:\sapdb\NSP\db 7.6.02.14 test offline

<b>3) sdbregview -l</b>

SAP utilities c:/sapdb/programs 7.6.02.14 32 bit valid

Server utilities c:/sapdb/programs 7.6.02.14 32 bit valid

BAse c:/sapdb/programs 7.6.02.14 32 bit valid

JDBC c:/sapdb/programs 7.6.03.02 valid

Messages c:/sapdb/programs MSG 0.5028 valid

ODBC c:/sapdb/programs 7.6.02.14 32 bit valid

Database kernel c:/sapdb/nsp/db 7.6.02.14 32 bit valid

SQLDBC c:/sapdb/programs 7.6.02.14 32 bit valid

Webtools c:/sapdb/programs/web 7.6.02.14 32 bit valid

SQLDBC 76 c:/sapdb/programs 7.6.02.14 32 bit valid

<b>4) xinstinfo</b>

IndepData : c:\sapdb\data

IndepPrograms : c:\sapdb\programs

<b>5) xinstinfo NSP</b>

IndepData : c:\sapdb\data

IndepPrograms : c:\sapdb\programs

InstallationPath : c:sapdb\NSP\db

Kernelversion : KERNEL 7.6.02 BUILD 014-123-152-175

Rundirectory : c:\sapdb\ata\wrk\nsp

Thanks a lot and best regards

[former_member229109 · Accepted solution]

Hello Jorge,

Could you please follow the further steps from my reply above:

1) Please run the following 2 commands < please replace the PWD by the correct password>:

c:\sapdb\programs\pgm\dbmcli -d NSP -u control,PWD db_state

c:\sapdb\programs\pgm\dbmcli -d NSP -n <servername> -u control,PWD db_state

and post your results in the thread.

2) Please post errors in dbmsrv_< server name> .prt located in c:\sapdb\data\wrk

3) Check if there are any permissions issues for the files located in c:\sapdb\data\wrk,

c:\sapdb\data\wrk.

4) Did you get this error, when you are connecting locally (local communication) with the OS user l0madm?

5) Please copy the files first::

c:\sapdb\data\wrk\NSP.dbm.shi

c:\sapdb\data\wrk\NSP.dbm.shm

As a workaround, try UNLOCK/DELETE the current DBM Shared Memory using the dbmshm tool update with the results:

c:\sapdb\NSP\db\pgm\dbmshm UNLOCK c:\sapdb\data NSP

c:\sapdb\programs\pgm\dbmcli -d NSP -u control,PWD

<enter>

If you still got 'ERR_SHMNOCLEANUP' error, reset DBM Server Shared Memory by executing the following command:

c:\sapdb\NSP\db\pgm\dbmshm DELETE c:\sapdb\data NSP

After that run:

c:\sapdb\programs\pgm\dbmcli -d NSP -u control,PWD

<enter>

-> If you have further questions/problems with MAXDB database, please post the question at MAXDB/liveCache forum

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hurra !!!!!!

the server is operational again, after doing the steps that you describe, and the screen turns green instead of red.

I´ll post partially the result, because the logfile in 2) is huge:

OK

state

ADMIN

It would be very interesting to know why this problem happend. I was trying to configure the ADS for being able to work with Adobe Forms, accoding to some information that I found in this forums .... and when I started the computer later again the server was damaged.

Thanks a lot for your help !!!

[klaus_keller]

Hello,

Have you checked whether any MaxDB services are running?

Check in Windows the services: <b>XServer</b> and <b>MAXDB: NSP</b>. You may try to start them manually.

Rgds,

Klaus

[Former Member]

hi,

restart ur server and then start the server,

[Former Member]

Hi,

I already did that more than once and doesn´t help.