on 10-12-2015 3:59 AM
Hi everyone
I have SAP Solution Manager 7.1 On Linux suse 11 and MaxDB 7.8 with SID ZZZ. The password of dba user SAPZZZ was changed.
The old password was for example'XxHh$115' (with special caracter $) and the new password is 'XxSYy2015'.
I change the password in Database studio following the instructions of the sap notes:
25591 - Password change for DBM and DBA users
39439 - XUSER entries for SAP MaxDB
The change of the password was succesfully.
I obtain an error in the transactioN DB13 and using dbmcli command:
dbmcli: hostname_xx:ssmadm 69> dbmcli -d ZZZ -u SAPZZZ,XxSYy2015
Error! Connection failed to node (local) for database ZZZ:
-24950,ERR_USRFAIL: User authorization failed
In DB13: Name and Server :
ZZZ - hostname_xx Function
: DBM_GETF Command
: DBAHIST DATE=20141010 Error
: DBM Error Return Code : -2 Error Message
: ERR_USRFAIL: User authorization failed
I try to change the password via dbmcli with the following command:
dbmcli -u SAPZZZ,XxHh\$115 -uk DEFAULT -us SAPZZZ,XxSYy2015 -d ZZZ -n hostname_xx
but the error is: Error! wrong username or password!
Database studio is working fine, I can to execute backups with the user SAPZZZ.
Please help us to solve it, I need schedule the database backup using the transaction DB13 but the job ended with message: -24950,ERR_USRFAIL: User authorization failed.
Thanks in advanced for your help.
Best Regards,
Osmany Martínez
Hi Martinez,
Have your try to check if the old password is still working.
also do check your x_server process is started. Also do verify the oss note 39439 - XUSER entries for SAP MaxDB
Do let us know the details.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ram
I try to use old password (with \ before $ to scape the special caracter) and I obtain:
-24950,ERR_USRFAIL: User authorization failed
x_server is runnig.
I follow the instrution of sap note 39439 to add the XUSER entries:
xuser -U DEFAULT -u SAP<SID>,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set
I obtain the error in DB13 transaction and using dbmcli.
Regards,
Osmany
Hi James
I change the password from Database Studio using the command:
ALTER PASSWORD SAPZZZ XxSYy2015
And add the xuser entry with the following command:
xuser -U DEFAULT -u SAPZZZ,XxSYy2015 -d ZZZ -n hostname_xx -S SAPR3 -t 0 -I 0 set
I can to connect to database with user SAPZZZ in Database Studio but cannot connect with dbmcli.
Best regards,
Osmany
Hi Ormany,
You can do as below:-
Connect to dbmcli -d <DB NAME> -u control,<password>
Then try below commands
sql_connect superdba,<password>
sql_connect superdba,admin
sql_execute select * from users --> This will give you list of users
ALTER PASSWORD <DBA_user> <new_password> for changing other user passwords.
And for superdba you can use below:-
ALTER PASSWORD <old password> to <new password>
Do let us know if this helps.
Regards,
Ram
Also as your system is solman do execute below commands per note 39439 - XUSER entries for SAP MaxDB being a dual stack,
xuser -U DEFAULT -u SAP<SID>,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set
for j2ee:-
xuser -U c_J2EE -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set
Regards,
Ram
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.