Change of hostname in R3 system on oracle

[Former Member]

Dear support,

We need to change hostname of one of our SAP system and below is the procedure i collected from different forums, i have taken complete backup of system , please let me know any of the step is missing as with my procedure SAP is not comming up.

1. Stop the SAP and Oracle

2. Chnage the Host name

3. Change the Profile parameter ( <drive> \usr\sap\SID\SYS\profile ) name

( Start and instance profile) and change the inside where the old host name.

4. Change the envirinment variable ( SAPLOCALHOST)

5. <b>Go to registry and find the old host name and change with new host name</b> ( exactly not performed for all entries by myself would like to review this step )

6. Change the tnsnames and listener ( <drive> \oahome\netw

rk\admin)

7. Change the TPPARAM file and open all the files in \usr\sap\trans\bin and

change the old hostname with new hostname

Appreciate if anyone can provide exact method.

Best Regards,

AjitR

[markus_doehr2]

I would rather not go for this, I think it´s much easier to backup the system and reinstall (as a system copy) than to do all those steps manually. If you already have a backup you can do that quickly.

--

Markus

[Former Member]

Markus,

As Basis person i even suggested the same methodology but our client is not Open for that option , thats why i need to find solution for the same in anyways out.

[markus_doehr2]

I understand...

You also need to take care of the following:

- All connected external systems must know the new server name (e. g. Fax, Archiving, BI/BW, CRM, Portal, XI, backup software, SMTP-Server...)

- All RFCs of connected systems must be changed accordingly to reflect the new hostname settings

- DNS settings must be changed (if they use DNS)

- Entries in saplogon.ini (SAPlogon) must reflect the new server name

- If the server is a member of an Active Directory Domain additional steps have to be done (there´s a document on the MS site I can´t find yet unfortunately)

Those are BIG tasks and may be even more work than reinstalling, I hope your client is aware of that

--

Markus

[Former Member]

Markus,

Problem is i have performed my mentioned steps and database is up and R3trans -d , tnsping SID gives proper results as below, but when i start SAP

C:\Documents and Settings\trgadm>R3trans -d

This is R3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

R3trans finished (0000).

C:\Documents and Settings\trgadm>tnsping TRG

TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 18-JUN-20

07 00:46:31

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

C:\Oracle\TRG\920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C

OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = cytest) (PORT = 1527))) (CONNECT_

DATA = (SID = TRG) (GLOBAL_NAME = TRG.WORLD)))

OK (60 msec)

dev_w0 showing one abnormal thing

Sun Jun 10 13:00:39 2007

M calling db_connect ...

C Got ORACLE_HOME=C:\Oracle\TRG\920 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPTRG's password

C Connecting as /@TRG on connection 0 ...

C Attaching to DB Server TRG (con_hdl=0,svchp=04A6C304,svrhp=0800AFE4)

C

C Sun Jun 10 13:00:40 2007

C Starting user session (con_hdl=0,svchp=04A6C304,srvhp=0800AFE4,usrhp=0801380C)

C Now I'm connected to ORACLE

C Got SAPTRG's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=04A6C304,usrhp=0801380C)

C Now I'm disconnected from ORACLE

C Connecting as SAPTRG/<pwd>@TRG on connection 0 ...

C Starting user session (con_hdl=0,svchp=04A6C304,srvhp=0800AFE4,usrhp=0801380C)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C <b>Database instance trg is running on CYSOFT4 with ORACLE version 9.2.0.5.0</b>

:::::: here CYSOFT4 is the old hostname then how dev_w0 is sh

[Former Member]

Markus,

Problem is i have performed my mentioned steps and database is up and R3trans -d , tnsping SID gives proper results as below, but when i start SAP

C:\Documents and Settings\trgadm>R3trans -d

This is R3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

R3trans finished (0000).

C:\Documents and Settings\trgadm>tnsping TRG

TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 18-JUN-20

07 00:46:31

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

C:\Oracle\TRG\920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C

OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = cytest) (PORT = 1527))) (CONNECT_

DATA = (SID = TRG) (GLOBAL_NAME = TRG.WORLD)))

OK (60 msec)

dev_w0 showing one abnormal thing

Sun Jun 10 13:00:39 2007

M calling db_connect ...

C Got ORACLE_HOME=C:\Oracle\TRG\920 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPTRG's password

C Connecting as /@TRG on connection 0 ...

C Attaching to DB Server TRG (con_hdl=0,svchp=04A6C304,svrhp=0800AFE4)

C

C Sun Jun 10 13:00:40 2007

C Starting user session (con_hdl=0,svchp=04A6C304,srvhp=0800AFE4,usrhp=0801380C)

C Now I'm connected to ORACLE

C Got SAPTRG's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=04A6C304,usrhp=0801380C)

C Now I'm disconnected from ORACLE

C Connecting as SAPTRG/<pwd>@TRG on connection 0 ...

C Starting user session (con_hdl=0,svchp=04A6C304,srvhp=0800AFE4,usrhp=0801380C)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C <b>Database instance trg is running on CYSOFT4 with ORACLE version 9.2.0.5.0</b>

:::::: here CYSOFT4 is the old hostname then how dev_w0 is showing this entry

can anybody let me know reason for this? ::::::

[Former Member]

Thanks to all problem seems to be resolved now and we have successfully changed hostname of our R3 server

[Former Member]

Hi Ranjit.

Have you prepared a document with screenshots when you did the hostname change on R3 system at your client place?

Would you be able to forward us the documentation?

Thank you,

Saran Mandhadapu

[sitiaishah_abdulfatah]

Could you sent me as well steps to change name in text also i will try. tq

[former_member204746]

this topic is 3 years old.

I am locking it to avoid people continually hijacking it.