Hot Clone EBS 11i on 10gR2 RAC and ASM

Rapid Clone Prerequisites

Software Minimum Version Current Version Location
Oracle Universal Installer 2.2.0.19 2.2.0.19 All source system nodes
Perl 5.0.0.5 5.8.8 Source and target database nodes
JRE 1.1.8 1.4.2 Source database node
JDK 1.3.1 1.5.0_10 Target middle-tier applications nodes
Zip 2.3 2.31 All source nodes
OS utilities: make, ld, cc, ar Db tier: ld is in version of 217.
Apps tier: link ld to ld215 Need to be in the PATH when running adcfgclone.pl
AD Minipack 11i.AD.I.6 (6502082) All source nodes
Autoconfig Template Patch 11i.TXK.S (6372396) All source nodes
Raplid Clone Patches 11i Rapidclone Consolidated Fix (6718351) All source nodes

10gR2 (10.2.0.4) CRS and ASM were installed.


On the Source System: PROD

1. run adpreclone.pl on all six production nodes

1.1 database tier: pind41 and pind42
$ORACLE_HOME/appsutil/scripts/

cd /opt/oracle/product/10.2.0/PROD/appsutil/scripts/PROD1_pind41
perl adpreclone.pl dbTier

cd /opt/oracle/product/10.2.0/PROD/appsutil/scripts/PROD2_pind42
perl adpreclone.pl dbTier

1.2 concurrent manager and admin server tier: pind43 and pind44

$COMMON_TOP/admin/scripts/

cd /data/applprod/common/admin/scripts/PROD_pind43
perl adpreclone.pl appsTier

cd /data/applprod/common/admin/scripts/PROD_pind44
perl adpreclone.pl appsTier

1.3 web, forms and mwa server tier: pind23 and pind24

$COMMON_TOP/admin/scripts/

cd /data/wfmprod/common/admin/scripts/PROD_pind23
perl adpreclone.pl appsTier

cd /data/wfmprod/common/admin/scripts/PROD_pind24
perl adpreclone.pl appsTier

2. create backups on the application tier

Run backup scripts on pind23 and pind43:

pind23: /home/wfmprod/scripts/backup and put backups to /data/wfmprod/backup
pind43:/home/applprod/scripts/backup and put backups to /data/applprod/backup

3. create tar file for the Oracle database binary on just one database node (pind41).

cd $ORACLE_HOME/..
tar -cpvzf /backup/PROD/racdb_techstack.tgz PROD

4. run rman backup

Use each morning’s daily rman backup. Need to run backup archivelogs to get archive logs generated after daily rman backup run. Rman backup code is on pind42

Backup files in /backup/PROD/archivelogs and datafiles.

5. move above backups to destination nodes:


on pind41:
cd /backup/PROD
scp racdb_techstack.tgz it-pwl-ods01:/backup/PROD

[/backup/PROD/datafiles] (only need today’s backup)
oracle@pind41(PROD1/DBTier):$ scp PROD_LVL0_20090505_gnke7tbk_s535_p1 PROD_LVL0_20090505_gmke7tbk_s534_p1 PROD_LVL0_20090505_gpke7tbl_s537_p1 PROD_LVL0_20090505_goke7tbk_s536_p1 it-pwl-ods01:/backup/PROD/datafiles


cd /backup/PROD/archivelogs (only need today’s backup)
oracle@pind41(PROD1/DBTier):$
scp * it-pwl-ods01:/backup/PROD/archivelogs

[/backup/PROD/controlfiles]
oracle@pind41(PROD1/DBTier):$ scp * it-pwl-ods01:/backup/PROD/controlfiles


[/pcp/applprod/backup]
applprod@pind43(PROD_806_BALANCE/CCM:Admin):$ scp -r * applmgr@it-pwl-oas01:/pcp/applmgr/backup

[/data/applprod/backup]
wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ scp –r * applmgr@it-pwl-ows01:/data/applmgr/backup

wfmprod@pind23(PROD_806_BALANCE/Web:Forms:MWA):$ scp –r * applmgr@it-pwl-ows02:/data/applmgr/backup


On the Destination System: GOLD

6. destination system preparation
6.0 destination should have crs and asm installed on db nodes, /pcp ocfs2 shared disks among ccm and database tier nodes.
6.1 clean the previous old instance on all tiers in refreshing old instance

6.2 for new system, check following OS level requirements
6.2.1 check hugepage
./home/oracle/scripts/hugepages_settings.sh
Recommended setting: vm.nr_hugepages = 2115 (when SGA size is 4GB).

To do for setting hugepage:

Vi /etc/sysctl.conf

Add following at the bottom:

#Custom Setting
#Huge pages for database
Vm.nr_hugepages=2115

Run following command to make the change in effect:
sysctl –p

oracle@it-pwl-ods02(GOLD2/DBTier):$ grep Huge /proc/meminfo
HugePages_Total: 2115
HugePages_Free: 17
HugePages_Rsvd: 14
Hugepagesize: 2048 kB

Run grep, if total is not 2115, then reboot servers.

6.2.2 update /etc/hosts on all servers to include database tiers’ public, private, and virtual ip address, cocurrent manager tier and web tiers. Or use DNS.

6.2.3 central inventory
Create /etc/oratab and /etc/oraInst.loc for new installation on all nodes. Make them chmod 666 oratab oraInst.loc and chown oracle:oinstall oratab oraInst.loc

On apps tiers
applmgr.it-pwl-oas01>cat oraInst.loc
inventory_loc=/opt/oracle/oraInventory
inst_group=oinstall

on database tier
GOLD1.oracle.it-pwl-ods01>cat /etc/oraInst.loc
inventory_loc=/opt/oracle/oraInventory
inst_group=oinstall

6.2.4 ownership of following directories
On database tier:
chown oracle:oinstall /opt/oracle /pcp /backup
On apps tier:
chown applmgr:oinstall /opt/oracle /data
6.2.5 create sub directories
On apps tier
mkdir –p /pcp/applmgr/common/temp
mkdir –p /opt/oracle/oraInventory
mkdir –p /data/applmgr/11i
mkdir –p /data/applmgr/common
mkdir –p /data/applmgr/product
on database tier
mkdir –p /backup/GOLD
mkdir –p /backup/PROD
mkdir –p /opt/oracle/product/10.2.0/GOLD

7. Clone the RAC database
7.1 make sure the ASM listener name is not in the format of LISTENER_. Make sure +ASM and listener are up on it-pwl-ods01 and ods02.

7.2 untar database binary backup on it-pwl-ods01

cd /opt/oracle/product/10.2.0
tar -xvzf /backup/PROD/racdb_techstack.tgz

mv PROD GOLD

7.3 create a pairsfile.txt for new primary target system node (it-pwl-ods01) and put the file in /appsutils/clone

cat pairsfile.txt

s_undo_tablespace=APPS_UNDOTS1
s_dbClusterInst=2
s_db_oh=/opt/oracle/product/10.2.0/GOLD


7.4 create context file for primary target system node: it-pwl-ods01

cd /opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin
run_adclonectx.sh
perl adclonectx.pl \
contextfile=/opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml \
template=/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp \
pairsfile=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt


Provide the values required for creation of the new Database Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target hostname [pind41]:it-pwl-ods01

It is recommended that your inputs are validated by the program.
However you might choose not to validate your inputs 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] ?:n

Target instance is a Real Application Cluster (RAC) instance (y/n) [y]: y

Current node is the first node in an N Node RAC Cluster (y/n)[n]:y

Target System database name [prod]:GOLD

Do you want to preserve the port values from the source system on the target \
system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install

Enter the port pool number [0-99]: 80 (avoid 80 as tomcat uses 8080).

Database port is 1601

Provide information for the Node 1 (current node):

Host name [pind41]:it-pwl-ods01

Virtual Host name [null]:it-pwl-ods01-vip

Instance number [1]: 1

Private interconnect name [pind41-priv]:it-pwl-ods01-priv

Provide information for the Node 2:

Host name [pind42]:it-pwl-ods02

Virtual Host name [null]:it-pwl-ods02-vip

Instance number [2]: 2

Private interconnect name [pind42]:it-pwl-ods02-priv

Target system quorum disk location required for cluster manager and node monitor \
[/dev/raw/raw2]:/dev/raw/raw2

Target system cluster manager service port [9998]:

Oracle OS User [oracle]:

Oracle OS Group [oinstall]:

Target system utl_file accessible directories list [/usr/tmp]: /pcp/applmgr/common/temp, /usr/tmp

Number of DATA_TOP's on the target system [3]:1

Target system DATA_TOP 1:+DSKGRP1

Do you want to preserve the Display set to :0.0 (y/n) [y] ?:n

Target system Display [it-pwl-oas01:0.0]:it-pwl-oas01.visioncorp.com:1.0


Perl executable location is set to:
/usr/bin/perl

New context path and file name [/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD1_it-pwl-ods01.xml]:

Creating the new Database Context file from :
/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp


7.5 Run the adclone.pl utility as follows:
Check KSH_VERSION is set and ld, ar, cc, make are set. Make sure ld link to ld215 (install a package on dbtier?, ld217). After rapidclone patchset, do not need to set KSH_VERION.
cd /opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin.
Run_adclone.sh
export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
perl adclone.pl
java=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/jre
component=dbTechStack
mode=apply
stage=/opt/oracle/product/10.2.0/GOLD/appsutil/clone
method=CUSTOM
dbctxtg=/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD1_it-pwl-ods01.xml
showProgress contextValidated=true

Note: Asks for apps password even though the database hasn’t been created yet.

7.6 rman duplicate to create cloned database

7.6.1 create password files

GOLD1.oracle.it-pwl-ods01>orapwd file=orapwGOLD1 password=syspasswd entries=10
(run on two nodes).

7.6.2 create initGOLD1.ora.dup

Cp initPROD1.ora to initGOLD1.ora

Make changes in initGOLD1.ora
Replace PROD with GOLD
Replace applprod with applmgr
Replace pind41 with it-pwl-ods01,pind42 with it-pwl-ods02
Comment out cluster_database,control_files,
Change sga_target from 24G to 4G
Change log_archive_dest_1 to ‘LOCATION=/backup/GOLD/arch’
Change the arch log format backup from GOLD to PROD.
Update temporary tnsnames.ora with local and remote listeners name in initGOLD1.ora, create entry for PROD1.

7.6.3 create temporary tnsnames.ora

set $TNS_ADMIN=/opt/oracle/product/10.2.0/GOLD/network/admin
Tnsnames.ora:

[/opt/oracle/product/10.2.0/GOLD/network/admin]
oracle@it-pwl-ods01(GOLD1/DBTier):$ cat tnsnames.ora
#
# $Header: ad8itns.ora 115.4 2004/04/01 12:57:26 rsanders ship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Net8 definition for the database
#
PROD1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=pind41-vip.visioncorp.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD1)
)
)


GOLD1 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
(CONNECT_DATA=(SID=GOLD1))
)

GOLD1_LOCAL =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
)

GOLD_REMOTE =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01)(PORT=1601))
)

#
# Intermedia
#
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCGOLD1))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )

IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD1_it-pwl-ods01/GOLD1_it-pwl-ods01_ifile.ora


[/opt/oracle/product/10.2.0/GOLD/network/admin]

7.6.4 check ASM and listener

Start asm if it is not up.
crs.oracle.it-pwl-ods01>srvctl start asm -n it-pwl-ods01
crs.oracle.it-pwl-ods01>srvctl start asm -n it-pwl-ods02

change asm listener name.

7.6.5 check backups

cd /home/oracle/scripts/clone/GOLD

make sure rman backups (datafile and archive logs) in right location.
It-pwl-ods01:/backup/PROD/archivelogs and datafiles


Check connection to PROD1. set until time in the rman run block accordingly. Make sure archive logs are backed up to this point of time and the archive log backup pieces are moved over.

7.6.6 run rman duplicate

startup new instance in nomount stage.

SQL> startup nomount;

Rman target sys/syspw@PROD1 auxiliary /
RMAN> @dupPRODtoGOLD.rman

(duplicate rman will restore archivelogs from backupsets to /backup/GOLD/arch (set in initGOLD1.ora) and apply the logs, after applying, delete them.)

[~/scripts/clone/GOLD]
oracle@it-pwl-ods01(GOLD1/DBTier):$ cat dupPRODtoGOLD.rman
CONFIGURE CHANNEL DEVICE TYPE disk CLEAR;
CONFIGURE DEFAULT DEVICE TYPE TO disk;
CONFIGURE DEVICE TYPE disk PARALLELISM 2;
run {
set until time "to_date('05-MAY-2009 11:00:00','DD-MON-YYYY HH24:mi:ss')";
set autolocate on;
DUPLICATE TARGET DATABASE TO "GOLD" pfile="/opt/oracle/product/10.2.0/GOLD/dbs/initGOLD1.ora";
}
[~/scripts/clone/GOLD]

7.6.7 post database duplicate steps

7.6.7.1 Update initGOLD1.ora

Update Control_file location, uncommented it.
Uncomment cluster_database.
Update *.log_archive_format from PROD to GOLD

Remember to update local and remote listener to match with previous definition.

7.6.7.2 Bounce database. Might need to turn off archivelog.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2089432 bytes
Variable Size 1392512552 bytes
Database Buffers 2885681152 bytes
Redo Buffers 14684160 bytes
Database mounted.
SQL> alter database noarchivelog;

Database altered.


SQL> alter database open;

7.6.7.3 In case need to turn on FRA:
Change init.ora
*.db_flashback_retention_target=1440
*.db_recovery_file_dest='/backup'
*.db_recovery_file_dest_size=500G
*.recovery_parallelism=2
#*.log_archive_dest_1='LOCATION=/backup/GOLD/arch'
#*.log_archive_format = 'GOLD_%r_%t_%s.arc'

SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database flashback on;
SQL> alter database open;

7.6.7.4 Use spfile:

SQL> create spfile='+DSKGRP1' from pfile;

Switch to asm instance to find the location of spfile.

Create initGOLD1.ora and initGOLD2.ora with same a pointer to spfile.
GOLD1.oracle.it-pwl-ods01>cat initGOLD1.ora
spfile='+DSKGRP1/GOLD/PARAMETERFILE/spfile.372.686313427'



7.6.7.5 Clean up source system node topology (fnd_node etc):

SQL> connect apps/apps
Connected.

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

-- must run autoconfig after this
--
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;


7.6.8 create temporary listener.ora and start temporary listener.

Cd $TNS_ADMIN
(/opt/oracle/product/10.2.0/GOLD/network/admin)
Config temp listener and start it

Listener.ora

# $Header: adlsnr10RAC.ora 115.3 2006/05/02 14:40:32 sbandla noship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Definition for RAC Database listener
#

LISTENER_it-pwl-ods01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods01-vip.visioncorp.com)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods01)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCGOLD1)))
)
)

SID_LIST_LISTENER_it-pwl-ods01 =
(SID_LIST =
(SID_DESC = (ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(SID_NAME = GOLD1))
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(PROGRAM = extproc))
)

STARTUP_WAIT_TIME_LISTENER_it-pwl-ods01 = 0
CONNECT_TIMEOUT_LISTENER_it-pwl-ods01 = 10
TRACE_LEVEL_LISTENER_it-pwl-ods01 = OFF

LOG_DIRECTORY_LISTENER_it-pwl-ods01 = /opt/oracle/product/10.2.0/GOLD/network/admin
LOG_FILE_LISTENER_it-pwl-ods01 = GOLD1
TRACE_DIRECTORY_LISTENER_it-pwl-ods01 = /opt/oracle/product/10.2.0/GOLD/network/admin
TRACE_FILE_LISTENER_it-pwl-ods01 = GOLD1
ADMIN_RESTRICTIONS_LISTENER_it-pwl-ods01 = OFF


IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD1_it-pwl-ods01/listener_ifile.ora

7.6.9 run adautocfg

7.6.9.1 modify adlsnr10RAC.ora template in /opt/oracle/product/10.2.0/GOLD/appsutil/template to change s_dbhost in the listener name to s_dbSid: LISTENER_%s_dbhost% to LISTENER_%s_dbSid% in case more than one apps database on the nodes.

7.6.9.2 Run adautocfg.sh in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD1_it-pwl-ods01

7.6.9.3 Source environment
Bounce listener and database using scripts in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD1_it-pwl-ods01

8. create database instance on secondary node

untar database binary code

On second node: it-pwl-ods02:

cd /opt/oracle/product/10.2.0
tar -xvzf /backup/PROD/racdb_techstack.tgz

mv PROD GOLD

create pairsfile.txt
create a pairsfile.txt for new secondary target system node (it-pwl-ods02) and put the file in /appsutils/clone

s_undo_tablespace=APPS_UNDOTS2
s_dbClusterInst=2
s_db_oh=/opt/oracle/product/10.2.0/GOLD
run adclonectx.pl to create contextfile.
Navigate to /appsutil/clone/bin. Run the adclonectx.pl utility as follows:
perl adclonectx.pl \
contextfile=/opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml \
template=/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp \
pairsfile=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt

oracle@it-pwl-ods02(GOLD2/DBTier):$ run_adclonectx.sh
../jre/bin/java -classpath ../jlib/classes12.jar:../jlib/xmlparserv2.zip:../jre/lib/rt.jar:../jlib/java: oracle.apps.ad.context.CloneContext -e /opt/oracle/product/10.2.0/GOLD/appsutil/PROD1_pind41.xml -tmpl /opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp -pairsfile /opt/oracle/product/10.2.0/GOLD/appsutil/clone/pairsfile.txt -perl "/usr/bin/perl" -perl5lib "/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi:/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.8:/usr/lib/perl5/site_perl/5.8.7:/usr/lib/perl5/site_perl/5.8.6:/usr/lib/perl5/site_perl/5.8.5:/usr/lib/perl5/site_perl:/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi:/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.8:/usr/lib/perl5/vendor_perl/5.8.7:/usr/lib/perl5/vendor_perl/5.8.6:/usr/lib/perl5/vendor_perl/5.8.5:/usr/lib/perl5/vendor_perl:/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi:/usr/lib/perl5/5.8.8:.:/opt/oracle/product/10.2.0/GOLD/appsutil/perl"

Provide the values required for creation of the new Database Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target hostname [pind41]:it-pwl-ods02

It is recommended that your inputs are validated by the program.
However you might choose not to validate your inputs 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] ?:n

Target instance is a Real Application Cluster (RAC) instance (y/n) [y]:y

Current node is the first node in an N Node RAC Cluster (y/n)[n]:n

Please provide the details to connect to one of live RAC nodes


Host name of the live RAC node:it-pwl-ods01

Domain name of the live RAC node:visioncorp.com

Database SID of the live RAC node:GOLD1

Listener port number of the live RAC node:1601

APPS password is required to fetch the information of the other nodes from the database
Enter APPS Password [APPS]:timn3h
Current Node:
Host Name : it-pwl-ods02

SID : GOLD2

Instance Name : GOLD2

Instance Number : 2

Instance Thread : 2

Undo Table Space: APPS_UNDOTS2

Listener Port : 1601

Target system quorum disk location required for cluster manager and node monitor [/dev/raw/raw2]:

Target system cluster manager service port [9998]:

Oracle OS User [oracle]:

Oracle OS Group [oinstall]:

Target system utl_file accessible directories list [/usr/tmp]:/pcp/applmgr/common/temp,/usr/tmp

Number of DATA_TOP's on the target system [3]:1

Target system DATA_TOP 1:+DSKGRP1

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ods02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Perl executable location is set to:
/usr/bin/perl

New context path and file name [/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml]:

Creating the new Database Context file from :
/opt/oracle/product/10.2.0/GOLD/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml

Log file located at /tmp/CloneContext_05110903.log

8.1 Modify adlsnrlORAC.ora
cd $ORACLE_HOME/appsutil/template
vi adlsnrlORAC.ora
Modify dbhost = dbSid (Not all, will provide example)
8.2 run adclone

oracle@it-pwl-ods02(GOLD1/DBTier):$ cat run_adclone.sh

export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'
perl adclone.pl java=/opt/oracle/product/10.2.0/GOLD/appsutil/clone/jre component=dbTechStack mode=apply stage=/opt/oracle/product/10.2.0/GOLD/appsutil/clone method=CUSTOM dbctxtg=/opt/oracle/product/10.2.0/GOLD/appsutil/GOLD2_it-pwl-ods02.xml showProgress contextValidated=true
[/opt/oracle/product/10.2.0/GOLD/appsutil/clone/bin]

8.3 startup instance on second node

Before running autocfg, cp initGOLD1.ora, rename initGOLD2.ora and startup database on it-pwl-ods02.

8.4 create temporary listener

set $TNS_ADMIN=/opt/oracle/product/10.2.0/network/admin

Config temporary listener.ora and start it.

# $Header: adlsnr10RAC.ora 115.3 2006/05/02 14:40:32 sbandla noship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################

#

#
# Definition for RAC Database listener
#

LISTENER_it-pwl-ods02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods02.visioncorp.com)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = it-pwl-ods02)(PORT = 1601)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCGOLD2)))
)
)

SID_LIST_LISTENER_it-pwl-ods02 =
(SID_LIST =
(SID_DESC = (ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(SID_NAME = GOLD2))
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/10.2.0/GOLD)(PROGRAM = extproc))
)

STARTUP_WAIT_TIME_LISTENER_it-pwl-ods02 = 0
CONNECT_TIMEOUT_LISTENER_it-pwl-ods02 = 10
TRACE_LEVEL_LISTENER_it-pwl-ods02 = OFF

LOG_DIRECTORY_LISTENER_it-pwl-ods02 = /opt/oracle/product/10.2.0/GOLD/network/admin
LOG_FILE_LISTENER_it-pwl-ods02 = GOLD2
TRACE_DIRECTORY_LISTENER_it-pwl-ods02 = /opt/oracle/product/10.2.0/GOLD/network/admin
TRACE_FILE_LISTENER_it-pwl-ods02 = GOLD2
ADMIN_RESTRICTIONS_LISTENER_it-pwl-ods02 = OFF


IFILE=/opt/oracle/product/10.2.0/GOLD/network/admin/GOLD2_it-pwl-ods02/listener_ifile.ora

8.5 run adautocfg


Run adautocfg.sh in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD2_it-pwl-ods02

Source environment
Bounce listener and database using scripts in /opt/oracle/product/10.2.0/GOLD/appsutil/scripts/GOLD2_it-pwl-ods02

run adautocfg.sh on primary and bounce listener and database

Run adautocfg.sh again on node1: it-pwl-ods01 and bounce listener and database.

8.6 Database postclone steps:
Clean up system level profile options, WF data and other source system specific data which remain in the newly cloned database:

On it-pwl-ods02: /home/oracle/scripts/clone/GOLD/post_clone1_gold.sql as system
And post_clone2_gold.sql as apps

8.6.1 update libraries

cd $ORACLE_HOME/appsutil/install/
adupdlib.sql is called from adcrdb.sql during the standard clone procedure. For RAC, we use manual clone and adcrdb.sql is not used. Thus, run adupdlib.sql here.

Sqlplus “/ as sysdba” @adupdlib.sql so

(so is the library extention).

Select * from dba_libraries where file_spec is not null;

8.6.2 update directories in database

sqlplus “/ as sysdba”

Select * from dba_directories;

Use following command to update the directory path:

drop directory POWL_OUTBOUND_EDI;
create directory POWL_OUTBOUND_EDI
as '/pcp/applmgr/common/xx_custom/outbound/edi';
Grant ALL on Directory POWL_OUTBOUND_EDI to APPS;
Grant ALL on Directory POWL_OUTBOUND_EDI to XX_CUSTOM;

Some directories only used by sys or system, not need for the grants.

8.6.3 check first before running following commands:

sqlplus “/ as sysdba”

--alter tablespace temp add tempfile size 2000m autoextend on maxsize 6000m;
--alter database rename global_name to PTCH.VISIONCORP.COM;
--alter database add logfile thread 2 group 16;
--alter database add logfile thread 2 group 17;
--alter database enable thread 2;

-- Added to create 1GB online redo logs - default is 1MB.
--alter database drop logfile group 2;
--alter database add logfile thread 2 group 3 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 4 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 5 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 6 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 7 ('+DSKGRP1') size 1048576k;
--alter database add logfile thread 2 group 8 ('+DSKGRP1') size 1048576k;

8.6.4 update session_cookie_name due to load balancing

sqlplus apps/apps

update icx_parameters set session_cookie_name=’gold’;

8.6.5 update profile option values

select profile_option_value from fnd_profile_option_values;

8.6.6 update workflow related data

select text_alue from wf_notification_attributes;

update wf_systems set display_name = ‘GOLD.VISIONCORP.COM’;
update wf_agents set address=replace(address,’PRD34,US.ORACLE.COM’,’GOLD.VISIONCORP.COM’);

select web_host_name from fnd_form_functions;

8.6.7 concurrent requests

delete from fnd_concurrent_requests where status_code=’C’;

select logfile_name,logfile_node_name,outfile_node_name from fnd_concurrent_requests;

update fnd_concurrent_requests set phase_code = ‘C’, status_code = ‘X’ where status_code = ‘T’;

update fnd_concurrent_requests set phase_code = ‘C’ where phase_code=’P’;

update fnd_concurrent_requests set status_code = ‘C’ where status_code = ‘P’

update fnd_concurrent_requests set hold_flag=’Y’ where phase_code = ‘P’ and status_code in (‘Q’,’I’);


select node_name from fnd_concurrent_queues;
update fnd_concurrent_queues set running_pocesses = 0, max_processes = 0;
update fnd_concurrent_queues set control_code = ‘X’ where concurrent_queue_name = ‘FNDICM’;


9. On Concurrent manager and administration servers (it-pwl-oas01 and oas02):


9.1 untar application binary backup

on it-pwl-oas01 and oas02

cd /data/applmgr/11i

tar –xzf /pcp/applmgr/backup/APPLTOP/11.5.tar.gz

cd /data/applmgr

unzip /pcp/applmgr/backup/COMMON/common.zip

cd /data/applmgr

tar -xzf /pcp/applmgr/backup/ORATOP/product.tar.gz

9.2 check central inventory
/etc/oraInst.loc
/opt/oracle/oraInventory (ownership: applmgr:oinstall).

check ld linked to ld215

check ulimit –a

stack size and open files

/etc/security/limits.conf

9.3 run adcfgclone in $COMMON_TOP/clone/bin
[applmgr@it-pwl-oas01 bin]$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
apps

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target system database SID [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

Does the target system have more than one application tier server node (y/n) [y] ?:y

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas01

Target system administration node [pind43]:it-pwl-oas01

Target system forms server node [pind23]:it-pwl-ows01

Target system web server node [pind23]:it-pwl-ows01

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

Target system APPL_TOP mount point [/data/applprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/applprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/applprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/applprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-oas01:0.0]:it-pwl-oas01.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-oas01/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD1_it-pwl-ods01
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]: 1

9.4 Stop ccm
cd $STOP
adstpall apps/apps

9.5 Source environment
Cd $TNS_ADMIN to create ifile.
8.0.6 and iAS homes.

9.6 run adcfgclone on node2
applmgr.it-pwl-oas02>perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
timn3h

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target system database SID [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods02

Target system database domain name [visioncorp.com]:visioncorp.com

Does the target system have more than one application tier server node (y/n) [y] ?:y

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas02

Target system administration node [pind43]:it-pwl-oas02

Target system forms server node [pind23]:it-pwl-ows02

Target system web server node [pind23]:it-pwl-ows02

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

Target system APPL_TOP mount point [/data/applprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/applprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/applprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/applprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-oas02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-oas02/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD2_it-pwl-ods02
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:1

10. On Web and Forms servers (it-pwl-ows01 and ows02):


10.1 untar application binary backup

on it-pwl-ows01 and ows02
on it-pwl-ows01:

mkdir –p /data/applmgr/backup

on pind23
cd /data/applprod/backup
scp -r * applmgr@it-pwl-ows01:/data/applmgr/backup


cd /data/applmgr/11i

tar –xzf /data/applmgr/backup/APPLTOP/11.5.tar.gz

cd /data/applmgr

unzip /data/applmgr/backup/COMMON_TOP/common.zip

cd /data/applmgr/

tar -xzf /data/applmgr/backup/ORATOP/product.tar.gz


10.2 check central inventory
/etc/oraInst.loc
/etc/oratab
/opt/oracle/oraInventory (ownership: applmgr:oinstall).

check ld linked to ld215 (On web/forms tier)

check ulimit –a

stack size and open files

/etc/security/limits.conf

Ping database tier’s vip and public ip address and hostname from web and ccm tiers. (/etc/hosts or DNS)
Otherwise, database connection check error when running adcfgclone.pl

Chown applmgr:oinstall /opt/oracle
Mkdir /opt/oracle/oraInventory
Cp /etc/oraInst.loc and /etc/oratab and chown applmgr:oinstall


cd /data/applmgr/common/clone/bin
10.3 run adcfgclone
[applmgr@it-pwl-ows01 bin]$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
apps

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target system database SID [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

Does the target system have more than one application tier server node (y/n) [y] ?:y

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas01

Target system administration node [pind43]:it-pwl-oas01

Target system forms server node [pind23]:it-pwl-ows01

Target system web server node [pind23]:it-pwl-ows01

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

Target system APPL_TOP mount point [/data/wfmprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/wfmprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/wfmprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/wfmprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ows01:0.0]:it-pwl-oas01.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-ows01/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD1_it-pwl-ods01
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:9

Creating the new APPL_TOP Context file from :
/data/applmgr/11i/ad/11.5.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
/data/applmgr/11i/admin/GOLD_it-pwl-ows01.xml

Log file located at /tmp/CloneContext_05130112.log

Running Rapid Clone with command:
perl /data/applmgr/common/clone/bin/adclone.pl java=/data/applmgr/common /clone/bin/../jre mode=apply stage=/data/applmgr/common/clone/bin/.. component=a ppsTier method=CUSTOM appctxtg=/data/applmgr/11i/admin/GOLD_it-pwl-ows01.xml sh owProgress contextValidated=true


/etc/oraInst.loc points to an Inventory that does not exist: /opt/oracle/oraInve ntory
Inventory Directory created...
Beginning application tier Apply - Wed May 13 13:15:57 2009
Log file located at /data/applmgr/11i/admin/GOLD_it-pwl-ows01/log/ApplyAppsTier_ 05131315.log


Completed Apply...
Wed May 13 13:25:09 2009

Beginning APPSIAS_GOLD registration to central inventory...

ORACLE_HOME NAME : APPSIAS_GOLD
ORACLE_HOME PATH : /data/applmgr/product/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /opt/oracle/oraInventory/logs/OracleHomeCloner_05130125.log
ORACLE_HOME /data/applmgr/product/iAS was registered successfully.

Starting application Services for GOLD:
Running:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adstrtal.sh APPS/

You are running adstrtal.sh version 115.19

Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adapcctl.sh start
script returned:
****************************************************

adapcctl.sh version 115.55

Apache Web Server Listener is not running.
Starting Apache Web Server Listener (dedicated HTTP) ...

05/13/09-13:25:16 :: Removing gantt cache directory

05/13/09-13:25:17 :: Successfully removed the gantt cache directory:/data/applmgr/common/html/cabo/images/cache/gantt
Apache Web Server Listener (PLSQL) is not running.
Starting Apache Web Server Listener (dedicated PLSQL) ...

adapcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 115.17

Checking for FNDFS executable.
Starting listener process APPS_GOLD.

adalnctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfrmctl.sh start
script returned:
****************************************************

You are running adfrmctl.sh version 115.38

Starting forms server for GOLD on port 9080.

adfrmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfmcctl.sh start
script returned:
****************************************************

You are running adfmcctl.sh version 115.20

Starting forms load balancing client for GOLD.

adfmcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/adfmsctl.sh start
script returned:
****************************************************

You are running adfmsctl.sh version 115.16

starting forms metrics server for GOLD.

adfmsctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/data/applmgr/common/admin/scripts/GOLD_it-pwl-ows01/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 115.16

Validating Fulfillment patch level via /data/applmgr/common/java
Fulfillment patch level validated.
Starting Fulfillment Server for GOLD on port 9380 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.
Check logfile /data/applmgr/common/admin/log/GOLD_it-pwl-ows01/05131325.log for details

Exiting with status 0
[/data/applmgr/common/clone/bin]
applmgr@it-pwl-ows01(web/forms):$

10.4 Shutdown web/forms
cd
. ./.profile
cd $STOP
adstpall apps/apps

10.5 run adcfgclone web node 2: it-pwl-ows02.
Check it-pwl-ows02 using step 10.2
cd /data/applmgr/common/clone/bin

applmgr@it-pwl-ows02(/CCM:Admin):$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:
apps

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:n

Target system database SID [PROD]:GOLD

Target system database server node [pind41]:it-pwl-ods01

Target system database domain name [visioncorp.com]:visioncorp.com

Does the target system have more than one application tier server node (y/n) [y] ?:y

Does the target system application tier utilize multiple domain names (y/n) [n] ?:n

Target system concurrent processing node [pind43]:it-pwl-oas02

Target system administration node [pind43]:it-pwl-oas02

Target system forms server node [pind23]:it-pwl-ows02

Target system web server node [pind23]:it-pwl-ows02

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

Target system APPL_TOP mount point [/data/wfmprod/11i]:/data/applmgr/11i

Target system COMMON_TOP directory [/data/wfmprod/common]:/data/applmgr/common

Target system 8.0.6 ORACLE_HOME directory [/data/wfmprod/product/8.0.6]:/data/applmgr/product/8.0.6

Target system iAS ORACLE_HOME directory [/data/wfmprod/product/iAS]:/data/applmgr/product/iAS

Do you want to preserve the Display set to pind43.visioncorp.com:1.0 (y/n) [y] ?:n

Target system Display [it-pwl-ows02:0.0]:it-pwl-oas02.visioncorp.com:1.0

Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
80

Checking the port pool 80
done: Port Pool 80 is free

Complete port information available at /data/applmgr/11i/admin/out/GOLD_it-pwl-ows02/portpool.lst

Verifying Database Connection...

Database Connection on Port 1601: Successful

UTL_FILE_DIR on database tier consists of the following directories.

1. /pcp/applmgr/common/temp
2. /pcp/applmgr/common/xx_custom/outbound/gl
3. /pcp/applmgr/common/xx_custom/inbound/gl
4. /pcp/applmgr/common/EDI/inholding
5. /pcp/applmgr/common/EDI/outholding
6. /pcp/applmgr/common/xx_custom/outbound/acsis
7. /opt/oracle/product/10.2.0/GOLD/appsutil/outbound/GOLD2_it-pwl-ods02
8. /pcp/applmgr/common/xx_custom/outbound/ceridian
9. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:1

10.6 Shutdown web/forms
cd
. ./.profile
cd $STOP
adapstpall apps/apps

10.7 update contextfile

10.7.1 web tier JDBC and listener load balancing
Update contextfile: s_tools_two_task from GOLD to GOLD_806_BALANCE
And s_weboh_twotask from GOLD to GOLD_BALANCE.

10.7.2 workflow

s_javamailer_reply_to from workflow.prod@visioncorp.com to workflow.gold@visioncorp.com
s_javamailer_imap_user from visioncorp\oraclework to visioncorp\oraclegold
s_smtphost from it-pwl-ows01 to pemco21


Need to create account on exchange server: PEMCO21 with account name: oraclegold and password: powelloracle (for all instances) with email address of workflow.gold@visioncorp.com

use webmail to check the account:

http://email.visioncorp.com
username: oraclegold
password:powelloracle

then OAM->workflow manager->service components->workflow notification mailer->edit->update password

then restart the workflow mailer.

10.7.3 Discoverer (10g, on separate node)
s_disco_machine from it-pwl-ows01.visioncorp.com to pind30.visioncorp.com
s_disco_port from 8080 to 7778

Need to create tnsnames.ora entry on pind30.

10.7.4 web tier load balancing

s_webentryhost=it-pwl-ows01
s_webentrydomain=visioncorp.com
s_webentryurlprotocol=http
s_active_webport=8080
s_login_page=http://it-pwl-ows01.visioncorp.com:8080/OA_HTML/US/ICXINDEX_GOLD_it-pwl-oas01.htm

10.7.5 update context_name_ifile.ora for concurrent processing tiers

GOLD_806_BALANCE=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods01-vip.visioncorp.com)(PORT=1601))
(CONNECT_DATA=
(SERVICE_NAME=GOLD)
(INSTANCE_NAME=GOLD1)
)
)
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=it-pwl-ods02-vip.visioncorp.com)(PORT=1601))
(CONNECT_DATA=
(SERVICE_NAME=GOLD)
(INSTANCE_NAME=GOLD2)
)
)
)

Update concurrent manager tier context file: s_cp_twotask from GOLD to GOLD_806_BALANCE in environment->tools_home

s_cp_twotask=GOLD_806_BALANCE



Environment->applsys: s_applcsf: update data to pcp

s_applcsf=/pcp/applmgr/common/admin
s_applptmp=/pcp/applmgr/common/temp
s_appltmp=/pcp/applmgr/common/temp

On web tier:

s_applcsf=/data/applmgr/common/admin
s_applptmp=usr/tmp
s_appltmp=data/applmgr/common/temp

Need to create directories (EDI etc) under /pcp/applmgr/common for new instance.


10.7.6 Modify template for MWATOP on web tier.
Cd $FND_TOP/admin/template
mkdir custom
Cp jserv_ux_ias1022.properties to custom
Change mwa entry to %s_mwatop%

10.7.7 database tier

Update s_dbService from GOLD to GOLD1 (changed back)

S_instLocalListener from LISTENER_GOLD1 to GOLD1_LOCAL
S_instRemoetListener from LISTENERS_GOLD to GOLD_REMOTE

Change default listener name
Cd /opt/oracle/product/10.2.0/GOLD/appsutil/template
Mkdir custom
Cp adlsnr10RAC.ora custom
Cd custom
Update _%s_dbhost% to _%s_dbSid%

10.8 clean clone setup

[~/scripts/clone]
oracle@it-pwl-ods02(GOLD2/DBTier):$ cat fnd_clone_clean.sql
-- must run autoconfig after this
--
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;

10.9 Run autoconfig on all nodes
cd $ORACLE_HOME/appsutil/scripts/GOLD1_it-pwl-ods01

Run adautocfg.sh ods01, ods02, ods01, oas01, oas02, ows01, ows02, oas01,oas02,ows01

10.10 checking
Select node_name,server_id from fnd_nodes

Make sure all server_id got populated.

Bounced listener (for using listener_ and database for init.ora parameter _immediate_commit_propagation)

Grant debug connect session to apps;

11 apps post clone steps
11.1 create custom.env on all apps node in $APPL_TOP
11.2 start xvnc on oas01 and oas02. copy startvnc.sh from prod ccm tier and run it.
11.3 tomcat for unitask: port 8080 used. In /data/applmgr/11i/xxlpr/11.5.0/apache-tomcat-4.1.36/conf/server.xml file, update to 8081.
11.4 workflow mailer: need to create email account visioncorp\oraclegold
11.5 unitask license for new implementation. Check with George Burgos.
11.6 PIC UI license: run following query and send dbid info to Michael Kendrick


1 select host_name, global_name, dbid
2* from v$database, v$instance, global_name
SQL> /

HOST_NAME GLOBAL_NAME DBID
-------------------- -------------------- ----------
pind42.visioncorp.com PROD.VISIONCORP.COM 94528928

11.7 Update icx_parameters
Login as system
SQL> update icx_parameter set session_cookie_domain = “.visioncorp.com” where session_cookie_name = ‘gold’
11.8 Update gsmstart.sh for MRP
cd $STOP
vi gsmstart.sh
modify TWO_TASK = ‘GOLD’ – not load balanced.

Or modify template $FND_TOP/admin/template/gsmstart.sh.
Cd $FND_TOP/admin/template
Mkdir custom
Cp gsmstart.sh custom
Cd custom
Cp gsmstart.sh gsmstat.sh.orig
Vi gsmstart.sh, modify s_cp_twotask to s_dbSid.

11.9 change passwords
cd scripts/clone/GOLD

FNDCPASS apps/appsPROD 0 Y system/systemPROD SYSTEM APPLSYS newappspw
FNDCPASS apps/newappspw 0 Y system/systemPROD ALLORACLE newpass
FNDCPASS apps/newappspw 0 Y system/systemPROD ORACLE xx_custom newpass
FNDCPASS apps/newappspw 0 Y system/systemPROD USER SYSADMIN newsysadminpw

modify chg.sh
execute chg.sh
11.10 start mwa
11.11 scramble HR data (script takes awhile) (from ccm tier)
cd $HOME/scripts/scramble
sqlplus apps/apps @powl_scramble_data

due to html tag issue, replace "<" with "leftarrow" and ">" with "rightarrow"