on 06-16-2007 3:08 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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? ::::::
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.