Maxdb 7.7.4 wont start ERR_WRONGDBSTATE Operational State UNKNOWN

[Former Member]

Hi,

We are running maxdb 7.7.4 on a linux suse 10 environment.

The system was shutdown the other week and we cannot get it to restart

When we try and restart we get the following in the dbm.prt

client connection was established at 2010-11-03 01:13:04 (client process has process ID 4520 on computer 169.254.82.132).

2010-11-03 01:13:04 0x00002cd0 INF 283 DBMSrv Command 'auto_extend show' is being executed.

2010-11-03 01:13:04 0x00002cd0 INF 419 DBMSrv Command 'auto_extend' has ended with return code 0.

2010-11-03 01:13:04 0x00002cd0 INF 283 DBMSrv Command 'auto_update_statistics show' is being executed.

2010-11-03 01:13:04 0x00002cd0 INF 419 DBMSrv Command 'auto_update_statistics' has ended with return code 0.

2010-11-03 01:13:08 0x00002cd0 INF 283 DBMSrv Command 'db_online -f' is being executed.

2010-11-03 01:13:08 0x00002cd0 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_online' has ended and failed with return code -24783.

0x00002cd0 ERR -24783 DBMSrv ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

0x00002cd0 ERR -24779 DBMSrv ERR_DBSTATENEEDED4: Database instance must be in one of the operational states OFFLINE, ADMIN, STANDBY or ONLINE.

2010-11-03 01:13:15 0x00002cd0 INF 283 DBMSrv Command 'db_online -f' is being executed.

2010-11-03 01:13:15 0x00002cd0 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_online' has ended and failed with return code -24783.

0x00002cd0 ERR -24783 DBMSrv ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

If we connect via dbmgui it shows it being in a u201Cunknown stateu201D

If I run a db_state command via dbmcli it returns:

OK

State

UNKNOWN

If I run a show state command via dbmcli I get the following message ( sorry about the retype )

OK

ERR 11311 IPC idfile: u2018/sapdb/data/dbspeed/EP4u2019 open error, no such file or directory

Bad magic number in /sapdb/data/wrk/EP4/rtedump_dir/RTEMemory_Table.0: 0x0x found (expected 0x184541191x)

No mapping chunk entries found

u2018RTECons_MemoryDumpMappingu2019 instance could not be created

Failed to map memory dump files

ERR 13638 RTE RTE_ConsoleRequestCommunicatio.cpp:280

ERR 13638 RTE 2010-11-22 07:13:45 RTE error 13638

ERR 13638 RTE Console: Server DB u2018EP4u2019 has not been started

Any ideas ??

Thanks in advance

Gary Vaughan

[Former Member · Accepted solution]

Any specific maintenance over the weekend?

Can you check Note 1283278 - Database cannot be started

[Former Member]

Hi,

Problem solved - a big thankyou

I actually had tried removing the directory contents but not the directory itself.

I had not found the oss note.

Thanks again

Gary Vaughan