How to Change SAP System's Hostname

[Former Member]

Changing SAP System’s Hostname

Assumptions

• SAP server is running smoothly
• Operating System is Microsoft Windows 2003
• Database is Oracle
• Valid for only AS ABAP Stack

Changing Hostname will be done in 5 Steps

Step 1 : Stopping SAP & Change Hostname on OS.

Step 2 : Changing Hostname in Oracle Profiles.

Step 3 : Changing Hostname in SAP profiles.

Step 4 : Running ORADBUSER.SQL Script

Step 5 : Uninstall and Install Service

STEP 1

It includes Stopping SAP & Oracle services and changing the hostname at OS Level

     i)     Stop SAP and Shutdown database

• Stop SAP through Management Console
• Right click on PRD and select Stop.

• Stop Database
• Logon to Sqlplus and type command “shutdown immediate;”

     ii)     Stop all SAP and Oracle services and set it to manual from Automatic.

            Goto --> services.msc and stop all SAP and Oracle Services and set all automatic services to manual 

iii)     Changing the hostname at OS Level

Right Click on My Computer --> Properties --> Computer Name and enter the new host name

 
  

Change hostname in Hosts File

Goto --> C:\windows\system32\drivers\etc and open File “Hosts” and enter the new hostname

Change the Environment variable “SAPLOCALHOST”

Set the new value for SAPLOCALHOST i.e. enter the new hostname

STEP 2 

First Please take the backup of all profiles before changing them.

i) Changing Listener.ora file

     Goto --> Oracle_home\Network\Admin in my case it is D:\oracle\PRD\102\Network\Admin

And change the entry “HOST” in listener.ora

     ii) Changing Tnsnames.ora

Goto --> Oracle_home\Network\Admin in my case it is D:\oracle\PRD\102\Network\Admin

And change the entry “HOST” in tnsnames.ora

STEP 3

i) Changing Default.pfl

Goto --> \usr\sap\<SID>\SYS\Profile and change hostname in default.pfl

ii) Changing START_DVEBMGS<SYSNR>_<HOST>

Goto --> \usr\SAP\<SID>\SYS\Profile

• COPY START_DVEBMGS<SYSNR>_<HOST> file and replace the hostname
1. e.g.

CURRENT FILE NAME: START_DVEBMGS00_PRD

NEW FILE NAME       : START_DVEBMGS00_NEWPRD

• Open the file and change the value of parameter SAPGLOBALHOST and profile name which are marked with red

iii) Changing <SID>_DVEBMGS<SYSNO>_<HOSTNAME>

COPY <SID>_DVEBMGS<SYSNR>_<HOST> file and replace the hostname

                         e.g.

CURRENT FILE NAME: R3P_DVEBMGS00_PRD

NEW FILE NAME       : R3P_DVEBMGS00_NEWPRD

Open the file and change the value of parameter SAPGLOBALHOST

STEP 4

Download ORADBUSER.SQL script from SAP Note 50088

Run ORADBUSER.SQL script (Instructions  how to run script is mentioned in the script)

STEP 5

Open a command prompt

Sapstartsrv

Uninstall the service

Restart the Server

Open the command prompt

Sapstartsrv

Enter the System Details

Profile : \usr\sap\PRD\sys\profile\ and select the start Profile

User : .\sapserviceadm

Install the service

Restart the SAP System