12.2 Manual Clone – XXXXXXX01 – Multi Node

Index

Pre-Clone	Incomplete
Source Database Backup	Incomplete
Pre-Clone dbTier	Incomplete
Copy Oracle Database Binaries of Source	Incomplete
Pre-Clone appsTier	Incomplete
Copy Application Binaries of Source	Incomplete
Send Outage Communication	Incomplete
Stop Application Services	Incomplete
SSO undeployag (All Nodes)	Incomplete
SSO dereg (All Nodes)	Incomplete
Cleanup Application Filesystems	Incomplete
Drop Database	Incomplete
Cleanup Database Binaries	Incomplete
unTar Database Binaries	Incomplete
unTar Application Binaries	Incomplete
Configure DB in First Node	Incomplete
Configure DB in Second Node	Incomplete
Duplicate Database	Incomplete
Convert Database to RAC	Incomplete
Database Post Checks / Purge Scripts	Incomplete
Configure Application using dualfs	Incomplete
Delete oacore5 make xml Changes in Primary Node	Incomplete
PreClone in Primary Node	Incomplete
Create PairFiles for other Nodes	Incomplete
Run Add Node in all Secondary Nodes	Incomplete
.xml Changes in all Application Nodes	Incomplete
Modify DB Directories	Incomplete
Change Passwords	Incomplete
Run Instance Specific scripts	Incomplete
update Profile Option Values	Incomplete
Softlinks Remapping	Incomplete
Re-Create DB Links	Incomplete
Register SSO	Incomplete
Modify mod_wl_ohs.conf	Incomplete
Create soft links for accessgate plan.xml file	Incomplete
Extranet Setup	Incomplete
Copy Custom Env File	Incomplete
Start Mobile Services	Incomplete
Release the Instance to the Business	Incomplete

PreClone:

From DT ORACLE USER:

mkdir -p /p01/XXXXXXX01/csf/preclone/${SID}.${DATEFMT}/DT/db/rdbms

cp $ORACLE_HOME/*.env .

cp $TNS_ADMIN/*.ora .

cp $ORACLE_HOME/appsutil/*.xml .

cp $ORACLE_HOME/dbs/init*.ora .

--- To take backup of DBlinks

sh /p01/XXXXXXX01/custom/scripts/budlink.sh

From APPL USER

mkdir -p /p01/XXXXXXX01/csf/preclone/${SID}.${DATEFMT}/AT/fs1-pre

cp $APPL_TOP/*.env .

cp $APPL_TOP/admin/adovars.env .

cp $APPL_TOP/admin/adpltfrm.txt .

cp $APPL_TOP/admin/topfile.txt .

cp $APPL_TOP/admin/*.xml* .

cp -r $FND_TOP/secure/* .

cp -r $FND_TOP/secure/${SID}/* .

cp $OA_HTML/env.txt .

cp -r $MWA_TOP/secure/* .

cp $ORACLE_HOME/*.env* .

cp $TNS_ADMIN/*.ora* .

$FMW_HOME/webtier/instances .

cp –rp $INST_TOP .

mkdir inst_patch

cd inst_patch

cp –rp $PATCH_BASE/inst .

Record the File Structure

cd /p01/XXXXXXX01/csf/preclone/${SID}.${DATEFMT}

sqlplus '/as sysdba'

spool file_structure.lst

select name from v$database;

archive log list

show parameter pfile

select name from v$controlfile;

select file_name from dba_data_files;

select file_name from dba_temp_files;

select group#,member from v$logfile;

sho parameter undo

select tablespace_name from dba_tablespaces where tablespace_name like '%UNDO%';

alter database backup controlfile to trace as '/p01/XXXXXXX01/csf/preclone/${SID}.${DATEFMT}/ctrltrace.sql';

spool off

Source Database Backup:

rman.sh

rman target / cmdfile='/p01/xxxxxx01/backup01/DB-BKP-26Dec2016/rman.cmd' log='/p01/xxxxxx01/backup01/DB-BKP-26Dec2016/db_backup.log'

rman.cmd

run {

ALLOCATE CHANNEL ch02 TYPE DISK;

ALLOCATE CHANNEL ch03 TYPE DISK;

ALLOCATE CHANNEL ch04 TYPE DISK;

ALLOCATE CHANNEL ch05 TYPE DISK;

ALLOCATE CHANNEL ch06 TYPE DISK;

ALLOCATE CHANNEL ch07 TYPE DISK;

ALLOCATE CHANNEL ch08 TYPE DISK;

ALLOCATE CHANNEL ch09 TYPE DISK;

ALLOCATE CHANNEL ch10 TYPE DISK;

ALLOCATE CHANNEL ch11 TYPE DISK;

BACKUP AS COMPRESSED BACKUPSET

FORMAT '/p01/xxxxxx01/backup01/DB-BKP-26Dec2016/%d_db_u%u_s%s_p%p_t%t_db'

FILESPERSET 10

database plus archivelog ;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

RELEASE CHANNEL ch07;

RELEASE CHANNEL ch08;

RELEASE CHANNEL ch09;

RELEASE CHANNEL ch10;

RELEASE CHANNEL ch11;

}

sql 'alter system archive log current';

run{

ALLOCATE CHANNEL ch00 TYPE DISK;

BACKUP FORMAT '/p01/xxxxxx01/backup01/DB-BKP-26Dec2016/%d_db_u%u_s%s_p%p_t%t_db' TAG 'xxxxxx01_ctrl' CURRENT CONTROLFILE;

RELEASE CHANNEL ch00;

}

exit

nohup sh rman.sh &

Once Completed Check for any Errors in log file:

egrep -i 'ERROR|error|ORA' db_restore.log

Give Full Permissions to the Directory:

chomod -R 777 /p01/xxxxxx01/backup01/DB-BKP-26Dec2016

Pre-Clone in dbTier

Check if same Patches are applied for Source and Target:

oraXXXXXXX01@qservername104(OPatch)$ opatch lsinv | grep -i applied

Patch 24701882 : applied on Fri Apr 14 02:44:42 EDT 2017

Patch 24701840 : applied on Fri Apr 14 02:34:58 EDT 2017

Patch 21967332 : applied on Fri Apr 14 02:24:44 EDT 2017

Patch 24499346 : applied on Fri Apr 14 02:21:42 EDT 2017

Patch 24502781 : applied on Fri Apr 14 02:17:31 EDT 2017

Patch 24315821 : applied on Fri Apr 14 01:58:11 EDT 2017

Patch 24340671 : applied on Fri Apr 14 01:45:02 EDT 2017

Patch 23477849 : applied on Sun Nov 13 02:25:22 EST 2016

Patch 22731026 : applied on Sun Nov 13 02:22:50 EST 2016

Patch 22496904 : applied on Sun Nov 13 02:19:27 EST 2016

Patch 21904072 : applied on Sun Nov 13 02:11:42 EST 2016

Patch 21321429 : applied on Sun Nov 13 02:07:34 EST 2016

Patch 21864513 : applied on Sun Nov 13 02:03:10 EST 2016

Patch 23057868 : applied on Sun Nov 13 01:41:33 EST 2016

Patch 23614158 : applied on Sun Nov 13 01:15:25 EST 2016

Patch 23286156 : applied on Sun Nov 13 00:38:28 EST 2016

Patch 23054319 : applied on Sun Nov 13 00:29:24 EST 2016

Patch 22037014 : applied on Tue Apr 12 08:32:42 EDT 2016

Patch 21028698 : applied on Tue Apr 12 07:35:44 EDT 2016

Patch 19835133 : applied on Sat Nov 21 18:35:48 EST 2015

Patch 16075609 : applied on Sat Nov 21 18:28:28 EST 2015

Patch 19472320 : applied on Fri Nov 20 09:16:41 EST 2015

Patch 17629476 : applied on Fri Nov 20 09:13:09 EST 2015

Patch 17429475 : applied on Fri Nov 20 09:11:55 EST 2015

Patch 16989137 : applied on Fri Nov 20 09:10:36 EST 2015

Patch 12949905 : applied on Fri Nov 20 09:02:17 EST 2015

Patch 4247037 : applied on Fri Nov 20 09:00:06 EST 2015

Patch 4189542 : applied on Thu Nov 19 17:44:57 EST 2015

Patch 19396455 : applied on Fri Oct 16 18:16:24 EDT 2015

oraXXXXXXX01@qservername104(OPatch)$

If same patches are already present, no need to copy the Oracle Binaries. If they differ follow the following

**** Important Note : While cloning ACA Instance please make sure you are copying the Oracle Binaries from any other ACA Instance where Latest patches are applied. (This is because we have separate list of patches for ACA and Exa)

If you are Copying Oracle Binaries to Target:

cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

perl adpreclone.pl dbTier

Copy Oracle Database Binaries of Source:

cd $ORACLE_HOME/..

nohup tar -cvf - 11.2.0.4 2> /backup/rman_1060/gpspgjp1/BIN_03june2016/11.2.0.4.log | gzip -c > /backup/rman_1060/gpspgjp1/BIN_03june2016/11.2.0.4.tar.gz &

Pre-Clone appsTier:

cd $ADMIN_SCRIPTPS_HOME

perl adpreclone.pl appsTier

Copy Application Binaries of Source:

cd /p01/xxxxxx01/appl/erpapp/fs1

nohup tar -cvf - EBSapps 2> /p01/XXXXXXX01/appl/EBSapps.log | gzip -c > /p01/XXXXXXX01/appl/EBSapps.tar.gz &

Send Outage Communication:

Send Outage Mail in the below Format:

Stop Application Services

on all WebNodes:

cd $ADMIN_SCRIPTS_HOME

adstpall.sh apps/********

On Primary Node:

cd $ADMIN_SCRIPTS_HOME

adstpall.sh apps/********

SSO De-Registration:

cd $NE_BASE/sso

--- In All Web Nodes

./oamreg_linux XXXXXXX01 stage apps_Password undeployag

--- on All Web Nodes (Internal)

./oamreg_linux XXXXXXX01 stage apps_Password dereg

---- On all DMZ Nodes

./oamreg_linux XXXXXXX01 stage apps_Password dmzdereg

Cleanup Application Filesystems:

cd /p01/XXXXXXX01/appl/erpapp

rm -rf fs1 &

rm -rf fs2 &

rm -rf fs_ne &

rm -rf oraInventory &

Drop The Database :

create pfile='$ORACLE_HOME/init$ORACLE_SID.ora' from spfile;

alter system set cluster_database=FALSE scope=spfile;

srvctl stop database -d XXXXXXX01

sqlplus '/as sysdba'

startup mount restrict

sho parameter cluster_database

drop database;

Cleanup Database Binaries:

On Node1:

cd $ORACLE_HOME/..

rm -rf 11.2.0.4 &

On Node2:

cd $ORACLE_HOME/..

rm -rf 11.2.0.4 &

unTar Database Binaries

On First Nodes;

cd $ORACLE_HOME/..

nohup gunzip -c /backup/rman_1060/gpspgjp1/BIN_03june2016/11.2.0.4.tar.gz |tar -xvf - > /gpspgjd1/erpapp/11.2.0.4.log &

On Second Node:

cd $ORACLE_HOME/..

nohup gunzip -c /backup/rman_1060/gpspgjp1/BIN_03june2016/11.2.0.4.tar.gz |tar -xvf - > /gpspgjd1/erpapp/11.2.0.4.log &

unTar Application Binaries:

cd /p01/XXXXXXX01/appl/erpapp/fs1

nohup gunzip -c /p01/XXXXXXX01/appl/EBSapps.tar.gz |tar -xvf - > /p01/XXXXXXX01/appl/EBSapps.log &

Configure Oracle Binaries in First Node:

export ORACLE_HOME=/p01/XXXXXXX01/oracle/product/11.2.0.4

cd $ORACLE_HOME/rdbms/lib

ar -t libknlopt.a | grep -c kcsm.o

1 means RAC , 0 means Non-RAC

make -f ins_rdbms.mk rac_off

make -f ins_rdbms.mk ioracle

ar -t libknlopt.a | grep -c kcsm.o

Copy the Existing xml file to Context File Location: (if Present)

cp XXXXXXX011_qservername103.xml $ORACLE_HOME/appsutil/XXXXXXX011_qservername103.xml

export ORACLE_HOME=/p01/XXXXXXX01/oracle/product/11.2.0.4

export ORACLE_SID=XXXXXXX011

export PATH=$ORACLE_HOME/perl/bin:$PATH

which perl

cd $ORACLE_HOME/appsutil/clone/bin

perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.39

Enter the APPS password :

Running:

/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/java:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/xmlparserv2.jar:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/ojdbc6.jar:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/obfuscatepassword.jar:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/ojmisc.jar:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/java:/p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_67562.lst -stage /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_67562.err; echo $? > /tmp/adcfgclone_67562.res

Log file located at /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/bin/CloneContext_1019180728.log

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

Target System Hostname (virtual or normal) [qservername103] : qservername103

Target Instance is RAC (y/n) [y] : n

Target System Database SID : XXXXXXX01

Target System Base Directory : /p01/XXXXXXX01/oracle

Target System utl_file_dir Directory List : /p01/XXXXXXX01/temp/tmpfiles,/p01/XXXXXXX01/csf,/usr/tmp

Number of DATA_TOP's on the Target System [3] : 1

Target System DATA_TOP Directory 1 : /p01/XXXXXXX01/oracle

Target System RDBMS ORACLE_HOME Directory [/p01/XXXXXXX01/oracle/11.2.0] : /p01/XXXXXXX01/oracle/product/11.2.0.4

Do you want to preserve the Display [pwerpl0581pv10:20] (y/n) : n

Target System Display [qservername103:0.0] : qservername103:1.0

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 1

Checking the port pool 1

done: Port Pool 1 is free

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/log/XXXXXXX01_qservername103/addlnctl.txt for more information ...

Configure DB in Second Node:

export ORACLE_HOME=/p01/XXXXXXX01/oracle/product/11.2.0.4

cd $ORACLE_HOME/rdbms/lib

ar -t libknlopt.a | grep -c kcsm.o

1 means RAC , 0 means Non-RAC

make -f ins_rdbms.mk rac_off

make -f ins_rdbms.mk ioracle

ar -t libknlopt.a | grep -c kcsm.o

Copy the xml file from preclone to Context File Location:

cp XXXXXXX012_qservername104.xml $ORACLE_HOME/appsutil/XXXXXXX012_qservername104.xml

export ORACLE_HOME=/p01/XXXXXXX01/oracle/product/11.2.0.4

export PATH=$ORACLE_HOME/perl/bin:$PATH

export ORACLE_SID=XXXXXXX012

which perl

cd $ORACLE_HOME/appsutil/clone/bin

perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.39

Enter the APPS password :

Running:

Log file located at /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/clone/bin/CloneContext_1019180728.log

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

Target System Hostname (virtual or normal) [qservername104] : qservername104

Target Instance is RAC (y/n) [y] : n

Target System Database SID : XXXXXXX01

Target System Base Directory : /p01/XXXXXXX01/oracle

Target System utl_file_dir Directory List : /p01/XXXXXXX01/temp/tmpfiles,/p01/XXXXXXX01/csf,/usr/tmp

Number of DATA_TOP's on the Target System [3] : 1

Target System DATA_TOP Directory 1 : /p01/XXXXXXX01/oracle

Target System RDBMS ORACLE_HOME Directory [/p01/XXXXXXX01/oracle/11.2.0] : /p01/XXXXXXX01/oracle/product/11.2.0.4

Do you want to preserve the Display [pwerpl0581pv10:20] (y/n) : n

Target System Display [qservername104:0.0] : qservername104:1.0

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 1

Checking the port pool 1

done: Port Pool 1 is free

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /p01/XXXXXXX01/oracle/product/11.2.0.4/appsutil/log/XXXXXXX01_qservername104/addlnctl.txt for more information ...

Change Group & Mode of oracle binary on all nodes:

cd $ORACLE_HOME/bin

ls -ltr oracle

-rwsr-s--x 1 oracle oinstall 240410831 Apr 18 02:15 oracle

chgrp asmadmin oracle

ls -ltr oracle

-rwsr-s--x 1 oracle asmadmin 240410831 Apr 18 02:15 oracle

chmod 6751 oracle

cd $ORACLE_HOME/bin

unlink lbuilder

ln -s $ORACLE_HOME/nls/lbuilder/lbuilder lbuilder

ls -ltr lbuilder

Copy pfile from preclone:

cp init$ORACLE_SID.ora $ORACLE_HOME/dbs

cd $ORACLE_HOME/dbs

grep -i convert init$ORACLE_SID.ora

*.db_file_name_convert='+DATAC1','+DATAC1'

*.log_file_name_convert='+DATAC1','+DATAC1'

Sqlpus ‘/as sysdba’

Create spfile=’+DATAC1/XXXXXXX01/parameterfile/spfileXXXXXXX01.ora’ from pfile=’ $ORACLE_HOME/dbs/init$ORACLE_SID.ora';

SQL> startup nomount

Duplicate Database:

rman.sh

rman auxiliary / cmdfile='/p01/XXXXXXX01/backup01/RMAN_14NOV2016/rman_restore.cmd' log='/p01/XXXXXXX01/backup01/RMAN_14NOV2016/rman_restore.log'

rman_restore.cmd

run {

ALLOCATE auxiliary CHANNEL ch01 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch02 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch03 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch04 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch05 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch06 TYPE DISK;

DUPLICATE DATABASE TO XXXXXXX01

BACKUP LOCATION '/p01/xxxxxx01/backup01/DB_BKP_14NOV16'

NOFILENAMECHECK;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

}

nohup sh rman.sh &

FOR PCA Instances:

CREATE RMAN SCRIPT FOR RESTORE AND RECOVERY:

Run the following query in Source to get the output used for preparing Restore script:

set head off;

set lines 900

select 'SET NEWNAME FOR DATAFILE ' ||FILE_ID|| ' TO ' || '''' || '/p01/xxxxxx04/oradata/data1/' || substr(FILE_NAME,(instr(FILE_NAME,'/',-1,1))+1)|| ''''||';' from dba_data_files where tablespace_name not in ('APPS_TS_TX_IDX','APPS_UNDOTS1','APPS_UNDOTS2','APPS_UNDOTS3','APPS_UNDOTS4','UNDOTBS1','UNDOTBS2','UNDOTBS3','UNDOTBS4')

UNION

select 'SET NEWNAME FOR DATAFILE ' ||FILE_ID|| ' TO ' || '''' || '/p01/xxxxxx04/oradata/undo/' || substr(FILE_NAME,(instr(FILE_NAME,'/',-1,1))+1)|| ''''||';' from dba_data_files where tablespace_name in ('APPS_UNDOTS1','APPS_UNDOTS2','APPS_UNDOTS3','APPS_UNDOTS4','UNDOTBS1','UNDOTBS2','UNDOTBS3','UNDOTBS4')

UNION

select 'SET NEWNAME FOR DATAFILE ' ||FILE_ID|| ' TO ' || '''' || '/p01/xxxxxx04/oradata/index/' || substr(FILE_NAME,(instr(FILE_NAME,'/',-1,1))+1)|| ''''||';' from dba_data_files where tablespace_name in ('APPS_TS_TX_IDX')

UNION

select 'SET NEWNAME FOR TEMPFILE ' ||FILE_ID|| ' TO ' || '''' || '/p01/xxxxxx04/oradata/temp/' || substr(FILE_NAME,(instr(FILE_NAME,'/',-1,1))+1)|| ''''||';' from dba_temp_files;

spool off;

Place the Output below channels allocation in Restore Script:

ALLOCATE auxiliary CHANNEL ch06 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch07 TYPE DISK;

SET NEWNAME FOR DATAFILE 1 TO '/p01/xxxxxx01/oradata/data1/system.1728.916054081';

SET NEWNAME FOR DATAFILE 10 TO '/p01/xxxxxx01/oradata/data1/apps_ts_media.1990.916054957';

SET NEWNAME FOR DATAFILE 100 TO '/p01/xxxxxx01/oradata/data1/gepsbackd.1781.916055643';

SET NEWNAME FOR TEMPFILE 5 TO '/p01/xxxxxx01/oradata/temp/temp.2291.916152947';

SET NEWNAME FOR TEMPFILE 6 TO '/p01/xxxxxx01/oradata/temp/temp.2290.916152947';

SET NEWNAME FOR TEMPFILE 7 TO '/p01/xxxxxx01/oradata/temp/temp.2289.916152947';

DUPLICATE DATABASE TO xxxxxx01

BACKUP LOCATION '/p01/xxxxxx01/backup02/xxxxxx01_clone_25Jan2017/db'

NOFILENAMECHECK;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

Edit few undo tablespaces such that they reside in data1 mount point as below (Undo MountPoint Issue)

oraxxxxxx01@pwercd01vn046(rman_restore_26Jan16)$ grep -i undo rman.cmd

SET NEWNAME FOR DATAFILE 220 TO '/p01/xxxxxx01/oradata/undo/undotbs3.2296.916154507';

SET NEWNAME FOR DATAFILE 221 TO '/p01/xxxxxx01/oradata/data1/undotbs4.2297.916154563';

SET NEWNAME FOR DATAFILE 222 TO '/p01/xxxxxx01/oradata/undo/undotbs2.2314.916356275';

SET NEWNAME FOR DATAFILE 229 TO '/p01/xxxxxx01/oradata/data1/undotbs4.2425.922017983';

SET NEWNAME FOR DATAFILE 230 TO '/p01/xxxxxx01/oradata/undo/undotbs1.2426.922028839';

SET NEWNAME FOR DATAFILE 232 TO '/p01/xxxxxx01/oradata/data1/undotbs4.2574.929794643';

SET NEWNAME FOR DATAFILE 233 TO '/p01/xxxxxx01/oradata/data1/undotbs3.2575.929794785';

SET NEWNAME FOR DATAFILE 234 TO '/p01/xxxxxx01/oradata/data1/undotbs3.2576.929794799';

SET NEWNAME FOR DATAFILE 235 TO '/p01/xxxxxx01/oradata/undo/undotbs2.2577.929794929';

SET NEWNAME FOR DATAFILE 236 TO '/p01/xxxxxx01/oradata/data1/undotbs1.2585.930155543';

SET NEWNAME FOR DATAFILE 242 TO '/p01/xxxxxx01/oradata/undo/undotbs3.2696.933030533';

SET NEWNAME FOR DATAFILE 3 TO '/p01/xxxxxx01/oradata/data1/undotbs1.1722.916054081';

SET NEWNAME FOR DATAFILE 5 TO '/p01/xxxxxx01/oradata/data1/undotbs2.1809.916054081';

oraxxxxxx01@pwercd01vn046(rman_restore_26Jan16)$

Check the following once Database is up:

show parameter pfile

SELECT * FROM V$RECOVER_FILE;

select name,user,open_mode from v$database;

archive log list

select name from v$controlfile;

select file_name from dba_data_files;

select file_name from dba_temp_files;

select group#,member from v$logfile;

select node_name from apps.fnd_nodes;

sho parameter undo

select tablespace_name from dba_tablespaces where tablespace_name like '%UNDO%';

select file_name,tablespace_name,BYTES/1024/1024 from dba_data_files where tablespace_name like '%UNDO%';

select file_name, tablespace_name, bytes/1024/1024 from dba_temp_files;

show parameter db_name

show parameter db_unique_name

--- DB Name DB Unique name should be in Small case, if not change in pfile.ora file and bounce DB.

show parameter service

alter system set service_names='ebs_patch,XXXXXXX01' scope=both;

select NAME from dba_services;

update dba_services set NAME='XXXXXXX01' where NAME='XXXXXXX01';

--- if Undo/Temp are not in Target Mount Point do the following:

create temporary tablespace TEMPDUP tempfile '+DATAC1' size 200m;

alter database default temporary tablespace TEMPDUP;

drop tablespace TEMP including contents and datafiles;

create temporary tablespace TEMP tempfile '+DATAC1' size 200m;

Convert Database to RAC:

startup

sho parameter undo

sho parameter pfile

select instance_name from gv$instance

select tablespace_name from dba_tablespaces where tablespace_name like '%UNDO%';

alter system set cluster_database=TRUE scope=spfile;

alter system set instance_number=1 SID='XXXXXXX011' scope=spfile;

alter system set thread=1 SID='XXXXXXX011' scope=spfile;

alter system set instance_number=2 SID='XXXXXXX012' scope=spfile;

alter system set thread=2 SID='XXXXXXX012' scope=spfile;

alter system set undo_tablespace='APPS_UNDOTS11' SID='XXXXXXX011' scope=spfile;

alter system set undo_tablespace='APPS_UNDOTS12' SID='XXXXXXX012' scope=spfile;

select GROUP#,THREAD#,MEMBERS,STATUS from v$log;

alter database enable public thread 2;

alter database enable public thread 3;

shut immediate

Convert Non-RAC to RAC

cd $ORACLE_HOME/rdbms/lib

ar -t libknlopt.a | grep -c kcsm.o

make -f ins_rdbms.mk rac_on

make -f ins_rdbms.mk ioracle

ar -t libknlopt.a | grep -c kcsm.o

Edit the pfile with Location of spfile:

Node1:

cd $ORACLE_HOME/dbs

cat init$ORACLE_SID.ora

spfile='+DATAC1/XXXXXXX01/parameterfile/spfileXXXXXXX01.ora'

Node2:

cd $ORACLE_HOME/dbs

cat init$ORACLE_SID.ora

spfile='+DATAC1/XXXXXXX01/parameterfile/spfileXXXXXXX01.ora'

Start using srvctl:

srvctl start database -d XXXXXXX01

Database Post Checks / Purge Scripts:

UPDATE PRODUCT_USER_PROFILE SET CHAR_VALUE='ENABLED' WHERE CHAR_VALUE='DISABLED';

COMMIT;

update apps.fnd_user set email_address = null;

update apps.per_all_people_f set email_address = null;

update apps.po_vendor_sites_all set fax = null, fax_area_code = null, attribute12 = null;

update apps.PO_VENDOR_SITES_ALL set attribute11 = NULL where attribute11 is not NULL;

UPDATE apps.po_vendor_sites_all SET email_address = NULL WHERE email_address IS NOT NULL;

commit;

Truncate table applsys.fnd_concurrent_processes;

Truncate table applsys.fnd_concurrent_requests;

update applsys.FND_CONCURRENT_QUEUES set node_name=null, target_node=null where concurrent_queue_name like 'FNDICM';

update apps.icx_parameters set session_cookie_domain=NULL;

update applsys.FND_CONCURRENT_QUEUE_SIZE set MIN_PROCESSES=5 where concurrent_queue_id in (SELECT a.CONCURRENT_QUEUE_id FROM applsys.fnd_concurrent_queues a, applsys.FND_CONCURRENT_QUEUE_SIZE b WHERE a.CONCURRENT_QUEUE_id=b.CONCURRENT_QUEUE_id and b.min_processes > 40);

update applsys.fnd_cp_services a set developer_parameters= (select b.developer_parameters||':-mx64m' from applsys.fnd_cp_services b where a.service_id=b.service_id and b.developer_parameters like 'J%'and a.service_handle not like 'FNDOPP%') where a.developer_parameters like 'J%' and developer_parameters not like '%-mx64m%' and a.service_handle not like 'FNDOPP%';

update applsys.wf_notifications set status='CLOSED' where status='OPEN';

update applsys.wf_notifications set MAIL_Status='SENT' where mail_status='MAIL';

update apps.alr_alerts set enabled_flag = 'N' where alert_name like 'GEPS%';

update hr.per_all_people_f set email_address = null;

UPDATE ASO.ASO_QUOTE_HEADERS_ALL SET ATTRIBUTE4 = NULL;

update applsys.wf_local_roles set email_address = null;

commit;

Clean up fnd_nodes:

conn apps/*****

exec fnd_conc_clone.setup_clean;

EXEC FND_CONC_CLONE.TARGET_CLEAN;

Run AutoConfig on Both DB Nodes in the Order : 1 - 2 - 1

Make the value of s_update_scan as TRUE before Running Autoconfig

grep -i s_update_scan $CONTEXT_FILE

cd $ORACLE_HOME/appsutil/bin

adconfig.sh

Repeat the Same in Second Node:

grep -i s_update_scan $CONTEXT_FILE

cd $ORACLE_HOME/appsutil/bin

adconfig.sh

Check connectivity on both the node :

sqlplus apps/****@XXXXXXX01

sqlplus apps/****@XXXXXXX011

sqlplus apps/****@XXXXXXX012

On 1st Node:

SQL> conn apps/****@XXXXXXX01

Connected.

SQL> conn apps/****@XXXXXXX011

Connected.

SQL> conn apps/****@XXXXXXX012

Connected.

On 2nd node:

SQL> conn apps/****@XXXXXXX01

Connected.

SQL> conn apps/****@XXXXXXX011

Connected.

SQL> conn apps/****@XXXXXXX012

Connected.

Configure Application using dualfs:

Connect to Primary Application Node:

cd /p01/XXXXXXX01/appl/erpapp

mkdir fs1

Verify the Inventory location and group of oraInst.loc in /etc and 10.1.2_Home

appXXXXXXX01@servername116(erpapp)$ cat /etc/oraInst.loc

inventory_loc=/p01/XXXXXXX01/appl/erpapp/oraInventory

inst_group=oaaXXXXXXX01

appXXXXXXX01@servername116(erpapp)$ cat /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/10.1.2/oraInst.loc

inventory_loc=/p01/XXXXXXX01/appl/erpapp/oraInventory

inst_group=oaaXXXXXXX01

Make sure env file .bash_profile is deleted/notsourced

cd /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin

perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] : no

Running: Context clone...

Log file located at /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin/CloneContext_0424230009.log

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

Target System Hostname (virtual or normal) [servername116] :

Target System Database SID : XXXXXXX01

Target System Database Server Node [servername116] : perald41-scan

Target System Database Domain Name [domain.com] :

Target System Base Directory : /p01/XXXXXXX01/appl/erpapp

Target System Base Directory set to /p01/XXXXXXX01/appl/erpapp

Target System Current File System Base set to /p01/XXXXXXX01/appl/erpapp/fs1

Target System Other File System Base set to /p01/XXXXXXX01/appl/erpapp/fs2

Target System Fusion Middleware Home set to /p01/XXXXXXX01/appl/erpapp/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /p01/XXXXXXX01/appl/erpapp/fs2/FMW_Home

Target System Web Oracle Home set to /p01/XXXXXXX01/appl/erpapp/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /p01/XXXXXXX01/appl/erpapp/fs2/FMW_Home/webtier

Target System Appl TOP set to /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /p01/XXXXXXX01/appl/erpapp/fs2/EBSapps/appl

Target System COMMON TOP set to /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /p01/XXXXXXX01/appl/erpapp/fs2/EBSapps/comn

Target System Instance Home Directory [/p01/XXXXXXX01/appl/erpapp] :

Target System Current File System Instance Top set to /p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116

Do you want to preserve the Display [pwerlp01vn37:1.0] (y/n) : n

Target System Display [servername116:0.0] : servername116:1.0

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 [enabled] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 1

Checking the port pool 1

done: Port Pool 1 is free

Report file located at /p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /p01/XXXXXXX01/temp/tmpfiles

2. /p01/XXXXXXX01/custom/pa/out

Choose a value which will be set as APPLPTMP value on the target node [1] :

The new APPL_TOP context file has been created :

/p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/appl/admin/XXXXXXX01_servername116.xml

Check Clone Context logfile /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin/CloneContext_0424230009.log for details.

Creating Patch file system context file.....

Log file located at /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0424230116.log

Target System Other File System Instance Top set to /p01/XXXXXXX01/appl/erpapp/fs2/inst/apps/XXXXXXX01_servername116

Target System Port Pool [0-99] : 3

Checking the port pool 3

done: Port Pool 3 is free

Report file located at /p01/XXXXXXX01/appl/erpapp/fs2/inst/apps/XXXXXXX01_servername116/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/p01/XXXXXXX01/appl/erpapp/fs2/inst/apps/XXXXXXX01_servername116/appl/admin/XXXXXXX01_servername116.xml

Check Clone Context logfile /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0424230116.log for details.

FMW Pre-requisite check log file location : /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/admin/log/clone/run/RCloneApplyAppstier_04242301.log

Configuring: Patch file system....

LogFile located at /p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/admin/log/clone/patch/RCloneApplyAppstier_04250002.log

Do you want to startup the Application Services for XXXXXXX01? (y/n) [n] : n

Services not started

Delete oacore5 make xml Changes in Primary Node:

Start Admin Server in Run and Patch Filesystems:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env patch

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start forcepatchfs

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env run

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-managedserver -contextfile=$CONTEXT_FILE -managedsrvname=oacore_server5 -servicetype=oacore -managedsrvport=7203 -logfile=$EBS_DOMAIN_HOME/servers/oacore_server5/logs/oacore_server5.log

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env patch

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-managedserver -contextfile=$CONTEXT_FILE -managedsrvname=oacore_server5 -servicetype=oacore -managedsrvport=7205 -logfile=$EBS_DOMAIN_HOME/servers/oacore_server5/logs/oacore_server5.log

Login to Run/Patch Weblogic Console and delete oaea_servers

Run:

http://servername116.domain.com:7002/console

Patch:

http://servername116.domain.com:7004/console

Make Nessessary Changes in the Run/Patch Context-Files: (Refer from Pre-Clone)

Below are some of the Important Parameters to be changed:

egrep -i 's_javamailer_imaphost|s_javamailer_imapdomainname|s_javamailer_reply_to|s_javamailer_imap_user' $CONTEXT_FILE

appXXXXXXX01@servername116(admin)$ egrep -i 's_javamailer_imaphost|s_javamailer_imapdomainname|s_javamailer_reply_to|s_javamailer_imap_user' $CONTEXT_FILE

<domain oa_var="s_javamailer_imapdomainname" customized="yes">ad.domain.com</domain>

<username oa_var="s_javamailer_reply_to" customized="yes">mail.XXXXXXX01@domain.com</username>

<username oa_var="s_javamailer_imap_user" customized="yes">mail.XXXXXXX01@domain.com</username>

<EndUserMonitoringURL oa_var="s_endUserMonitoringURL">https://servername1.domain.com/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL>

<externURL oa_var="s_external_url">https://servername1.domain.com</externURL>

<webentryhost oa_var="s_webentryhost">servername1</webentryhost>

<webentrydomain oa_var="s_webentrydomain">domain.com</webentrydomain>

<login_page oa_var="s_login_page">https://servername1.domain.com/OA_HTML/AppsLogin</login_page>

<webentryurlprotocol oa_var="s_webentryurlprotocol">https</webentryurlprotocol>

<dbhost oa_var="s_dbhost">perald41-scan</dbhost>

<jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=perald41-scan)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XXXXXXX01)))</jdbc_url>

<APPLCSF oa_var="s_applcsf">/p01/XXXXXXX01/csf</APPLCSF>

<APPLTMP oa_var="s_appltmp">/p01/XXXXXXX01/temp/tmpfiles</APPLTMP>

<APPLPTMP oa_var="s_applptmp" osd="UNIX">/p01/XXXXXXX01/temp/tmpfiles</APPLPTMP>

<admin_ui_access_nodes oa_var="s_admin_ui_access_nodes">localhost</admin_ui_access_nodes>

<oacore_nodes oa_var="s_oacore_nodes">servername116.domain.com:7202,servername117.domain.com:7202</oacore_nodes>

<forms_nodes oa_var="s_forms_nodes">servername116.domain.com:7402,servername117.domain.com:7402</forms_nodes>

<oafm_nodes oa_var="s_oafm_nodes">servername116.domain.com:7602,servername117.domain.com:7602</oafm_nodes>

<forms-c4ws_nodes oa_var="s_forms-c4ws_nodes">servername116.domain.com:7802,servername117.domain.com:7802</forms-c4ws_nodes>

<oaea_nodes oa_var="s_oaea_nodes">servername116.domain.com:6802,servername117.domain.com:6802</oaea_nodes>

<TIER_ADMIN oa_var="s_isAdmin">YES</TIER_ADMIN>

<TIER_NODE oa_var="s_isConc">YES</TIER_NODE>

<TIER_NODEDEV oa_var="s_isConcDev">YES</TIER_NODEDEV>

<CP_TWOTASK oa_var="s_cp_twotask">XXXXXXX01</CP_TWOTASK>

<oa_service_status oa_var="s_concstatus">enabled</oa_service_status>

Once Completed Run Autoconfig on Run/Patch:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adautocfg.sh

Disable the Trigger: (From DB Node)

sqlplus '/as sysdba'

alter trigger SYSTEM.EBS_LOGON DISABLE;

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env patch

cd $ADMIN_SCRIPTS_HOME

adautocfg.sh

Once completed. Enabled the Trigger

alter trigger SYSTEM.EBS_LOGON ENABLE;

Start the Services in Run File System. Do Complete Sanity before proceeding to Further Steps

PreClone in Primary Node:

Run Pre-Clone in Run FileSystem:

cd $COMMON_TOP

mv clone clone_bkp

cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier

Create PairFiles for other Nodes:

· mkdir -p /p01/XXXXXXX01/appl/erpapp/pair_files/26Apl2017

· cp $INST_TOP/appl/admin/XXXXXXX01_servername116_run.txt /p01/XXXXXXX01/appl/erpapp/pair_files/26Apl2017/XXXXXXX01_servername116_run.txt

· cd /p01/XXXXXXX01/appl/erpapp/pair_files/26Apl2017

· cp XXXXXXX01_servername116_run.txt XXXXXXX01_servername117_run.txt

Edit the Newly Created Pair File with the following changes:

vi XXXXXXX01_servername117_run.txt

[Instance Specific]

s_temp=/p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername117/temp

s_contextname=XXXXXXX01_servername117

s_hostname=servername117

s_domainname=domain.com

s_cphost=servername116

s_webhost=servername117

s_config_home=/p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername117

s_inst_base=/p01/XXXXXXX01/appl/erpapp

s_display=servername117:1.0

s_forms-c4ws_display=servername117:0.0

s_ohs_instance=EBS_web_XXXXXXX01_OHS2

s_webport=8001

s_http_listen_parameter=8001

s_https_listen_parameter=4444

[Services To be Enabled on the Secondary Application Tier Node]

s_web_applications_status=enabled

s_web_entry_status=enabled

s_apcstatus=enabled

s_root_status=enabled

s_batch_status=enabled

s_other_service_group_status=enabled

s_adminserverstatus=disabled

s_web_admin_status=disabled

Add the Entry:

patch_s_port_pool=3

Run Add Node in all Secondary Nodes:

Make sure env is not Sourced

echo $TWO_TASK

cd /p01/XXXXXXX01/appl/erpapp/fs1/EBSapps/comn/clone/bin

./adclonectx.pl addnode contextfile=/p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/appl/admin/XXXXXXX01_servername116.xml pairsfile=/p01/XXXXXXX01/appl/erpapp/pair_files/26Apl2017/XXXXXXX01_servername117_run.txt outfile=/p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername117/appl/admin/XXXXXXX01_servername117.xml dualfs=yes

Follow similar steps in Rest of the Application Nodes

.xml Changes in all Application Nodes:

Once completed. Make nessasary changes in the Context file of both Run/Patch Filesystem in All Nodes followed by Autoconfig on all Nodes.

For Run:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start

egrep -i 's_javamailer_imaphost|s_javamailer_imapdomainname|s_javamailer_reply_to|s_javamailer_imap_user' $CONTEXT_FILE

For Patch:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env patch

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start forcepatchfs

egrep -i 's_javamailer_imaphost|s_javamailer_imapdomainname|s_javamailer_reply_to|s_javamailer_imap_user' $CONTEXT_FILE

Start Services in all the Application Nodes and Perform Full Sanity before proceeding with further steps

POST CLONE STEPS:

Modify DBA Directories:

col directory_path for a100

set pages 1000 lines 150

select directory_name,directory_path from dba_directories;

update dir$ set OS_PATH=replace(OS_PATH,'&OLD_VALUE','&NEW_VALUE') where OS_PATH like '%&OLD_VALUE%';

And verifiy once Directories are Upadated….Need to check Physical exixtence of Path Also.

Change Passwords:

Start Admin Server of Run and Patch Filesystems:

For Run:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start

For Patch:

. /p01/XXXXXXX01/appl/erpapp/EBSapps.env patch

cd $ADMIN_SCRIPTS_HOME

adadminsrvctl.sh start forcepatchfs

All Passwords are placed in /p01/XXXXXXX01/appl/erpapp/.postclone Location

Change Passwords of Sys and System

sqlplus '/as sysdba'

alter user sys identified by manager;

alter user system identified by manager;

FNDCPASS apps/exaoq01nucl3r 0 Y system/manager SYSTEM APPLSYS exaoq01nucl3r

Execute the following predefined scripts

exec_FNDCPASS_custom.sh --- For Custom User Password change

exec_FNDCPASS_std.sh --- For Standard User Password change

exec_ALTER_cust.sql --- For Custom Schema Password change (from db user)

Login to Weblogic Console:

Run:

http://servername116.domain.com:7002/console

Follow the below Steps to change apps password in Weblogic Console:

Click Lock & Edit in Change Center

In the Domain Structure tree, expand Services, then select Data Sources

On the “Summary of JDBC Data Sources” page, select EBSDataSource

On the “Settings for EBSDataSource” page, select the Connection Pool tab.

Enter the new password in the “Password” field.

Enter the new password in the “Confirm Password” field.

Click Save.

Click Activate Changes in Change Center.

Then go to OAEADatasource

In the Domain Structure tree, expand Services, then select Data Sources.

On the “Summary of JDBC Data Sources” page, select OAEADatasource

On the “Settings for EBSDataSource” page, select the Connection Pool tab.

Enter the new password in the “Password” field.

Enter the new password in the “Confirm Password” field.

Click Save.

Click Activate Changes in Change Center.

Follow the Same for Patch Filesystem:

http://servername116.domain.com:7004/console

Run Instance Specific scripts:

postclone_std.sql --- Post Clone Script

instance_spec_prof.sql --- Post Clone Script

update applsys.fnd_profile_option_values set profile_option_value='GE NUCLEAR EXA Instance - XXXXXXX01 - Cloned @ '||sysdate where profile_option_id='125';

SELECT value FROM XDO_CONFIG_VALUES WHERE property_code = 'SYSTEM_TEMP_DIR';

VALUE

--------------------------------------------------------------------------------

/p01/XXXXXXX01/temp/tmpfiles

update XDO_CONFIG_VALUES set value='/p01/servername01/temp/tmpfiles' WHERE property_code = 'SYSTEM_TEMP_DIR';

SELECT NAME ,DISPLAY_NAME FROM WF_SYSTEMS;

NAME DISPLAY_NAME

--------------------------------------------------------------------------------

XXXXXXX01.DOMAIN.COM XXXXXXX01.DOMAIN.COM

update WF_SYSTEMS set DISPLAY_NAME='XXXXXX01.DOMAIN.COM' where DISPLAY_NAME='XXXXXX01.DOMAIN.COM';

Update Profile Option Values:

We need to update profiles to Target which are pointing to Source

Query to Check:

select a.profile_option_name, b.profile_option_value, a.profile_option_id, a.application_id

from fnd_profile_options a, fnd_profile_option_values b

where a.application_id = b.application_id

and a.profile_option_id = b.profile_option_id

and b.profile_option_value like '%&profile%';

Check with sid,SID,hostname and bigip

Query to Update:

update apps.fnd_profile_option_values set profile_option_value=replace(profile_option_value,'&OLD_VALUE','&NEW_VALUE')

where profile_option_value like '%&OLD_VALUE%';

Softlinks:

cd $APPL_TOP/geps

find . -type l -exec ls -ls '{}' \; |grep -i "fndcpesr" |awk '{print "ls -ltr "$(NF-2)}'

– to check links

find . -type l -exec ls -ls '{}' \; |grep -i "fndcpesr" |awk '{print "ln -s $FND_TOP/bin/fndcpesr "$(NF-2)}

- to make links

find . -type l -exec ls -ls '{}' \; |grep -i "fndcpesr" |awk '{print "rm -f "$(NF-2)}'

– to remove the links

Once completed, give full permissions to geps directory:

chmod -R 777 $APPL_TOP/geps

Re-Create DB Links

To check the existing DB-Links:

set pages 2000

set lines 200

col OWNER for a10

col DB_LINK for a35

col USERNAME for a20

col HOST for a40

select OWNER, DB_LINK, USERNAME, HOST, CREATED from dba_db_links order by created desc;

To drop the DB-Links:

drop database link APPS_DOMAIN.COM;

Re-Create the DB-Links using:

CREATE DATABASE LINK JS1_TO_JO1.DOMAIN.COM CONNECT TO GEPSREADONLY IDENTIFIED BY gepsreadonly123 USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pwerpl0596dv01.cloud.domain.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=gpspgjo1)(INSTANCE_NAME=gpspgjo1)))';

Validate:

select name from v$database@JS1_TO_JO1.DOMAIN.COM;

mkdir $NE_BASE/sso

cd $NE_BASE/sso

wget --no-check-certificate https://oamsso.com/downloads/webgate.zip

wget --no-check-certificate https://oamsso.com/downloads/oamreg_linux.zip

unzip webgate.zip -d webgate

unzip oamreg_linux.zip

./oamreg_linux XXXXXXX01 stage <apps Password> undeployag --- on servername116

./oamreg_linux XXXXXXX01 stage <apps Password> dereg -- on servername116 and servername117

./oamreg_linux XXXXXXX01 stage <apps Password> dmzdereg -- on servername118 and servername119

./oamreg_linux XXXXXXX01 stage <apps Password> deployag node1 -- -- on servername116

./oamreg_linux XXXXXXX01 stage <apps Password> deployag node2 -- -- on servername117

./oamreg_linux XXXXXXX01 stage <apps Password> deployag node3 -- -- on servername118

./oamreg_linux XXXXXXX01 stage <apps Password> deployag node4 -- -- on servername119

./oamreg_linux XXXXXXX01 stage <apps Password> reg -- on servername116 and servername117

./oamreg_linux XXXXXXX01 stage <apps Password> dmzreg -- on servername118 and servername119

Once completed run autoconfig on Primary Node

Modify mod_wl_ohs.conf

Edit the mod_wl_ohs.conf File as per the Instance:

cd $FMW_HOME/webtier/instances/EBS_web_XXXXXXX01_OHS1/config/OHS/EBS_web_XXXXXXX01

cp mod_wl_ohs.conf mod_wl_ohs.conf-original

vi mod_wl_ohs.conf

Give the entires of both the nodes in all the Components:

Example:

Before

SetHandler weblogic-handler

WLCookieName JsessionIDForms

WebLogicCluster servername116.domain.com:7402

WLTempDir ${ORACLE_INSTANCE}/tmp

</Location>

After

SetHandler weblogic-handler

WLCookieName JsessionIDForms

WebLogicCluster servername116.domain.com:7402,servername117.domain.com:7402

WLTempDir ${ORACLE_INSTANCE}/tmp

</Location>

Extranet Setup

Login as Primary Node and run the below scripts : -

sqlplus apps/********

SQL> @$FND_TOP/patch/115/sql/txkChangeProfH.sql SERVRESP

Changing the hierarchy type for the Profile APPS_WEB_AGENT

Profile APPS_WEB_AGENT hierarchy type has been