MaxDB Database Startup Error

[Former Member]

The maxDB database is not starting,

When I type

dbmcli -n mgiusdgrc1 -d CME -u superdba,<passwd> db_online, I get the following error.

Error! Connection failed to node <hostname> for database CME:

-24700, ERR_DBMSRV_NOSTART: Could not start DBM Server.

-24832, ERR_SHMNOTAVAILABLE: Shared memory not available.

-24827, ERR_SHMALLOCFAILED: ID E:\sapdb\data\wrk\CME.dbm.shi, requested size 260010,

Opening shared memory file E:\sapdb\data\wrk\CME.dbm.shi failed, rc = 5.

I tried to rename the file CME.dbm.shi, but it did not work.

Currently we have 8 GB of physical memory RAM allocated on Wndows 2008 Server and paging size specified is 16 GB.

1- Can anyone help in resolving the above shared memory error?

2- Are there any logfiles and specific error messages that I need to check, to resolve the MaxDB startup issue error.

Thanks in advance.

[markus_doehr2 · Accepted solution]

- As which user are you trying to start the database?

- You have UAC disabled?

Markus

[Former Member · Accepted solution]

Hi Markus,

I am trying to start the database with superdba user who is the sysdba.

We are on Windows 2008 server. Can you please elaborate, how can I check if UAC is disabled or enabled?

Please note that after the MaxDB install, we got the following list of users and schemas seen below.

In du, I get the following list of database users

Username - Attributes

-

---

Control - Admin, Multiple

SAPCMEDB - DBA, Multiple

SUPERDBA - SYSDBA, Multiple

In ds, I have the following list of database schemas

Username Attributes

-

---

Control - Control

Domain - Superdba

OMS - Superdba

SAPCMEDB - SAPCMEDB

SUPERDBA - SUPERDBA

SYSINFO - SUPERDBA

Thanks,

haleem

[markus_doehr2 · Accepted solution]

> I am trying to start the database with superdba user who is the sysdba.

> We are on Windows 2008 server. Can you please elaborate,

My question was concerning the user you were logged on to the Windows box.

> how can I check if UAC is disabled or enabled?

If you didn't explicitly disable it then it's enabled.

Was the database working before?

Is this database part of a SAP installation?

Markus

[Former Member · Accepted solution]

Hi Markus,

I am logged on as <sid>adm user into Windows Box.

This MaxDB database is a part of SAP AS JAVA install. It was working perfectly since last 3 days and I started facing this MaxDB startup issue, since today morning.

Thanks,

Haleem

[markus_doehr2 · Accepted solution]

Try to start the database with <sid>adm using

dbmcli -U c db_online

What happened before? Did you change any settings? Installed patches?

Markus

[Former Member · Accepted solution]

I typed C:\ dbmcli -U c db_online and got the message

Error! XUser not found!

Then I typed dmcli -n <hostname> -d CME -u superdba,<passwd> db_online, I got the same error as seen in above message.

The database was running OK. Then we installed few add-ons and patches and we executed few background jobs that caused log full situation. We made automatic log backup on and later we got this database startup error.

Can you please let me know, what can I check to get the database startup error resolved. I am getting same message "Shared memory not available, Could not start DBM server. requested size 260010, opening shared memory file failed, rc =5.

Thanks for help in advance.

[markus_doehr2 · Accepted solution]

> I typed C:\ dbmcli -U c db_online and got the message

> Error! XUser not found!

I was wrong, since it's an AS-Java please try

dbmcli -U c_J2EE db_online

> Can you please let me know, what can I check to get the database startup error resolved. I am getting same message "Shared memory not available, Could not start DBM server. requested size 260010, opening shared memory file failed, rc =5.

That's what I'm trying to do

Markus

[Former Member · Accepted solution]

Thanks Markus,

I executed C:\ dbmcli -U c_J2EE db_online and got the same error message as before.

[markus_doehr2 · Accepted solution]

> I executed C:\ dbmcli -U c_J2EE db_online and got the same error message as before.

which one? the shared memory or the xuser error message?

It seems to me that the user running the database is not permitted to create a shared memory segment. This may be caused by the UAC which (sometimes) has some nifty side effects.

You can switch the UAC off by

- start - execute - msconfig

- last tab

- scroll down to "disable UAC"

- reboot

Markus

[Former Member · Accepted solution]

Thanks Markus for your kind help.

Disabling UAC solved the problem.

[Former Member]

Hi all, I see that this was solved. Good. I just wanted to write that I aslo got:

Error! Connection failed to node <hostname> for database CME:

-24700, ERR_DBMSRV_NOSTART: Could not start DBM Server.

-24832, ERR_SHMNOTAVAILABLE: Shared memory not available.

-24827, ERR_SHMALLOCFAILED: ID E:\sapdb\data\wrk\CME.dbm.shi, requested size 260010,

Opening shared memory file E:\sapdb\data\wrk\CME.dbm.shi failed, rc = 5.

when using dbmcli.

My problem was that my database logs was full. I installed maxdb database studio 7.9 for my maxdb 7.7. There it was red light 'Full logs'. I put the log in overwrite mode and the problem disapeared.

Thanks