ERR -24909,ERR_DBAUNKNOWN: SYSDBA unknown

[Former Member]

Hi all,

I 've this message while trying to upgrade an 7.3 version to an 7.5 but I couldn't find how to activate SYSDBA.

I've tryed:

user_sysdba

db_activate

and none of it works.

some more ideas ?!?!

Thanks and best regards!

[former_member229109]

Dear Mr. Rodrigues,

1) Please see the documentation to use 'db_activate' command at MAXDB Library :

http://dev.mysql.com/doc/maxdb/en/91/1a74d35cad11d4aa1500a0c9430730/content.htm

2)You reported in another post that upgrade from an 7.3 to an 7.5 in phase load systab I've this error ::

-24909: ERR_DBAUNKNOWN - SYSDBA unknown

The message "ERR_DBAUNKNOWN: SYSDBA unknown" means, that the dbmserver

could not find the SYSDBA user of the database.

Please update with output of the following commands on the database server:

cd /sapdb/programs/bin

sdbregview -l

dbmcli -s inst_enum

dbmcli -s db_enum

xinstinfo <db-name>

dbmcli -d <db-name> -u control,<pwd> show version

dbmcli -d <db-name> -u control,<pwd> user_getall

Please check if you are able to connect to the database as superdba user < default password - admin >:

dbmcli -d <db-name> -u control,<pwd>

<enter>

dbmcli on <db-name>>sql_connect superdba,<pwd>

<enter>

dbmcli on <db-name>>exit

Or you could use the SQLStudio to connect to the database.

If you know the password of the superdba user =>

load system tables manually with command :

dbmcli -d <db-name> -u control,<pwd> load_systab -u superdba,<pwd> -ud domain

=> the SYSDBA user/password will be updated in the UPC files.

See "load_systab" documentation in MAXDB Library at:

http://dev.mysql.com/doc/maxdb/en/48/b751d25c7f11d4aa1500a0c9430730/content.htm

Please review the SAP notes::

129352 Homogeneous system copy with MaxDB (SAP DB)

<After recovery with initialization, you need to load the system tables.>

25591 Changing the DBM, SYSDBA and DBA user passwords

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Thanks for your quick answer, it gave me the light to solve it, I'm already at 7.6. I've updated table from DBM GUI witch asked me for user and password!!

I've already reward some points to you.

Thanks a lot.

Best Regards