DBstate UNKNOWN

[Former Member]

Hi,

I cant restart the maxdb, the error messages are this.

-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.

What can try?

[markus_doehr2 · Accepted solution]

Try

dbmcli -U c db_offline
dbmcli -U c db_online

Markus

[Former Member · Accepted solution]

Thanks markus,

I´ve tried the two commands and this is the output for both

x123uy:> dbmcli -U c db_offline

Error! XUser not found!

It´s not necessary to indicate a user?

[markus_doehr2 · Accepted solution]

x123uy:> dbmcli -U c db_offline

Error! XUser not found!

It´s not necessary to indicate a user?

Is that a SAP system or a single database?

Usually the key "U" is the control user.

This problem happens if you e. g. shut down the operating system without shutting down the database before.

Markus

[Former Member · Accepted solution]

It´s a SAP system.

The server was shutdown accidentally.

What is the steps to follow in this case? The D.B is corrupted??

More thanks

[markus_doehr2 · Accepted solution]

It´s a SAP system.

So you're logged on as adm? Is it ABAP or Java?

Markus

[Former Member · Accepted solution]

Yes, I´ve tried with user root, sidadm and control.

Is an abap system.APO 7.0

With user sidadm, this are the results.

xxxxx:sidadm> dbmcli -d SID -u control,password db_state

OK

State

UNKNOWN

xxxxx:sidadm> dbmcli -d LIV -u control,password db_start

ERR

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

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

[markus_doehr2 · Accepted solution]

> xxxxx:sidadm> dbmcli -d SID -u control,password db_state

> OK

> State

> UNKNOWN

> xxxxx:sidadm> dbmcli -d LIV -u control,password db_start

> ERR

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

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

So please execute first a "db_offline" and then a db_start.

Markus

[Former Member · Accepted solution]

It´s the same output

xxxxx:sidadm> dbmcli -d SID -u control,password db_offline

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.

xxxxx:sidadm> dbmcli -d SID -u control,password db_start

ERR

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

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

[markus_doehr2 · Accepted solution]

Try a "db_stop"

Markus

[Former Member · Accepted solution]

the answer is

xxxx:sidadm> dbmcli -d SID -u control,password db_stop

ERR

-24960,ERR_DBRUN: Database instance is running

[former_member229109 · Accepted solution]

Use the db_admin command to start the database in admin status & post the results.

Please post the output of the commands:

sdbregview -l

xinstinfo <DB-name>

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

After of a time, I´ve tried to connect with the dbmgui, and the Database was an online status.

Before to do your steps I´ve tried with editing the script lcinit that says in this note

Note 1461628 - support of liveCache 7.7 on Solaris Cluster

But I´m not sure which is the cause of the stopped and started??

[former_member229109 · Accepted solution]

Hello Ruben,

-> Did you create the SAP message on the reported in this thread issue?

-> Do you install the liveCache 7.7 in Solaris Cluster configuration?

Thank you and best regards, Natalia khlopina

[Former Member · Accepted solution]

Hi,

I don´t create a sap message.

I had been installed the livecache 7.7 on solaris

[Former Member]

I had a similar issue, due to file-system filling up overnight:

83,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.

I issued the statement provided above:

dbmcli -U c db_stop

OK

That worked and I was able to restart successfully.