4 Replies Latest reply: Nov 24, 2009 9:52 PM by Natalia Khlopina RSS

Uninstall MaxDB

Currently Being Moderated

Hi

 

How to uninstall MaxDB when user's DB password is lost?

 

Thanks

Vidyadhar

  • Re: Uninstall MaxDB
    Natalia Khlopina
    Currently Being Moderated

    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

    • Re: Uninstall MaxDB
      vaibhav gore
      Currently Being Moderated

      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

      • Re: Uninstall MaxDB
        Natalia Khlopina
        Currently Being Moderated

        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

    • Re: Uninstall MaxDB
      vaibhav gore
      Currently Being Moderated

      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

Actions