Cannot connect to MaxDB after a system copy (recovery method)

[Former Member]

Hello all,

I wanted to refresh our QAS DB with our PRD DB. So, I have carried out a recovery with a PRD backup. I have made a mistake when I loaded the system tables with Database Studio. I used SUPERDBA for the login and not the SAP<SID> login.

I tried :

dbmcli -d QAS -u CONTROL,pass -uSQL SUPERDBA,Pass sql_execute rename user SUPERDBA to SAPQAS

But no effect ...

How can I come back ?

Thanks,

--

Fabien

[Former Member · Accepted solution]

The correct command would be

dbmcli -d QAS -u CONTROL,pass -uSQL SUPERDBA,Pass sql_execute rename user SAPPRD to SAPQAS

Maybe you need to rename SAPQAS first back to SUPERDBA. SUPERDBA is not the appropriate user for SAP tables, the best thing would be to start over with your restore.

[Former Member · Accepted solution]

Hi Daniel,

With dbmcli when I check the users table, I can see the SAPQAS user. How can I reset his password ?

regards,

[Former Member · Accepted solution]

After rename, the user should have PRDs SUPERDBA password.

[Former Member · Accepted solution]

I tried to connect with SAPPRD on our PRD system with dbmcli :

dbmcli -u SAPPRD,Pass -d PRD

It fails, I don't have the correct password for SAPPRD ... So if I carry out a new recovery, I will not be able to create xuser.

I did not find yet a way to reset this password, do you know ?

[Former Member · Accepted solution]

You need at least password of SUPERDBA:

dbmcli -U c -uSQL superdba,<password SUPERDBA PRD> sql_execute "alter password SAPPRD <new password>"

[Former Member · Accepted solution]

Thank you Daniel ! After recreate xuser, I can connect to my QAS instance.

Thanks a lot !

regards,

--

Fabien

[Former Member · Accepted solution]

Glad we could solve it!

[former_member188883]

Hi Fabien,

Have you selected initialize database during restoration ?

If not please repeat restoration with the same.

Secondly you may need to reset the password for Superdba user post restoration.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Yes I carried out the restoration with initialization.

I can connect with dbmcli and superdba user.

When I start sap, I have an error in dev_w0 file :

C  *** ERROR => the connected user (SUPERDBA) does not work with the right user/

schema

[dbslsdb.cpp  5443]

C  *** ERROR => application has to work with schema SAPQAS (dbs/ada/schema)

[dbslsdb.cpp  5445]

C  Disconnecting from connection 0 ...

C  Now I'm disconnected from MaxDB

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1497]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thx

xhead.c   11348]

Regards,

--

Fabien

[former_member188883]

Hi Fabien,

Check SAP note 129352 - Homogeneous system copy with MaxDB

Replace profile parameter dbs/ada/schema with SAPQAS

Hope this helps.

Regards,

Deepak Kori

[Former Member]

The profile parameter is correct and set to dbs/ada/schema/SAPQAS.

The user connected is SUPERDBA, I would like to know how to create or replace a user SAPQAS or SAPPRD in my DB ?

Regards,

--

Fabien

[former_member188883]

Hi Fabien,

Refer screenshot in link below

MaxDB - Overview

http://maxdb.sap.com/doc/7_6/f7/2ca441b75ca109e10000000a155106/frameset.htm

Hope this helps.

Regards,

Deepak Kori