maxdb parameter file corrupt

[Former Member]

Hello Experts,

The file system /sapdb/data was 100% full some time ago, and since then we cannot start one of the database instances anymore.

When trying to start the instance it returns:

dbmcli -U c_J2EE db_start

ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'

Error! Connection failed to node sapwd2 for database WD2:

connection broken

In the file /sapdb/data/wrk/dbmsrv_nlbsf02.prt I find the following lines at the time of error:

2009-02-18 14:04:00 0x00002a05 INF          1 DBMSrvCo A DBM Server client connection was established at 2009-02-18 14:03:59 (client process has process ID 10755 on computer sapwd2.bsf.bouwstenenfabriek.nl).
2009-02-18 14:04:00 0x00002a05 ERR     -24700 DBMSrv   ERR_DBMSRV_NOSTART: Could not start DBM server.
                    0x00002a05 ERR     -24840 DBMSrv   ERR_NODBMLOGGER: DBM logger could not be initialized
                    0x00002a05 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                    0x00002a05 ERR      20062 RTE      RTE error checksum does not match, parameter file may be corrupt
                    0x00002a05 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                    0x00002a05 ERR      20062 RTE      RTE error checksum does not match, parameter file may be corrupt
2009-02-18 14:04:00 0x00002a05 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 10755 on computer sapwd2.bsf.bouwstenenfabriek.nl). 

However, there is no indication which parameter file is corrupt. There is nothing written in directory /sapdb/data/wrk/WD2 when I try to start, so the KnlMsg file does not change either.

My question is for which parameter file is the checksum not correct? Is there a way to fix this parameter file?

I have searched google and SDN but not found anything usefull so far.

Rob Veenman

SAP Basis

[Former Member · Accepted solution]

Hi,

it looks like the database parameter file located in indepdata/wrk has been corrupted.

The name of the file is <DBNAME>.

This file contains the database configuration.

It sounds like during the file system full situation the file has been corrupted.

The database has more than one version of the parameter file stored.

You will find the elder version of the parameter file in the indepdata/wrk directory as well.

To solve this problem you should copy the corrupted one to <DBNAME>.corr

and then reload the last correct version of the parameter file with dbmcli param_restore <version>

Regards, Christiane