Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB
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
CONTAINER DB NAME=EBSCDB1
pluggable DB NAMe=EBSDB1
1. I got new server , so that I checked prerequest
**************************************************
Red Hat Enterprise Linux Server release 7.7 (Maipo)
Use the “oracle-database-preinstall-19c” package to perform all your prerequisite setup.
# yum install -y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
2. Backup Move:
***************
Backup move from source to target
3.Context file Creation:
************************
@ /u01/install/APPS/19.5.0/appsutil/clone/bin
Create the Context File for a Single-Node Database,
[oracle@dlx19cvis bin]$ cd ..
[oracle@dlx19cvis appsutil]$ cd clone/
[oracle@dlx19cvis clone]$ cd bin/
[oracle@dlx19cvis bin]$ 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
[oracle@dlx19cvis bin]$ 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) [dlx19cvis] :
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 : EBSCDB1
Target System PDB Name : EBSDB1
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 [dlx19cvis:0.0] : dlx19cvis: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/EBSDB1_dlx19cvis.xml
contextfile=/u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.xml
Check Clone Context logfile /u01/install/APPS/19.5.0/appsutil/clone/bin/CloneContext_1111070107.log for details.
[oracle@dlx19cvis bin]$
Also Created the required (s_outbound_dir) directory,
cat EBSDB1_dlx19cvis.xml | grep -i s_outbound_dir
[oracle@dlx19cvis appsutil]$ cat EBSDB1_dlx19cvis.xml | grep -i s_outbound_dir
<OUTBOUND_DIR oa_var=”s_outbound_dir”>/u01/install/APPS/19.5.0/appsutil/outbound/EBSDB1_dlx19cvis</OUTBOUND_DIR>
mkdir -p /u01/install/APPS/19.5.0/appsutil/outbound/EBSDB1_dlx19cvis
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,
oracle@dlx19cvis bin]$ 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
[oracle@dlx19cvis bin]$ export PATH=/u01/install/APPS/19.5.0/bin:$PATH
[oracle@dlx19cvis bin]$ export LD_LIBRARY_PATH=/u01/install/APPS/19.5.0/lib
[oracle@dlx19cvis bin]$ perl adcfgclone.pl dbTechStack /u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.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_dlx19cvis.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_dlx19cvis.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_dlx19cvis/ApplyDBTechStack_11190430.log
| 0% completed
Log file located at /u01/install/APPS/19.5.0/appsutil/log/EBSDB_dlx19cvis/ApplyDBTechStack_11190430.log
| 100% completed
Completed Apply…
Thu Nov 19 04:33:15 2020
Starting database listener for EBSDB1:
Running:
/u01/install/APPS/19.5.0/appsutil/scripts/EBSDB_dlx19cvis/addlnctl.sh start EBSCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/EBSDB_dlx19cvis/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process EBSCDB1 …
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/EBSDB1_dlx19cvis/listener.ora
Log messages written to /u01/install/APPS/19.5.0/admin/EBSDB1_dlx19cvis/diag/tnslsnr/dlx19cvis/ebscdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dlx19cvis.itess.com)(PORT=1536))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dlx19cvis.itess.com)(PORT=1536)))
STATUS of the LISTENER
————————
Alias EBSCDB1
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_dlx19cvis/listener.ora
Listener Log File /u01/install/APPS/19c/admin/EBSDB_dlx19cvis/diag/tnslsnr/dlx19cvis/ebscdb/alert/log.xml
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dlx19cvis.itess.com)(PORT=1536)))
STATUS of the LISTENER
————————
Alias EBSCDB1
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/EBSDB1_dlx19cvis/listener.ora
Listener Log File /u01/install/APPS/19.5.0/admin/EBSDB_dlx19cvis/diag/tnslsnr/dlx19cvis/ebscdb/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dlx19cvis.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/EBSDB1_dlx19cvis/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/EBSDB1_dlx19cvis.xml
Using context file from command line argument:
/u01/install/APPS/19c/appsutil/EBSDB1_dlx19cvis.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 EBSCDB1
– Pluggable database (PDB) identified via s_pdb_name is EBSDB1
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/EBSDB1_dlx19cvis.xml’ from commandline and make sure it completes successfully. Failure to do so might result in ADOP related issues.
[oracle@dlx19cvis bin]$
5.LISTENER CREATION:
*******************
Create the listener.ora and tnsnames.ora for the Target Database
/u01/install/APPS/19.5.0/appsutil
[oracle@dlx19cvis 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=EBSCDB1 -cdbsid=EBSCDB1 -dbport=1536 -outdir=$ORACLE_HOME/appsutil/log -israc=no
[oracle@dlx19cvis bin]$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/u01/install/APPS/19.5.0 -cdbname=EBSCDB1 -cdbsid=EBSCDB1 -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 : EBSCDB1
CDB SID : EBSCDB1
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 : dlx19cvis
DB Domain : xyz.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:
****************************************************************
[oracle@dlx19cvis bin]$
@ /u01/install/APPS/19.5.0/appsutil/scripts/EBSDB1_dlx19cvis
[oracle@dlx19cvis EBSDB1_dlx19cvis]$ ./adcdblnctl.sh start EBSCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/EBSDB1_dlx19cvis/adcdblnctl.txt
You are running adcdblnctl.sh version 120.0.12020000.1
Starting listener process EBSCDB1 …
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/dlx19cvis/ebscdb1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dlx19cvis.itesss.com)(PORT=1536)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dlx19cvis.itess.com)(PORT=1536)))
STATUS of the LISTENER
————————
Alias EBSCDB1
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/dlx19cvis/ebscdb1/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dlx19cvis.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/EBSDB1_dlx19cvis/adcdblnctl.txt for more information …
[oracle@dlx19cvis EBSDB1_dlx19cvis]$
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 initEBSCDB1.ora
*.local_listener=”(ADDRESS =(PROTOCOL = TCP)(HOST = dlx19cvis.iess.com)(PORT = 1536)”
*.log_archive_format=’%t_%s_%r.dbf’
*.db_name=’EBSCDB’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=EBSCDB1XDB)’
*.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
$ . EBSCDB1_dlx19cvis.env
$ cd /u01/install/APPS/19.5.0/dbs
$ sqlplus “/as sysdba”
$ startup nomount pfile=’initEBSCDB1.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 initEBSCDB1.ora created.
Create RMAN script
[oracle@dlx19cvis APPS]$ cat RMAN_DUPLICATE.sql
run
{
allocate auxiliary channel t1 type disk;
duplicate database to EBSCDB1 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=EBSCDB1
sqlplus “/as sysdba”
alter pluggable database “EBSDB” close;
alter pluggable database “EBSDB” unplug into ‘/u01/install/APPS/19.5.0/dbs/EBSDB_PDBDesc.xml’;
drop pluggable database “EBSDB”;
create pluggable database “EBSDB1” using ‘/u01/install/APPS/19.5.0/dbs/EBSDB_PDBDesc.xml’ NOCOPY SERVICE_NAME_CONVERT=(‘ebs_EBSDB’,’ebs_EBSDB1′,’EBSDB_ebs_patch’,’EBSDB1_ebs_patch’);
alter pluggable database “EBSDB1” open read write;
alter pluggable database all open;
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,
/u01/install/APPS/19.5.0/appsutil/install/EBSDB1_dlx19cvis
$ sqlplus / as sysdba @adupdlib.sql so
9.UTL_FILE_DIRECTORY :
************************
Modify URL_FILE_DIR Parameter:
[oracle@dlx19cvis bin]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis.xml exists.
==============================================================================
Successfully generated the below file with UTL_FILE_DIR content:
/u01/install/APPS/19.5.0/dbs/EBSDB1_utlfiledir.txt
==============================================================================
Completed : Sat Nov 21 06:09:29 EST 2020
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
[oracle@dlx19cvis dbs]$ cat EBSDB1_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/EBSDB1_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/EBSDB1
/u01/install/APPS/19.5.0/appsutil/outbound/EBSDB_apps
/u01/install/APPS/temp/EBSDB1
[oracle@dlx19cvis bin]$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis.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
[oracle@dlx19cvis bin]$
10.Database Autoconfiq:
[oracle@dlx19cvis EBSDB1_dlx19cvis]$
[oracle@dlx19cvis EBSDB1_dlx19cvis]$
[oracle@dlx19cvis EBSDB1_dlx19cvis]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/install/APPS/19.5.0/appsutil/log/EBSDB1_dlx19cvis/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/EBSDB1_dlx19cvis.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:
*******************************
[oracle@dlx19cvis 19.5.0]$ . EBSDB1_dlx19cvis.env
[oracle@dlx19cvis 19.5.0]$ cd appsutil/
[oracle@dlx19cvis appsutil]$ ls
admin checkMTpatch.log EBSDB1_dlx19cvis.xml etcc log outbound sql txkSetCfgCDB.env_18Nov
bin checkMTpatch.sh EBSDB1_dlx19cvis.xml21bkp html LOGFILE p17537119_R12_GENERIC.zip temp
checkDBpatch.cmd clone EBSDB1_dlx19cvis.xmlBKKP install media perl temp_checkDBpatch_31678
checkDBpatch.sh db EBSDB1_dlx19cvis.xmlbkp21 java mw README.txt template
checkMTpatch.cmd driver EBSDB_apps.xmlbkp jre out scripts txkSetCfgCDB.env
[oracle@dlx19cvis appsutil]$ cd clone/
[oracle@dlx19cvis clone]$ ls
adlnkoh.sh bin context data dbts html jlib jre oui ouicli.pl
[oracle@dlx19cvis clone]$ cd bin/
[oracle@dlx19cvis bin]$ ls
adcfgclone.pl adclonectx.pl CloneContext_1120053914.log CloneContext_1121035406.log log
adchkutl.sh adclone.pl CloneContext_1121024857.log CloneContext_1121050454.log
[oracle@dlx19cvis bin]$ perl adcfgclone.pl dbconfig /u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis/ApplyDatabase_11210900.log
| 0% completed
Log file located at /u01/install/APPS/19.5.0/appsutil/log/EBSDB1_dlx19cvis/ApplyDatabase_11210900.log
| 30% completed
Completed Apply…
Sat Nov 21 09:02:15 2020
Starting database listener for EBSDB1:
Running:
/u01/install/APPS/19.5.0/appsutil/scripts/EBSDB1_dlx19cvis/addlnctl.sh start EBSCDB1
Logfile: /u01/install/APPS/19.5.0/appsutil/log/EBSDB1_dlx19cvis/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process EBSCDB1 …
Listener EBSCDB1 has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/APPS/19.5.0/appsutil/log/EBSDB1_dlx19cvis/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/EBSDB1_dlx19cvis.xml
Using context file from command line argument:
/u01/install/APPS/19.5.0/appsutil/EBSDB1_dlx19cvis.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 EBSCDB1
– Pluggable database (PDB) identified via s_pdb_name is EBSDB1
Connecting to database.
Database connection successful.
Database EBSDB1 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/EBSDB1_dlx19cvis.xml’ from commandline and make sure it completes successfully. Failure to do so might result in ADOP related issues.
11. APPLICATION:
[oracle@dlx19cvis bin]$ pwd
/u01/install/fs1/EBSapps/comn/clone/bin
[oracle@dlx19cvis 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) [dlx19cvis] :
Target System Database SID : EBSDB1
Target System Database Server Node [dlx19cvis] :
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/EBSDB1_dlx19cvis
Do you want to preserve the Display [localhost:5.0] (y/n) : n
Target System Display [dlx19cvis:0.0] : dlx19cvis: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/EBSDB1_dlx19cvis/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/EBSDB1
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/EBSDB1_dlx19cvis/appl/admin/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis
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/EBSDB1_dlx19cvis/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/install/fs2/inst/apps/EBSDB1_dlx19cvis/appl/admin/EBSDB1_dlx19cvis.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/EBSDB1_dlx19cvis/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/EBSDB1_dlx19cvis/admin/log/clone/patch/RCloneApplyAppstier_11211023.log
Do you want to startup the Application Services for EBSDB1? (y/n) [n] : n
Services not started
Oracle EBS 12.2 Cloning using RMAN Backup Step by Steps
Refer : Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)
Thanks …..