cancel
Showing results for 
Search instead for 
Did you mean: 

-24907,ERR_DBAWRONG: wrong SYSDBA

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

please try to run


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

first and afterwards the load_systab.

regards,

Lars

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello everybody

I got the same problem, I read the whole article , even I got the password for superdba I am not able to load systables.

My case/procedure: Homogenous migration from MaxDB 7.5 win 2003  -> 7.9 win 2008 (production DB on customer side with SAP Content Server)

1.complete data backup on 7.5 on old server via database manager 7.5

2.moved backup file from old to new server

3.installed MaxDB database 7.9 + studio 7.9

5. During installation I create by default - DBADMIN and set password

6. performed  recovery via studio - 129352 SAP note  ( Administration Tasks -> Recovery. Choose Recover a Medium and select Initialize Database before Recovery for a system copy )

7. recovery completed and successfully

8. I tried also perfrom db_activate superdba,admin - 25591 SAP note (but I lost datas which is not good as this is customer production system)

9. Perfromed recovery again and now I am in this status:

outputs from new server:  DBM user is (control) fro my understanding in new MaxDB version 7.9

I:\sapdb\programs\pgm>dbmcli -d SDB -u superdba,admin sql_connect

OK

I:\sapdb\programs\pgm>dbmcli -d SDB -u dbm,control

dbmcli on SDB>sql_connect

OK

I:\sapdb\programs\pgm>dbmcli -d SDB -u superdba,admin user_getall

OK

DBM

superdba

dbmcli on SDB>param_checkall

OK

---

dbmcli on SDB>

I:\sapdb\programs\pgm>

I:\sapdb\programs\pgm>dbmcli -d SDB -u superdba,admin

dbmcli on SDB>load_systab

ERR

-24909,ERR_DBAUNKNOWN: SYSDBA unknown

---

dbmcli on SDB>

I:\sapdb\programs\pgm>dbmcli -d SDB -u superdba,admin

dbmcli on SDB>user_sysdba superdba,admin

OK

---

dbmcli on SDB>

dbmcli on SDB>

db_state

OK

State

ONLINE

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

outputs from old server:

C:\>dbmcli -d SDB -u superdba,admin user_getall

OK

sdbadmin

control

domain

superdba

C:\>dbmcli -d SDB -u superdba,admin sql_connect

OK

C:\>

Load systables on old server working fine

I am still not able to load systables and perfrom correct recovery on new server.

Attached screen of new MaxDB in current status.

Please kindly check, I will appreciate every help.

Many thanks.

BR

Daniel

Former Member
0 Kudos

Hello Daniel,

what is the result of

dbmcli -d SDB -u superdba,admin user_get superdba

Can you try to load the the system tables with

dbmcli -d DBM,control load_systab -u superdba,admin

Kind regards,

Burkhard

Former Member
0 Kudos

Hi Burkhard

output from 1st command:

I:\sapdb\programs\pgm>dbmcli -d SDB -u superdba,admin user_get superdba

OK

SERVERRIGHTS=UserMgm,InstallMgm,SystemCmd,DBFileRead,AccessUtility,Recovery,Back

up,ParamFull,ParamCheckWrite,ParamRead,AccessSQL,ExecLoad,LoadSysTab,DBStop,DBSt

art,DBInfoRead,SharedMemoryMgm,SchedulerMgm,Scheduling,EvtDispMgm,EvtDisp

GUIRIGHTS=

SECONDPASSWORD=NO

DISABLED=NO

COMMENT=

USERTYPE=DBA

EXTERNAL_IDS=

MASTER_PW_ALTER_TIME=2016-01-28 15:04:48

second did not worked due to wrong syntax, but probably you mean:

I:\sapdb\programs\pgm>dbmcli -d SDB -u DBM,control load_systab -u superdba,admin

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

I:\sapdb\programs\pgm>

Still not working

BR

Daniel

Former Member
0 Kudos

Hallo Daniel,

could you please check if your sysdba is the superdba.

Try it with sqlcli

sqlcli -d SDB -u superdba,admin select sysdba from dual

use table SYSDD.VERSION instead of dual. Table dual is loaded by load_systab

Message was edited by: Burkhard Diesing

Former Member
0 Kudos

Hi Burkhard

I am also available on gmail: daniel.krupinsky@gmail.com

I think we can discuss there via chat , will be much quicker discussion if you got time of course to help me.

Many thanks in advance for help.

sqlcli -d SDB -u superdba,admin select sysdba from dual

I:\sapdb\programs>cd bin

I:\sapdb\programs\bin>sqlcli -d SDB -u superdba,admin select sysdba from dual

* -4008: POS(1) Unknown user name/password combination SQLSTATE: 28000

* -4008: POS(1) Unknown user name/password combination SQLSTATE: 28000

I:\sapdb\programs\bin>

BR

Daniel

Message was edited by: Daniel Krupinsky

Former Member

OK the sysdba is the SUPERDBA but the login on db level did not work (-4008: Unknown user name / password)


I suggest to do the following:

1) Reset the  the sysdba password in the database with

dbmcli -d SDB -u DBM,control db_execute alter password SUPERDBA ADMIN

2) Then test the connection with sqlcli to check the password in the database.

sqlcli –d SDB –u superdba,admin select sysdba from sysdd.version

3) Now try to load the system tables

dbmcli -d SDB -u DBM,control load_systab -u SUPERDBA,ADMIN

Former Member
0 Kudos

Hi,

I called our outsourcing partnerto request the password.

load_systab is really fun using the correct password ....

Thank you.

But, is there no way to reset this when it is unknown?

i.e I saw the feature to set a second password for the DBM operators in DBMGui which does not work because of wrong first password....

Best regards

Christian

lbreddemann
Active Contributor
0 Kudos

> load_systab is really fun using the correct password ....

Well, it usually works without problems - but I wouldn't call that 'fun'...

> But, is there no way to reset this when it is unknown?

Unfortunately not.

> i.e I saw the feature to set a second password for the DBM operators in DBMGui which does not work because of wrong first password....

Hmm... yes you might use the feature, but:

- there's no frontend part for it in DB Studio

- you have to assign the 2nd password in advance

- you have to remember the 2nd password.

If you think about it, that's not really an advantage to having just one password.

best regards,

Lars

Former Member
0 Kudos

Sorry, was quiet late last night.

There was data in the database, now it is gone .. I am trying a recovery with initialisation...

Best regards

Christian

former_member229109
Active Contributor
0 Kudos

Hello Christian,

You will get the error "-24907,ERR_DBAWRONG: wrong SYSDBA", if you loaded the system tables with the wrong password of SYSDBA user.

Try "sql_connect superdba,<passwd> " to check if the password is correct or not.

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hello Lars, hello Natalia,

both suggestions did not work:

dbmcli -d XXX -u control,<pwd> user_sysdba superdba

gave me a

ERR

-24996,ERR_PARAM: wrong parameters

sql_connect superdba,admin

gave me a

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

so I tried

user_put superdba password=<pass>

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

But note 25591 - Changing the DBM, SYSDBA and DBA user passwords mentiones, that:


The SYSDBA is the user with the most privileges in the database.
This user is specified when the database is activated.

util_activate superdba,admin    (SAP DB Versions 7.3/7.4)
db_activate superdba,admin      (MaxDB Versions >= 7.5)

So I did a

db_admin

db_activate superdba,<pass>

OK

sql_connect superdba,<pass>

OK

load_systab -u superdba,<pass> -ud domain

OK

...

Installation successfully finished

Thank you very much for your help.

Best regards

Christian

lbreddemann
Active Contributor
0 Kudos

> So I did a

> db_admin

> db_activate superdba,<pass>

> OK

> sql_connect superdba,<pass>

> OK

> load_systab -u superdba,<pass> -ud domain

> OK

> ...

> Installation successfully finished

>

> Thank you very much for your help.

>

Hmmm.... I hope there had not been any user data in that db before, because it would be gone by now.

regards,

Lars

former_member229109
Active Contributor
0 Kudos

Hello,

1. "dbmcli -d XXX -u control,<pwd> user_sysdba superdba"

See syntax/document at http://maxdb.sap.com/doc/7_7/45/1befa8be505d7be10000000a11466f/content.htm

But it will not help with reported error.

2. "sql_connect superdba,admin

gave me a

ERR

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination"

Exactly, what I wrote, that you got the error during the loading system tables, because you used the wrong password.

Example on the local server:

dbmcli -d NLK -u control,test

dbmcli on NLK>sql_connect superdba,test

OK

dbmcli on NLK>sql_release

OK

dbmcli on NLK>load_systab -u superdba,admin

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

dbmcli on NLK>load_systab -u superdba,test

u2026 done.

3. "so I tried

user_put superdba password=<pass>

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA"

The Sap note 25591 gave the correct procedure to change the sysdba password.

< read the section "3. Changing the password for the SYSDBA user "!>

You could not use the dbm command user_put to change the SYSDBA user password.

4. As you are running the database installation, you could run "db_activate superdba,<pass>" to initialize the database again. At that time you know the password of the superdba user. But the database is initialized, so don't use this option when you will have application data in the database!

The database was already online, when you posted this question on forum.

What password did you select for SYSDBA (UserDatabase System Administrator) during installation?

Are you running new installation?

The XCMDOUT.log need to be checked.

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hi Natalia,

I am doing a homogenous systemcopy, using backup restore.

I am sorry, but I can't get the difference between

The Sap note 25591 gave the correct procedure to change the sysdba password.

< read the section "3. Changing the password for the SYSDBA user "!>

and:

You could not use the dbm command user_put to change the SYSDBA user password.

Best regards

Christian

former_member229109
Active Contributor
0 Kudos

Hello Christian,

1. "The Sap note 25591 gave the correct procedure to change the sysdba password.

< read the section "3. Changing the password for the SYSDBA user "!>"

As it was written in the note, to change the SYSDBA user password the database has to be online,

then you need to connect to the database as SYSDBA user & change the password with the

given SQL statement. After the password is changed & you could connect to the database as

SYSDBA user with the new password, you could adjust the UPC containers with new password

of the SYSDBA user.

You could reload the system tables or run the dbm command 'user_sysdba superdba,<new-pwd>'.

-> Basic Information -> MaxDB Security Guide -> User Administration and Authentication ->

Changing the Passwords of Standard Users

    • "ALTER PASSWORD" statement => see documentation in

"SQL Statements: Overview" in "SQL Reference Manual"

at MAXDB library: http://maxdb.sap.com/doc/7_6/default.htm

    • see the documentation on dbm command user_put from the list of

"Overview of All DBM Commands" at

MaxDB library: http://maxdb.sap.com/doc/7_6/default.htm -> Tools -> Database Manager CLI

2. "a homogenous systemcopy"

Please review the SAP notes SAP Note No. 129352 2C & SAP Note No. 1090087.

The loading system tables in the target database copy should work with the SYSDBA

user & password of the sysdba user in source database.

Do you know the password of the SYSDBA user in the source database?

I recommend to create the SAP ticket, if you will need SAP support further.

Thank you and best regards, Natalia Khlopina

former_member229109
Active Contributor
0 Kudos

Hello Christian,

1. "The Sap note 25591 gave the correct procedure to change the sysdba password.

< read the section "3. Changing the password for the SYSDBA user "!>"

As it was written in the note, to change the SYSDBA user password the database has to be online,

then you need to connect to the database as SYSDBA user & change the password with the

given SQL statement. After the password is changed & you could connect to the database as

SYSDBA user with the new password, you could adjust the UPC containers with new password

of the SYSDBA user, you could reload the system tables or run the dbm command

'user_sysdba superdba,<new-pwd>'.

-> Basic Information -> MaxDB Security Guide -> User Administration and Authentication ->

Changing the Passwords of Standard Users

    • "ALTER PASSWORD" statement => see documentation in

"SQL Statements: Overview" in "SQL Reference Manual"

at MAXDB library: http://maxdb.sap.com/doc/7_6/default.htm

    • see the documentation on dbm command user_put from the list of

"Overview of All DBM Commands" at

MaxDB library: http://maxdb.sap.com/doc/7_6/default.htm -> Tools -> Database Manager CLI

2. "a homogenous systemcopy"

Please review the SAP notes SAP Note No. 129352 2C & SAP Note No. 1090087.

The loading system tables in the target database copy should work with the SYSDBA

user & password of the sysdba user in source database.

Do you know the password of the SYSDBA user in the source database?

I recommend to create the SAP ticket, if you will need SAP support further.

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hi Natalia,

I called our outsourcer to get the correct password, and laoding systabs worked.

Thats what I mean when I said that loading the systabs with the correct password ist fun, because it works!

Many thanks

Christian