shared memory problem : MaxDB

[Former Member]

Hi

I am using SAP ABAP trial version. It was working well but now when i start server. it gives the error:

===================================================

============== Starting System NSP ================

===================================================

=============== Starting database instance ...

The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

The MaxDB Database Starter, Version 7.6.02.14

Copyright 2000-2007 by SAP AG

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

-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

-24827,ERR_SHMALLOCFAILED: ID E:\sapdb\data\wrk\NSP.dbm.shm, requested size 4287

037658

Error: Error while calling dbmcli

"E:\sapdb\programs\pgm\dbmcli" -d NSP -u , db_online

============== Start database failed !

Press any key to continue . . .

can someone tell me the exact steps with command to handle this issue. I am dummie in database administration

Thanks

Vishal Kapoor

[markus_doehr2]

Try to completely stop everything and restart it, if that doesn't help reboot the machine.

Markus

[Former Member]

Hi,

yes, try to stop "everything".

Then kill all processes with name dbmsrv.exe, if there are any.

Then remove E:\sapdb\data\wrk\NSP.dbm.shi and E:\sapdb\data\wrk\NSP.dbm.shm.

There should be no need to reboot the machine.

Now you should be fine.

HTH,

Marc-Philip

[Former Member]

Thanks Mark for the advise.

after the file deletion and system restart as recomended, the new error is coming:

I stopped every MAXDB running service, deleted 2 given files and rebooted system.

=============== Starting database instance ...

The SAP DB WWW service is starting.

The SAP DB WWW service was started successfully.

The MaxDB Database Starter, Version 7.6.02.14

Copyright 2000-2007 by SAP AG

ERR

-24988,ERR_SQL: SQL error

-9022,System error: BD Corrupted datapage

3,Database state: OFFLINE

6,Internal errorcode, Errorcode 9163 "corrupted_datapage"

20026,PAM::GetPage: Data page is not assigned.

6,bd13GetNode, Errorcode 9163 "corrupted_datapage"

20066,HistDir: registered files 50, max used are 50

20017,RestartFilesystem failed with 'System error: BD Corrupted datapage'

Error: Error while calling dbmcli

"E:\sapdb\programs\pgm\dbmcli" -d NSP -u , db_online

============== Start database failed !

Press any key to continue . . .

Thanks

Vishal Kapoor

[markus_doehr2]

Please check the file "knldiag" - it seems you have a corrupt page (I hope you have a backup).

Markus

[former_member199694]

hi Vishal,

Wondering if this "BD Corrupted datapage" issue is resolved? how it was fixed.

I have similar issue, thought your input if any would be helpful.

Thanks,

Raj

[Former Member]

Hi Raj

Please open a new thread for discussion as this one is several years old..

Please provide the details of the error you have observed in the new thread

Thanks

Rishi

Issue locked as requested

Message was edited by: Christiane Hienger