Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Cloning 19c ERP database
——————————–
Reference doc : Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)
Directory Structure
——————–
Same directory structure as same like source system.
SHIRAZI_DATATOP’S
———————
/proddata/oracle/PROD/apps_st/data –> PDB
/prodidx/oracle/PROD/apps_st/data –> PDB
/redo/oracle/PROD/apps_st/data –> PDB
/db/oracle/PROD/oradata/TEST –> CDB
Database Binaries path= /db/oracle/PROD/tech_st/19.0.0
Source CDB SID = TEST
Tagrget CDB SID = TEST
SOURCE PDB SID = PROD
TARGET PDB SID = PROD
=============================================================
First STEP
———-
su – root
vi /etc/oraInst.loc
edit below parameters /etc/oraInst.loc
inventory_loc=/db/oracle/PROD/oraInventory
inst_group=oinstall
chmod -Rf 775 /etc/oraInst.loc
==============================================================
Second STEP
————-
4.1.3.1 Create the Context File for a Single-Node Database
———————————————————–
>> Provide source contextfile name in below contextfile path.
cd /db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin
perl adclonectx.pl
contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml
template=/db/oracle/PROD/tech_st/19.0.0/appsutil/template/adxdbctx.tmp
output
——
Copyright (c) 2011, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adclonectx Version 120.30.12020000.22
Running:
/db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -classpath /db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/../jlib/ojdbc8.jar:/db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/../jlib/xmlparserv2.jar:/db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/../jlib/java: oracle.apps.ad.context.CloneContext -e /db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml -tmpl /db/oracle/PROD/tech_st/19.0.0/appsutil/template/adxdbctx.tmp
Enter the APPS password :
Log file located at /db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/CloneContext_0831124227.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [ebsprod] :
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] ? : n
Target System Base Directory : /db/oracle/PROD
Target Instance is RAC (y/n) [n] : n
Target System CDB Name : TEST
Target System PDB Name : PROD
Oracle OS User [oracle] :
Oracle OS Group [oinstall] :
Role separation is supported y/n [n] ? : n
Number of DATA_TOP’s on the Target System [3] : 4
Target System DATA_TOP Directory 1 : /proddata/oracle/PROD/apps_st/data
Target System DATA_TOP Directory 2 : /prodidx/oracle/PROD/apps_st/data
Target System DATA_TOP Directory 3 : /redo/oracle/PROD/apps_st/data
Target System DATA_TOP Directory 4 : /db/oracle/PROD/oradata/TEST
Specify value for OSBACKUPDBA group [oinstall] :
Specify value for OSDGDBA group [oinstall] :
Specify value for OSKMDBA group [oinstall] :
Specify value for OSRACDBA group [oinstall] :
Target System RDBMS ORACLE_HOME Directory [/db/oracle/PROD/19.0.0] : /db/oracle/PROD/tech_st/19.0.0
Do you want to preserve the Display [localhost:10.0] (y/n) : n
Target System Display [ebsprod:0.0] :
Target System Port Pool [0-99] : 2
Report file located at /db/oracle/PROD/tech_st/19.0.0/appsutil/temp/portpool.lst
New context path and file name [/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml] :
The location specified for the new contextfile would overwrite the source contextfile, which is not allowed. Please enter a different location or name.
New context path and file name [/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml] : /db/oracle/PROD/tech_st/19.0.0/appsutil/abc/PROD_ebsprod.xml
The new database context file has been created :
/db/oracle/PROD/tech_st/19.0.0/appsutil/abc/PROD_ebsprod.xml
contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/abc/PROD_ebsprod.xml
Check Clone Context logfile /db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin/CloneContext_0831124227.log for details.
===========================================================================================================================
STEP 3
——
perl adcfgclone.pl dbTechStack /db/oracle/PROD/tech_st/19.0.0/appsutil/abc/PROD_ebsprod.xml
===========================================================================================================================
4.1.5 Create the listener.ora and tnsnames.ora for the Target Database.
>> Create the listener.ora and tnsnames.ora files for the target CDB by running the following commands:
Set the environment.
On Unix:
$ cd /db/oracle/PROD/tech_st/19.0.0/appsutil
$ source ./txkSetCfgCDB.env -dboraclehome=/db/oracle/PROD/tech_st/19.0.0
cd /db/oracle/PROD/tech_st/19.0.0/appsutil/bin
perl txkGenCDBTnsAdmin.pl -dboraclehome=/db/oracle/PROD/tech_st/19.0.0 -cdbname=TEST
-cdbsid=TEST -dbport=1523 -outdir=/db/oracle/PROD/tech_st/19.0.0/appsutil/log
===========================================================================================================================
Restore Database with database
——————————
Backup location: /backup1/Sun_29_08_2021
Restore spfile:
Source CDB env.
cd /db/oracle/PROD/tech_st/19.0.0
source TEST_ebsprod.env
rman target /
startup nomount force;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/db/oracle/PROD/tech_st/19.0.0/dbs/initTEST.ora’
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1073737800 bytes
Fixed Size 8904776 bytes
Variable Size 406847488 bytes
Database Buffers 645922816 bytes
Redo Buffers 12062720 bytes
RMAN> restore spfile from ‘/backup1/Sun_29_08_2021/spfile.bkp’;
Starting restore at 31-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=506 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /backup1/Sun_29_08_2021/spfile.bkp
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 31-AUG-21
exit
conn /as sysdba
shut immediate
startup nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.6106E+10 bytes
Fixed Size 16234096 bytes
Variable Size 4026531840 bytes
Database Buffers 1.2046E+10 bytes
Redo Buffers 17317888 bytes
———————————————-
> RESTORE CONTROLFILE:
rman target /
RMAN> restore controlfile from ‘/backup1/Sun_29_08_2021/controlfile.bkp’
2> ;
Starting restore at 31-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=848 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/db/oracle/PROD/oradata/TEST/control01.ctl
output file name=/db/oracle/PROD/oradata/TEST/control02.ctl
Finished restore at 31-AUG-21
exit
conn /as sysdba
SQL> alter database mount;
Database altered.
————————————————-
> RESTORE DATAFILES:
rman target /
RMAN> catalog start with ‘/backup1/Sun_29_08_2021’;
using target database control file instead of recovery catalog
searching for all files that match the pattern /backup1/Sun_29_08_2021
List of Files Unknown to the Database
=====================================
File Name: /backup1/Sun_29_08_2021/spfile.bkp
File Name: /backup1/Sun_29_08_2021/ih07orip_1_1_29_08_2021.bkp
File Name: /backup1/Sun_29_08_2021/i907or9c_1_1_29_08_2021.bkp
File Name: /backup1/Sun_29_08_2021/gl07ophv_1_1_29_08_2021.bkp
File Name: /backup1/Sun_29_08_2021/hp07oqrh_1_1_29_08_2021.bkp
File Name: /backup1/Sun_29_08_2021/j507os7t_1_1_29_08_2021.arc
File Name: /backup1/Sun_29_08_2021/hn07oqon_1_1_29_08_2021.bkp
File Name: /backup1/Sun_29_08_2021/gs07oq66_1_1_29_08_2021.bkp
etc…..
Run below command on live on both container and pdb.
—————————————————–
set head off pages 0 feed off echo off verify off
set lines 200
spool rename_datafiles.lst
select ‘set newname for datafile ‘ || file_id || ‘ to ”/proddata/oracle/PROD/apps_st/data’ || substr(file_name,instr(file_name,’/’,-1)+1) || ”’;’ from dba_data_files ;
spool off
exit;
rename.datafiles.lst
——————-
set newname for datafile 1 to ‘/db/oracle/PROD/oradata/TEST/system01.dbf’;
set newname for datafile 3 to ‘/db/oracle/PROD/oradata/TEST/sysaux01.dbf’;
set newname for datafile 7 to ‘/db/oracle/PROD/oradata/TEST/users01.dbf’;
set newname for datafile 4 to ‘/db/oracle/PROD/oradata/TEST/undotbs01.dbf’;
set newname for datafile 27 to ‘/proddata/oracle/PROD/apps_st/data/system01.dbf’;
set newname for datafile 10 to ‘/proddata/oracle/PROD/apps_st/data/system08.dbf’;
set newname for datafile 11 to ‘/proddata/oracle/PROD/apps_st/data/system09.dbf’;
set newname for datafile 12 to ‘/proddata/oracle/PROD/apps_st/data/system07.dbf’;
set newname for datafile 13 to ‘/proddata/oracle/PROD/apps_st/data/system06.dbf’;
set newname for datafile 14 to ‘/proddata/oracle/PROD/apps_st/data/system10.dbf’;
set newname for datafile 15 to ‘/proddata/oracle/PROD/apps_st/data/system19.dbf’;
set newname for datafile 16 to ‘/proddata/oracle/PROD/apps_st/data/system18.dbf’;
set newname for datafile 17 to ‘/proddata/oracle/PROD/apps_st/data/system17.dbf’;
set newname for datafile 18 to ‘/proddata/oracle/PROD/apps_st/data/system16.dbf’;
etc ……………..
Now restore datafiles
———————–
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
allocate channel c6 device type disk;
set newname for datafile 1 to ‘/db/oracle/PROD/oradata/TEST/system01.dbf’;
set newname for datafile 3 to ‘/db/oracle/PROD/oradata/TEST/sysaux01.dbf’;
set newname for datafile 7 to ‘/db/oracle/PROD/oradata/TEST/users01.dbf’;
set newname for datafile 4 to ‘/db/oracle/PROD/oradata/TEST/undotbs01.dbf’;
set newname for datafile 27 to ‘/proddata/oracle/PROD/apps_st/data/system01.dbf’;
set newname for datafile 10 to ‘/proddata/oracle/PROD/apps_st/data/system08.dbf’;
set newname for datafile 11 to ‘/proddata/oracle/PROD/apps_st/data/system09.dbf’;
set newname for datafile 12 to ‘/proddata/oracle/PROD/apps_st/data/system07.dbf’;
set newname for datafile 13 to ‘/proddata/oracle/PROD/apps_st/data/system06.dbf’;
set newname for datafile 14 to ‘/proddata/oracle/PROD/apps_st/data/system10.dbf’;
set newname for datafile 15 to ‘/proddata/oracle/PROD/apps_st/data/system19.dbf’;
set newname for datafile 16 to ‘/proddata/oracle/PROD/apps_st/data/system18.dbf’;
set newname for datafile 17 to ‘/proddata/oracle/PROD/apps_st/data/system17.dbf’;
set newname for datafile 18 to ‘/proddata/oracle/PROD/apps_st/data/system16.dbf’;
set newname for datafile 19 to ‘/proddata/oracle/PROD/apps_st/data/system15.dbf’;
set newname for datafile 20 to ‘/proddata/oracle/PROD/apps_st/data/system14.dbf’;
set newname for datafile 21 to ‘/proddata/oracle/PROD/apps_st/data/system13.dbf’;
set newname for datafile 22 to ‘/proddata/oracle/PROD/apps_st/data/system12.dbf’;
set newname for datafile 23 to ‘/proddata/oracle/PROD/apps_st/data/system05.dbf’;
set newname for datafile 24 to ‘/proddata/oracle/PROD/apps_st/data/system04.dbf’;
set newname for datafile 25 to ‘/proddata/oracle/PROD/apps_st/data/system03.dbf’;
set newname for datafile 26 to ‘/proddata/oracle/PROD/apps_st/data/system02.dbf’;
set newname for datafile 9 to ‘/proddata/oracle/PROD/apps_st/data/system11.dbf’;
set newname for datafile 28 to ‘/proddata/oracle/PROD/apps_st/data/ctxd02.dbf’;
set newname for datafile 29 to ‘/proddata/oracle/PROD/apps_st/data/ctxd01.dbf’;
set newname for datafile 30 to ‘/proddata/oracle/PROD/apps_st/data/owad01.dbf’;
set newname for datafile 122 to ‘/proddata/oracle/PROD/apps_st/data/odm02.dbf’;
set newname for datafile 123 to ‘/proddata/oracle/PROD/apps_st/data/odm01.dbf’;
set newname for datafile 124 to ‘/proddata/oracle/PROD/apps_st/data/odm.dbf’;
set newname for datafile 31 to ‘/proddata/oracle/PROD/apps_st/data/portal01.dbf’;
set newname for datafile 32 to ‘/proddata/oracle/PROD/apps_st/data/undo03.dbf’;
set newname for datafile 33 to ‘/proddata/oracle/PROD/apps_st/data/undo02.dbf’;
set newname for datafile 34 to ‘/proddata/oracle/PROD/apps_st/data/undo01.dbf’;
set newname for datafile 35 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data03.dbf’;
set newname for datafile 36 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data02.dbf’;
set newname for datafile 37 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data01.dbf’;
set newname for datafile 38 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data27.dbf’;
set newname for datafile 39 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data26.dbf’;
set newname for datafile 40 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data25.dbf’;
set newname for datafile 41 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data24.dbf’;
set newname for datafile 42 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data23.dbf’;
set newname for datafile 43 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data22.dbf’;
set newname for datafile 44 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data21.dbf’;
set newname for datafile 45 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data20.dbf’;
set newname for datafile 46 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data19.dbf’;
set newname for datafile 47 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data18.dbf’;
set newname for datafile 48 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data17.dbf’;
set newname for datafile 49 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data16.dbf’;
set newname for datafile 50 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data15.dbf’;
set newname for datafile 51 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data14.dbf’;
set newname for datafile 52 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data13.dbf’;
set newname for datafile 53 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data12.dbf’;
set newname for datafile 54 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data11..dbf’;
set newname for datafile 55 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data10.dbf’;
set newname for datafile 56 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data09.dbf’;
set newname for datafile 57 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data08.dbf’;
set newname for datafile 58 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data07.dbf’;
set newname for datafile 59 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data06.dbf’;
set newname for datafile 60 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data05.dbf’;
set newname for datafile 61 to ‘/proddata/oracle/PROD/apps_st/data/a_txn_data04.dbf’;
set newname for datafile 62 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind05.dbf’;
set newname for datafile 63 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind04.dbf’;
set newname for datafile 64 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind03.dbf’;
set newname for datafile 65 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind02.dbf’;
set newname for datafile 66 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind01.dbf’;
set newname for datafile 67 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind15.dbf’;
set newname for datafile 68 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind14.dbf’;
set newname for datafile 69 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind16.dbf’;
set newname for datafile 70 to ‘/prodidx/oracle/PROD/apps_st/data/a_summ05.dbf’;
set newname for datafile 71 to ‘/prodidx/oracle/PROD/apps_st/data/apps_ts_tools02.dbf’;
set newname for datafile 72 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind13.dbf’;
set newname for datafile 73 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind12.dbf’;
set newname for datafile 74 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind11.dbf’;
set newname for datafile 75 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind10.dbf’;
set newname for datafile 76 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind09.dbf’;
set newname for datafile 77 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind08.dbf’;
set newname for datafile 78 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind07.dbf’;
set newname for datafile 79 to ‘/prodidx/oracle/PROD/apps_st/data/a_txn_ind06.dbf’;
set newname for datafile 80 to ‘/proddata/oracle/PROD/apps_st/data/a_ref02.dbf’;
set newname for datafile 81 to ‘/proddata/oracle/PROD/apps_st/data/a_ref01.dbf’;
set newname for datafile 82 to ‘/proddata/oracle/PROD/apps_st/data/a_ref06.dbf’;
set newname for datafile 83 to ‘/proddata/oracle/PROD/apps_st/data/a_ref07.dbf’;
set newname for datafile 84 to ‘/proddata/oracle/PROD/apps_st/data/a_ref05.dbf’;
set newname for datafile 85 to ‘/proddata/oracle/PROD/apps_st/data/a_ref04.dbf’;
set newname for datafile 86 to ‘/proddata/oracle/PROD/apps_st/data/a_ref03.dbf’;
set newname for datafile 87 to ‘/proddata/oracle/PROD/apps_st/data/a_int01.dbf’;
set newname for datafile 88 to ‘/proddata/oracle/PROD/apps_st/data/a_int04.dbf’;
set newname for datafile 89 to ‘/proddata/oracle/PROD/apps_st/data/a_int03.dbf’;
set newname for datafile 90 to ‘/proddata/oracle/PROD/apps_st/data/a_int02.dbf’;
set newname for datafile 91 to ‘/proddata/oracle/PROD/apps_st/data/a_summ01.dbf’;
set newname for datafile 92 to ‘/proddata/oracle/PROD/apps_st/data/a_summ08.dbf’;
set newname for datafile 93 to ‘/proddata/oracle/PROD/apps_st/data/a_summ07.dbf’;
set newname for datafile 94 to ‘/proddata/oracle/PROD/apps_st/data/a_summ06.dbf’;
set newname for datafile 95 to ‘/proddata/oracle/PROD/apps_st/data/a_summ04.dbf’;
set newname for datafile 96 to ‘/proddata/oracle/PROD/apps_st/data/a_summ03.dbf’;
set newname for datafile 97 to ‘/proddata/oracle/PROD/apps_st/data/a_summ02.dbf’;
set newname for datafile 98 to ‘/proddata/oracle/PROD/apps_st/data/a_nolog01.dbf’;
set newname for datafile 99 to ‘/proddata/oracle/PROD/apps_st/data/a_nolog05.dbf’;
set newname for datafile 100 to ‘/proddata/oracle/PROD/apps_st/data/a_nolog04.dbf’;
set newname for datafile 101 to ‘/proddata/oracle/PROD/apps_st/data/a_nolog03.dbf’;
set newname for datafile 102 to ‘/proddata/oracle/PROD/apps_st/data/a_nolog02.dbf’;
set newname for datafile 103 to ‘/proddata/oracle/PROD/apps_st/data/a_archive01.dbf’;
set newname for datafile 104 to ‘/proddata/oracle/PROD/apps_st/data/a_archive04.dbf’;
set newname for datafile 105 to ‘/proddata/oracle/PROD/apps_st/data/a_archive03.dbf’;
set newname for datafile 106 to ‘/proddata/oracle/PROD/apps_st/data/a_archive02.dbf’;
set newname for datafile 107 to ‘/proddata/oracle/PROD/apps_st/data/a_queue01.dbf’;
set newname for datafile 108 to ‘/proddata/oracle/PROD/apps_st/data/a_queue12.dbf’;
set newname for datafile 109 to ‘/proddata/oracle/PROD/apps_st/data/a_queue11.dbf’;
set newname for datafile 110 to ‘/proddata/oracle/PROD/apps_st/data/a_queue10.dbf’;
set newname for datafile 111 to ‘/proddata/oracle/PROD/apps_st/data/a_queue09.dbf’;
set newname for datafile 112 to ‘/proddata/oracle/PROD/apps_st/data/a_queue08.dbf’;
set newname for datafile 113 to ‘/proddata/oracle/PROD/apps_st/data/a_queue07.dbf’;
set newname for datafile 114 to ‘/proddata/oracle/PROD/apps_st/data/a_queue06.dbf’;
set newname for datafile 115 to ‘/proddata/oracle/PROD/apps_st/data/a_queue05.dbf’;
set newname for datafile 116 to ‘/proddata/oracle/PROD/apps_st/data/a_queue04.dbf’;
set newname for datafile 117 to ‘/proddata/oracle/PROD/apps_st/data/a_queue03.dbf’;
set newname for datafile 118 to ‘/proddata/oracle/PROD/apps_st/data/a_queue02.dbf’;
set newname for datafile 119 to ‘/proddata/oracle/PROD/apps_st/data/a_media01.dbf’;
set newname for datafile 120 to ‘/proddata/oracle/PROD/apps_st/data/a_media03.dbf’;
set newname for datafile 121 to ‘/proddata/oracle/PROD/apps_st/data/a_media02.dbf’;
set newname for datafile 125 to ‘/proddata/oracle/PROD/apps_st/data/olap03.dbf’;
set newname for datafile 126 to ‘/proddata/oracle/PROD/apps_st/data/olap02.dbf’;
set newname for datafile 127 to ‘/proddata/oracle/PROD/apps_st/data/olap01.dbf’;
set newname for datafile 128 to ‘/proddata/oracle/PROD/apps_st/data/olap.dbf’;
set newname for datafile 129 to ‘/proddata/oracle/PROD/apps_st/data/sysaux15.dbf’;
set newname for datafile 130 to ‘/proddata/oracle/PROD/apps_st/data/sysaux14.dbf’;
set newname for datafile 131 to ‘/proddata/oracle/PROD/apps_st/data/sysaux13.dbf’;
set newname for datafile 132 to ‘/proddata/oracle/PROD/apps_st/data/sysaux16.dbf’;
set newname for datafile 133 to ‘/proddata/oracle/PROD/apps_st/data/sysaux12.dbf’;
set newname for datafile 134 to ‘/proddata/oracle/PROD/apps_st/data/sysaux11.dbf’;
set newname for datafile 135 to ‘/proddata/oracle/PROD/apps_st/data/sysaux10.dbf’;
set newname for datafile 136 to ‘/proddata/oracle/PROD/apps_st/data/sysaux09.dbf’;
set newname for datafile 137 to ‘/proddata/oracle/PROD/apps_st/data/sysaux08.dbf’;
set newname for datafile 138 to ‘/proddata/oracle/PROD/apps_st/data/sysaux07.dbf’;
set newname for datafile 139 to ‘/proddata/oracle/PROD/apps_st/data/sysaux06.dbf’;
set newname for datafile 140 to ‘/proddata/oracle/PROD/apps_st/data/sysaux05.dbf’;
set newname for datafile 141 to ‘/proddata/oracle/PROD/apps_st/data/sysaux04.dbf’;
set newname for datafile 142 to ‘/proddata/oracle/PROD/apps_st/data/sysaux03.dbf’;
set newname for datafile 143 to ‘/proddata/oracle/PROD/apps_st/data/sysaux02.dbf’;
set newname for datafile 144 to ‘/proddata/oracle/PROD/apps_st/data/sysaux01.dbf’;
set newname for datafile 145 to ‘/proddata/oracle/PROD/apps_st/data/apps_ts_tools03.dbf’;
set newname for datafile 146 to ‘/proddata/oracle/PROD/apps_st/data/apps_ts_tools01.dbf’;
restore database;
switch datafile all;
}
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
allocate channel c6 device type disk;
set until sequence 317 thread 1;
recover database;
}
alter database open resetlogs;
SQL> alter database open resetlogs;
Database altered.
After starting database we can see now pdb and cdb tempfiles are created and only cdb logfile is created not pdb logfile
and also pdb controfile not created .
—————————————————————————————————————————
SQL> select name from v$tempfile;
NAME
——————————————————————————–
/db/oracle/PROD/oradata/TEST/temp01.dbf
/db/oracle/PROD/oradata/TEST/pdbseed/temp012020-12-30_17-56-25-271-PM.dbf
/proddata/oracle/PROD/apps_st/data/TEMP10.DBF
/proddata/oracle/PROD/apps_st/data/TEMP11.DBF
====================================================================================
source CDB env.
SQL> select status from v$instance;
STATUS
————
OPEN
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> alter pluggable database all save state instances=all;
Pluggable database altered.
====================================================================================
Run the library update script against the Oracle database.
———————————————————-
$ cd /db/oracle/PROD/tech_st/19.0.0/appsutil/install/PROD_ebsprod
$ sqlplus / as sysdba
@adupdlib.sql s1
PL/SQL procedure successfully completed.
commit;
======================================================================================
start listener
—————
Must check local listner in database and set target local listener
———————————————————————-
SQL> show parameter local;
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string ebsprod.com:1522
alter system set local_listener=’ebsprod.com:1523′;
Set your pdb tns entry in cdb tns file.
—————————————-
PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ebsprod)(PORT=1523))
(CONNECT_DATA= (SERVICE_NAME=PROD)
(INSTANCE_NAME=TEST))
)
lsnrctl start TEST <–cdb
======================================================================================
Perform the following steps to set the target UTL_FILE_DIR values in the database.(19c)
—————————————————————————————–
Source CDB ENV
——————
source /db/oracle/PROD/tech_st/19.0.0/TEST_ebsprod.env
On Unix:
$ cd /db/oracle/PROD/tech_st/19.0.0/appsutil
$ source ./txkSetCfgCDB.env -dboraclehome=/db/oracle/PROD/tech_st/19.0.0
perl /db/oracle/PROD/tech_st/19.0.0/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml
-oraclehome=/db/oracle/PROD/tech_st/19.0.0 -outdir=/db/oracle/PROD/tech_st/19.0.0/appsutil/log -mode=getUtlFileDir
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
—————————————————————————————————————————
$ cd /db/oracle/PROD/tech_st/19.0.0/appsutil
$ source ./txkSetCfgCDB.env -dboraclehome=/db/oracle/PROD/tech_st/19.0.0
cd /db/oracle/PROD/tech_st/19.0.0/appsutil/bin
$ perl /db/oracle/PROD/tech_st/19.0.0/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml
-oraclehome=/db/oracle/PROD/tech_st/19.0.0 -outdir=/db/oracle/PROD/tech_st/19.0.0/appsutil/log
-mode=setUtlFileDir
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
—————————————————————————————————————————-
perl /db/oracle/PROD/tech_st/19.0.0/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml
-oraclehome=/db/oracle/PROD/tech_st/19.0.0 -outdir=/db/oracle/PROD/tech_st/19.0.0/appsutil/log -mode=createDirObject
> Enter the OS path for which directory object needs to be created: /db/oracle/PROD/tech_st/19.0.0/appsutil/outbound/PROD_ebsprod
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
——————————————————————————————————————————
perl /db/oracle/PROD/tech_st/19.0.0/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml /
-oraclehome=/db/oracle/PROD/tech_st/19.0.0 -outdir=/db/oracle/PROD/tech_st/19.0.0/appsutil/log -mode=syncUtlFileDir /
-skipautoconfig=yes
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
—————————————————————————————————————————–
Configure the Target Database(without env source)
=================================================
cd /db/oracle/PROD/tech_st/19.0.0/appsutil/clone/bin
$ perl adcfgclone.pl dbconfig /db/oracle/PROD/tech_st/19.0.0/appsutil/PROD_ebsprod.xml
===========================================================================================================================
You can check now:
—————–
no controlfile is created by pdb and pdb is also running with TEST parameter file which is cdb pfile;
==========================================================================================================================
NOW CLONE APPLICATION Tier
————————–
Before cloning appsTier remove source ip address and hostname with below command.
source pdb env file
SQL> select SERVER_ADDRESS,HOST from fnd_nodes;
sqlplus apps/apps@PROD
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
commit;
Autoconfig is failing create below temp directory first then run autoconfig;
—————————————————————————-
mkdir -p /db/oracle/PROD/temp/PROD
run autoconfig on pdb
AutoConfig is exiting with status 0
========================================================================================================================
run postclone on appsTier
————————–
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 /apps/oracle/PROD/fs2/EBSapps/comn/clone/bin/CloneContext_0831181253.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [ebsprod] :
Target System Database SID : PROD
Target System Database Server Node [ebsprod] :
Target System Database Domain Name [com] :
Target System Base Directory : /apps/oracle/PROD
Target System Base Directory set to /apps/oracle/PROD
Target System Current File System Base set to /apps/oracle/PROD/fs2
Target System Other File System Base set to /apps/oracle/PROD/fs1
Target System Fusion Middleware Home set to /apps/oracle/PROD/fs2/FMW_Home
Target System Other File System Fusion Middleware Home set to /apps/oracle/PROD/fs1/FMW_Home
Target System Web Oracle Home set to /apps/oracle/PROD/fs2/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /apps/oracle/PROD/fs1/FMW_Home/webtier
Target System Appl TOP set to /apps/oracle/PROD/fs2/EBSapps/appl
Target System Other File System Appl TOP set to /apps/oracle/PROD/fs1/EBSapps/appl
Target System COMMON TOP set to /apps/oracle/PROD/fs2/EBSapps/comn
Target System Other File System COMMON TOP set to /apps/oracle/PROD/fs1/EBSapps/comn
Target System Instance Home Directory [/apps/oracle/PROD] :
Target System Current File System Instance Top set to /apps/oracle/PROD/fs2/inst/apps/PROD_ebsprod
Do you want to preserve the Display [ebsprod:0.0] (y/n) : n
Target System Display [ebsprod: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] :
Target System Port Pool [0-99] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /apps/oracle/PROD/fs2/inst/apps/PROD_ebsprod/admin/out/portpool.lst
RC-40201: Unable to connect to Database PROD.
Enter the Database listener port [1522] : 1523
Target System proxy port [80] :
UTL_FILE_DIR on database tier consists of the following directories.
1. /db/oracle/PROD/tech_st/temp/PROD
2. /db/oracle/PROD/tech_st/temp/PROD
3. /db/oracle/PROD/tech_st/19.0.0/appsutil/outbound/PROD_ebsprod
4. /db/oracle/PROD/tech_st/temp/PROD
5. /db/oracle/PROD/tech_st/19.0.0/temp/PROD
Choose a value which will be set as APPLPTMP value on the target node [1] : 3
The new APPL_TOP context file has been created :
/apps/oracle/PROD/fs2/inst/apps/PROD_ebsprod/appl/admin/PROD_ebsprod.xml
Check Clone Context logfile /apps/oracle/PROD/fs2/EBSapps/comn/clone/bin/CloneContext_0831181253.log for details.
Creating Patch file system context file…..
Log file located at /apps/oracle/PROD/fs2/EBSapps/comn/clone/bin/CloneContextPatch_0831181613.log
Target System Other File System Instance Top set to /apps/oracle/PROD/fs1/inst/apps/PROD_ebsprod
Target System Port Pool [0-99] : 1
Patch file system should have different port pool than Run file system..
Target System Port Pool [0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /apps/oracle/PROD/fs1/inst/apps/PROD_ebsprod/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/apps/oracle/PROD/fs1/inst/apps/PROD_ebsprod/appl/admin/PROD_ebsprod.xml
Check Clone Context logfile /apps/oracle/PROD/fs2/EBSapps/comn/clone/bin/CloneContextPatch_0831181613.log for details.
FMW Pre-requisite check log file location : /apps/oracle/PROD/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check…
Configuring: Run file system….
LogFile located at /apps/oracle/PROD/fs2/inst/apps/PROD_ebsprod/admin/log/clone/run/RCloneApplyAppstier_08311819.log
cloning started on appsTier
============================================================================================================================
