SAPDB in status STOPPED INCORRECTLY due to file system failure

[valeriocicchiel]

Hi community,

we have a problem with our SAPDB server.

The file system on which the whole database is installed disappeared form the list of filesystem mounted because of hardware problems, the database instances crashed. Now the problem should be technically solved, the filesystem is mounted again and files should be not corrupted

The first problem was to start the x server, If I tried to start it replied with the following error:

en950_GetProgramExecPath failed:
OS_ERROR  0: No system errortext for ERRNO 0
RTE_ERROR 1: Open Registry:No such file or directoryIndepPrograms

I resolved the problem looking at the file in directory /var/spool/sql/ini and changing the extensions of two files:

SAP_DBTech.ini from Registry_dcom.ini.cnt01

SAP_DBTech.ini from SAP_DBTech.ini.cnt01

Now the x server starts correctly, but the state of the 2 SAPDB instances appears as STOPPED INCORRECTLY

My questions:

- Why the configuration files had that (wrong) extension ?

- What is the correct procedure to try to start the instances in this case?

Regards, Valerio

[markus_doehr2]

> Now the x server starts correctly, but the state of the 2 SAPDB instances appears as STOPPED INCORRECTLY

>

> My questions:

> - Why the configuration files had that (wrong) extension ?

Is this a cluster filesystem?

> - What is the correct procedure to try to start the instances in this case?

Start them using db_online.

Markus

[valeriocicchiel]

Hi everybody,

some additional informations:

- the messages in knldiag are of no help, because the log interrupts at the time of the hardware crash, and it had "no time" to write something down.

- If I try to start the database instances with db_warm get the following error:

ERR
-24994,ERR_RTE: runtime environment error
-11987,Paramfile for serverdb <DEV> not found!

- If I try to start the xinstinfo command I get a similar error:

OS_ERROR  0: No system errortext for ERRNO 0
RTE_ERROR 1: Open Registry:No such file or directoryIndepData
OS_ERROR  0: No system errortext for ERRNO 0
RTE_ERROR 1: Open Registry:No such file or directoryIndepPrograms

So, what are the configuration files that I can check in which SAPDB stores the configuration information it needs?

I suppose that something is missing or cannot be read, but I don't know where to search

Valerio

[lbreddemann]

>

> Hi everybody,

> some additional informations:

> So, what are the configuration files that I can check in which SAPDB stores the configuration information it needs?

> I suppose that something is missing or cannot be read, but I don't know where to search

Yes, obviously there is something missing...

Please, do yourself a favour - reinstall the software and reanimate the instances.

"Repairing" this installation will rather lead to more issues.

regards,

Lars

[valeriocicchiel]

Hi everybody,

the problem was solved simply by renaming these configuration files and giving full permission to them, even if these files are never written but only read. The various errors encountered referred to these two files only and the file system was not corrupted

[root:/var/spool/sql/ini:] ls -lrt
total 32
-rwxrwxrwx    1 root     system          463 Oct 17 2007  Registry_dcom.ini.cnt01
-rwxrwxrwx    1 root     system          545 Oct 17 2007  SAP_DBTech.ini.cnt01
-rwxrwxrwx    1 root     system          463 Aug 26 11:18 Registry_dcom.ini
-rwxrwxrwx    1 root     system          545 Aug 26 11:18 SAP_DBTech.ini
[root:/var/spool/sql/ini:]

Thanks everybody for your support, the question is solved

Valerio

[lbreddemann]

> The file system on which the whole database is installed disappeared form the list of filesystem mounted because of hardware problems, the database instances crashed. Now the problem should be technically solved, the filesystem is mounted again and files should be not corrupted

SHOULD is the keyword of the last sentence!

> The first problem was to start the x server, If I tried to start it replied with the following error:

>

>

en950_GetProgramExecPath failed:
> OS_ERROR  0: No system errortext for ERRNO 0
> RTE_ERROR 1: Open Registry:No such file or directoryIndepPrograms

>

> I resolved the problem looking at the file in directory /var/spool/sql/ini and changing the extensions of two files:

>

> SAP_DBTech.ini from Registry_dcom.ini.cnt01

> SAP_DBTech.ini from SAP_DBTech.ini.cnt01

Hmm... one thing is for sure: the MaxDB software does not rename these files!

> Now the x server starts correctly, but the state of the 2 SAPDB instances appears as STOPPED INCORRECTLY

Did you had a look into the KNLDIAG files?

> My questions:

> - Why the configuration files had that (wrong) extension ?

No idea? Storage/Filesystem issue?

Bad user?

> - What is the correct procedure to try to start the instances in this case?

Depending on how much is broken here... reinstall the software from scratch and either re-register the instances or perform a restore and recovery of them.

regards,

Lars