Skip to Content

Connect dbacockpit to maxdb

Hi

I am doing a system copy of content server from a Win2003 system to a Win2012 system.

These are the steps

Installed cs 6.40 on win2012

backup database on old cs

recovery of database with backup of old system

All runs fine and documents can be accessed from SAP

Now I want to setup dbacockpit.

using user control for dbm connection

usin user sapr3 for sql

The dbm connection is fine, but the sql connection cant be made.

Looked like a user/pw issue, but I am able to logon to database with SAPR3/SAP so the password seems ok.

I tried to connect a system which I just installed and did not do the db recovery on, used CONTROL and SAPR3 and that one got setup OK.

Can I just reset the SAPR3 password to SAP in the maxdb? Do I have to update the password in SAP ERP too somewhere?

Or isnt the user/password not the issue?

Thanks

Sander

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 02, 2016 at 12:47 AM

    Hi Gemert,


    what is the error? Can you show me with the screenshot?

    Generally you can maintain the right password in dbco, or dbacockpit database connections.

    If the password you used can log on database manually, then I do not think reset password helps, it should be the password was wrongly maintained in somewhere.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

    • Hi James,

      Note 1657257 - MaxDB-specific system copy: wrong SYSDBA solved the issue

      because of the db copy something went wrong.

      I did the following

      Set the password of the superdba user to the password specified in the system copy:

        1. Use dbmcli to set up a connection to the database:

        dbmcli -d <databaseID> -u control,<control_password>
        2. Execute the following commands:

        load_systab -u superdba,<oldsuperdba_pwd>

        sql_connect superdba,<oldsuperdba_pwd>

        sql_execute alter password superdba <superdba_pwd>

      1. quit