EBS 12.2.10: step by step multitenant cloning with 19c Database

 This post is not about how we normally do an EBS 12.2 cloning. You can search many blogs, articles over web. Well, in this post i am going to illustrate on how we can clone an EBS 12.2.10 environment where the Database is 19c multitenant with one CDB and one PDB. The main challenge comes when we want to do a restore the database and rename it based upon our target convention.

Did, any of the below questions come to your mind, when you are about to do these sort of clone

1. When we do a restore/recover the database which is multitenant in nature, then in the target, then how the database will be opened

2. Which script to use to achieve the multitenant clone for EBS

3. How to rename the PDB after clone

High level Steps:-

Run adpreclone on the source database and application nodes.

Back up the full Container Database (CDB) database with archives by using RMAN Hot backup and copy it to the target node.

Clean up the target database and application node.

Copy the source application binaries and database binaries to the target node.

Configure $Oracle_Home on the target database node.

Restore and recover the databases.

Perform post-restore steps on the Target database node.

Configure the application on the target application node.

Perform post-clone steps on the application node.

Start the target application services.

Steps:-

I am not going to explain the clone steps as there are already many blogs, articles available. I am going to jump directly on the main part on how to restore/recover the database. 

Create a pairs file:-

 cat pairsfile.txt

s_undo_tablespace=APPS_UNDOTS1

s_db_oh=/u02/oracle/ABCD/product/19c/db

s_dbhost=fjfjfjjfldw

s_dbSid=BORISPP2

s_pdb_name=PDB_name

s_cdb_name=cdb_name

s_base=/u02/oracle/ABCD/product/19c/base

s_dbuser=oracle

s_dbgroup=oinstall

s_dbhome1=/u03/oracle/ABCD/product/11.2.0.4/data

s_display=localhost:10.0

s_dbCluster=false

s_isDBCluster=n

s_dbport=1526

s_port_pool=6

This pairs file will be used to create the new context file.

Create the context file

perl adclonectx.pl \

contextfile=/u02/oracle/ABCD/product/19c/db/appsutil/PDB_0wbcvrjgtki7uqv.xml\

template=/u02/oracle/ABCD/product/19c/db/appsutil/template/adxdbctx.tmp \

pairsfile=/u02/oracle/ABCD/product/19c/db/appsutil/clone/pairsfile.txt

Configure the DB technology stack

perl adcfgclone.pl dbTechStack /u02/oracle/ABCD/product/19c/db/appsutil/PDB_0wbcvrjgtki7uqv.xml

Create the listener.ora and tnsnames.ora files for the target CDB by running the following commands:

1.Set the environment.

On UNIX:

$ cd /u02/oracle/ABCD/product/19c/db/appsutil

$ source ./txkSetCfgCDB.env -dboraclehome=/u02/oracle/ABCD/product/19c/db

Generate the listener.ora and tnsnames.ora.

$ cd <ORACLE_HOME>/appsutil/bin

$ perl txkGenCDBTnsAdmin.pl -dboraclehome/u02/oracle/ABCD/product/19c/db -cdbnameCDB \

-cdbsid=CDB -dbport=1526 -outdir=$ORACLE_HOME/appsutil/log \

where:

Parameter Description

Cdbname Name of the target container database.

Cdbsid Oracle SID of the target container database instance.

• For single-node database, the value is same as the cdbname.

• For Oracle RAC database, it is the Instance name of the target database.

Israc • Provide the value 'yes' for an Oracle RAC database.

• Provide the value 'no' for a single-node database.

virtualhostname Virtual hostname for the Oracle RAC database. For a single-node database, this parameter should not be used.

Start the listener for the target container database as follows:

On UNIX:

$ cd /u02/oracle/ABCD/product/19c/db/appsutil/scripts/PDB_0wbcvrjgtki7uqv.xml

./adcdblnctl.sh start CDB

Restore the database(Delete the existing datafiles if any before starting the process)

   Start the target in nomount using temporary init/spfile

 

 

set -x export TIMESTAMP=`date +%Y%m%d` export BACKUP_BASE=/u02/oracle/ABCD/product/19c/base export LOGFILE=/u02/oracle/ABCD/product/19c/base/DB_Duplicate-${TIMESTAMP}.log touch ${LOGFILE} rman log=${LOGFILE} << EOF connect auxiliary / run { allocate auxiliary channel aux1 device type disk; allocate auxiliary channel aux2 device type disk; allocate auxiliary channel aux3 device type disk; allocate auxiliary channel aux4 device type disk; allocate auxiliary channel aux5 device type disk; allocate auxiliary channel aux6 device type disk; allocate auxiliary channel aux7 device type disk; allocate auxiliary channel aux8 device type disk; allocate auxiliary channel aux9 device type disk; allocate auxiliary channel aux10 device type disk; allocate auxiliary channel aux11 device type disk; allocate auxiliary channel aux12 device type disk; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind02.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind02.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind10.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind10.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind15.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind15.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind21.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind21.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind33.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind33.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind38.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind38.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind46.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind46.dbf'; set newname for datafile '/u03/oracle/ABCD/product/11.2.0.4/data/a_txn_ind47.dbf' to '/binaries/oracle/ABCD/data/a_txn_ind47.dbf'; duplicate database to 'CDB' backup location '/binaries/BKP_12210_TST002' nofilenamecheck; release channel aux1; release channel aux2; release channel aux3; release channel aux4; release channel aux5; release channel aux6; release channel aux7; release channel aux8; release channel aux9; release channel aux10; release channel aux11; release channel aux12; } EOF echo >> ${LOGFILE}

The DB will be open read write mode and the PDB name will have the source PDB name. Thus we will have to rename it based upon our target value

Rename the PDB

If any service already exists with the Target PDB name, delete it as follows:

[oracle@ABCD db]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 22 11:05:42 2021

Version 19.11.0.0.0

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

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> alter session set container="ABCDT02";

Session altered.

Run the following steps to rename the PDB.

[oracle@ABCD dbs]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 22 11:18:31 2021

Version 19.11.0.0.0

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

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> alter pluggable database "ABCDT02" close;

alter pluggable database "ABCDT02" close

*

ERROR at line 1:

ORA-65020: pluggable database ABCDT02 already closed

SQL> alter pluggable database "ABCDT02" unplug into '/u02/oracle/ABCD/product/19c/db/dbs/ABCDT02_PDBDesc.xml';

Pluggable database altered.

SQL> drop pluggable database "ABCDT02";

Pluggable database dropped.

SQL> create pluggable database "ABCDPP2" using '/u02/oracle/ABCD/product/19c/db/dbs/ABCDT02_PDBDesc.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_ABCDT02','ebs_ABCDPP2','ABCDT02_ebs_patch','ABCDPP2_ebs_patch');

Pluggable database created.

SQL> alter pluggable database "ABCDPP2" open read write;

Pluggable database altered.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

SQL>

Run the library update script against the Oracle database.

cd <ORACLE_HOME>/appsutil/install/<CONTEXT_NAME>

$ sqlplus / as sysdba @adupdlib.sql <libext>

Store the target UTL_FILE_DIR values in the target database

You can refer my earlier blog https://samappsdba.blogspot.com/2020/12/upgrade-EBS-12.2-database-12c12.1.0.2-to-19c19.3-Part-1.html on how to do this.

Configure the target database

cd /u02/oracle/ABCD/product/19c/db/appsutil/clone/bin

$ perl adcfgclone.pl dbconfig contextfile

In every cloning methodology, database cloning is the most vital part and if that is complete, half of the work is done. The application clone can be configured by using the adcfgclone.pl appsTier dualfs option, the steps for which i have not covered here and which is very straightforward.

I hope this can be helpful to someone. Till then happy learning

References:-Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)