DB_state:unknown

[harshavarddhan_pandeya]

Hi,

While starting the database (maxDB),i am getting the following error:

ERR

-24783,ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

-24782,ERR_DBSTATENEEDED1: Database instance must be in operational state OFFLINE.

Opening Database...

ERR

-24783,ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

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

present DB_state: unknown

And also i checked the data area and data logs,free space is available.

kindly help me in this issue.

Thanks in advance.

Regards,

Harshavardhan

[former_member229109 · Accepted solution]

Hello Harshavardhan,

-> What is the version of the database?

-> What command did you use to restart the database? < db_admin or db_online ? >

-> Please update the ticket with the output of the following commands:

sdbregview -l

dbmcli db_enum

dbmcli inst_enum

xinstinfo <SID>

dbmcli -d <SID> -u control,<pwd-control> db_state

-> Do you have the database kernel processes running on the server?

What is the OS of the database server?

How did you stop the database?

Was the database server rebooted without the stopping database?

Thank you and best regards, Natalia Khlopina

[harshavarddhan_pandeya · Accepted solution]

Hello Natalia,

Thank you for fast reply.

Now,the issue is solved and system is up and running.

Could you please explain me,why the system Database went to

Unknown state.

I have properly stopped the system and clean the shared memory.

Version of DB: 7.7.03.24

OS of the database server: Linux

*i have only stop the system not rebooted it.

Please suggest me,how to proceed in this situation and why it happens?

Thanks & Regards,

Harshavarddhan

[harshavarddhan_pandeya · Accepted solution]

Hi,

Could you please explain me,why this problem occurs?

Thanks,

Harshavardhan

[Melanie · Accepted solution]

Hello!

To be able to answer your questions you would have to answer Natalias questions.

What do you mean with "i have only stop the system not rebooted it."?

What exactly did you do, when you state "I have properly stopped the system and clean the shared memory."?

Please let us know, which commands you executed before you got this problem.

Then let us know, which commands you executed to solve it.

Be also specific about what you mean with 'system'. Is this the linux server? Or is this the database?

We need as much detailed information as possible - otherwise we are not able to answer why the problem occured. This is not a problem, each customer has every day! So you must have done something special...

Regards, Melanie

[harshavarddhan_pandeya · Accepted solution]

Hello Melanie,

I am working on linux server.

Firstly,I given the command " stopsap <hostname> " to stop the system.I checked the database status which was offline.

After killing all the running processes,I cleared the shared and semaphore memory.

After this,when I tried to start the system by " startsap <hostname>,its DB instance get failed.When I checked the error,I found the error as given below:

-

---

ERR

-24783,ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

-24782,ERR_DBSTATENEEDED1: Database instance must be in operational state OFFLINE.

Opening Database...

ERR

-24783,ERR_WRONGDBSTATE: Operational state UNKNOWN of the database instance is unsuitable.

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

-

---

Commands executed before I got this problem:

1.stopsap <hostname>

2. checking DB staus:which was offline after this command.

3. Killing the running services

:kill -9

4. cleanipcrm 00 rm

cleanipcrm 01 rm....

ipcs

5.clean the shared and semaphore memory.

6.start the system:startsap <hostname>

7. startup failed and db_status:unknown

Commands executed to solve the issue:

1.dbmcli -U c db_start

Could you ,please explain me in this regard?

Thanks & Regards,

Harshavardhan

[Melanie · Accepted solution]

Hello!

How did you check the database state?

Which services did you kill?

Why did you have to "clean the shared and semaphore memory"?

The error message 'state unknown' indicates that the database was not yet stopped correctly.

Do you still have the knlmsg file from the stopping of the database? And also the dbm.prt file from stopping/starting the database?

Regards,

Melanie

[harshavarddhan_pandeya · Accepted solution]

Hello,

I checked DB state through :

dbmcli -d <SID> -u <user name> <password> db_state.

After stopping the system through stopsap <hostname>,I checked the the db state,it was offline.

But I fail to understand,why DB went in unknown state.

I donot have any logs at present related to mentioned problem.

Could you please suggest me the possible reasons?

And how to troubleshoot this problem?

Thanks in advance !!!

Best Regards,

Harshavarddhan

[Melanie · Accepted solution]

Hello Harshavarddhan,

I would expect answers to all of my questions if I'm supposed to help you.

However, as you do not have any log files from the problem situation, I'm afraid I cannot explain what happened.

In case the problem occurs again, you should open a message that SAP support can have a look at the system and analyze what happened!

Regards,

Melanie

[harshavarddhan_pandeya]

Unanswered