on 10-12-2009 1:51 PM
Hi
How to uninstall MaxDB when user's DB password is lost?
Thanks
Vidyadhar
Hello Vidyadhar,
1. Please post more details about the database version and OS of the database server.
Please update with output of the following commands:
sdbregview -l
dbmcli -s db_enum
dbmcli -s inst_enum
xinstinfo <SID-DB>
2. Please review the MaxDB Library at
http://maxdb.sap.com/doc/7_7/default.htm ->
Installation Manual ->
Installation, Upgrade, and Uninstalling in the Command Line
Are you planning uninstall the dependent database software or all MAXDB software on the server?
Are you SAP customer?
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.
Hi,
Below is the command i have performed.Please help as i dnt want to reinstall content server.
C:\Program Files (x86)\SDB\DBM>xuser list
-
XUSER Entry 1
-
Key :DEFAULT
Username :CONTROL
UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2:?????????
Dbname :SDB
Nodename :<unspecified>
Sqlmode :<unspecified>
Cachelimit :-1
Timeout :-1
Isolation :-1
Charset :<unspecified>
C:\Program Files (x86)\SDB\DBM>dbmcli dbmcli -n <dbhostname> -d <DBSID> -u contr
ol,<pw> ...
The system cannot find the file specified.
C:\Program Files (x86)\SDB\DBM>dbmcli -n <dbhostname> -d <DBSID> -u control,<pw>
...
The system cannot find the file specified.
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,Admin@dms1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,dmsadmin1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,dmsadmin1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,control
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -s db_enum
Warning! Can't find Installation!
(use "dbmcli -s -R <instroot> inst_reg [-c]" to avoid this message)
OK
SDB E:\sapdb\SDB\db 7.6.03.09 fast running
SDB E:\sapdb\SDB\db 7.6.03.09 quick offline
SDB E:\sapdb\SDB\db 7.6.03.09 slow offline
SDB E:\sapdb\SDB\db 7.6.03.09 test offline
CDB E:\sapdb\CDB\db 7.6.03.09 fast running
CDB E:\sapdb\CDB\db 7.6.03.09 quick offline
CDB E:\sapdb\CDB\db 7.6.03.09 slow offline
CDB E:\sapdb\CDB\db 7.6.03.09 test offline
Regards,
vaibhav
Hi,
Below is the command i have performed.Please help as i dnt want to reinstall content server.
C:\Program Files (x86)\SDB\DBM>xuser list
-
XUSER Entry 1
-
Key :DEFAULT
Username :CONTROL
UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password :?????????
PasswordUCS2:?????????
Dbname :SDB
Nodename :<unspecified>
Sqlmode :<unspecified>
Cachelimit :-1
Timeout :-1
Isolation :-1
Charset :<unspecified>
C:\Program Files (x86)\SDB\DBM>dbmcli dbmcli -n <dbhostname> -d <DBSID> -u contr
ol,<pw> ...
The system cannot find the file specified.
C:\Program Files (x86)\SDB\DBM>dbmcli -n <dbhostname> -d <DBSID> -u control,<pw>
...
The system cannot find the file specified.
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,Admin@dms1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,dmsadmin1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,dmsadmin1
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -n dmsserver -d SDB -u control,control
Error! Connection failed to node dmsserver for database SDB:
-24950,ERR_USRFAIL: User authorization failed
C:\Program Files (x86)\SDB\DBM>dbmcli -s db_enum
Warning! Can't find Installation!
(use "dbmcli -s -R <instroot> inst_reg [-c]" to avoid this message)
OK
SDB E:\sapdb\SDB\db 7.6.03.09 fast running
SDB E:\sapdb\SDB\db 7.6.03.09 quick offline
SDB E:\sapdb\SDB\db 7.6.03.09 slow offline
SDB E:\sapdb\SDB\db 7.6.03.09 test offline
CDB E:\sapdb\CDB\db 7.6.03.09 fast running
CDB E:\sapdb\CDB\db 7.6.03.09 quick offline
CDB E:\sapdb\CDB\db 7.6.03.09 slow offline
CDB E:\sapdb\CDB\db 7.6.03.09 test offline
Regards,
vaibhav
Hello Vaibhav,
You could not connect to the SDB database as control user with control password. So far from the posted information itu2019s not clear if you are using the correct DBM user. May be you created the SDB user with DBM user u2013 dbm,
So try to connect to the database as dbm user with default password u2013 dbm.
You donu2019t want to reinstall content server, so you donu2019t want to uninstall MaxDB instance.
=>
You have following options:
1) Create a new thread where you will post your problem.
or
2) If you are SAP customer, create the SAP ticket to the component u201CBC-DB-SDBu201D.
Thank you and best regards, Natalia Khlopina
User | Count |
---|---|
86 | |
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.