Upgrade 7.9.07 BUILD 014-123-244-287 to 7.9.08.22 not possible

[Former Member]

After upgrading to 7.9.08.08, it's not possible to upgrade to .22:

pagxen010:/mnt/BPO_Files/MAXDB/MAXDB7908_22/maxdb-server-linux-64bit-x86_64-7_9_08_22 # ./SDBUPD


SAP MaxDB Installation Manager - Database Upgrade 7.9.08.22
***********************************************************


Upgrade Database:
0: UQ1 "/sapdb/UQ1/db" 7.9.08.08
1: None (Abort upgrade)

please enter database id: 0
Please enter Database Manager Operator: CONTROL
Please enter Database Manager Operator Password:
Checking upgrade...
Running finalize check...
Current database state is ONLINE
Switching database state to OFFLINE
Checking parameters...
Switching database state to ADMIN
Switching database state to ONLINE
ERR: Upgrade failed
ERR: error upgrading
ERR: Finalize upgrade failed: Current database state is ONLINE
Switching database state to OFFLINE
Checking parameters...
Switching database state to ADMIN
Switching database state to ONLINE
Cannot switch database mode, error during dbm command:
db_online
ERR
-24622,ERR_AUTOLOADSYSTAB: Automatic loading of the System Tables
failed-24909,ERR_DBAUNKNOWN: SYSDBA unknown
Looking for error messages in knldiag
No error messages found in knldiag

I tried to restore a backup, no effort. It seems like SUPERDBA isn't working any more, data cache can't be displayed as well.

Any suggestions?

[former_member188883 · Accepted solution]

Hi Daniel,

Could you refer to thread http://scn.sap.com/thread/1706350

Similar issue is discussed here.

Regards,

Deepak Kori

[Former Member · Accepted solution]

I already checked this thread - my problem is that SUPERDBA can't connect:

dbmcli on UP1>sql_connect SUPERDBA,<pwd>

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

---

How can I solve this error?

[former_member188883 · Accepted solution]

Hi Daniel,

Could you share the output of below sql command

> sql_execute select * from users

Regards,

Deepak Kori

[Former Member · Accepted solution]

Something seems wrong:

dbmcli on pagsapup1 : UP1>sql_execute select * from users

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name or unknown schema:USERS

---

dbmcli on pagsapup1 : UP1>sql_execute select * from DOMAIN.USERS

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name or unknown schema:USERS

[former_member188883 · Accepted solution]

Hi Daniel,

Connect with user control and check db_state.

Post this check whether you can execute the sql command.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Problem is resolved by http://service.sap.com/sap/support/notes/1882932 - the password was destroyed during the upgrade.