cancel
Showing results for 
Search instead for 
Did you mean: 

Max-DB 7.5 Error, Can't make it Offline

Former Member
0 Kudos

Hello all,

I am trying to upgrade my MaxDb 7.5 to 7.6 patch level 18. Before doing this as per the SAP notes I need to make the Max-DB offline using the dbmcli > db_offline command. But when I issue this command using sqd<SID> user then it given me error which is as follows:

"Error! Connection failed to node (local) for database ACP: ERR_USRFAIL: user authorization failed" I tried to issue this command using <SID>adm and even root, but still I get the same error.

Kindly help me to resolve this issue.

Regards,

Premkishan Chourasia

Accepted Solutions (1)

Accepted Solutions (1)

roland_mallmann
Advisor
Advisor
0 Kudos

Hi,

you have to use a DB user to connect with using DMBCLI. For admin purposes, this is the DBM user, normally called 'control'. You should be able to connect to your db with the following syntax:

dbmcli -n <host> -d <DB name> -u <DBM-user>,<password>

Example:

dbmcli -d SDB -u control,control

(in the above example, I did not need to specify a hostname, because the db instance is on the local machine)

The above dbmcli-command will put you in a DBMCLI-session, you can then enter other commands, including your db_offline.

Ofcourse you may also directly use:

dbmcli -d SDB -u control,control db_offline.

Please let me know if this worked out for you.

Regards,

Roland

Former Member
0 Kudos

Hello Roland,

thanks for the information.

After posting the message I too tried the same what you have posted using the control, control and it worked properly.

thanks for the help.

Regards,

Prem

Answers (0)