-24907,ERR_DBAWRONG: wrong SYSDBA

[Former Member]

Hi all,

I want to load the system tables on Maxdb 7.6.05_15.

using dbmcli -d xxx -u control,<passwd>l load_systab -u superdba,<passwd> -ud domain

and I get

-24907,ERR_DBAWRONG: wrong SYSDBA

an sql_execute select * from users shows

OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20070208';'00101102';'20070208';'00101102';'20070208';'00101102';'XXX';'host';0;'NO';(null)

'SUPERDBA';'';'DBSERVICE';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20070208';'00101249';'20070208';'00101249';'20070208';'00101249';'XXX';'host';6;'YES';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20051105';'00140111';'20090218';'00170520';'20060117';'00113906';'XXX';'host';10;'NO';(null)

So the user superdba should be ok to use.

Does anbody have an idea how to fix this?

Thank you.

Best regards

Christian

[lbreddemann · Accepted solution]

please try to run

dbmcli -d xxx -u control,<pw> user_sysdba superdba

first and afterwards the load_systab.

regards,

Lars