on 11-12-2009 2:46 PM
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
please try to run
dbmcli -d xxx -u control,<pw> user_sysdba superdba
first and afterwards the load_systab.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
> 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
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
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
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>'.
Read the document at MaxDB library: http://maxdb.sap.com/doc/7_6/default.htm
-> 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
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>'.
Read the document at MaxDB library: http://maxdb.sap.com/doc/7_6/default.htm
-> 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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.