MaxDB on VMWare - 2 system connected to the same MaxDB database

[Former Member]

Dear SAP,

I do have a strange problem. Let's summarize :

1. P1E is running on serveur saperp01. P1E is our productive ECC system.

2. We have restored P1E on serveur saperp09.

3. saperp01 and saperp09 are both virtual serveurs, who are running on the same physical server.

Summary :

1. On virtual server saperp01, we have P1E.

2. On virtual server saperp09, we have P1E.

3. Both virtual serveur are running on physical serveur vmsapprod1.

When I start P1E from saperp09 (the restored system), it connects to the database from server saperp01 and not to its own database which is running on saperpp09.

I have changed DEFAULT.PFL profile.

I have copied START_DVEBMGS17_saperp01 to P1E_DVEBMGS17_saperp09 and modify it.

I have also copied P1E_DVEBMGS17_saperp01 to P1E_DVEBMGS17_saperp09.

Any inputs is welcome to understand why my P1E system running on saperp09 is connecting to database running on saperp01 when it starts ...

Merry Christmas !

SAP NetWeaverAdmin

[Former Member]

Have you changed the xuser details on server saperp09?

follow wiki.sdn.sap.com/wiki/display/MaxDB/User+concept

[Former Member]

Hello Sunil,

Thanks for your excellent input. I have started xuser list command and I get this answer from saperp09.

As you can read, all "Nodename" are pointing to saperp01 instead saperp09.

How can I change that ?

saperp09:p1eadm 51> xuser list

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPP1E

UsernameUCS2:S.A.P.P.1.E. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :P1E

Nodename :saperp01

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 :P1E

Nodename :saperp01

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 :P1E

Nodename :saperp01

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

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

Password :?????????

PasswordUCS2:?????????

Dbname :P1E

Nodename :saperp01

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

Best regards

SAPNetWeaverAdmin

[Former Member]

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

also read comments from Markus from