on 07-24-2006 7:13 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.