Wrong SYSDBA Error -24908

[Former Member]

Greetings,

We are having a problem with SAPDB that I am not able to solve. We restored a full backup from another server, and after installing it, I managed to bring it online (after some trouble, we ran into some bugs in our particular version of DBMGUI). I can log into both SQL and DBM, but the DBA user was missing after restore (in DBMGUI, it's registered in the SQL). I created the SUPERDBA user, intending it to be the DBA user, but it doesn't show up anything special in DBMCLI. When I log into the SQLStudio and do a check on the users with SELECT * FROM DOMAIN.USERS, SUPERDBA does show up as having SYSDBA mode.

When trying to do a load_systab from DBMCLI, however, it gives the error: -24908 Wrong SYSDBA.

That's great, since there is no other SYSDBA. The DB Engine is 7.4.3.19 Yes, I am aware that it isn't supported, but that doesn't mean it shouldn't work We have to use 7.4 for this project, otherwise I would gladly use 7.7.

(And yes, we are an SAP customer, and I have already put in an OSS note, but I prefer the forum if possible so everyone can see the answer).

Also in the log we get:

ERR_DBAWRONG: wrong SYSDBA

I checked in the help for MaxDB and there is a command (something like conf_sysdba) to change the sysdba user - but that only works on 7.6 or newer. How can we force it to recognize the SYSDBA user on 7.4.3.x?

(Also, I have seen some mysterious commands changing config settings like SAPDB12, but is this stuff documented anywhere).

Thank you very much,

Noah Silva

[Former Member]

Hi there!

I see this question is still not answered yet and because my problem is probably closest to this issue, I will post it here.

We have created a homogenous system copy using the Database Studio Version: 7.8.01.16. MaxDB release 7.7.07.014. When we wanted to change the DB user passwords, we followed these steps:

(with database on-line)

- Login to the database with CONTROL user using the password from the source system.

- Password change for the user CONTROL using the command line in Database Studio: user_put CONTROL password=newpassword

- Login to the database with CONTROL user using the new password.

- Password change for the user SUPERDBA using the command line in Database Studio: user_put SUPERDBA password=newpassword

- Login to the database with SUPERDBA user using the new password... and uh oh... user has only "DBM sessions are possible", even though this user should have SQL and DBM access at the same time. However when we login with the password from the source system, we get only SQL sessions are possible without DBM access.

So now we have SUPERDBA with TWO passwords! When we login with SUPERDBA using password from the source system and try to change the password with the SQL command "alter password oldpassword to newpassword" we get this error:

[-103]: SQL statement not available for this application

But with the above command for the password change we are able to change the password for the user SAP<sid> without problem. The SQL command is not working when executed under SUPERDBA user.

What should we do to have user SUPERDBA with SQL and DBM access at the same time? And of course with only one password.

Thanks a lot for help in advance.