Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB

 

 

 

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 …..

Quora

 

 

 

 

 

 

Leave a Comment

Your email address will not be published.