Skip to Content

How to Change SAP System’s Hostname

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.

/wp-content/uploads/2013/09/1_274473.png

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

/wp-content/uploads/2013/09/2_274474.png

     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 

/wp-content/uploads/2013/09/3_274484.png

iii)     Changing the hostname at OS Level

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

  /wp-content/uploads/2013/09/5_274485.gif
  

Change hostname in Hosts File


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

/wp-content/uploads/2013/09/6_274486.gif

Change the Environment variable “SAPLOCALHOST”


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

/wp-content/uploads/2013/09/7_274490.gif

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

/wp-content/uploads/2013/09/9_274492.gif

     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

/wp-content/uploads/2013/09/11_274493.gif

 

STEP 3


i) Changing Default.pfl

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

/wp-content/uploads/2013/09/13_274495.gif

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

/wp-content/uploads/2013/09/14_274505.gif

 
  

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

/wp-content/uploads/2013/09/15_274506.gif

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

/wp-content/uploads/2013/09/16_274507.png

Restart the Server

Open the command prompt

Sapstartsrv

/wp-content/uploads/2013/09/16_274507.png

Enter the System Details

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

User : .\sapserviceadm

Install the service

Restart the SAP System

16 Comments
You must be Logged on to comment or reply to a post.