Cloning an EBS instance R12.2.10 from OEL 6.10 to OEL 7.9 using adcfgclone and RMAN




In this post, I am going to share how to clone the EBS R12.2.10 instance from OEL 6 to OEL 7. This can be used for the normal cloning process as well.


Source Machine: OEL 6.10
DB : 12.1.0.2
APPS: 12.2.10

Target Machine: OEL 7.9
DB : 12.1.0.2
APPS: 12.2.10

Shared Mount between both machines: /media/sf_Downloads

Pre-requisites:
Please install a target machine with Oracle Linux 7.9 and install all related RPMs from the below post.



Target Machine Preparation

1) Edit Security Limits.conf and enter below values

/etc/security/limits.conf:
---------------
 * hard nofile 65536
 * soft nofile 4096
 * hard nproc 16384
 * soft nproc 2047
 * hard stack 16384
 * soft stack 10240

2) Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

Validate using below

# sestatus

3) If you have the Linux firewall enabled, you will need to disable or configure it.

To disable it, do the following.

# systemctl stop firewalld
# systemctl disable firewalld

4) Validate user oracle and applmgr users

[root@funebs122 yum.repos.d]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[root@funebs122 yum.repos.d]# id applmgr
uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall)
[root@funebs122 yum.repos.d]# usermod -aG dba applmgr
[root@funebs122 yum.repos.d]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password contains the user name in some form
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@funebs122 yum.repos.d]# passwd applmgr
Changing password for user applmgr.
New password: 
BAD PASSWORD: The password fails the dictionary check - it is based on a dictionary word
Retype new password: 
passwd: all authentication tokens updated successfully.


5) Create directory structure for EBS

[root@funebs122 yum.repos.d]# mkdir /oraapps122
[root@funebs122 yum.repos.d]# chown oracle:dba /oraapps122
[root@funebs122 yum.repos.d]# chmod 777 /oraapps122

6) Set your inventory location under /etc/oraInst.loc as  

vi /etc/oraInst.loc

inventory_loc=/oraapps122/oracle/oraInventory 
inst_group=dba 

From oracle user create directory

mkdir -p /oraapps122/oracle/oraInventory
chmod 777 /oraapps122/oracle/oraInventory

7) Validate Swap space


[root@funebs122 yum.repos.d]# cat /proc/meminfo |grep -i swap
SwapCached:            0 kB
SwapTotal:      16773116 kB
SwapFree:       16773116 kB



Source Machine 


1) Make sure the database is in archive mode.

SYS@GOLD >archive log list;
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /oracleapps/DATABASE/GOLD/data
Oldest online log sequence     76
Next log sequence to archive   77
Current log sequence	       77
2) Download patch 17537119 from My Oracle Support, unzip it under /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc and run /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc/checkDBpatch.sh to avoid ADOP related issues. 
if etcc directory doesn't exists, please create.

3) Run ad-pre clone on database and application.
DB:
perl adpreclone.pl dbTier

                     Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password: 
Verifying if Database Patch checker (ETCC) exists in /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc 


Running:
perl /oracleapps/DATABASE/GOLD/12.1.0/appsutil/bin/adclone.pl java=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/jre mode=stage stage=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/GOLD_ebs122.xml showProgress 


Beginning database tier Stage - Wed Mar  3 08:47:41 2021

/oracleapps/DATABASE/GOLD/12.1.0/appsutil/jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracleapps/DATABASE/GOLD/12.1.0/oui -classpath /oracleapps/DATABASE/GOLD/12.1.0/lib/xmlparserv2.jar:/oracleapps/DATABASE/GOLD/12.1.0/jdbc/lib/ojdbc6.jar:/oracleapps/DATABASE/GOLD/12.1.0/appsutil/java:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/OraInstaller.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/ewt3.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/share.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/srvm.jar:/oracleapps/DATABASE/GOLD/12.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /oracleapps/DATABASE/GOLD/12.1.0/appsutil/GOLD_ebs122.xml -stage /oracleapps/DATABASE/GOLD/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password : 
Log file located at /oracleapps/DATABASE/GOLD/12.1.0/appsutil/log/GOLD_ebs122/StageDBTier_03030847.log

  -     50% completed       

Completed Stage...
Wed Mar  3 08:48:09 2021

APPS:



perl adpreclone.pl appsTier

                     Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password: 
Enter the Weblogic AdminServer password : 

 Checking the status of the Oracle WebLogic Administration Server....

 Running perl /oracleapps/APPLICATION/GOLD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml -servername=AdminServer -promptmsg=hide  

The Oracle WebLogic Administration Server is up.

wlsDomainName: EBS_domain_GOLD
WLS Domain Name is VALID.

Running:
perl /oracleapps/APPLICATION/GOLD/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/clone component=appsTier method= appctx=/oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml showProgress 



 Setting the wls environment 

Beginning application tier Stage - Wed Mar  3 09:13:15 2021

/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/java/classes:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/share.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml -stage /oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg 

Log file located at /oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/admin/log/clone/StageAppsTier_03030913.log

  -     20% completed       

Completed Stage...
Wed Mar  3 09:30:24 2021

4) Take a rman backup.

rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 3 09:39:23 2021

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

connected to target database: GOLD (DBID=3218346444)

RMAN> list backup of database;

using target database control file instead of recovery catalog
specification does not match any backup in the repository

RMAN> show all;

RMAN configuration parameters for database with db_unique_name GOLD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO 30000 M;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracleapps/DATABASE/GOLD/12.1.0/dbs/snapcf_GOLD.f'; # default

Start the RMAN backup of the database. I am taking backup at a shared location so that I don't have to manually copy backup pieces to the target server. Else, please copy backup pieces to the target machine.

RMAN> RUN
{
  ALLOCATE CHANNEL ch1 TYPE DISK;
  BACKUP
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_D_%T_%u_s%s_p%p'
  DATABASE
  CURRENT CONTROLFILE
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_C_%T_%u'
  SPFILE
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_S_%T_%u'
  PLUS ARCHIVELOG
  FORMAT '/media/sf_Downloads/RMANBACKUP/%d_A_%T_%u_s%s_p%p';
  RELEASE CHANNEL ch1;
 }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>
5) Take tar backup of the Database Oracle Home and EBSapps folder from the application run file system.

tar -zcvf /media/sf_Downloads/12.1.0.tar.gz 12.1.0

My run file system is fs1 so taking tar from fs1.

tar -zcvf /media/sf_Downloads/EBSapps.tar.gz EBSapps


Go to Target Machine which is OEL 7.9.

1) We need to configure our database.

a) Make a directory structure for database home and data files.

[oracle@funebs122 oraapps122]$ mkdir -p /oraapps122/DATABASE/FUAT /oraapps122/DATABASE/FUAT/data
[oracle@funebs122 oraapps122]$ mkdir -p /oraapps122/DATABASE/FUAT/arch

FUAT-- Duplicate DB name and funebs122 my hostname.

b) Copy the Oracle Home tar from the shared location which was taken from the source instance to  /oraapps122/DATABASE/FUAT.

[oracle@funebs122 sf_Downloads]$ cp 12.1.0.tar.gz /oraapps122/DATABASE/FUAT/
c) Untar the file.

[oracle@funebs122 /oraapps122/DATABASE/FUAT]$ tar -zxvf 12.1.0.tar.gz

d) Set below value

export ORACLE_HOME=/oraapps122/DATABASE/FUAT/12.1.0
export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib
export ORACLE_SID=FUAT


e)Run adcfgclone for configuring oracle Home.

[oracle@funebs122 bin]$ 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.65

Enter the APPS password : 

Running: Context clone...

Log file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/CloneContext_0303160655.log

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

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

Target System Base Directory : /oraapps122/DATABASE

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

Target System Database SID : FUAT

Role separation is supported y/n [n] ? : n

Target System utl_file_dir Directory List : /tmp

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

Target System DATA_TOP Directory 1 [/oraapps122/DATABASE/data] : /oraapps122/DATABASE/FUAT/data

Target System RDBMS ORACLE_HOME Directory [/oraapps122/DATABASE/12.1.0] : /oraapps122/DATABASE/FUAT/12.1.0

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

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

Checking the port pool 30
done: Port Pool 30 is free
Report file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/temp/portpool.lst
The new database context file has been created :
  /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml
Check Clone Context logfile /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/CloneContext_0303160655.log for details.

Running Rapid Clone with command:

Running:
perl /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/adclone.pl java=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml showProgress contextValidated=true


Beginning rdbms home Apply - Wed Mar  3 16:08:22 2021

/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oraapps122/DATABASE/FUAT/12.1.0/oui -classpath /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/java:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/share.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml -stage /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone   -showProgress
APPS Password : Log file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/ApplyDBTechStack_03031608.log
  /      0% completed       

Completed Apply...
Wed Mar  3 16:11:24 2021

Starting database listener for FUAT:
Running:
/oraapps122/DATABASE/FUAT/12.1.0/appsutil/scripts/FUAT_funebs122/addlnctl.sh start FUAT
Logfile: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/addlnctl.txt

You are running addlnctl.sh version 120.4


Starting listener process FUAT ...


LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-MAR-2021 16:11:24

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /oraapps122/DATABASE/FUAT/12.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oraapps122/DATABASE/FUAT/12.1.0/network/admin/FUAT_funebs122/listener.ora
Log messages written to /oraapps122/DATABASE/FUAT/12.1.0/admin/FUAT_funebs122/diag/tnslsnr/funebs122/fuat/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=funebs122.lab)(PORT=1551)))
STATUS of the LISTENER
------------------------
Alias                     FUAT
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                03-MAR-2021 16:11:25
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oraapps122/DATABASE/FUAT/12.1.0/network/admin/FUAT_funebs122/listener.ora
Listener Log File         /oraapps122/DATABASE/FUAT/12.1.0/admin/FUAT_funebs122/diag/tnslsnr/funebs122/fuat/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))
Services Summary...
Service "FUAT" has 1 instance(s).
  Instance "FUAT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/addlnctl.txt for more information ...  


Running ETCC to check status of DB technology patches... 


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

Validating context file: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml

Using context file from command line argument:
/oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml


Starting Database EBS Technology Codelevel Checker, Version 120.82 
Wed Mar  3 16:11:26 IST 2021
Log file for this session : /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/log/checkDBpatch_10124.log

Identifying database release. 
Database release set to 12.1.0.2.

Connecting to database. 

+-----------------------------------------------------------------------------+
[WARNING] DB-ETCC: Could not connect to database, so unable to check:
  - Whether database is in READ-WRITE mode. 
  - Existence of table needed to store DB-ETCC results. 
  - Enablement of database In-Memory option. 
    If this feature is enabled, additional fixes need to be verified.

Resolve the database connectivity issue, and then rerun DB-ETCC.
+-----------------------------------------------------------------------------+

Bugfix file /oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.57
This file will be used for identifying missing bugfixes. 

Mapping file /oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.32
This file will be used for mapping bugfixes to patches.


[WARNING] DB-ETCC: Bugfix XML file (/oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.
 Check if a newer version is available in patch 17537119.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

All the required one-off bugfixes are present in Database ORACLE_HOME.

[WARNING] Database not available. DB-ETCC results cannot be stored.

Finished checking fixes for Oracle Database: Wed Mar  3 16:11:43 IST 2021

Log file for this session: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/log/checkDBpatch_10124.log

===============================================================================

f) Create the database using duplicate commands and with backup pieces.

Source environment file and Start database in nomount

Edit /oraapps122/DATABASE/FUAT/12.1.0/dbs/initFUAT.ora file and add below db and log convert parameter.

DB_FILE_NAME_CONVERT=(/oracleapps/DATABASE/GOLD/data/,/oraapps122/DATABASE/FUAT/data/)
LOG_FILE_NAME_CONVERT=(/oracleapps/DATABASE/GOLD/data/,/oraapps122/DATABASE/FUAT/data/)
[oracle@funebs122 12.1.0]$ . FUAT_funebs122.env
[oracle@funebs122 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 3 16:24:45 2021

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

Connected to an idle instance.

SYS@FUAT >startup nomount pfile='/oraapps122/DATABASE/FUAT/12.1.0/dbs/initFUAT.ora'
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size		    2926472 bytes
Variable Size		  452987000 bytes
Database Buffers	 1677721600 bytes
Redo Buffers		   13848576 bytes

Start Duplicate

[oracle@funebs122 dbs]$ rman AUXILIARY /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 3 16:31:34 2021

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

connected to auxiliary database: FUAT (not mounted)

RMAN> DUPLICATE DATABASE TO FUAT
        BACKUP LOCATION '/media/sf_Downloads/RMAN_BACKUP/'
  NOFILENAMECHECK;2> 3>

g)  Connect to sqlplus using apps/source_Apps_password and run fnd conc cleanup.

[oracle@funebs122 ~]$ sqlplus apps/apps

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 3 18:23:36 2021

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

Last Successful login time: Wed Mar 03 2021 18:23:14 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

APPS@FUAT >select node_name from fnd_nodes;

NODE_NAME
--------------------------------------------------------------------------------
AUTHENTICATION
EBS122

APPS@FUAT >EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

APPS@FUAT >commit;

Commit complete.

APPS@FUAT >select node_name from fnd_nodes;

no rows selected


h) Run Autoconfig on DB Tier

[oracle@funebs122 ~]$ cd $ORACLE_HOME/appsutil/scripts
[oracle@funebs122 scripts]$ ls
FUAT_funebs122
[oracle@funebs122 scripts]$ cd FUAT_funebs122/
[oracle@funebs122 FUAT_funebs122]$ ls
adautocfg.sh  adchknls.pl  addbctl.sh  addlnctl.sh  adexecsql.pl  adpreclone.pl  adstopdb.sql  adstrtdb.sql
[oracle@funebs122 FUAT_funebs122]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/03031825/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
	Using ORACLE_HOME location : /oraapps122/DATABASE/FUAT/12.1.0

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
	Classpath                   : :/oraapps122/DATABASE/FUAT/12.1.0/jdbc/lib/ojdbc6.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/java/xmlparserv2.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/java:/oraapps122/DATABASE/FUAT/12.1.0/jlib/netcfg.jar:/oraapps122/DATABASE/FUAT/12.1.0/jlib/ldapjclnt12.jar:/oraapps122/DATABASE/FUAT/12.1.0/jlib/orai18n.jar

	Using Context file          : /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.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 db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.


2) Configure Application Tier

a) make the Below directory structure from applmgr user.

[applmgr@funebs122 oraapps122]$ mkdir -p /oraapps122/APPS/FUAT
[applmgr@funebs122 oraapps122]$ cd /oraapps122/APPS/FUAT
[applmgr@funebs122 FUAT]$ ls
[applmgr@funebs122 FUAT]$ mkdir fs1 fs2 fs_ne
[applmgr@funebs122 FUAT]$ ls -ltr
total 0
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs_ne
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs2
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs1

b) Copy the tar taken in source to fs1 as it was taken from run file system which at source and untar it.

[applmgr@funebs122 FUAT]$ cd fs1
[applmgr@funebs122 fs1]$ ls -ltr
total 0
[applmgr@funebs122 fs1]$ cp /media/sf_Downloads/EBSapps.tar.gz .
tar -zxvf EBSapps.tar.gz

c) Run adcfgclone for application configuration now.

[applmgr@funebs122 clone]$ cd /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone
[applmgr@funebs122 clone]$ ls
appl  appsts  bin  context  FMW  html  jlib  jre  oui  prereq
[applmgr@funebs122 clone]$ cd bin
[applmgr@funebs122 bin]$ ls
adaddnode.pl  adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl
[applmgr@funebs122 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.65

Enter the APPS password : 

Enter the Weblogic AdminServer password : 

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


Running: Context clone...

Log file located at /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContext_0303182714.log

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

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

Target System Database SID : FUAT

Target System Database Server Node [funebs122] : 

Target System Database Domain Name [lab] : 

Target System Base Directory : /oraapps122/APPS/FUAT

Target System Base Directory set to /oraapps122/APPS/FUAT

Target System Current File System Base set to /oraapps122/APPS/FUAT/fs1

Target System Other File System Base set to /oraapps122/APPS/FUAT/fs2

Target System Fusion Middleware Home set to /oraapps122/APPS/FUAT/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /oraapps122/APPS/FUAT/fs2/FMW_Home

Target System Web Oracle Home set to /oraapps122/APPS/FUAT/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /oraapps122/APPS/FUAT/fs2/FMW_Home/webtier

Target System Appl TOP set to /oraapps122/APPS/FUAT/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /oraapps122/APPS/FUAT/fs2/EBSapps/appl

Target System COMMON TOP set to /oraapps122/APPS/FUAT/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /oraapps122/APPS/FUAT/fs2/EBSapps/comn

Target System Instance Home Directory [/oraapps122/APPS/FUAT] : 

Target System Current File System Instance Top set to /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122

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

Target System Display [funebs122: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] : 30

Checking the port pool 30
done: Port Pool 30 is free
Report file located at /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122/admin/out/portpool.lst

Target System proxy port [80] : 

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /tmp
3. /oraapps122/DATABASE/FUAT/12.1.0/appsutil/outbound/FUAT_funebs122
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 
The new APPL_TOP context file has been created :
  /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122/appl/admin/FUAT_funebs122.xml
Check Clone Context logfile /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContext_0303182714.log for details.

Creating Patch file system context file.....

Log file located at /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0303182812.log

Target System Other File System Instance Top set to /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122

Target System Port Pool [0-99] : 40

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

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

Configuring: Run file system....
LogFile located at /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122/admin/log/clone/run/RCloneApplyAppstier_03031828.log



3) Open the EBS URL and validate.



If you like please follow and comment