MaxDB cannot start: Missing root pointer in memory mapping

[Former Member]

Hello,

I cannot start (or change to any other state) my MaxDB. I have already tried to remove directory rtedump_dir as per SAP Note 1283278, but this did not help.

Any help will be greatly appreciated

Warm greetings

Jan

mibse2:se2adm 62> dbmcli -d SE2 -u superdba,xxxyyy show state

OK

Missing root pointer in memory mapping when restoring memory map from /sapdb/SE2/data/wrk/SE2/rtedump_dir

mibse2:se2adm 63> dbmcli -d SE2 -u superdba,xxxyyy db_enum

OK

SE2 /sapdb/SE2/db 7.8.01.14 fast offline

SE2 /sapdb/SE2/db 7.8.01.14 quick offline

SE2 /sapdb/SE2/db 7.8.01.14 slow offline

SE2 /sapdb/SE2/db 7.8.01.14 test offline

mibse2:se2adm 64> dbmcli -d SE2 -u superdba,xxxyyy inst_enum

OK

7.8.01.14 /sapdb/clients/SE2

7.8.01.14 /sapdb/SE2/db

mibse2:se2adm 65> sdbregview -l

Installation: Global /sapdb/programs

Global Listener 7.8.01.14 valid 64 bit

Installation Compatibility 7.8.01.14 valid 64 bit

Installer 7.8.01.14 valid

SAP Utilities Compatibility 7.8.01.14 valid 64 bit

Installation: CL_SE2 /sapdb/clients/SE2

Base 7.8.01.14 valid 64 bit

Fastload API 7.8.01.14 valid 64 bit

JDBC 7.6.06.07 valid

Messages MSG 0.9004 valid

ODBC 7.8.01.14 valid 64 bit

SAP Utilities 7.8.01.14 valid 64 bit

SQLDBC 7.8.01.14 valid 64 bit

SQLDBC 76 7.6.06.10 valid 64 bit

SQLDBC 77 7.8.01.14 valid 64 bit

Installation: SE2 /sapdb/SE2/db

Base 7.8.01.14 valid 64 bit

DB Analyzer 7.8.01.14 valid 64 bit

Database Kernel 7.8.01.14 valid 64 bit

Fastload API 7.8.01.14 valid 64 bit

JDBC 7.6.06.07 valid

Loader 7.8.01.14 valid 64 bit

Messages MSG 0.9004 valid

ODBC 7.8.01.14 valid 64 bit

Redist Python 7.8.01.14 valid 64 bit

SAP Utilities 7.8.01.14 valid 64 bit

SQLDBC 7.8.01.14 valid 64 bit

SQLDBC 76 7.6.06.10 valid 64 bit

SQLDBC 77 7.8.01.14 valid 64 bit

Server Utilities 7.8.01.14 valid 64 bit

mibse2:se2adm 66> xinstinfo SE2

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/SE2/db

Kernelversion : KERNEL 7.8.01 BUILD 014-121-233-288

Rundirectory : /sapdb/SE2/data/wrk/SE2

mibse2:se2adm 67>

[former_member188883 · Accepted solution]

Hi,

1. Please update with output of the following commands:

ps u2013efe | grep dbmsrv

ls u2013l /var/lib/sdb/dbm/ipc

ipcs -m | wc u2013l

sysctl -a | grep kernel.shmmni

dbmcli inst_enum

dbmcli db_enum u2013s

2. Please post the dbmsrv*.err located in /sapdb/data/wrk

3. Check first<!> that you have not active dbmrfc/dbmsrv processes,

Stop the x_server .

- kill all these processes manually, if they where not release after

Closing DBMGUI, dbmcli sessions, stoping the application server.

- try to check/remove the shared memory

/sapdb/MAXDB1/db/pgm/dbmshm CHECK /var/lib/sdb/dbm/ipc MAXDB1

/sapdb/MAXDB1/db/pgm/dbmshm DELETE /var/lib/sdb/dbm/ipc MAXDB1

- Check in /var/lib/sdb/dbm/ipc if you have files MAXDB1.dbm.shi and MAXDB1.dbm.shm

< rename both files to MAXDB1.dbm.shi.old and MAXDB1.dbm.shm.old>

- Try to connect to the database using dbmcli tool & post results.

Hope above steps are helpful.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Dear Deepak,

The "dbmshm DELETE" solved the issue !

THANKS 1000 times

cheers

Jan