MAXDB Upgrade Error :load_systab ERR -24909,ERR_DBAUNKNOWN: SYSDBA unknown

[Former Member]

Hi,

I'm upgrading SAPDB 7.3.035 to MAXDB 7.6.03 on Testing Server (previously done homogenous system copy on windows 2000).

During upgrade (dbupdate -d SDB -u superdba,admin -dir c:\temp) , I get the following error:

load_systab ERR -24909,ERR_DBAUNKNOWN: SYSDBA unknown

When try to run the following

sql_connect superdba,admin

getting error:

ERR-24988,ERR_SQL: SQL error-4008,Unknown user name/password combination

Checking the current system status:

=========================================================================================================

C:\sapdb\programs\bin>sdbregview -l

Server Utilities c:/sapdb/programs 7.6.03.09 32 bit valid

DB Analyzer c:/sapdb/programs 7.6.03.09 32 bit valid

PCR 7300 c:/sapdb/programs 7.3.00.59 valid

PCR 7301 c:/sapdb/programs 7.3.01.22 valid

PCR 7500 c:/sapdb/programs 7.5.00.46 32 bit valid

PCR 7104 c:/sapdb/programs 7.1.04.45 valid

SAP Utilities c:/sapdb/programs 7.6.03.09 32 bit valid

PCR 7240 c:/sapdb/programs 7.2.04.17 valid

Redist Python c:/sapdb/programs 7.6.03.09 32 bit valid

Base c:/sapdb/programs 7.6.03.09 32 bit valid

JDBC c:/sapdb/programs 7.6.03.03 valid

Messages c:/sapdb/programs MSG 0.5603 valid

ODBC c:/sapdb/programs 7.6.03.09 32 bit valid

Database Kernel c:/sapdb/sdb/db 7.6.03.09 32 bit valid

Loader c:/sapdb/programs 7.6.03.09 32 bit valid

SQLDBC c:/sapdb/programs 7.6.03.09 32 bit valid

Fastload API c:/sapdb/programs 7.6.03.09 32 bit valid

PCR 7250 c:/sapdb/programs 7.2.05.24 valid

SQLDBC 76 c:/sapdb/programs 7.6.03.09 32 bit valid

PCR 7403 c:/sapdb/programs 7.4.03.49 32 bit valid

C:\sapdb\programs\bin>dbmcli -s inst_enum

OK

7.6.03.09 C:\sapdb\sdb\db

C:\sapdb\programs\bin>dbmcli -s db_enum

OK

SDB C:\SAPDB\SDB\DB 7.6.03.09 quick offline

SDB C:\SAPDB\SDB\DB 7.6.03.09 slow offline

SDB C:\SAPDB\SDB\DB 7.6.03.09 test offline

SDB C:\SAPDB\SDB\DB 7.6.03.09 fast running

C:\sapdb\programs\bin>xinstinfo SDB

IndepData : C:\sapdb\data

IndepPrograms : C:\sapdb\programs

InstallationPath : C:\SAPDB\SDB\DB

Kernelversion : KERNEL 7.6.03 BUILD 009-123-163-622

Rundirectory : e:\sapdb\data\wrk\SDB

C:\sapdb\programs\bin>dbmcli -d SDB -u control,control show version

OK

SERVERDB: SDB

Kernel Version 'Kernel 7.6.03 Build 009-123-163-622'

RTE Version 'W32/INTEL 7.6.03 Build 009-123-163-622'

Console command finished (2010-01-25 10:43:23).

C:\sapdb\programs\bin>dbmcli -d SDB -u control,control user_getall

OK

domain

CONTROL

superdba

========================================================================================================

How to solve this?

Thanks and regards,

Hery

[former_member524429]

Hi,

load_systab ERR -24909,ERR_DBAUNKNOWN: SYSDBA unknown

The SYSDBA (database system administrator) required to load the system tables is not known to the DBM server. Specify the database system administrator.

ERR-24988,ERR_SQL: SQL error-4008,Unknown user name/password combination

The specified combination of user name and password is unknown. The database system can only be accessed by a combination that is known to the database instance. Provide valid user-name with correct password.

Regards,

Bhavik G. Shroff

[Former Member]

Hi Bhavik,

Thanks for your checking..

Yes, I try to reset password of user superdba as per SAP Note 25591, getting the following:

C:\sapdb\programs\bin>dbmcli -d SDB -u control,control

dbmcli on SDB>user_put superdba password=admin

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

But when try to connect to DB via dbmcli using superdba user, it is OK:

C:\sapdb\programs\bin>dbmcli -d SDB -u superdba,admin

dbmcli on SDB>

What's wrong? How to solve this?

Thanks and regards,

Hery

[former_member524429]

Hi,

Connect to DB via dbmcli using superdba user

C:\sapdb\programs\bin>dbmcli -d SDB -u superdba,admin

dbmcli on SDB>user_put superdba password=<new password>

Status of your Upgradation Progress ?

Regards,

Bhavik G. Shroff

[Former Member]

Hi Bhavik,

Getting the same error:

C:\sapdb\programs\bin>dbmcli -d SDB -u superdba,admin

dbmcli on SDB>user_put superdba password=admin

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

The upgrade status is halted on step "Loading System Tables" :

loading system tables...

loading system tables failed

load_systab

ERR

-24909,ERR_DBAUNKNOWN: SYSDBA unknown

Thanks and regards,

Hery

[former_member524429]

PS: Please don't go with those steps without the analysis of the real issue!

      The application data will be lost after you will run "db_activate" command!!

Hi,

May be superdba is in inactive mode.

Please do the following.

db_admin

db_activate superdba,<pass>

sql_connect superdba,<pass>

load_systab -u superdba,<pass> -ud domain

And proceed with your installation process.

On error, please post the same.

Regards,

Bhavik G. Shroff

Edited by: Natalia Khlopina on Jan 25, 2010 10:48 AM

!!!!!!!!!!!!!!!!!!!!!!

Please pay attention:

After you run "db_activate superdba,<pass>" the database will be initialized & application data will be lost.

See: http://maxdb.sap.com/doc/7_7/44/ede271d43e67dfe10000000a155369/content.htm

It was wrong solution in this thread Read to the end of this thread.

[Former Member]

Hi Bhavik,

It is working ..

Thanks a lot for the solution.

Upgrade completed as below:

loading system tables...

checking catalog...

current database state is ONLINE

switch database state to OFFLINE

migrating catalog to unicode...

current database state is ONLINE

MaxDB instance "SDB" updated successfully Mo, Jan 25, 2010 at 14:50:04

0

Upgrade to MaxDB version 7.6 finished successful

regards,

Hery

[former_member524429]

Congratulation.

Regards,

Bhavik G. Shroff

[Melanie]

Hello Hery,

did you actually perform a 'db_activate'?

Have you checked afterwards, if your data is still there?

'db_activate' initalizes the database! During that process the sysdba user is set - but this is not the correct solution

to solve a 'wrong password' problem!

Regards, Melanie

[lbreddemann]

Amazing to see that

a) you tend to answer any question without actually knowing the technical background

b) you find people that actually just believe what you write

and

c) you're just happy to see that they loose all data by following your advise!

This thread is unbelievable!

thanks for all the entertainment!

Lars

[Former Member]

Hi Bhavik,

Bad News.. after completing upgrade and checking why I cannot access data from my test application, I just aware that my data is Gone ! ..on DBM, Data size is showed as 0 %

Fortunately it is a test system.. So, need to redo everything..

regards,

Hery

[Former Member]

I have uninstall MAXDB 7.6 then reinstall SAP DB 7.3.035.. Then I repeat

the system copy using the same/previous Backup + applying additional

Log files. But when trying to activate the database, it is giving

error "ERR -24988,ERR_SQL sql error-8888,connection broken". The

Database then become OFFLINE status. Checking the knldiag file, it is

showing:

"

2010-01-27 07:47:13 0x15C ERR 51361 RESTART CONTROL USER ALR. EXISTS; 0

2010-01-27 07:47:13 0x15C ERR 18196 DBCRASH vabort:Emergency Shutdown, vgg01.c: 2374

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE module file name |.text start |.text end

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE kernel.exe | 0x00400000 | 0x00844000

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE DBGHELP.dll | 0x72a00000 | 0x72a2d000

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE WS2HELP.DLL | 0x75020000 | 0x75028000

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE WS2_32.dll | 0x75030000 | 0x75043000

2010-01-27 07:47:13 0x15C ERR 19999 BTRACE WSOCK32.DLL | 0x75050000 | 0x75058000

"

Just wondering, As I am only repeating the previous homogeneous system copy steps which was successfully done last time

(before upgrade). and it is using the same backup file.

Thanks and regards,

Hery

[Former Member]

Hello ,

at this stage , if you are SAP customer, I would suggest you open SAP message

Regards

Ivan