Case study of System domain name and application host Switching

Case study of System domain name and application host Switching
1. DNS server ConfigurationAlan has bound the new domain name erp.djicorp.com to 10.10.0.20. -- Implemented
2. Backup
Application Layer software backup: -- cd/u01/erpdbtar czvf/erpbk/apps _ $ (date required policy1_m1_d1_.tar.gz apps) has been executed at, 20140701
Database Software backup: -- cd/u01/erpdbtar czvf/erpdb_bk/db _ $ (date required policy1_m1_d1_.tar.gz db/
Data backup [ora user]-This step needs to be performed after the system is shut down in step 1 to ensure that all operations performed by the user can be backed up before the system is shut down. Implemented on 20140702 03: 45cd/erpdb_bk & mkdir $ (date + % Y % m % d) & cd $ (date + % Y % m % d) & pwdrman target/<EOFrun {allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel c4 type disk; allocate channel c5 type disk; allocate channel c6 type disk; allocate channel c7 type disk; allocate channel c8 type disk; BACKUP as copy full DATABASE format'/erpdb_bk/20140702/backup _ % U. dbf' plus archivelog skip inaccessible format'/erpdb_bk/20140702/arch _ % T-% d-% u-% p. log'; backup as copy current controlfile format '/erpdb_bk/20140702/ctl. f'; release channel c1; release channel c2; release channel c3; release channel c4; release channel c5; release channel c6; release channel c7; release channel c8;} EOF
3. Stop the application system[Appl @ erp ~] $ Cd $ ADMIN_SCRIPTS_HOME
[Appl @ erp scripts] $ sh adstpall. sh apps/password
4. Clone the erpt1 environment.Check the log select max (first_time) from v $ log_history returned by the dg Environment. After cloning the erpt1 environment, check whether the mail sending function and password are consistent with those in the production environment.

5. Back up applications to the Database Host-- [Root @ erp erpbk] # scp 1__20140701.tar.gz 10.10.0.133:/u01/erpdb has been implemented

6. Solve the tar package of apps-- [Root @ erpdb] # cd/u01/erpdb has been implemented
[Root @ erpdb] # tar-xzvf pai_20140701.tar.gz [root @ erpdb] # chown-R appl: dba apps
7. Create an appl user and an inst folder at the database layer-- Implemented
Useradd-g dba-G oinstall appl
Passwd appl cd/u01/erpdbmkdir instchown-R appl: dba inst
Add the environment variable vi appl to the appl user. envexport BASE_HOME =/u01/erpdbexport kernel = $ BASE_HOME/apps/tech_st/10.1.3export PERL5LIB = $ kernel/perl/lib/5.8.3: $ kernel/perl/lib/site_perl/5.8.3: $ BASE_HOME/apps/apps_st/appl/au/12.0.0/perl: $ IAS_ORACLE_HOME/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multiexport PATH = $ IAS_ORACLE_HOME/perl/bin: $ PATHexport COMMON_TOP = $ BASE_HOME/apps/pai_st/comn
Vi. bash_profile if. appl. env
8. Change the hostname,/etc/hosts fileHostname erp.djicorp.com
It takes 20 minutes to restart the vi/etc/sysconfig/networkvi/etc/hostsreboot host.
9. Start the database and listen
Lsnrctl start erpdbsqlplus '/as sysdba' <EOFstartupEOF

10. Clone the database
Cd $ ORACLE_HOME/appsutil/clone/binperl adcfgclone. pl dbTier
Only database cloning is performed for the old xml configuration file to clear node information. Cd $ ORACLE_HOME/appsutil/clone/binperl adcfgclone. pl dbconfig/u01/erpdb/db/tech_st/11.2.0/appsutil/erpdb_erp.xml check node information, $ TNS_ADMIN, CONTEXT_FILE is updated
If there is a problem with cloning later, we will re-execute this step, add the pre-clone, and clone the database software, and stop listening before cloning the database software.
Stop listening. For pre-cloning, software cloning, database cloning, and so on.
Finally, the software database was cloned twice, because only the second time was executed, the content in $ TNS_ADMIN was not updated, and the node information was not updated. in addition, you must take the first step to generate the corresponding xml file.

11. Clone the application
Pre-clone. Cd $ {COMMON_TOP}/clone/binperl adclone clone. pl appsTier
After cloning, check whether the database node information is the latest. Select NAME, SERVER_TYPEfrom FND_APP_SERVERS, FND_NODESwhere FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID;
Load environment variables to appl users: vi. bash_profile./u01/erpdb/apps/pai_st/appl/APPSerpdb_erpdb.env


12. change the password of apps and applsysBack up the password by referring to EBS multi-level password modification.
Create table apps. fnd_user_20140701 as select * from apps. fnd_user;
Create table apps. fnd_oracle_userid_20140701 as select * from apps. fnd_oracle_userid;

The FNDCPASS tool automatically sets the passwords of APPS and APPLSYS users to the same.
[Appl @ erp ~] $ FNDCPASS apps/old_password 0 Y system/old_password system applsys new_password

Note:
A. Stop the entire application layer, especially the concurrency manager, before changing the password.
B. Check the log to check whether any errors are reported. Do not manually run the Auoconfig command,
C. If the ERP system is abnormal after the modification, use the following method to roll back
Insert into apps. fnd_user select * from apps. fnd_user_yyyymmdd;
Insert into apps. fnd_oracle_userid select * from apps. fnd_oracle_userid_yyyymmdd;
Commit;
13. Start the applicationCd $ ADMIN_SCRIPTS_HOMEsh adstrtal. sh apps/CLONE
13. VerifyCheck whether the web page is opened normally, whether the concurrent manager is started normally, and whether the email can be sent normally.

Note: 1. If the password of the APPLSYSPUB user is not the default PUB, change the environment variable password of the user to the corresponding password. Echo $ GWYUIDvi $ CONTEXT_FILE # change the two passwords that involve APPLSYSPUB. Cd $ ADMIN_SCRIPTS_HOME # execute autoconfigsh adautocfg. sh after modification
2. If the host is configured on the user's PC, the content in the host should be changed. C: \ Windows \ System32 \ drivers \ etc \ hosts

Failed to change: Because the GI cluster cannot start after the hostname is changed, the ASM cannot start.