cancel
Showing results for 
Search instead for 
Did you mean: 

Connect dbacockpit to maxdb

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JamesZ
Advisor
Advisor
0 Kudos

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

0 Kudos

Hi James,

thank you for your quick reply.

I did some further investigation.

Seems the SAPR3 schema is not there.

This is what happened:

Installed Content Server D71 with MAXdb 7.9.08.23

Restored backup of old Content Server D70 on this database

Exchanged certificates

Repositories can be used in ERP.

I now installed P71 Content Server. This one still has the default installationi databsae, so no restore has been done.

In Database Studio, If I logon to D71 with SAPR3, I dont see roles, schemas etc. below SAPR3

But for P71 (still with the default database) I do see roles, schemas etc

Did some authorizations got removed from user SAPR3?

Thanks

Sander

JamesZ
Advisor
Advisor
0 Kudos

Hi Gemert,

The display could be caused by wrong password in login.

Please drop the login of SAPSR3, then create new loggin, this time you have to make sure the password is right.

What is below command?

dbmcli -d <dbsid> -u sapsr3,<password> db_state

Best regards,
James

0 Kudos

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

Answers (0)