1. DB Tier: Deregister the current database server
As the database hostname and domain will be changed, the current database server node needs to be de-registered.
select NAME, SERVER_TYPE
from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID
and SERVER_TYPE='DB'
and FND_NODES.NODE_NAME='old_hostname';
NAME SERVER_TYPE
--------------- -----------
oldhost_<SID>_DB DB
Executing following commands to deregister the current database server:
cd $ORACLE_HOME/appsutil
perl ./bin/adgentns.pl appspass=<APPSpwd> contextfile=./<SID>_oldhost.xml -removeserver
select NAME, SERVER_TYPE
from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID
and SERVER_TYPE='DB'
and FND_NODES.NODE_NAME='old_hostname';
no rows selected.
2. DB Tier: Create a new Context file
You can create the new context file using whichever of the following methods:
a. Manual Method:
cd $ORACLE_HOME/appsutil
cp <SID>_oldhost.xml <SID>_newhost.xml
Edit <SID>_newhost.xml manually:
Replace all oldhost with newhost
b. Script Method:(The command below will create a new Context file of the format <SID>_newhost.xml in the current working directory.)
cd $ORACLE_HOME/appsutil
perl ./clone/bin/adclonectx.pl contextfile=./<SID>_oldhost.xml
**************************************************************************************************************************
Enter the APPS password : <Password>
Log file located at <DB - $ORACLE_HOME>/appsutil/CloneContext_1223165155.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [nascapp6] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? :
Target Instance is RAC (y/n) [n] :
Target System Database SID : <SID>
Target System Base Directory : <EBS Base Directory>
Oracle OS User [oravis] :
Oracle OS Group [dba] :
Target System utl_file_dir Directory List :/usr/tmp
Number of DATA_TOP's on the Target System [4] : 1
Target System DATA_TOP Directory 1 : /d01/oracle/PROD/db/apps_st/data <------- input the path of your data files
Target System RDBMS ORACLE_HOME Directory [/d01/oracle/PROD/db/tech_st/11.1.0] :
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [newhost:0.0] :
Do you want the the target system to have the same port values as the source system (y/n) [y]?:
Complete port information available at <DB - $ORACLE_HOME>/appsutil/out/<SID>_nascapp6/portpool.lst
New context path and file name [<DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml] :
Creating the new Database Context file from :
<DB - $ORACLE_HOME>/appsutil/template/adxdbctx.tmp
The new database context file has been created :
<DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml
Log file located at <DB - $ORACLE_HOME>/appsutil/CloneContext_1223170424.log
contextfile=<DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml
Check Clone Context logfile <DB - $ORACLE_HOME>/appsutil/CloneContext_1223170424.log for details.
**************************************************************************************************************************
3. APPS Tier: Deregister the current Applications server
As the Applications hostname and domain will be changed, the current Applications server node needs to be de-registered.
select NAME, SERVER_TYPE
from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID
and SERVER_TYPE='APPS'
and FND_NODES.NODE_NAME='old_hostname';
NAME SERVER_TYP
----------------- ----------
oldhost_<SID>_APPS APPS
Executing following commands to deregister the current Applications server:
cd $APPL_TOP/admin
perl $AD_TOP/bin/adgentns.pl appspass=<APPSpwd> contextfile=./<SID>_oldhost.xml -removeserver
select NAME, SERVER_TYPE
from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID
and SERVER_TYPE='APPS'
and FND_NODES.NODE_NAME='old_hostname';
no rows selected.
4. APPS Tier: Create a new Context file
You can create the new context file using whichever of the following methods:
a. Manual Method:
cd $APPL_TOP/admin
cp <SID>_oldhost.xml <SID>_newhost.xml
Edit <SID>_newhost.xml manually:
Replace all oldhost with newhost
b. Script Method:(The command below will create a new Context file of <SID>_newhost.xml in new <SID>_newhost directory.)
cd $INST_TOP/appl/admin
perl $COMMON_TOP/clone/bin/adclonectx.pl contextfile=./<SID>_oldhost.xml
**************************************************************************************************************************
Enter the APPS password : apps
Log file located at $INST_TOP/appl/admin/CloneContext_1223173053.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [nascapp6] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? :
Target System Database SID : <SID>
Target System Database Server Node [nascapp6] :
Target System Base Directory : <EBS Base Directory>
Target System Tools ORACLE_HOME Directory [<10.1.2 $ORACLE_HOME>] :
Target System Web ORACLE_HOME Directory [<10.1.3 $ORACLE_HOME>] :
Target System APPL_TOP Directory [<$APPL_TOP>] :
Target System COMMON_TOP Directory [<$COMMON_TOP>] :
Target System Instance Home Directory [<$INST_TOP>] :
Username for the Applications File System Owner [applvis] :
Group for the Applications File System Owner [dba] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [oldhost:0.0] (y/n) ? : newhost:0.0
Target System Display [newhost:0.0] :
New context path and file name [$INST_TOP/appl/admin/<SID>_newhost.xml] :
**************************************************************************************************************************
5. APPS Tier: Shutdown the Application Tier Services
cd $INST_TOP/admin/scripts
./adstpall.sh apps/<appspasswd>
6. Change the server machine hostname.
Please contact your IT administrator to change the machine hostname.
7. DB Tier: Reseed the Net Services Topology Model
cd $ORACLE_HOME/appsutil
./bin/adconfig.sh contextfile=./<SID>_newhost.xml
8. APPS Tier: Reseed the Net Services Topology Model
The Net Services Topology Model is automatically updated by running AutoConfig.
$AD_TOP/bin/adconfig.sh contextfile= $INST_TOP/../<SID>_newhost//appl/admin/<SID>_newhost.xml appspass=<appspasswd>
9. DB Tier: Shutdown the database and listener
$ORACLE_HOME/appsutil/scripts/<SID>_oldhost/addbctl.sh stop
$ORACLE_HOME/appsutil/scripts/<SID>_oldhost/addlnctl.sh stop <SID>
10. DB Tier: Start the listener and database
$ORACLE_HOME/appsutil/scripts/<SID>_newhost/addlnctl.sh start <SID>
$ORACLE_HOME/appsutil/scripts/<SID>_newhost/addbctl.sh start
11. APPS Tier: Start the Application Tier Services
$INST_TOP/admin/scripts/<SID>_newhost/adstrtal.sh apps/<appspasswd>
No comments:
Post a Comment