The clone steps are as below:
The database details that we will be cloning are as below:
CONTAINER DB NAME=TESTCDB1
Pluggable DB NAME=TESTDB1
1. Pre-Requisite Tasks
**************************************************
For prerequisite details, see Section 2 of My Oracle Support Knowledge Document 1383621.1, Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone.
If your Oracle E-Business Suite instance has an Oracle RAC database, also see Section 1 of My Oracle Support Knowledge Document 1679270.1, Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone.
Refer to Section 2 of My Oracle Support Knowledge Document 1383621.1, Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone for the prerequisite tasks to be completed on the source Oracle E-Business Suite instance before cloning.
In case the instance has an Oracle RAC database, also refer to Section 2 of My Oracle Support Knowledge Document 1679270.1, Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone for additional prerequisites.
Ensure the target system meets all requirements for Oracle E-Business Suite Release 12.2 as stated in My Oracle Support Knowledge Document 1320300.1, Oracle E-Business Suite Release Notes, Release 12.2, and Oracle E-Business Suite Installation and Upgrade Notes for each platform.
If the source instance has an Oracle RAC database, also refer to Section 3 of My Oracle Support Knowledge Document 1679270.1, Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone.
2. Backup Transfer:
***************
Backup move from SOURCE to TARGET
3.Context file Creation:
************************
$ export PERL5LIB=/u01/install/APPS/19.5.0/perl/lib/5.28.1:/u01/install/APPS/19.5.0/perl/lib/site_perl/5.28.1
$ export PATH=/u01/install/APPS/19.5.0/bin:$PATH
$ export LD_LIBRARY_PATH=/u01/install/APPS/19.5.0/lib
$ cd /u01/install/APPS/19.5.0/appsutil/clone/bin
Create the Context File for a Single-Node Database,
$ ls -lrt
total 284
-rwxr-xr-x. 1 oracle oracle 100066 Nov 10 00:51 adclone.pl
-rwxr-xr-x. 1 oracle oracle 48268 Nov 10 00:51 adclonectx.pl
-rwxr-xr-x. 1 oracle oracle 5101 Nov 10 00:51 adchkutl.sh
-rwx--x--x. 1 oracle oracle 128097 Nov 10 00:51 adcfgclone.pl
$ perl adclonectx.pl contextfile=/u01/install/APPS/19.5.0/appsutil/EBSDB_apps.xml template=/u01/install/APPS/19.5.0/appsutil/template/adxdbctx.tmp
Copyright (c) 2011, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adclonectx Version 120.30.12020000.21
Running:
/u01/install/APPS/19.5.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/19.5.0/appsutil/clone/bin/../jlib/ojdbc8.jar:/u01/install/APPS/19.5.0/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/install/APPS/19.5.0/appsutil/clone/bin/../jlib/java: oracle.apps.ad.context.CloneContext -e /u01/install/APPS/19.5.0/appsutil/EBSDB_apps.xml -tmpl /u01/install/APPS/19.5.0/appsutil/template/adxdbctx.tmp
Enter the APPS password :
Log file located at /u01/install/APPS/19.5.0/appsutil/clone/bin/CloneContext_1111070107.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [<hostname>] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? : y
Target System Base Directory : /u01/install/
Target Instance is RAC (y/n) [n] : n
Target System CDB Name : TESTCDB1
Target System PDB Name : TESTDB1
Oracle OS User [oracle] : oracle
Oracle OS Group [oracle] : oracle
Role separation is supported y/n [n] ? :
Number of DATA_TOP's on the Target System [2] : 2
Target System DATA_TOP Directory 1 [/u01/install/EBSCDB] : /u01/install/oradata/EBSCDB
Target System DATA_TOP Directory 2 [/u01/install/data] : /u01/install/APPS/data
Specify value for OSBACKUPDBA group [oracle] :
Specify value for OSDGDBA group [oracle] :
Specify value for OSKMDBA group [oracle] :
Specify value for OSRACDBA group [oracle] :
Target System RDBMS ORACLE_HOME Directory [/u01/install/19.0.0] : /u01/install/APPS/19.5.0
Do you want to preserve the Display [localhost:10.0] (y/n) : n
Target System Display [<hostname>:0.0] : <hostname>: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] : 15
Checking the port pool 15
done: Port Pool 15 is free
Report file located at /u01/install/APPS/19.5.0/appsutil/temp/portpool.lst
The new database context file has been created :
/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
contextfile=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Check Clone Context logfile /u01/install/APPS/19.5.0/appsutil/clone/bin/CloneContext_1111070107.log for details.
Also Created the required (s_outbound_dir) directory,
$ cat TESTDB1_<hostname>.xml | grep -i s_outbound_dir
<OUTBOUND_DIR oa_var="s_outbound_dir">/u01/install/APPS/19.5.0/appsutil/outbound/TESTDB1_<hostname></OUTBOUND_DIR>
$ mkdir -p /u01/install/APPS/19.5.0/appsutil/outbound/TESTDB1_<hostname>
4.DB TECHSTACK:
*****************
Configure the Database Technology Stack,
Navigate to <ORACLE_HOME>/appsutil/clone/bin and run Rapid Clone (adcfgclone.pl utility) with the following parameters
to configure the database technology stack
PreReq for running dbTechStack:
*******************************
So, export PERL5LIB Variable like below and configure dbTechStack again,
$ export PERL5LIB=/u01/install/APPS/19.5.0/perl/lib/5.28.1:/u01/install/APPS/19.5.0/perl/lib/site_perl/5.28.1
$ export PATH=/u01/install/APPS/19.5.0/bin:$PATH
$ export LD_LIBRARY_PATH=/u01/install/APPS/19.5.0/lib
$ perl adcfgclone.pl dbTechStack /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.63
Enter the APPS password :
Running Rapid Clone with command:
Running:
perl /u01/install/APPS/19.50/appsutil/clone/bin/adclone.pl java=/u01/install/APPS/19.5.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/APPS/19.5.0/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/install/APPS/19.5.0/appsutil/EBSDB_<hostname>.xml showProgress contextValidated=false
Beginning rdbms home Apply - Thu Nov 19 04:30:23 2020
/u01/install/APPS/19.5.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/install/APPS/19.5.0/oui -classpath /u01/install/APPS/19.5.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/ojdbc8.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/java:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/share.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/srvm.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e /u01/install/APPS/19.5.0/appsutil/EBSDB_<hostname>.xml -stage /u01/install/APPS/19.5.0/appsutil/clone -showProgress
APPS Password : Log file located at /u01/install/APPS/19.5.0/appsutil/log/EBSDB_<hostname>/ApplyDBTechStack_11190430.log
| 0% completed
Log file located at /u01/install/APPS/19.5.0/appsutil/log/EBSDB_<hostname>/ApplyDBTechStack_11190430.log
| 100% completed
Completed Apply...
Thu Nov 19 04:33:15 2020
Starting database listener for TESTDB1:
Running:
/u01/install/APPS/19.5.0/appsutil/scripts/EBSDB_<hostname>/addlnctl.sh start TESTCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/EBSDB_<hostname>/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process TESTCDB1 ...
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-NOV-2020 04:33:15
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/install/APPS/19c/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/install/APPS/19.5.0/network/admin/TESTDB1_<hostname>/listener.ora
Log messages written to /u01/install/APPS/19.5.0/admin/TESTDB1_<hostname>/diag/tnslsnr/<hostname>/ebscdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.itess.com)(PORT=1536))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>.itess.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias TESTCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-NOV-2020 04:33:15
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/APPS/19c/network/admin/EBSDB_<hostname>/listener.ora
Listener Log File /u01/install/APPS/19c/admin/EBSDB_<hostname>/diag/tnslsnr/<hostname>/ebscdb/alert/log.xml
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>.itess.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias TESTCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-NOV-2020 04:33:15
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/APPS/19.5.0/network/admin/TESTDB1_<hostname>/listener.ora
Listener Log File /u01/install/APPS/19.5.0/admin/EBSDB_<hostname>/diag/tnslsnr/<hostname>/ebscdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.itess.com)(PORT=1536)))
Services Summary...
Service "EBSDB" has 1 instance(s).
Instance "EBSDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/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: /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Using context file from command line argument:
/u01/install/APPS/19c/appsutil/TESTDB1_<hostname>.xml
Starting Database EBS Technology Codelevel Checker, Version 120.81
Thu Nov 19 04:33:15 EST 2020
Log file for this session : /u01/install/APPS/19.5.0/appsutil/clone/bin/log/checkDBpatch_25376.log
Identifying database release.
Database release set to 19.5.0.0.
Multitenant identified.
- Container database (CDB) identified via s_cdb_name is TESTCDB1
- Pluggable database (PDB) identified via s_pdb_name is TESTDB1
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.
+-----------------------------------------------------------------------------+
/u01/install/APPS/19.0.5/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml does not exist.
Extract it from patch zip file to this script execution directory and then rerun DB-ETCC.
WARNING: ETCC did not run successfully. Run the command '/u01/install/APPS/19.5.0/appsutil/etcc/checkDBpatch.sh contextfile=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml' from commandline and make sure it completes successfully. Failure to do so might result in ADOP related issues.
5.LISTENER CREATION:
*******************
Create the listener.ora and tnsnames.ora for the Target Database
/u01/install/APPS/19.5.0/appsutil
$ . txkSetCfgCDB.env -dboraclehome=/u01/install/APPS/19.5.0
Oracle Home being passed: /u01/install/APPS/19.5.0
$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/u01/install/APPS/19.5.0 -cdbname=TESTCDB1 -cdbsid=TESTCDB1 -dbport=1536 -outdir=$ORACLE_HOME/appsutil/log -israc=no
$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/u01/install/APPS/19.5.0 -cdbname=TESTCDB1 -cdbsid=TESTCDB1 -dbport=1536 -outdir=$ORACLE_HOME/appsutil/log -israc=no
Script Name : txkGenCDBTnsAdmin.pl
Script Version : 120.0.12020000.1
Started : Fri Nov 20 06:01:01 EST 2020
Log File : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/txkGenCDBTnsAdmin.log
-----------
Values used
-----------
Database Oracle Home : /u01/install/APPS/19.5.0
CDB NAME : TESTCDB1
CDB SID : TESTCDB1
Database port : 1536
OUT Directory : /u01/install/APPS/19.5.0/appsutil/log
Is RAC? : no
Virtual Hostname :
=========================
Validating oracle home...
=========================
Oracle Home: /u01/install/APPS/19.5.0 exists.
===========================
Validating out directory...
===========================
Out directory: /u01/install/APPS/19.5.0/appsutil/log exists.
============================
Inside getDBHostDetails()...
============================
DB Hostname : <hostname>
DB Domain : chainsys.com
=====================
Inside getDBPort()...
=====================
DB Port passed as an argument, using the same.
DB Port: 1536
======================================
Inside generateCDBTNSAdminContent()...
======================================
Creating the directory: /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_bkp
Creating the directory: /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp
listener_template: listener_ora_cdb_db19.tmp
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/template/listener_ora_cdb_db19.tmp
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/listener.ora
===================================
Inside replaceContextVariables()...
===================================
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/network/admin/listener.ora
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_bkp/listener.ora
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/listener.ora
TARGET : /u01/install/APPS/19.5.0/network/admin/listener.ora
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/template/tnsnames_ora_cdb_db121.tmp
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/tnsnames.ora
==================================
Inside replaceContextVariables()...
===================================
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/network/admin/tnsnames.ora
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_bkp/tnsnames.ora
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/tnsnames.ora
TARGET : /u01/install/APPS/19.5.0/network/admin/tnsnames.ora
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/template/sqlnet_ora_cdb_db19.tmp
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/sqlnet.ora
===================================
Inside replaceContextVariables()...
===================================
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/network/admin/sqlnet.ora
TARGET : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_bkp/sqlnet.ora
Copying the file
----------------
SOURCE : /u01/install/APPS/19.5.0/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Nov_20_06_01_01_2020/tns_admin_cdb_temp/sqlnet.ora
TARGET : /u01/install/APPS/19.5.0/network/admin/sqlnet.ora
Exiting from the script.
Ended: Fri Nov 20 06:01:01 EST 2020
5.1 Start the listener for the target container database as follows:
****************************************************************
$ cd /u01/install/APPS/19.5.0/appsutil/scripts/TESTDB1_<hostname>
$ ./adcdblnctl.sh start TESTCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/adcdblnctl.txt
You are running adcdblnctl.sh version 120.0.12020000.1
Starting listener process TESTCDB1 ...
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 20-NOV-2020 06:19:35
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/install/APPS/19.5.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/install/APPS/19.5.0/network/admin/listener.ora
Log messages written to /u01/install/APPS/19.5.0/log/diag/tnslsnr/<hostname>/TESTCDB1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.itesss.com)(PORT=1536)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>.itess.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias TESTCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 20-NOV-2020 06:19:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/APPS/19.5.0/network/admin/listener.ora
Listener Log File /u01/install/APPS/19.5.0/log/diag/tnslsnr/<hostname>/TESTCDB1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.itess.com)(PORT=1536)))
The listener supports no services
The command completed successfully
adcdblnctl.sh: exiting with status 0
adcdblnctl.sh: check the logfile /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/adcdblnctl.txt for more information ...
6.Restore and Start the Target Database:
**************************************
RMAN Duplicate Without Connecting to Target Database,
6.1 Create Target Database directoy manually,
DATA_TOP Directories,
DATA_TOP Location 1 :
$ mkdir -p /u01/install/oradata/EBSCDB/pdbseed
Audit File Destination Directory,
Audit File Directory :
$ mkdir -p /u01/install/admin/EBSCDB/adump
Diag file directory :
$ mkdir -p /u01/install/diag
6.2 Do the following changes in Parameter file
$ mv initEBSCDB.ora initTESTCDB1.ora
*.local_listener="(ADDRESS =(PROTOCOL = TCP)(HOST = <hostname>.iess.com)(PORT = 1536)"
*.log_archive_format='%t_%s_%r.dbf'
*.db_name='EBSCDB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTCDB1XDB)'
*.diagnostic_dest='/u01/install'
*.audit_file_dest='/u01/install/admin/EBSCDB/adump'
*.db_file_name_convert=('/u01/install/oradata/EBSCDB','/u01/install/oradata/EBSCDB','/u01/install/oradata/EBSCDB/pdbseed','/u01/install/oradata/EBSCDB/pdbseed','/u01/install/APPS/data','/u01/install/APPS/data','/u01/install/APPS/19c/dbs/arch','/u01/install/APPS/data/archive')
*.log_file_name_convert=('/u01/install/oradata/EBSCDB','/u01/install/oradata/EBSCDB','/u01/install/oradata/EBSCDB/pdbseed','/u01/install/oradata/EBSCDB/pdbseed','/u01/install/APPS/data','/u01/install/APPS/data','/u01/install/APPS/19c/dbs/arch','/u01/install/APPS/data/archive')
6.3 Prepare for duplicate by starting the auxiliary instance
$ cd /u01/install/APPS/19.5.0
$ . TESTCDB1_<hostname>.env
$ cd /u01/install/APPS/19.5.0/dbs
$ sqlplus "/as sysdba"
$ startup nomount pfile='initTESTCDB1.ora';
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated
ORACLE instance started.
Total System Global Area 1.7180E+10 bytes
Fixed Size 12856800 bytes
Variable Size 872415232 bytes
Database Buffers 1.6274E+10 bytes
Redo Buffers 20643840 bytes
This will nomount the instance using the initTESTCDB1.ora created.
Create RMAN script
$ cat RMAN_DUPLICATE.sql
run
{
allocate auxiliary channel t1 type disk;
duplicate database to TESTCDB1 backup location '/u01/install/APPS/DB_BK_10112020/' NOFILENAMECHECK;
release channel t1;
}
6.4 Connect and run the duplicate command
$ rman auxiliary / cmdfile=RMAN_DUPLICATE.sql log=RMAN_Duplicate_20NOVr20.log
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
6.5 Start the database in Noarchivelog Mode,
startup database in mount
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> create spfile from pfile;
SQL> shut immediate;
SQL> startup;
7. Pluggable Database Name change:
*******************************
If the PDB name needs to be changed,
$ cd /u01/install/APPS/19.5.0/appsutil
$ . txkSetCfgCDB.env dboraclehome=/u01/install/APPS/19.5.0
export ORACLE_SID=TESTCDB1
sqlplus "/as sysdba"
SQL> alter pluggable database "EBSDB" close;
SQL> alter pluggable database "EBSDB" unplug into '/u01/install/APPS/19.5.0/dbs/EBSDB_PDBDesc.xml';
SQL> drop pluggable database "EBSDB";
SQL> create pluggable database "TESTDB1" using '/u01/install/APPS/19.5.0/dbs/EBSDB_PDBDesc.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_EBSDB','ebs_TESTDB1','EBSDB_ebs_patch','TESTDB1_ebs_patch');
SQL> alter pluggable database "TESTDB1" open read write;
SQL> alter pluggable database all open;
SQL> alter pluggable database all save state instances=all;
8.Run the library update script against the Oracle database:
**********************************************************
$ cd <ORACLE_HOME>/appsutil/install/<CONTEXT_NAME>
$ sqlplus / as sysdba @adupdlib.sql <libext>
Where <libext> should be set to sl for HP-UX, so for any other UNIX platform,
$ cd /u01/install/APPS/19.5.0/appsutil/install/TESTDB1_<hostname>
$ sqlplus / as sysdba @adupdlib.sql so
9.UTL_FILE_DIRECTORY :
************************
Modify URL_FILE_DIR Parameter:
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml -oraclehome=/u01/install/APPS/19.5.0 -outdir=/u01/install/APPS/19.5.0/appsutil/log -mode=getUtlFileDir
Enter the APPS Password:
Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.7
Started : Sat Nov 21 06:09:21 EST 2020
Log File : /u01/install/APPS/19.5.0/appsutil/log/TXK_UTIL_DIR_Sat_Nov_21_06_09_18_2020/txkCfgUtlfileDir.log
Context file: /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml exists.
=========================================================================
Successfully generated the below file with UTL_FILE_DIR content:
/u01/install/APPS/19.5.0/dbs/TESTDB1_utlfiledir.txt
=========================================================================
Completed : Sat Nov 21 06:09:29 EST 2020
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
$ cat TESTDB1_utlfiledir.txt
#############################################################################
# This file stores the UTL FILE DIR parameter values used #
# by various EBS product teams #
# #
# ***** DO NOT CHANGE THE NAME OR LOCATION OF THIS FILE ***** #
# #
# IMPORTANT NOTES: #
# ================ #
# #
# 1. OS path should not be a symbolic link #
# #
# 2. OS path given in the list should physically exist with proper #
# permissions #
# #
# 3. OS path /usr/tmp which generally is a symbolic link is replaced with #
# <ORACLE_BASE>/temp/<PDB_NAME> #
# #
# Make sure that OS path <ORACLE_BASE>/temp/<PDB_NAME> exists #
# #
# 4. <APPLPTMP> variable on Apps Tier should match with one of the OS paths #
# in the list. Otherwise you need to modify <APPLPTMP> on all Apps tiers #
# and run Autoconfig #
# #
# 5. Ensure that all the paths defined in this file exist physically on the #
# server #
# #
# 6. Maximum allowed length of UTL_FILE_DIR parameter (combined length of #
# all paths separated by commas) is 4000 characters, hence ensure that #
# value does not exceed the limit #
# #
#===========================================================================#
# For reference, original contents of UTL_FILE_DIR without any updates are #
# retained in below file: #
# #
# /u01/install/APPS/19.5.0/appsutil/log/TXK_UTIL_DIR_Sat_Nov_21_06_09_18_2020/TESTDB1_utlfiledir.txt
#############################################################################
/u01/install/APPS/temp/EBSDB
/u01/install/APPS/19c/appsutil/outbound/EBSDB_apps
/u01/install/APPS/temp/EBSDB
New UTL file Location:
**********************
/u01/install/APPS/temp/TESTDB1
/u01/install/APPS/19.5.0/appsutil/outbound/EBSDB_apps
/u01/install/APPS/temp/TESTDB1
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml -oraclehome=/u01/install/APPS/19.5.0 -outdir=/u01/install/APPS/19.5.0/appsutil/log -mode=setUtlFileDir
Enter the APPS Password:
Enter the SYSTEM Password:
Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.7
Started : Sat Nov 21 06:48:39 EST 2020
Log File : /u01/install/APPS/19.5.0/appsutil/log/TXK_UTIL_DIR_Sat_Nov_21_06_48_32_2020/txkCfgUtlfileDir.log
Context file: /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml exists.
Value for s_applptmp on Apps Tier nodes is valid
Completed : Sat Nov 21 06:49:12 EST 2020
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
10.Database Autoconfiq:
$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/11210854/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/install/APPS/19.5.0
Classpath : :/u01/install/APPS/19.5.0/jdbc/lib/ojdbc8.jar:/u01/install/APPS/19.5.0/appsutil/java/xmlparserv2.jar:/u01/install/APPS/19.5.0/appsutil/java:/u01/install/APPS/19.5.0/jlib/netcfg.jar:/u01/install/APPS/19.5.0/jlib/ldapjclnt19.jar
Using Context file : /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.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 db19
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
11.Configure the Target Database:
*******************************
$ . TESTDB1_<hostname>.env
$ cd $ORACLE_HOME/appsutil/
$ ls
admin checkMTpatch.log TESTDB1_<hostname>.xml etcc log outbound sql txkSetCfgCDB.env_18Nov
bin checkMTpatch.sh TESTDB1_<hostname>.xml21bkp html LOGFILE p17537119_R12_GENERIC.zip temp
checkDBpatch.cmd clone TESTDB1_<hostname>.xmlBKKP install media perl temp_checkDBpatch_31678
checkDBpatch.sh db TESTDB1_<hostname>.xmlbkp21 java mw README.txt template
checkMTpatch.cmd driver EBSDB_apps.xmlbkp jre out scripts txkSetCfgCDB.env
$ cd clone/
$ ls
adlnkoh.sh bin context data dbts html jlib jre oui ouicli.pl
$ cd bin/
$ ls
adcfgclone.pl adclonectx.pl CloneContext_1120053914.log CloneContext_1121035406.log log
adchkutl.sh adclone.pl CloneContext_1121024857.log CloneContext_1121050454.log
$ perl adcfgclone.pl dbconfig /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.63
Enter the APPS password :
Running Rapid Clone with command:
Running:
perl /u01/install/APPS/19.5.0/appsutil/clone/bin/adclone.pl java=/u01/install/APPS/19.5.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/APPS/19.5.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml showProgress contextValidated=false
Beginning dbconfig Apply - Sat Nov 21 09:00:43 2020
/u01/install/APPS/19.5.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/install/APPS/19.5.0/oui -classpath /u01/install/APPS/19.5.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/ojdbc8.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/java:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/share.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/oui/srvm.jar:/u01/install/APPS/19.5.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml -stage /u01/install/APPS/19.5.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection
APPS Password : Log file located at /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/ApplyDatabase_11210900.log
| 0% completed
Log file located at /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/ApplyDatabase_11210900.log
| 30% completed
Completed Apply...
Sat Nov 21 09:02:15 2020
Starting database listener for TESTDB1:
Running:
/u01/install/APPS/19.5.0/appsutil/scripts/TESTDB1_<hostname>/addlnctl.sh start TESTCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process TESTCDB1 ...
Listener TESTCDB1 has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/APPS/19.5.0/appsutil/log/TESTDB1_<hostname>/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: /u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Using context file from command line argument:
/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml
Starting Database EBS Technology Codelevel Checker, Version 120.81
Sat Nov 21 09:02:16 EST 2020
Log file for this session : /u01/install/APPS/19.5.0/appsutil/clone/bin/log/checkDBpatch_31144.log
Identifying database release.
Database release set to 19.5.0.0.
Multitenant identified.
- Container database (CDB) identified via s_cdb_name is TESTCDB1
- Pluggable database (PDB) identified via s_pdb_name is TESTDB1
Connecting to database.
Database connection successful.
Database TESTDB1 is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
/u01/install/APPS/19.5.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml does not exist.
Extract it from patch zip file to this script execution directory and then rerun DB-ETCC.
WARNING: ETCC did not run successfully. Run the command '/u01/install/APPS/19.5.0/appsutil/etcc/checkDBpatch.sh contextfile=/u01/install/APPS/19.5.0/appsutil/TESTDB1_<hostname>.xml' from commandline and make sure it completes successfully. Failure to do so might result in ADOP related issues.
11. APPLICATION:
$ cd /u01/install/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.63
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 /u01/install/fs1/EBSapps/comn/clone/bin/CloneContext_1121094307.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [<hostname>] :
Target System Database SID : TESTDB1
Target System Database Server Node [<hostname>] :
Target System Database Domain Name [iess.com] :
Target System Base Directory : /u01/install
Target System Base Directory set to /u01/install
Target System Current File System Base set to /u01/install/fs1
Target System Other File System Base set to /u01/install/fs2
Target System Fusion Middleware Home set to /u01/install/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /u01/install/fs2/FMW_Home
Target System Web Oracle Home set to /u01/install/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /u01/install/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/install/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /u01/install/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/install/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /u01/install/fs2/EBSapps/comn
Target System Instance Home Directory [/u01/install] :
Target System Current File System Instance Top set to /u01/install/fs1/inst/apps/TESTDB1_<hostname>
Do you want to preserve the Display [localhost:5.0] (y/n) : n
Target System Display [<hostname>:0.0] : <hostname>: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 [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] : 15
Checking the port pool 15
done: Port Pool 15 is free
Report file located at /u01/install/fs1/inst/apps/TESTDB1_<hostname>/admin/out/portpool.lst
Target System proxy port [80] :
UTL_FILE_DIR on database tier consists of the following directories.
1. /u01/install/APPS/temp/EBSDB
2. /u01/install/APPS/19c/appsutil/outbound/EBSDB_apps
3. /u01/install/APPS/temp/EBSDB
4. /u01/install/APPS/temp/TESTDB1
Choose a value which will be set as APPLPTMP value on the target node [1] : 1
The new APPL_TOP context file has been created :
/u01/install/fs1/inst/apps/TESTDB1_<hostname>/appl/admin/TESTDB1_<hostname>.xml
Check Clone Context logfile /u01/install/fs1/EBSapps/comn/clone/bin/CloneContext_1121094307.log for details.
Creating Patch file system context file.....
Log file located at /u01/install/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1121094511.log
Target System Other File System Instance Top set to /u01/install/fs2/inst/apps/TESTDB1_<hostname>
Target System Port Pool [0-99] : 20
Checking the port pool 20
done: Port Pool 20 is free
Report file located at /u01/install/fs2/inst/apps/TESTDB1_<hostname>/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/install/fs2/inst/apps/TESTDB1_<hostname>/appl/admin/TESTDB1_<hostname>.xml
Check Clone Context logfile /u01/install/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1121094511.log for details.
FMW Pre-requisite check log file location : /u01/install/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...
Configuring: Run file system....
LogFile located at /u01/install/fs1/inst/apps/TESTDB1_<hostname>/admin/log/clone/run/RCloneApplyAppstier_11210945.log
<Nov 21, 2020 10:17:06 AM EST> <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 /u01/install/fs1/inst/apps/TESTDB1_<hostname>/admin/log/clone/patch/RCloneApplyAppstier_11211023.log
Do you want to startup the Application Services for TESTDB1? (y/n) [n] : n
Services not started
Reference:
Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)
https://maharshitrivedidba.blogspot.com/2021/05/cloning-oracle-apps-r122x-rac-2.html
https://maharshitrivedidba.blogspot.com/2021/05/cloning-multi-node-oracle-apps-r122x.html
https://maharshitrivedidba.blogspot.com/2021/05/enable-rac-configurations-on-oracle.html
https://maharshitrivedidba.blogspot.com/2021/06/cloning-oracle-e-business-suite-release_1.html
Every business needs a well-designed website to help them make a good first impression on potential customers. It gives customers a good user experience and allows them to easily navigate your website. Visit our website to learn more about the website design services we provide.website design company
ReplyDelete