DB in wrong state

[Former Member]

Hello -

We encounter a problem with our livecache after a cluster switch

the db is not usable anymore

symptons:

dbmcli -U c db_start

ERR

-24783,ERR_WRONGDBSTATE: Operational state ONLINE of the database

instance is unsuitable.

-24782,ERR_DBSTATENEEDED1: Database instance must be in operational

state OFFLINE.

but when:

x_cons LSC show all

SERVERDB: LSC

The SERVERDB state is OFFLINE

So it seems the effective state is offline, while all tools (incl LC10) thinks it's online

when trying to bring it down with db_offline or with LC10, we get:

dbmcli on LSC>db_offline

ERR

-24994,ERR_RTE: Runtime environment error

1,database not accesssible: pipe open (6:N

Any ideas ??

thanks

Paul

[Former Member]

answered through OSS call

[markus_doehr2]

> dbmcli on LSC>db_offline

> ERR

> -24994,ERR_RTE: Runtime environment error

> 1,database not accesssible: pipe open (6:N

Without knowing the filesystem setup and an OS it's unlikely that we will be able to help.

I suggest you open an OSS call so the support can have an immediate look onto your system.

Markus

[Former Member]

OSS message was created but no answer yet ...

OS = HP-UX IA64 B.11.23

sdbverfiy indicates the following:

mode of /sapdb/LSC/db/sap/lcinit was modified

mode of /sapdb/LSC/db/pgm/starter/dbmverifypw was modified

mode of /sapdb/LSC/db/sap/lvcbench.so was modified

mode of /sapdb/LSC/db/sap/grantxdb.dbm was modified

mode of /sapdb/LSC/db/sap/saprfc.ini was modified

mode of /sapdb/LSC/db/sap/ObjectAccessProvider.lst was modified

mode of /sapdb/LSC/db/misc/drop_demo_db.sh was modified

mode of /sapdb/LSC/db/pgm/starter/sdbstarter was modified

mode of /sapdb/LSC/db/misc/create_demo_db.sh was modified

mode of /sapdb/LSC/db/install/SDBRUN was modified

mode of /sapdb/LSC/db/sap/ObjectAccessProvider.sdbsql was modified

mode of /sapdb/LSC/db/lib/python23.zip was modified

mode of /sapdb/LSC/db/sap/dbpinstall.lst was modified

mode of /sapdb/LSC/db/env/en/DBM.en was modified

mode of /sapdb/LSC/db/install/libperl.so was modified

any critical objects in here maybe that could cause this problem ?

is there a way to force the db to have state offline ?

regards

Paul

[former_member229109]

Hello Paul,

What is OSS ticket number?

Additional information is needed to get clear on the reported issue:

1. Did you run sdbverify as root ?

2. Please post the output of the commands:

dbmcli u2013s inst_enum

dbmcli u2013s db_enum

ps u2013efe | grep kernel

ps u2013efe | grep sdb

3. Please review SAP Note No. 803452.

Did you set up the directories in <independent_data_path> as share directories?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello,

dbmcli -d LSC -s inst_enum

OK

7.7.04.29 /sapdb/LSC/db

7.7.04.29 /sapdb/LSC/sapdata1/db

strange that it gives 2 lines ?

dbmcli -d LSC -s db_enum

OK

LSC /sapdb/LSC/db 7.7.04.29 fast offline

LSC /sapdb/LSC/db 7.7.04.29 quick offline

LSC /sapdb/LSC/db 7.7.04.29 slow offline

LSC /sapdb/LSC/db 7.7.04.29 test offline

LSC /sapdb/LSC/db 7.7.04.29 fast offline

LSC /sapdb/LSC/db 7.7.04.29 quick offline

LSC /sapdb/LSC/db 7.7.04.29 slow offline

LSC /sapdb/LSC/db 7.7.04.29 test offline

the OSS message number is: 0001148628

thanks

Paul

[Former Member]

Hi,

I unregistered the 2nd one, now I have a correct reply - problem however remains...

dbmcli -d LSC -s inst_enum

OK

7.7.04.29 /sapdb/LSC/db

dbmcli -d LSC -u control,******

dbmcli on LSC>db_stop

ERR

-24994,ERR_RTE: Runtime environment error

20091,STOP: Kill failed: Not owner

Paul

[former_member229109]

Hello Paul,

Further processing of this issue could be done via SAP ticket.

Please update it with additional information.

Thank you and best regards, Natalia Khlopina