******* Rafi ORACLE DBA & APPS DBA Blog*******: Step by Step Oracle Applications and Database Cloning for Oracle EBS 12.2 Environment

Monday, August 20, 2018

Step by Step Oracle Applications and Database Cloning for Oracle EBS 12.2 Environment

Hi All,

Cloning of Oracle ERP Database and Applications for Oracle EBS 12.2 ( 12.2.x) can be done in several ways. Below I have described one such scenario. Based on the backup policy and customization you have for your Oracle EBS Environment steps might vary . Here I just documented based on my experiences.

Source :ERP122_Source

DB node:source_db_host
App node:source_apps_host

Target :erp1226

DB node:target_db_host
App node:target_apps_host

Step 1: Running Pre-clone on the Source Apps Tier(ERP122_Source)

To prepare the source environment for cloning we need to run adpreclone.pl script.

cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier

apps:welcome1
weblogic:welcome1

Log file located at /erpapp/ERP122_Source/upgrade/fs1/inst/apps/ERP122_Source_uat-

cm2/admin/log/clone/StageAppsTier_02041740.log

\ 20% completed

Completed Stage...

END: Calling StagefmwTechStack...

#############################################################

END: StageAppsTier Finished at Thu Feb 04 18:14:16 GST 2018
Status: Completed Successfully
#############################################################

Step 2: Running Pre-Clone on the Source DB Tier

To prepare the source environment for cloning we need to run adpreclone.pl script.

cd /u01/ERP122_Source/db/dbhome_1/appsutil/scripts/ERP122_Source_host

perl adpreclone.pl dbTier

Log file located at /u01/ERP122_Source/db/dbhome_1/appsutil/log/ERP122_Source_host/StageDBTier_02041853.log

/ 50% completed

Completed Stage...
Thu Feb 4 18:55:58 2018

Step 3: Copying Application Tier from Source to Target

WHAT NEEDS TO BE COPIED
----------------------------
Choose only RUN FILE SYSTEM for copying

Copy EBSapps directory from source(ERP122_Source) to target(erp1226) (no need to copy FMW_Home and inst Directories)

a) EBSapps =>COPY

On Source(ERP122_Source): Take tar backup of EBSapps

cd /erpapp/ERP122_Source/upgrade/fs1
tar -cvf /u04/ERP122_Source/apps/EBSapps.tar

b) FMW_HOME =>DON'T COPY
c) inst =>DON'T COPY

Prepare Target:(erp1226 : 12.2.5)
=========================================

cd /erpapp/
applmgr@orace_erp_host:~$ mkdir erp1226

mkdir -p /erpapp/erp1226/fs1/
mkdir -p /erpapp/erp1226/fs2/
mkdir -p /erpapp/erp1226/fs_ne/

Step 4:Copy the Oracle Home from source(ERP122_Source) to target(erp1226):

Step a:Create Required directory structures on target with 'oracle' ownership and permissions

root@host:~# mkdir -p /u01/erp1226/db
chown -R oracle:oinstall /u01/erp1226/db

Step b: Take tar backup on ERP122_Source(Source Environment)

cd /u01/ERP122_Source/db
tar -cvf /u04/ERP122_Source/db/dbhome_1.tar dbhome_1 &

drwxr-xr-x 82 oracle oinstall 87 Jan 18 10:32 dbhome_1
-rw-r--r-- 1 oracle oinstall 3711308097 Jan 18 17:36 dbhome_1.tar.gz

Step 5:On Target: Extract and give required permissions.

APPS:
======
cd /erpapp/erp1226/fs1
tar -xvf /u04/ERP122_Source/apps/EBSapps.tar

DB:
====
cd /u01/erp1226/db
tar -xvf /u04/ERP122_Source/db/dbhome_1.tar

After extracting DB home please give the required permisssion VVIMP

root@host:~# cd /u01/erp1226/db/dbhome_1/bin
root@host:/u01/erp1226/db/dbhome_1/bin# chmod 6751 oracle
root@host:/u01/erp1226/db/dbhome_1/bin# ls -l oracle
-rwsr-s--x 1 oracle oinstall 258934216 Jan 31 12:51 oracle
root@host:/u01/erp1226/db/dbhome_1/bin#

$ perl adcfgclone.pl dbTechStack

first source perl
--------------------

export

PERL5LIB=/u01/erp1226/db/dbhome_1/perl/lib/5.10.0:/u01/erp1226/db/dbhome_1/perl/lib/site_perl/5.10.0:/u01/erp1226/db/dbhom

e_1/appsutil/perl
export

PATH=/u01/erp1226/db/dbhome_1/perl/bin:/u01/erp1226/db/dbhome_1/perl/bin:/u01/erp1226/db/dbhome_1/bin:/usr/ccs/bin:/usr/sb

in:/u01/erp1226/db/dbhome_1/jdk/jre/bin:/usr/bin:/bin:.:.
export ADPERLPRG=/u01/erp1226/db/dbhome_1/perl/bin/perl

support id: 458653.1 OUICLI.PL Fail while running adcfgclone
-------------------------------------------------------------

Note:Take oraInst.loc backup

I created oraInventory directory in $ORACLE_HOME and updated new location in oraInst.loc and the issue resolved.

-bash-4.1$ cd $ORACLE_HOME
-bash-4.1$ pwd
/u01/erp1226/db/dbhome_1
-bash-4.1$ mkdir oraInventory
-bash-4.1$ cd oraInventory
-bash-4.1$ pwd
/u01/erp1226/db/dbhome_1/oraInventory

-bash-4.1$ mv oraInst.loc oraInst.loc.org (backup oraInst.loc.org)

-bash-4.1$ vi oraInst.loc
-bash-4.1$ cat $ORACLE_HOME/oraInst.loc
inventory_loc=/u01/erp1226/db/dbhome_1/oraInventory
inst_group=oinstall

Step 6: Execute adcfgclone with tech_st for configuring Technology stack on Target DB Tier

/u01/erp1226/db/dbhome_1/appsutil/clone/bin

export

PERL5LIB=/u01/erp1226/db/dbhome_1/perl/lib/5.10.0:/u01/erp1226/db/dbhome_1/perl/lib/site_perl/5.10.0:/u01/erp1226/db/dbhom

e_1/appsutil/perl

perl adcfgclone.pl dbTechStack

practical
=============
(Eg:export

PERL5LIB=/u01/erp1223/db/dbhome_1/perl/lib/5.10.0:/u01/erp1223/db/dbhome_1/perl/lib/site_perl/5.10.0:/u01/erp1223/db/dbhom

e_1/appsutil/perl)

On Target set the perl path:

export

PERL5LIB=/u01/erp1226/db/dbhome_1/perl/lib/5.10.0:/u01/erp1226/db/dbhome_1/perl/lib/site_perl/5.10.0:/u01/erp1226/db/dbhom

e_1/appsutil/perl

-bash-4.1$ perl adcfgclone.pl dbTechStack

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 :

Running: Context clone...

Log file located at /u01/erp1226/db/dbhome_1/appsutil/clone/bin/CloneContext_0204213607.log

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

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

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

Target System Database SID : erp1226

Target System Base Directory : /u01/erp1226/

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 : /u04/erp1226

Target System RDBMS ORACLE_HOME Directory [/u01/erp1226/db/11.2.0] : /u01/erp1226/db/dbhome_1

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

Target System Port Pool [0-99] : 20

Checking the port pool 6
done: Port Pool 6 is free
Report file located at /u01/erp1226/db/dbhome_1/appsutil/temp/portpool.lst
The new database context file has been created :
/u01/erp1226/db/dbhome_1/appsutil/erp1226_host.xml
Check Clone Context logfile /u01/erp1226/db/dbhome_1/appsutil/clone/bin/CloneContext_0204213607.log for details.

Running Rapid Clone with command:

Running:
perl /u01/erp1226/db/dbhome_1/appsutil/clone/bin/adclone.pl java=/u01/erp1226/db/dbhome_1/appsutil/clone/bin/../jre

mode=apply stage=/u01/erp1226/db/dbhome_1/appsutil/clone component=dbTechStack method=CUSTOM

dbctxtg=/u01/erp1226/db/dbhome_1/appsutil/erp1226_host.xml showProgress contextValidated=true

Beginning rdbms home Apply - Thu Feb 4 21:40:11 2018

/u01/erp1226/db/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -

Doracle.installer.oui_loc=/u01/erp1226/db/dbhome_1/oui -classpath

/u01/erp1226/db/dbhome_1/appsutil/clone/jlib/xmlparserv2.jar:/u01/erp1226/db/dbhome_1/appsutil/clone/jlib/ojdbc6.jar:/u01/

erp1226/db/dbhome_1/appsutil/clone/jlib/java:/u01/erp1226/db/dbhome_1/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/erp122

6/db/dbhome_1/appsutil/clone/jlib/oui/ewt3.jar:/u01/erp1226/db/dbhome_1/appsutil/clone/jlib/oui/share.jar:/u01/erp1226/db/

dbhome_1/appsutil/clone/jlib/oui/srvm.jar:/u01/erp1226/db/dbhome_1/appsutil/clone/jlib/ojmisc.jar

oracle.apps.ad.clone.ApplyDBTechStack -e /u01/erp1226/db/dbhome_1/appsutil/erp1226_host.xml -stage

/u01/erp1226/db/dbhome_1/appsutil/clone -showProgress
APPS Password : Log file located at /u01/erp1226/db/dbhome_1/appsutil/log/erp1226_host/ApplyDBTechStack_02042140.log
| 0% completed

Cloning of Database:
===========================
We can use various techniques for cloning depending on the backup policy and availability of Database.
Here I have discussed few approaches. Please follow your own approach depending on backup you have.

Step 7 a:Backup Database:(ERP122_Source)
===========================

run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
allocate channel ch6 device type disk;
backup as copy database format '/u04/ERP122_Source/db/data/%b';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
}

Note:For inventory issue:ETCC issue:
====
Download the patch 17537119 and Apply

Step 1:
-bash-4.1$ . erp1226_host.env
-bash-4.1$ cd /u01/erp1226/db/dbhome_1/appsutil/
-bash-4.1$ mkdir etcc
-bash-4.1$ cd etcc/
-bash-4.1$ pwd
/u01/erp1226/db/dbhome_1/appsutil/etcc

Step 2:
cd /export/home/oracle/DBA/1225_Patches/

mkdir 17537119

unzip p17537119.zip

-bash-4.1$ ls -ltr
total 1923
-rwxrwxrwx 1 oracle oinstall 37060 Feb 1 15:53 checkDBpatch.sh
-rwxrwxrwx 1 oracle oinstall 34675 Feb 1 15:56 txk_R1220_MT_base_bugs.xml
-rwxrwxrwx 1 oracle oinstall 275560 Feb 1 16:21 txk_R1220_DB_mappings.xml
-rwxrwxrwx 1 oracle oinstall 228911 Feb 1 16:31 txk_R1220_MT_mappings.xml
-rwxrwxrwx 1 oracle oinstall 45408 Feb 1 17:04 checkMTpatch.cmd
-rwxrwxrwx 1 oracle oinstall 41856 Feb 1 17:28 checkMTpatch.sh
-rwxrwxrwx 1 oracle oinstall 25103 Feb 1 19:14 txk_R1220_DB_base_bugs.xml
-rw-r--r-- 1 oracle oinstall 23546 Feb 1 19:39 README.txt
-rwxrwxrwx 1 oracle oinstall 40266 Feb 2 13:08 checkDBpatch.cmd
-rw-r--r-- 1 oracle oinstall 70609 Feb 5 13:28 p17537119_R12_GENERIC.zip
-bash-4.1$ pwd
/export/home/oracle/DBA/1225_Patches/17537119

Step 3:

-bash-4.1$ cp *.* /u01/erp1226/db/dbhome_1/appsutil/etcc
-bash-4.1$ cd /u01/erp1226/db/dbhome_1/appsutil/etcc
-bash-4.1$

step 4:Execute checkdbpatch.sh

-bash-4.1$ ./checkDBpatch.sh

+===============================================================+
| Copyright (c) 2005, 2018 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+

Using context file from currently set database environment:
/u01/erp1226/db/dbhome_1/appsutil/erp1226_host.xml

Starting Database EBS Technology Codelevel Checker, Version 120.31
Fri Feb 5 15:40:05 GST 2018
Log file for this session : ./checkDBpatch_25691.log

Bugfix XML file version: 120.0.12020000.28
This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.1
This file will be used for mapping bugfixes to patches.

Identifying database release.
Database release set to 11.2.0.4.

Connecting to database.

on 170 DB node:
==========

Verify the backup location :(/u04/ERP122_Source/db/data)

/u04/ERP122_Source/db/onlinelog

mkdir -p /u04/ERP122_Source/db/onlinelog

-bash-4.1$ cp initERP122_Source.ora initERP122_Source.ora
-bash-4.1$ ps -ef|grep smno
oracle 5639 20586 0 15:57:39 pts/8 0:00 grep smno
-bash-4.1$ ps -ef|grep smon
oracle 16818 16642 0 Jan 06 ? 2:27 ora_smon_obieedb
grid 17823 5568 0 Jan 06 ? 1:22 asm_smon_+ASM
oracle 16301 17091 0 Feb 03 ? 4:54 ora_smon_erp1223
oracle 5759 20586 0 15:57:42 pts/8 0:00 grep smon
oracle 13428 13320 0 Feb 03 ? 6:09 ora_smon_erp1224
-bash-4.1$ pwd
/u01/erp1226/db/dbhome_1/dbs
-bash-4.1$ export ORACLE_SID=ERP122_Source

-bash-4.1$ du -sh .
2.1T .

Note: IN SOURCE ENV:
===================

-bash-4.1$ . ERP122_Source_host.env

-bash-4.1$ pwd
/export/home/oracle
-bash-4.1$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 5 16:39:55 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size 2194184 bytes
Variable Size 5570036984 bytes
Database Buffers 2.0804E+10 bytes
Redo Buffers 355704832 bytes
Database mounted.
Database opened.
SQL> select name from v$database;

NAME
---------
ERP122_Source

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

once copy archives and than shut down ERP122_Source(source)

SQL> shut immediate

create archivelog destination and copy archives

mkdir -p /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05

Login as 'grid' os user and do below:

chmod -R 777 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05

Eg:
===

cp thread_1_seq_1425.13277.902885815 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1426.13275.902889561 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1427.13273.902892401 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1428.13267.902894711 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1429.13265.902894727 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1430.13263.902894743 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05
cp thread_1_seq_1431.13261.902894755 /u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05

SQL> startup nomount pfile='/u01/erp1226/db/dbhome_1/dbs/initERP122_Source.ora'
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size 2194184 bytes
Variable Size 3221226744 bytes
Database Buffers 2.3153E+10 bytes
Redo Buffers 355704832 bytes
SQL> show parameter db_recover%

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
/u04/ERP122_Source/db/data/erp122
5/archivelog
db_recovery_file_dest_size big integer
2000G
SQL> alter database mount;

Database altered.

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u04/ERP122_Source/db/data/contro
l1.dbf, /u04/ERP122_Source/db/dat
a/control2.dbf
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-4.1$ echo $ORACLE_SID
ERP122_Source
-bash-4.1$ rman target /

RMAN> recover database;

Starting recover at 05-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5429 device type=DISK

starting media recovery

RMAN-08187: WARNING: media recovery until scN 9814470450787 complete
Finished recover at 05-FEB-16

SQL> recover database using backup controlfile;
ORA-00279: change 9814470450787 generated at 02/04/2018 21:30:22 needed for
thread 1
ORA-00289: suggestion :
/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/o1_mf_1
_1559_%u_.arc
ORA-00280: change 9814470450787 for thread 1 is in sequence #1559

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

NAME
---------
ERP122_Source

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u04/ERP122_Source/db/data/contro
l1.dbf, /u04/ERP122_Source/db/dat
a/control2.dbf
SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-4.1$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 17:49:55 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ERP122_Source (DBID=3882746714, not open)

RMAN> recover database;

Starting recover at 05-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5429 device type=DISK

starting media recovery

archived log for thread 1 with sequence 1559 is already on disk as file

/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1559.12972.903026451
archived log for thread 1 with sequence 1560 is already on disk as file

/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1560.12971.903026455
archived log file

name=/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1559.12972.90302

6451 thread=1 sequence=1559
archived log file

name=/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1560.12971.90302

6455 thread=1 sequence=1560
RMAN-08187: WARNING: media recovery until scN 9814470462883 complete
archived log file

name=/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1560.12971.90302

6455 thread=1 sequence=1561
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/05/2018 17:50:35
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile

'/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05/thread_1_seq_1560.12971.903026455

'
ORA-00283: recovery session canceled due to errors
ORA-01112: media recovery not started
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1561 and starting scN of

9814470462883

RMAN> exit

Recovery Manager complete.
-bash-4.1$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 5 17:50:56 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
ERP122_Source

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open resetlogs;

Database altered.

-bash-4.1$ cd /u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05
-bash-4.1$ ls -l *1559*
*1559*: No such file or directory
-bash-4.1$ pwd
/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05
-bash-4.1$ ls -ltr
total 0
-bash-4.1$ pwd
/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05
-bash-4.1$ cd /u04/ERP122_Source/db/data/ERP122_Source/archivelog
-bash-4.1$ ls

Original defined:
================

/u04/ERP122_Source/db/data/ERP122_Source/archivelog/2018_02_05

As per recommendation:

/u04/ERP122_Source/db/data/ERP122_Source/archivelog/ERP122_Source/archivelog/2018_02_05

NOW bring up the database as erp1226:
------------------------------------

alter database backup controlfile to trace as '/export/home/oracle/CLONE_erp1226/trace_cont_05Feb2018_u04_up_trc';

shut immediate the ERP122_Source database which is running already.

shut immediate

SQL> select name from v$database;

NAME
---------
ERP122_Source

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> show parameter %CONTROL%

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u04/rman/01Jan2015/cnt1.db
f, /u04/rman/01Jan2015/cnt2
.dbf, /u04/rman/01Jan2015/c
nt3.dbf
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u04/rman/01Jan2015/system.272.845039815

export ORACLE_SID=erp1226

-bash-4.1$ mv initerp1226.ora initerp1226.ora_orig
-bash-4.1$ cp initERP122_Source.ora initerp1226.ora
-bash-4.1$ vi initerp1226.ora
-bash-4.1$ grep -i control_files initerp1226.ora
*.control_files='/u04/ERP122_Source/db/data/control1_erp1226.dbf','/u04/ERP122_Source/db/data/control2_erp1226.dbf'
-bash-4.1$ grep -i db_name initerp1226.ora
*.db_name='erp1226'
-bash-4.1$

b. Rename trace file to ctrl.sql
vi ctrl.sql
Change “REUSE” to “SET”
Change “ERP122_Source” to “erp1226”
Change “noresetlogs” to “resetlogs”
Change “archivelog” to “noarchivelog”

after rename cont_01Jan2015_u04_dev.sql

c. cp initERP122_Source.ora initerp1226.ora

VVIMP

Change db_name=erp1226 in initerp1226.ora
change the controlfile names in initerp1226.ora

racle@erp3client01:/u01/app/oracle/product/11.2.0/dbhome_1/dbs$ grep -i control_file initerp1226.ora
*.control_files='/u04/rman/01Jan2015/cnt_d1.dbf','/u04/rman/01Jan2015/cnt_d2.dbf','/u04/rman/01Jan2015/cnt_d3.dbf'

oracle@erp3client01:/u01/app/oracle/product/11.2.0/dbhome_1/dbs$ grep -i db_name initerp1226.ora
*.db_name='erp1226'

d. export ORACLE_SID=erp1226

(Eg controlfile erp1226
CREATE CONTROLFILE SET DATABASE "erp1226" RESETLOGS FORCE LOGGING NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 8
MAXLOGHISTORY 20157
LOGFILE
)

SQL> startup nomount pfile='/u01/erp1226/db/dbhome_1/dbs/initerp1226.ora'
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size 2194184 bytes
Variable Size 3221226744 bytes
Database Buffers 2.3153E+10 bytes
Redo Buffers 355704832 bytes
SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u04/ERP122_Source/db/data/contro
l1_erp1226.dbf, /u04/erp122
5/db/data/control2_erp1226.dbf

SQL> startup nomount pfile='/u01/erp1226/db/dbhome_1/dbs/initerp1226.ora'
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size 2194184 bytes
Variable Size 3221226744 bytes
Database Buffers 2.3153E+10 bytes
Redo Buffers 355704832 bytes
SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u04/ERP122_Source/db/data/contro
l1_erp1226.dbf, /u04/erp122
5/db/data/control2_erp1226.dbf
SQL> !pwd
/export/home/oracle/CLONE_erp1226

SQL> @cont_05Feb2018_u04_erp1226.sql

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL> select name from v$database;

NAME
---------
erp1226

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u04/ERP122_Source/db/data/contro
l1_erp1226.dbf, /u04/erp122
5/db/data/control2_erp1226.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u04/ERP122_Source/db/onlinelog/group_17.9627.902761661
/u04/ERP122_Source/db/onlinelog/group_17.9626.902761663
/u04/ERP122_Source/db/onlinelog/group_16.9629.902761653
/u04/ERP122_Source/db/onlinelog/group_16.9628.902761655
/u04/ERP122_Source/db/onlinelog/group_15.9631.90276164

e. sqlplus "/as sysdba"

startup nomount

SQL> startup nomount
ORACLE instance started.

Total System Global Area 7484866560 bytes
Fixed Size 2196112 bytes
Variable Size 1627397488 bytes
Database Buffers 5519704064 bytes
Redo Buffers 335568896 bytes
SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u04/rman/01Jan2015/cnt_dev
1.dbf, /u04/rman/01Jan2015/
cnt_dev2.dbf, /u04/rman/08D
ec2015/cnt_dev3.dbf

SQL> @contr_01Jan2015_u04_DEV.sql

Control file created.

alter database open resetlogs;

SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u04/rman/erp1226/data/contro
l_d1.dbf, /u04/rman/erp1226/d
ata/control_d2.dbf
SQL> select status from v$instance;

STATUS
------------------------------------
STARTED

SQL> @contr_dev_u04_03Jan2018.sql

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL> select name from v$database;

NAME
---------
erp1226

SQL> select status from v$instance;

STATUS
------------
OPEN

Once the Database is recovered verify the Datafiles,Redolog files.

SQL> select name from v$database;

NAME
---------
erp1226

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u04/ERP122_Source/db/onlinelog/group_17.9627.902761661
/u04/ERP122_Source/db/onlinelog/group_17.9626.902761663
/u04/ERP122_Source/db/onlinelog/group_16.9629.902761653
/u04/ERP122_Source/db/onlinelog/group_16.9628.902761655
/u04/ERP122_Source/db/onlinelog/group_15.9631.902761641
/u04/ERP122_Source/db/onlinelog/group_15.9630.902761643
/u04/ERP122_Source/db/onlinelog/group_14.9633.902761631
/u04/ERP122_Source/db/onlinelog/group_14.9632.902761631
/u04/ERP122_Source/db/onlinelog/group_13.9635.902761623
/u04/ERP122_Source/db/onlinelog/group_13.9634.902761623
/u04/ERP122_Source/db/onlinelog/group_12.9637.902761701

MEMBER
--------------------------------------------------------------------------------
/u04/ERP122_Source/db/onlinelog/group_12.9636.902761701
/u04/ERP122_Source/db/onlinelog/group_11.9639.902761589
/u04/ERP122_Source/db/onlinelog/group_11.9638.902761591

14 rows selected.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u04/ERP122_Source/db/data/system.9939.902760745
/u04/ERP122_Source/db/data/system.10052.902761115
/u04/ERP122_Source/db/data/system.9931.902761091
/u04/ERP122_Source/db/data/system.10016.902761093
/u04/ERP122_Source/db/data/system.10050.902761123
/u04/ERP122_Source/db/data/system.10007.902761093
/u04/ERP122_Source/db/data/system.10048.902761123
/u04/ERP122_Source/db/data/system.10040.902761139
/u04/ERP122_Source/db/data/system.10049.902761107
/u04/ERP122_Source/db/data/system.9998.902761021
/u04/ERP122_Source/db/data/system.10042.902761123

Create temporary tablespace and make it default.

Once the Database is recovered verify the Datafiles,Redolog files.

select member from v$logfile;
select name from v$datafile;

SQL> select * from v$tempfile;

no rows selected

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP11
TEMP8

create temporary tablespace and make it default.

select name from v$datafile;
create temporary tablespace temp12 tempfile '/u04/ERP122_Source/db/data/temp12_01.dbf' size 20g;
alter database default temporary tablespace temp12;

drop tablespace temp11 including contents and datafiles;
drop tablespace temp8 including contents and datafiles;

SQL> select PROPERTY_NAME,PROPERTY_VALUE from database_properties where property_name like '%DEFAULT%';

PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TEMP12

CREATE SPFILE:
===============

create spfile from pfile;

SQL> create spfile from pfile;

File created.

shut immediate

Migrate Database from Filesystem to ASM location:
====================================================

Startup with SPFILE

shut immediate
startup

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/erp1226/db/dbhome_1/dbs/s
pfileerp1226.ora

Migrate to ASM:
==================

ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks

Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 25165824 6296220 65536 3115342 0

N DATA/

ASMCMD> cd DATA/
ASMCMD> ls
ASM/
DB_UNKNOWN/
DEVOATS/
erp1223/
erp1224/
ERP122_Source/
UPGUAT1/
spfileerp1224.ora

ASMCMD> pwd
+DATA

ASMCMD> mkdir erp1226
ASMCMD> ls
ASM/
DB_UNKNOWN/
DEVOATS/
erp1223/
erp1224/
ERP122_Source/
erp1226/
UPGUAT1/
spfileerp1224.ora

ASMCMD> cd erp1226/
ASMCMD> pwd
+DATA/erp1226

+DATA/erp1226
ASMCMD> mkdir CONTROLFILE
ASMCMD> ls
CONTROLFILE/

B. Migrate Database from Filesystem to ASM location

Startup with SPFILE
SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/erp1226/db/dbhome_1/dbs/s
pfileerp1226.ora

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u04/ERP122_Source/db/data/contro
l1_erp1226.dbf, /u04/erp122
5/db/data/control2_erp1226.dbf

alter system set db_recovery_file_dest='+DATA';
alter system set db_create_file_dest='+DATA';

alter system set control_files='+DATA/erp1226/CONTROLFILE/ctrlerp1226_05Feb2018.dbf' scope=spfile;
SQL> show parameter control_files

SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u04/ERP122_Source/db/data/contro
l1_erp1226.dbf, /u04/erp122
5/db/data/control2_erp1226.dbf

shut immediate
startup nomount

SQL> show parameter control_files

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
+DATA/erp1226/controlfile/ctrl
erp1226_05feb2018.dbf

(WE HAVE TO DO THIS STEP AFTER DB CLONE)

(optionally workaround step

SQL> alter system set local_listener='erp1226' scope=spfile;

System altered.

SQL> shut immediate
ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 2.6732E+10 bytes
Fixed Size 2194184 bytes
Variable Size 3556771064 bytes
Database Buffers 2.2817E+10 bytes
Redo Buffers 355704832 bytes
SQL> show parameter %LOCAL%

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
local_listener string
ERP122_Source
log_archive_local_first boolean
TRUE
parallel_force_local boolean
FALSE

)

SQL> alter system register;

System altered.

-bash-4.1$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE host STABLE
ora.LISTENER.lsnr
ONLINE ONLINE host STABLE
ora.asm

)

Registering listener:
========================

-bash-4.1$ srvctl status listener -l listener
srvctl stop listener -l listener

srvctl modify listener -l listener -endpoints 1521,1596,1548,1561,1701
srvctl start listener -l listener

-bash-4.1$ srvctl status listener -l listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): host

Restore controlfile using RMAN from backup location taken earlier.

rman target /

RMAN> restore controlfile from '/u04/ERP122_Source/db/data/control1_erp1226.dbf';

-bash-4.1$ echo $ORACLE_SID
erp1226
-bash-4.1$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 5 19:17:54 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: erp1226 (not mounted)

RMAN> restore controlfile from '/u04/ERP122_Source/db/data/control1_erp1226.dbf';

Starting restore at 05-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6373 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATA/erp1226/controlfile/ctrlerp1226_05feb2018.dbf
Finished restore at 05-FEB-16

RMAN> alter database mount;

ASMCMD> cd CONTROLFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
CONTROLFILE HIGH FINE FEB 05 19:00:00 N ctrlerp1226_05feb2018.dbf =>

+DATA/erp1226/CONTROLFILE/current.3903.903035901
CONTROLFILE HIGH FINE FEB 05 19:00:00 Y current.3903.903035901
ASMCMD> pwd
+DATA/erp1226/CONTROLFILE

Note:Eg: Test with 1 datafile:
======

RMAN> backup as copy datafile 1 format '+DATA';

Starting backup at 05-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6137 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u04/ERP122_Source/db/data/system.9939.902760745
output file name=+DATA/erp1226/datafile/system.10315.903036027 tag=TAG20180205T192025 RECID=1 STAMP=903036055
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA/erp1226/controlfile/backup.10316.903036061 tag=TAG20180205T192025 RECID=2 STAMP=903036062
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 05-FEB-16
channel ORA_DISK_1: finished piece 1 at 05-FEB-16
piece handle=+DATA/erp1226/backupset/2018_02_05/nnsnf0_tag20180205t192025_0.10317.903036063 tag=TAG20180205T192025

comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-FEB-16

verify:
=========

DATAFILE/
ASMCMD> cd DATAFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE MIRROR COARSE FEB 05 19:00:00 Y SYSTEM.10315.903036027
ASMCMD> pwd
+DATA/erp1226/DATAFILE

Remove the file tested:
========================

ASMCMD> pwd
+DATA/erp1226/DATAFILE
ASMCMD> ls -ltr
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'

Type Redund Striped Time Sys Name
DATAFILE MIRROR COARSE FEB 05 19:00:00 Y SYSTEM.10315.903036027
ASMCMD> rm SYSTEM.10315.903036027
ASMCMD> pwd
+DATA/erp1226/DATAFILE
ASMCMD> cd ..
ASMCMD> pwd
+DATA/erp1226
ASMCMD> ls
BACKUPSET/
CONTROLFILE/

Now start the Migration of erp1226 Db from filesystem to ASM:
================================================================

rman target / log rman_05Feb2018.log trace rman_05Feb2018.trc debug
set echo on;
debug on;

run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
allocate channel ch6 device type disk;
allocate channel ch7 device type disk;
backup as copy database format '+DATA';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
release channel ch7;
}

RMAN> exit

rman target /

RMAN> switch database to copy;

RMAN> alter database open;

Create the temporary tablespace and make it default

create temporary tablespace temp14 tempfile '+DATA03' size 30g;
alter database default temporary tablespace temp14;

drop tablespace temp12 including contents and datafiles;

set lines 200
col member for a60
select member,group# from v$logfile;
select group#,status from v$log;

Drop the unused groups and Drop the Thread2 groups

select group#,thread#,status from v$log;
alter system switch logfile;
alter database drop logfile group 12;

select group#,thread#,status from v$log;
alter database disable thread 2;
alter database drop logfile group 13;
alter database drop logfile group 14;

Verify and add groups:
select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 ACTIVE
2 1 CURRENT
3 1 UNUSED

alter database add logfile group 1 size 500m;
alter database add logfile group 6 size 500m;
alter database add logfile group 13 size 500m;
alter system switch logfile;

Drop the inactive group

SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 INACTIVE
2 1 ACTIVE
3 1 CURRENT
4 1 UNUSED
5 1 UNUSED
6 1 UNUSED

6 rows selected.

alter database drop logfile group 1;
alter system switch logfile;

Verify 3 Redo logs Groups exists.

SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
2 1 ACTIVE
3 1 ACTIVE
4 1 CURRENT
5 1 UNUSED
6 1 UNUSED

alter database open

Check the status of Redolog files and make sure all are active

select group#,thread#,status from v$log;
SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
2 1 INACTIVE
3 1 INACTIVE
4 1 CURRENT
5 1 UNUSED
6 1 UNUSED

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
4 1 CURRENT
5 1 UNUSED
6 1 UNUSED

SQL> alter system switch logfile;

System altered.

SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
4 1 ACTIVE
5 1 CURRENT
6 1 UNUSED

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/erp1226/onlinelog/group_6.12953.903043737
+DATA/erp1226/onlinelog/group_6.12952.903043739
+DATA/erp1226/onlinelog/group_7.12951.903043757
+DATA/erp1226/onlinelog/group_7.12950.903043757
+DATA/erp1226/onlinelog/group_8.12949.903043759
+DATA/erp1226/onlinelog/group_8.12948.903043761
+DATA/erp1226/onlinelog/group_9.12947.903043763
+DATA/erp1226/onlinelog/group_9.12946.903043765
+DATA/erp1226/onlinelog/group_10.12945.903043767
+DATA/erp1226/onlinelog/group_10.12944.903043769
+DATA/erp1226/onlinelog/group_1.12963.903043559

MEMBER
--------------------------------------------------------------------------------
+DATA/erp1226/onlinelog/group_1.12962.903043561
+DATA/erp1226/onlinelog/group_2.12961.903043579
+DATA/erp1226/onlinelog/group_2.12960.903043581
+DATA/erp1226/onlinelog/group_3.12959.903043583
+DATA/erp1226/onlinelog/group_3.12958.903043583
+DATA/erp1226/onlinelog/group_4.12957.903043587
+DATA/erp1226/onlinelog/group_4.12956.903043589
+DATA/erp1226/onlinelog/group_5.12955.903043591
+DATA/erp1226/onlinelog/group_5.12954.903043593

20 rows selected.

select group#,status from v$log;

This completes the database restore and recovery.

Step 7 b:Post Clone Steps on Database node

Now the Database is up. We need to Source the Environment and complete the post clone steps.

a.Execute FND_CONC_CLEAN to cleanup nodes entries of source Database.( as 'apps' user)
exec fnd_conc_clone.setup_clean;

b.Run Autoconfig
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
./adautocfg.sh

-bash-4.1$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/erp1226/db/dbhome_1/appsutil/log/erp1226_host/02052136/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/erp1226/db/dbhome_1
Classpath :

:/u01/erp1226/db/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/erp1226/db/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/erp1226/db/dbhom

e_1/appsutil/java:/u01/erp1226/db/dbhome_1/jlib/netcfg.jar:/u01/erp1226/db/dbhome_1/jlib/ldapjclnt11.jar

Using Context file : /u01/erp1226/db/dbhome_1/appsutil/erp1226_host.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

c.Execute post clone script on Database for Data Masking

--VIMP check fnd_nodes uat-cm2
--Change the node name
update fnd_concurrent_queues set node_name='orace_erp_host' WHERE node_name in 'uat-CM2';
commit;

UPDATE XXerp_MISSN_CAPABILITY_DTLS set MISSION_CAP_STATUS_CODE = '1234';
commit;

--For Faster adcfgclone Execution
Execute package body APPS.WF_CLONE .

This completes the Database Cloning

(Note :Before starting application run cmclean.sql and than start applications )

Before starting Application cloning, modify FND Template as below for faster application tier cloning:
cd $FND_TOP/admin/driver/
vi fndtmpl.drv
txkWfClone.sh INSTE8_SETUP to txkWfClone.sh INSTALL_SETUP

Step 8: APPS CLONING:(erp1226 :12.2.5)
=======
Log on to the Run Edition File System in the Target System as the applmgr user and enter the following commands:
$ cd <COMMON_TOP>/clone/bin

cd /erpapp/erp1226/fs1/EBSapps/comn/clone/bin
total 561
-rwxr-xr-x 1 applmgr dba 5101 Feb 2 15:22 adchkutl.sh
-rwxr-xr-x 1 applmgr dba 95774 Feb 4 17:44 adclone.pl
-rwxr-xr-x 1 applmgr dba 47194 Feb 4 17:44 adclonectx.pl
-rwxr-xr-x 1 applmgr dba 125060 Feb 4 17:44 adcfgclone.pl
-rwxr-xr-x 1 applmgr dba 10050 Feb 4 17:44 adaddnode.pl
applmgr@orace_erp_host:~/erp1226/fs1/EBSapps/comn/clone/bin$ pwd

*******NOTE BELOW STEP of adcfgclone should be done in VNC SESSION to avoid disconnection of session ***************

$ perl adcfgclone.pl appsTier dualfs

• At the prompt:
• "Do you want to add a node (yes/no)", enter the value as 'no'.
• At the prompt:
• "Target System Base Directory", enter the location of the base directory. =>/erpapp/erp1226
• Provide:
• the new port pools for the Run Edition File System and the Patch Edition File System need to be provided.

• When asked the question:
• "Do you want to startup the Application Services for <TWO_TASK>? (y/n)" you should answer 'y' if you do not need

to perform any further actions and 'n' =>choose n

if there are other pending actions which need the Application services to be down.

Different logs are created for Run Edition and Patch Edition Cloning. The log files are created in the following

directories in the Run Edition File System:
• <INST_TOP>/admin/log/clone/run
• <INST_TOP>/admin/log/clone/patch

applmgr@orace_erp_host:~/erp1226/fs1/EBSapps/comn/clone/bin$ pwd
/erpapp/erp1226/fs1/EBSapps/comn/clone/bin
applmgr@orace_erp_host:~/erp1226/fs1/EBSapps/comn/clone/bin$ uname -a
SunOS orace_erp_host 5.11 11.1 sun4v sparc sun4v
applmgr@orace_erp_host:~/erp1226/fs1/EBSapps/comn/clone/bin$ echo $TWO_TASK

You have new mail in /var/mail/applmgr
applmgr@orace_erp_host:~/erp1226/fs1/EBSapps/comn/clone/bin$ ls -ltr
total 561
-rwxr-xr-x 1 applmgr dba 5101 Feb 2 15:22 adchkutl.sh
-rwxr-xr-x 1 applmgr dba 95774 Feb 4 17:44 adclone.pl
-rwxr-xr-x 1 applmgr dba 47194 Feb 4 17:44 adclonectx.pl
-rwxr-xr-x 1 applmgr dba 125060 Feb 4 17:44 adcfgclone.pl
-rwxr-xr-x 1 applmgr dba 10050 Feb 4 17:44 adaddnode.pl
applmgr@orace_erp_host:~/erp1226/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 /erpapp/erp1226/fs1/EBSapps/comn/clone/bin/CloneContext_0205214743.log

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

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

Target System Database SID : erp1226

Target System Database Server Node [orace_erp_host] : host

Target System Database Domain Name [erpdom.local] :

Target System Base Directory : /erpapp/erp1226

Target System Base Directory set to /erpapp/erp1226

Target System Current File System Base set to /erpapp/erp1226/fs1

Target System Other File System Base set to /erpapp/erp1226/fs2

Target System Fusion Middleware Home set to /erpapp/erp1226/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /erpapp/erp1226/fs2/FMW_Home

Target System Web Oracle Home set to /erpapp/erp1226/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /erpapp/erp1226/fs2/FMW_Home/webtier

Target System Appl TOP set to /erpapp/erp1226/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /erpapp/erp1226/fs2/EBSapps/appl

Target System COMMON TOP set to /erpapp/erp1226/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /erpapp/erp1226/fs2/EBSapps/comn

Target System Instance Home Directory [/erpapp/erp1226] :

Target System Base Directory set to /erpapp/erp1226

Target System Current File System Base set to /erpapp/erp1226/fs1

Target System Other File System Base set to /erpapp/erp1226/fs2

Target System Fusion Middleware Home set to /erpapp/erp1226/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /erpapp/erp1226/fs2/FMW_Home

Target System Web Oracle Home set to /erpapp/erp1226/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /erpapp/erp1226/fs2/FMW_Home/webtier

Target System Appl TOP set to /erpapp/erp1226/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /erpapp/erp1226/fs2/EBSapps/appl

Target System COMMON TOP set to /erpapp/erp1226/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /erpapp/erp1226/fs2/EBSapps/comn

Target System Instance Home Directory [/erpapp/erp1226] :

Target System Current File System Instance Top set to /erpapp/erp1226/fs1/inst/apps/erp1226_orace_erp_host

Do you want to preserve the Display [uat-cm2:0.0] (y/n) : n

Target System Display [orace_erp_host:0.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 [disabled] :

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] : 20

Checking the port pool 20
done: Port Pool 20 is free
Report file located at /erpapp/erp1226/fs1/inst/apps/erp1226_orace_erp_host/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /u01/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/
4. /u04/oradata/utl_dir
Choose a value which will be set as APPLPTMP value on the target node [1] :

Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/erpapp/erp1226/fs1/inst/apps/erp1226_orace_erp_host/appl/admin/erp1226_orace_erp_host.xml
Check Clone Context logfile /erpapp/erp1226/fs1/EBSapps/comn/clone/bin/CloneContext_0205214743.log for details.

Creating Patch file system context file.....

Log file located at /erpapp/erp1226/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0205215144.log

Target System Other File System Instance Top set to /erpapp/erp1226/fs2/inst/apps/erp1226_orace_erp_host

Target System Port Pool [0-99] : 21

Checking the port pool 21
done: Port Pool 21 is free
Report file located at /erpapp/erp1226/fs2/inst/apps/erp1226_orace_erp_host/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/erpapp/erp1226/fs2/inst/apps/erp1226_orace_erp_host/appl/admin/erp1226_orace_erp_host.xml
Check Clone Context logfile /erpapp/erp1226/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0205215144.log for details.

FMW Pre-requisite check log file location : /erpapp/erp1226/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...

Configuring: Run file system....
LogFile located at /erpapp/erp1226/fs1/inst/apps/erp1226_erp3-dev-zc1/admin/log/clone/run/RCloneApplyAppstier_02052152.log

Checking the port pool 21
done: Port Pool 21 is free
Report file located at /erpapp/erp1226/fs2/inst/apps/erp1226_orace_erp_host/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/erpapp/erp1226/fs2/inst/apps/erp1226_orace_erp_host/appl/admin/erp1226_orace_erp_host.xml
Check Clone Context logfile /erpapp/erp1226/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0205215144.log for details.

FMW Pre-requisite check log file location : /erpapp/erp1226/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...

Configuring: Run file system....
LogFile located at /erpapp/erp1226/fs1/inst/apps/erp1226_erp3-dev-zc1/admin/log/clone/run/RCloneApplyAppstier_02052152.log

Configuring: Patch file system....
LogFile located at /erpapp/erp1226/fs1/inst/apps/erp1226_erp3-dev-

zc1/admin/log/clone/patch/RCloneApplyAppstier_02052237.log

AutoConfig has completed with errors for .patch

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

Services not started

Step 9:Validation steps:
====================

applmgr@orace_erp_host:~/erp1226$ pwd
/erpapp/erp1226
applmgr@orace_erp_host:~/erp1226$ ls -ltr
total 23
drwxr-xr-x 5 applmgr dba 5 Feb 5 21:55 fs1
drwxr-xr-x 4 applmgr dba 4 Feb 5 22:19 fs_ne
drwxr-xr-x 5 applmgr dba 5 Feb 5 23:17 fs2
-rw-r--r-- 1 applmgr dba 6465 Feb 5 23:36 EBSapps.env
applmgr@orace_erp_host:~/erp1226$ . EBSapps.env run

E-Business Suite Environment Information
----------------------------------------
RUN File System : /erpapp/erp1226/fs1/EBSapps/appl
PATCH File System : /erpapp/erp1226/fs2/EBSapps/appl
Non-Editioned File System : /erpapp/erp1226/fs_ne

DB Host: host.erpdom.local Service/SID: erp1226

Sourcing the RUN File System ...

applmgr@orace_erp_host:~/erp1226/fs1/inst/apps/erp1226_orace_erp_host/ora/10.1.2/network/admin$ cp tnsnames.ora

tnsnames.ora_05Feb2018bkup
applmgr@orace_erp_host:~/erp1226/fs1/inst/apps/erp1226_orace_erp_host/ora/10.1.2/network/admin$ vi tnsnames.ora
applmgr@orace_erp_host:~/erp1226/fs1/inst/apps/erp1226_orace_erp_host/ora/10.1.2/network/admin$ tnsping erp1226

TNS Ping Utility for Solaris: Version 10.1.0.5.0 - Production on 05-FEB-2018 23:56:33

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/erpapp/erp1226/fs1/inst/apps/erp1226_orace_erp_host/ora/10.1.2/network/admin/sqlnet_ifile.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DEscRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host.erpdom.local)(PORT=1541)) (CONNECT_DATA=

(SERVICE_NAME=erp1226) (INSTANCE_NAME=erp1226)))
OK (0 msec)
applmgr@orace_erp_host:~/erp1226/fs1/inst/apps/erp1226_orace_erp_host/ora/10.1.2/network/admin$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Feb 5 23:56:44 2018

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select name from v$database;

NAME
---------
erp1226

SQL> select status from v$instance;

STATUS
------------
OPEN

applmgr@orace_erp_host:~$ cd /erpapp/erp1226
applmgr@orace_erp_host:~/erp1226$ pwd
/erpapp/erp1226
applmgr@orace_erp_host:~/erp1226$ ls -ltr
total 23
drwxr-xr-x 5 applmgr dba 5 Feb 5 21:55 fs1
drwxr-xr-x 4 applmgr dba 4 Feb 5 22:19 fs_ne
drwxr-xr-x 5 applmgr dba 5 Feb 5 23:17 fs2
-rw-r--r-- 1 applmgr dba 6465 Feb 5 23:36 EBSapps.env
applmgr@orace_erp_host:~/erp1226$ . EBSapps.env run

E-Business Suite Environment Information
----------------------------------------
RUN File System : /erpapp/erp1226/fs1/EBSapps/appl
PATCH File System : /erpapp/erp1226/fs2/EBSapps/appl
Non-Editioned File System : /erpapp/erp1226/fs_ne

DB Host: host.erpdom.local Service/SID: erp1226

Sourcing the RUN File System ...

Step 10: Start the Target Applications after cloning
======================================

a. Take a backup of context file
b. vi $CONTEXT_FILE
c. Change the load balancing related parameters
d. adstrtal.sh apps/<password>

Step 11:Post Cloning Steps on Application node:
=====================================

a)Change Logo

Upload the below logo to $OA_MEDIA/erp_logo.jpg

/erpapp/apps/apps_st/comn/java/classes/oracle/apps/media
-bash-4.1$ ls -ltr erp_sc.jpg
-rw-r--r-- 1 applmgr dba 6008 Mar 14 2014 erp_logo.jpg
-bash-4.1$ mv erp_logo.jpg erp_logo.jpg_old
-bash-4.1$ cp /erpapp/erp_sc.jpg .
-bash-4.1$ ls -ltr erp_logo.jpg
-rw-r--r-- 1 applmgr dba 16907 Apr 16 12:33 erp_logo.jpg

b)Execute below wfntfqup.sql from apps node:
==============================================

Disable Workflow Notification Mailer. Set the override address from OAM. Purge pending notifications.

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfntfqup.sql apps apps applsys

cd $FND_TOP/patch/115/sql

cd /erpapp/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/
sqlplus apps/apps

@wfntfqup.sql

-bash-4.1$ cd $FND_TOP/patch/115/sql/
-bash-4.1$ ls -l wfntfqup.sql
-rwxr-xr-x 1 applmgr dba 11862 Oct 28 2010 wfntfqup.sql
-bash-4.1$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jan 16 12:34:19 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
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

SQL> @wfntfqup.sql

Take backup of context file before configuring load balancing in APPS NODE

c) Change the URLs previously in Context File configured for Load Balancing in PROD and run autoconfig.

s_external_url http://erpdev.erp.ae:8020
s_login_page http://erpdev.erp.ae:8020/OA_HTML/AppsLogin
s_webentryhost erpdev
s_webentrydomain erp.ae

If we are working in Oracle SuperCluster Environment we need to start the application with the below commands:
=====================================================================================================================

We need to start the erpuat applications with 'clrg' command as 'root' user from APPS NODE1:

# clrg online cm-rg
# clrg online opmn-rg
#cluster status

(OR)
Source the Apps Environment.

cd $ADMIN_SCRIPTS_HOME
./adstral.sh

Step 12: Post clonning steps after Application Tier cloning.

Changing password:
======================

a)system and sys database users:
----------------------------------

alter user system identified by welcome1;

alter user sys identified by welcome1;

FNDCPASS apps/welcome1 0 Y system/welcome1 SYSTEM APPLSYS new_pass

b)sysadmin password:
=========================

FNDCPASS apps/welcome1 0 Y system/welcome1 USER SYSADMIN welcome6

FNDCPASS apps/welcome1 0 Y system/welcome1 USER rafi welcome6

FNDCPASS apps/welcome1 0 Y system/welcome1 USER sysadmin Welcome789

c)Postclone steps for to clean up FND_NODES entries for concurrent Manager:
==========================

Execute cmclean.sql by connecting with 'apps' user.

To make sure all the Database and Applications service comes up smoothly follow below approach

Shut down the Application tier services.

On App node:
------------

cd $ADMIN_scRIPTS_HOME
./adstpall.sh

d) Execute autoconfig on apps node than on db node and than again on apps node

On DB node:
----------
cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

./adautocfg.sh

On App node:
------------

cd $ADMIN_scRIPTS_HOME
./adautocfg.sh

ONLY if require do below steps:

C ) Update the Node information for all Concurrent Managers from Concurrent Manager Define to current node name and

Restart concurrent managers using adcmctl.sh

d) Postclone steps for discoverer:
====================================

1)Update Discoverer URL in Context File ( Application Tier - s_disco_url):

2)For Discoverer Copy the new DBC file and change the name in lower case on Discoverer Server

/erpapp/erp1226/fs1/inst/apps/erp1226_orace_erp_host/appl/fnd/12.0.0/secure

applmgr@orace_erp_host:~/erp1226/fs1/inst/apps/erp1226_orace_erp_host/appl/fnd/12.0.0/secure$ scp erp1226.dbc

oracle@198.17.18.142:/u01/app/oracle/Middleware/fmw11gr1/discodom_1/config/discovererr/discovererr_discodom_1
Password:
erp1226.dbc 100% |*********************************************************************************

e)Postclone steps for Colour change at site level:
===================================================

1) Change the profile options:
Site Name to “DEV Instance”
Java Color schme to a color which is not same as PROD

IN POST CLONE FOR UPGRADE ENV Please do cutom sync driver steps:

add Below to adop_sync.drv

applmgr@uat-cm2:/erpapp/ERP122_Source/upgrade/fs_ne/EBSapps/appl/ad/custom$ view adop_sync.drv
applmgr@uat-cm2:/erpapp/ERP122_Source/upgrade/fs_ne/EBSapps/appl/ad/custom$ pwd
/erpapp/ERP122_Source/upgrade/fs_ne/EBSapps/appl/ad/custom

f) Begin Customization

##Customization for erp
rsync -zr %s_current_base%/EBSapps/comn/java/classes/xxadat %s_other_base%/EBSapps/comn/java/classes
rsync -zr %s_current_base%/EBSapps/comn/java/classes/xxad %s_other_base%/EBSapps/comn/java/classes
rsync -zr %s_current_base%/EBSapps/comn/java/classes/xxerp %s_other_base%/EBSapps/comn/java/classes

#Copy Starts
mkdir -p %s_other_base%/EBSapps/comn/java/classes/com/excel4apps
rsync -zr %s_current_base%/EBSapps/comn/java/classes/com/excel4apps %s_other_base%/EBSapps/comn/java/classes/com
rsync -zr %s_current_base%/EBSapps/appl/xxe4a %s_other_base%/EBSapps/appl
rsync -zr %s_current_base%/EBSapps/appl/xxe4arw %s_other_base%/EBSapps/appl
rsync -zr %s_current_base%/EBSapps/appl/fnd/12.0.0/admin/template/custom %s_other_base

%/EBSapps/appl/fnd/12.0.0/admin/template
cp %s_current_base%/EBSapps/comn/java/classes/customall.jar %s_other_base%/EBSapps/comn/java/classes

*****Now Login in separate putty session,source the Envrionmement for APPS DEV and Start all the application services:

applmgr@orace_erp_host:~$ . APPSERPDEV_orace_erp_host.env
applmgr@orace_erp_host:~$ cd $ADMIN_scRIPTS_HOME
applmgr@orace_erp_host:~/inst/apps/ERPDEV_orace_erp_host/admin/scripts$ ./adstrtal.sh

You are running adstrtal.sh version 120.15.12010000.3

f)Postclone steps for Colour change at site level:
===================================================

Change the profile options:
Site Name to “DEV Instance”
Java Color scheme to a color which is not same as PROD

g) Validation steps and Sanity checks after Doing ERP Cloning:
=============================================================

1)Check all the Concurrent managers are up and reduce the number of processes for Standard managers.

2)Submit the Active user or Active Responsibilities Concurrent request.

3)Check the discovererer URL for viewer and Desktop and share DBC file with team.

4)Make sure to verify logs after starting the ERP Applications

5)Submit Gather schema stats request for all schemas to improve performance of ERP applications

This completes clonning of Database and Applications for Oracle EBS 12.2 .

Enjoy Apps DBA Tasks...

Thanks,

Rafi

“Two useful technologies for working from anywhere – Cloud Desktop and Cloud SharePoint.”

https://www.apps4rent.com

2 comments:

UnknownSeptember 4, 2018 at 3:51 AM
On your website valuable information is there,thanks for sharing.
Oracle HRMS Training in Ameerpet
ReplyDelete
Replies
AnonymousSeptember 6, 2018 at 2:51 AM
Very interesting blog to read and to share, thanks for sharing such a good blog.Keep posting more blogs like this thank you.... Please contact us for Oracle Financials Training in Ameerpet details in our Erptree Training Institute
ReplyDelete
Replies

Add comment

* Rafi ORACLE DBA & APPS DBA Blog*

Pages

Monday, August 20, 2018

Step by Step Oracle Applications and Database Cloning for Oracle EBS 12.2 Environment

2 comments:

VISITORS

Followers

MY ORACLE POSTS

My ORACLE FORUMS BOOKS & LINKS

ORACLE EXPERT'S & PROFESSIONAL'S BLOGS