Skip to Content

DB_state:unknown

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 29, 2008 at 06:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 05, 2008 at 07:25 AM

    Unanswered

    Add comment
    10|10000 characters needed characters exceeded