12.2 Manual Clone – XXXXXXX01
– Multi Node
Index
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
|
|
Incomplete
|
Release the Instance to the Business
|
Incomplete
|
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
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
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
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 &
cd $ADMIN_SCRIPTPS_HOME
perl adpreclone.pl
appsTier
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 Mail in the below Format:
on all WebNodes:
cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/********
On Primary Node:
cd $ADMIN_SCRIPTS_HOME
adstpall.sh
apps/********
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
cd /p01/XXXXXXX01/appl/erpapp
rm -rf fs1 &
rm -rf fs2 &
rm -rf fs_ne &
rm -rf oraInventory &
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;
On Node1:
cd $ORACLE_HOME/..
rm -rf 11.2.0.4 &
On Node2:
cd $ORACLE_HOME/..
rm -rf 11.2.0.4 &
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 &
cd /p01/XXXXXXX01/appl/erpapp/fs1
nohup gunzip -c /p01/XXXXXXX01/appl/EBSapps.tar.gz |tar
-xvf - > /p01/XXXXXXX01/appl/EBSapps.log &
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
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
0
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
Copyright (c) 2011 Oracle
Corporation
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 ...
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
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
0
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
Copyright (c) 2011 Oracle
Corporation
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) [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
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;
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
0
make
-f ins_rdbms.mk rac_on
make
-f ins_rdbms.mk ioracle
ar
-t libknlopt.a | grep -c kcsm.o
1
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
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
<scanUpdateFlag oa_var="s_update_scan">TRUE</scanUpdateFlag>
cd $ORACLE_HOME/appsutil/bin
adconfig.sh
Repeat the Same in Second Node:
grep -i s_update_scan $CONTEXT_FILE
<scanUpdateFlag
oa_var="s_update_scan">TRUE</scanUpdateFlag>
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.
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
Copyright (c) 2002, 2015
Oracle Corporation
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
<Apr
25, 2017 12:02:07 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
<Apr
25, 2017 12:02:07 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
<Apr
25, 2017 12:02:07 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
Configuring:
Patch file system....
LogFile
located at /p01/XXXXXXX01/appl/erpapp/fs1/inst/apps/XXXXXXX01_servername116/admin/log/clone/patch/RCloneApplyAppstier_04250002.log
<Apr
25, 2017 1:46:58 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
<Apr
25, 2017 1:46:58 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
<Apr
25, 2017 1:46:58 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
<Apr
25, 2017 1:46:58 AM EDT> <Warning> <JNDI> <BEA-050001>
<WLContext.close() was called in a different thread than the one in which it
was created.>
Do
you want to startup the Application Services for XXXXXXX01? (y/n) [n] : n
Services
not started
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
egrep
-i
's_webentryurlprotocol|s_webentryhost|s_webentrydomain|s_active_webport|s_login_page|s_external_url|s_endUserMonitoringURL'
$CONTEXT_FILE
egrep
-i
's_dbport|s_dbhost|s_applcsf|s_appltmp|s_applptmp|s_apps_jdbc_connect_descriptor'
$CONTEXT_FILE
egrep
-i
's_admin_ui_access_nodes|s_oacore_nodes|s_forms_nodes|s_oafm_nodes|s_forms-c4ws_nodes|s_oaea_nodes'
$CONTEXT_FILE
egrep
-i 's_appldcp|s_concstatus|s_cp_twotask|s_isConc|s_isConcDev|s_isAdmin'
$CONTEXT_FILE
appXXXXXXX01@servername116(admin)$
egrep -i 's_javamailer_imaphost|s_javamailer_imapdomainname|s_javamailer_reply_to|s_javamailer_imap_user'
$CONTEXT_FILE
<hostname
oa_var="s_javamailer_imaphost"
customized="yes">mail</hostname>
<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>
appXXXXXXX01@servername116(admin)$
egrep -i
's_webentryurlprotocol|s_webentryhost|s_webentrydomain|s_active_webport|s_login_page|s_external_url|s_endUserMonitoringURL'
$CONTEXT_FILE
<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>
<activewebport
oa_var="s_active_webport" oa_type="DUP_PORT"
base="8000" step="1" range="-1"
label="Active Web Port">443</activewebport>
appXXXXXXX01@servername116(admin)$
egrep -i 's_dbport|s_dbhost|s_applcsf|s_appltmp|s_applptmp|s_apps_jdbc_connect_descriptor'
$CONTEXT_FILE
<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>
<dbport oa_var="s_dbport"
oa_type="EXT_PORT" base="1521" step="1"
range="-1" label="Database Port">1521</dbport>
appXXXXXXX01@servername116(admin)$
egrep -i 's_admin_ui_access_nodes|s_oacore_nodes|s_forms_nodes|s_oafm_nodes|s_forms-c4ws_nodes|s_oaea_nodes'
$CONTEXT_FILE
<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>
appXXXXXXX01@servername116(admin)$
egrep -i 's_appldcp|s_concstatus|s_cp_twotask|s_isConc|s_isConcDev|s_isAdmin'
$CONTEXT_FILE
<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>
<APPLDCP
oa_var="s_appldcp">ON</APPLDCP>
<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
Run Pre-Clone in Run FileSystem:
cd $COMMON_TOP
mv clone clone_bkp
cd $ADMIN_SCRIPTS_HOME
perl adpreclone.pl
appsTier
·
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
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
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
egrep
-i
's_webentryurlprotocol|s_webentryhost|s_webentrydomain|s_active_webport|s_login_page|s_external_url|s_endUserMonitoringURL'
$CONTEXT_FILE
egrep
-i
's_dbport|s_dbhost|s_applcsf|s_appltmp|s_applptmp|s_apps_jdbc_connect_descriptor'
$CONTEXT_FILE
egrep
-i
's_admin_ui_access_nodes|s_oacore_nodes|s_forms_nodes|s_oafm_nodes|s_forms-c4ws_nodes|s_oaea_nodes'
$CONTEXT_FILE
egrep
-i 's_appldcp|s_concstatus|s_cp_twotask|s_isConc|s_isConcDev|s_isAdmin'
$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
egrep
-i
's_webentryurlprotocol|s_webentryhost|s_webentrydomain|s_active_webport|s_login_page|s_external_url|s_endUserMonitoringURL'
$CONTEXT_FILE
egrep
-i 's_dbport|s_dbhost|s_applcsf|s_appltmp|s_applptmp|s_apps_jdbc_connect_descriptor'
$CONTEXT_FILE
egrep
-i
's_admin_ui_access_nodes|s_oacore_nodes|s_forms_nodes|s_oafm_nodes|s_forms-c4ws_nodes|s_oaea_nodes'
$CONTEXT_FILE
egrep
-i 's_appldcp|s_concstatus|s_cp_twotask|s_isConc|s_isConcDev|s_isAdmin'
$CONTEXT_FILE
Start Services in all the Application Nodes and Perform Full Sanity before
proceeding with further steps
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.
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
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';
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%';
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
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
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
<Location /forms>
SetHandler weblogic-handler
WLCookieName JsessionIDForms
WebLogicCluster servername116.domain.com:7402
WLTempDir ${ORACLE_INSTANCE}/tmp
</Location>
After
<Location /forms>
SetHandler weblogic-handler
WLCookieName JsessionIDForms
WebLogicCluster servername116.domain.com:7402,servername117.domain.com:7402
WLTempDir ${ORACLE_INSTANCE}/tmp
</Location>
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
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
APPS_SERVLET_AGENT
Profile
APPS_SERVLET_AGENT hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
APPS_JSP_AGENT
Profile
APPS_JSP_AGENT hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
APPS_FRAMEWORK_AGENT
Profile
APPS_FRAMEWORK_AGENT hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
ICX_FORMS_LAUNCHER
Profile
ICX_FORMS_LAUNCHER hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
ICX_DISCOVERER_LAUNCHER
Profile
ICX_DISCOVERER_LAUNCHER hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
ICX_DISCOVERER_VIEWER_LAUNCHER
Profile
ICX_DISCOVERER_VIEWER_LAUNCHER hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
HELP_WEB_AGENT
Profile
HELP_WEB_AGENT hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
APPS_PORTAL
Profile
APPS_PORTAL hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
CZ_UIMGR_URL
Profile
CZ_UIMGR_URL hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
QP_PRICING_ENGINE_URL
Profile
QP_PRICING_ENGINE_URL hierarchy type has been
successfully
changed to SERVRESP
Changing
the hierarchy type for the Profile
TCF:HOST
Profile
TCF:HOST hierarchy type has been
successfully
changed to SERVRESP
Disconnected
from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With
the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data
Mining and Real Application Testing options
appXXXXXXX01@servername116(geps)$
Update Node Trust Level
To change the value of the Node Trust Level profile option value to
External for a particular node, perform the following steps:
·
Login to
Oracle E-Business Suite as sysadmin user using the internal URL
·
Select
the System Administrator Responsibility
·
Select
Profile / System
·
From the
'Find system profile option Values' window, select the server that you want to
designate as the external web tier
·
Query for
%NODE%TRUST%. You will see a profile option named 'Node Trust Level'. The value
for this profile option at the site level will be Normal. Leave this setting
unchanged.
·
Set the
value of this profile option to External at the server level. The site level
value should remain set to Normal
Record the output of:
select node_name,server_id from fnd_nodes where
support_web='Y';
Perform the below:
cd $FMW_HOME/Oracle_EBS-app1/deployment_plans/accessgate
cp plan.xml plan.xml.original
rm plan.xml
Go to each application tier node and do this
Login as applmgr
mkdir $HOME/.sso
cd $FMW_HOME/Oracle_EBS-app1/deployment_plans/accessgate
cp plan.xml.original $HOME/.sso/plan.xml
ln -s $HOME/.sso/plan.xml plan.xml
vi $HOME/.sso/plan.xml
Search for string APPL_SERVER_ID
<name>app_APPL_SERVER_ID</name>
<value>081877EC50246AE0E053823D2F03371136087014321141155826551352395400</value>
Replace the value of APPL_SERVER_ID with the server_id value from fnd_nodes
From servername116:
cp customXXXXXXX01_servername116.env $INST_TOP/appl/admin
From servername117:
cp customXXXXXXX01_servername117.env $INST_TOP/appl/admin
Run autoconfig on extranet and then on intranet
Run autoconfig on extranet tier 1
Run autoconfig on extranet tier 2
Run autoconfig on intranet tier 2
Run autoconfig on intranet tier 1
Start all services on intranet tier and Extranet.
cd $INST_TOP/appl/admin
ls -ltr *.env
. ./customXXXXXXX01_servername116.env
cd $INST_TOP/admin/install
grep -i mwa.telnetportnumber mwa.cfg
mwa.TelnetPortNumber=10206,10208,10210
cd $INST_TOP/admin/scripts
ls -ltr mwactl.sh
./mwactl.sh start 10206
./mwactl.sh start 10208
./mwactl.sh start 10210
ps -fu $LOGNAME|grep -i mwa
