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

Database failed Mini SAP

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 27, 2007 at 09:39 PM

    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 SAP MaxDB

    Thank you and best regards, Natalia Khlopina

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Natalia Khlopina

      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 !!!

  • Posted on Nov 27, 2007 at 06:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 02:13 PM

    hi,

    restart ur server and then start the server,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.