MaxDB on VMWare - Xuser to change

[Former Member]

Dear all,

I do have the following problem. Let's explain our architecture :

1. P1C is our main productive system, running on CRMPROD1

2. P1C is our 'restored" system running on CRMPPROD7.

3. Both virtual serveurs are running on the samed physical server.

4. I have restored P1C-CRMPROD1 to P1C-CRMPROD7.

5. Now, when I start P1C-CRMPROD7, it connects to ... P1C-CRMPROD1 database, not to its own P1C-CRMPROD7 database.

I have found the reason. When I start the OS command :

xuser list, I get the following answer :

====================================================================================================

CRMPPROD7:p1cadm 51> xuser list

XUSER Entry 1

Key :DEFAULT

Username :SAPP1C

UsernameUCS2:S.A.P.P.1.C. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :P1C

Nodename :CRMPROD1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

XUSER Entry 2

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :P1C

Nodename :CRMPROD1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

XUSER Entry 3

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :P1C

Nodename :CRMPROD1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

XUSER Entry 4

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Dbname :P1C

Nodename :CRMPROD1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

========================================================================================

Question :

Do you know how to replace the 'Nodename' properties for all users, replacing them from CRMPROD1 to CRMPROD7 ?

Thanks

Best regards

SAPAdmin2010

[markus_doehr2 · Accepted solution]

> 3. Both virtual serveurs are running on the samed physical server.

> 4. I have restored P1C-CRMPROD1 to P1C-CRMPROD7.

VMWare "cloning" is not supported to create system copies, too many things would need to be adapted manually that are not documented.

Markus

[Former Member · Accepted solution]

Dear Markus,

Thanks for your input.

In other term, I can restore P1C to CRMPROD7 if this virtual server is not running on the same physical server as CRMPROD1.

1. P1C-source system runs on CRMPROD1 virtual server. This virtual server runs on Vmserv01 physical server.

2. P1C-restore system runs on CRMPROD7 virtual server. This virtual server runs on Vmserv07 physical server.

This system copy will be possible ?

Best regards

SAPAdmin2010

[markus_doehr2 · Accepted solution]

You will need to run sapinst to adapt the environment, profiles and permissions. How you then restore the database itself doesn't matter.

Markus

[Former Member]

You need to follow Note 129352 - Homogeneous system copy with MaxDB (SAP DB)

[Former Member]

hi,

change the SAPDBHOST value in the profile settings, and also ensure that the environment variables point to the CRMPROD7.

Regards,

SBK