Maxdb connection error during system build

[Former Member]

Hi All,

I am performing a system copy of Live cache from production to an FDR landscape. We are on AIX 7.1 and maxdb 7.9. I have been performing the system copy as per the SAP notes 886103 and post cloning as per 877203.

Status till now: I have copied the file systems from source machine to target machine one on one.

When i try unregistering the live cache instance it's throwing the error as below:

# pwd

/sapdb/programs/bin

# ./dbmcli -d TLP -u control,Twining1

Error! Connection failed to node (local) for database TLP:

-24950,ERR_USRFAIL: User authorization failed

The above was performed as root user.

However if i try performing the same using sidadm i get a different error and thats as below:

$ sudo su - tlcadm

Password:

$ cd /sapdb/programs/bin

$ ./dbmcli -d TLP -u control,Twining1

Bad path '/db2/TLP/sapdb/TLP/db/pgm/starter/sdbstarter'

Wanted (UserId     0, GroupId   254, Mode 104510 '-r-s--x---')

Got    (UserId   255, GroupId   254, Mode 104510 '-r-s--x---')

RTE_CallSdbStarter(): Wrong ownership for starter program absolute path

Error! Connection failed to node (local) for database TLP:

Reading header from pipe:closed by serv

I have performed this kind of system copy for 2 other landscapes and both the times i have used root only as the user.

Could anybody assist me as how to proceed further.

This is critical as we are in the middle of the build and need to hand over the system by tomorrow.

Thanks,

Soumya

[Former Member]

Hi All,

Now the error remains the same whether i connect as root user or as sidadm user.

Error details as below:

$ ./dbmcli -d TLP -u control,Twining1

Error! Connection failed to node (local) for database TLP:

-24950,ERR_USRFAIL: User authorization failed

[former_member188883]

Hi Soumya,

Please paste the results from

dbmcli -d <DB-name> -u control,<password for control>

Share the length of password for control user?

Additionally as you performed system copy please refer to below SAP notes to adjust the password of DBM and DBA users.

Note 25591 - Password change for DBM and DBA users

Note 39439 - XUSER entries for SAP DB and MaxDB

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi deepak,

Pls find the output below:

$ ./dbmcli -d TLP -u control,Twining1

Error! Connection failed to node (local) for database TLP:

-24950,ERR_USRFAIL: User authorization failed

The lenght of the password is 8.

I am in the process of performing system copy. Yet to start with the actual steps. All i have done so far is one to one file system copy from the source to target machine.

Thanks,

Soumya