Oracle Apps/DBA: 11 Oracle EBS 12.2.14 Clone with 19c Database

11.1 RUN AD PRE-CLONE UTILITY on DB and APPS Nodes

11.1.1 Make sure the cdb listener and database (CDB and PDB) is running

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

FUNCDB READ WRITE

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 FBS READ WRITE NO

11.1.2 Make sure etcc folder is present in Oracle home/appsutil

/u01/app/FBS/db/tech_st/19c/appsutil/etcc

If it is not present

mkdir -p /u01/app/FBS/db/tech_st/19c/appsutil/etcc

Download patch 17537119(latest) from My Oracle Support, unzip it under /u01/app/FBS/db/tech_st/19c/appsutil/etcc and run /u01/app/FBS/db/tech_st/19c/appsutil/etcc/checkDBpatch.sh to avoid ADOP related issues.

Before running /u01/app/FBS/db/tech_st/19c/appsutil/etcc/checkDBpatch.sh source the pluggable database (PDB) environment file.

Multitenant identified.

- Container database (CDB) identified via s_cdb_name is funcdb

- Pluggable database (PDB) identified via s_pdb_name is FBS

11.1.3 Run the following commands to source the pluggable database (PDB) environment file on the database node at $ORACLE_HOME

cd $ORACLE_HOME

. <PDB_NAME>_hostname.env

cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

perl adpreclone.pl dbTier

[oracle@fbsebs 19c]$ . FBS_fbsebs.env

[oracle@fbsebs 19c]$ cd appsutil/scripts/FBS_fbsebs/

[oracle@fbsebs FBS_fbsebs]$ ls

adautocfg.sh adcdblnctl.sh addbctl.sh adexecsql.pl adstopcdb.sql adstrtcdb.sql

adcdbctl.sh adchknls.pl addlnctl.sh adpreclone.pl adstopdb.sql adstrtdb.sql

[oracle@fbsebs FBS_fbsebs]$ perl adpreclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.28

Enter the APPS User Password:

Verifying if Database Patch checker (ETCC) exists in /u01/app/FBS/db/tech_st/19c/appsutil/etcc

Enter value for 1: Enter value for 2: Enter value for 3: Version of /u01/app/FBS/db/tech_st/19c/appsutil/etcc/checkDBpatch.sh is 120.127

Running:

perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/adclone.pl java=/u01/app/FBS/db/tech_st/19c/appsutil/jre mode=stage stage=/u01/app/FBS/db/tech_st/19c/appsutil/clone component=dbTier method=CUSTOM dbctx=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml showProgress

Beginning database tier Stage - Wed Jan 8 11:33:28 2025

/u01/app/FBS/db/tech_st/19c/appsutil/jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/app/FBS/db/tech_st/19c/oui -classpath /u01/app/FBS/db/tech_st/19c/lib/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/jdbc/lib/ojdbc8.jar::/u01/app/FBS/db/tech_st/19c/appsutil/java:/u01/app/FBS/db/tech_st/19c/jlib/orai18n.jar:/u01/app/FBS/db/tech_st/19c/oui/jlib/OraInstaller.jar:/u01/app/FBS/db/tech_st/19c/oui/jlib/ewt3.jar:/u01/app/FBS/db/tech_st/19c/oui/jlib/share.jar:/u01/app/FBS/db/tech_st/19c/oui/jlib/srvm.jar:/u01/app/FBS/db/tech_st/19c/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml -stage /u01/app/FBS/db/tech_st/19c/appsutil/clone -tmp /tmp -method CUSTOM -showProgress

APPS Password :

Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_fbsebs/StageDBTier_01081133.log

/ 79% completed

Completed Stage...

Wed Jan 8 11:33:43 2025

This is a CDB instance. Hence not checking duplicate data files.

11.1.4 d) Run the following commands on the application node:

Note: At least Weblogic Admin server should be up while doing this.

Source Run filesystem

. EBSApps run

cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier

[applmgr@fbsebs ~]$ . EBSapps.env run

E-Business Suite Environment Information

----------------------------------------

RUN File System : /u01/app/FBS/fs1/EBSapps/appl

PATCH File System : /u01/app/FBS/fs2/EBSapps/appl

Non-Editioned File System : /u01/app/FBS/fs_ne

DB Host: fbsebs.finsys.co.ke Service/SID: FBS

Sourcing the RUN File System ...

[applmgr@fbsebs ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@fbsebs scripts]$ perl adpreclone.pl appsTier

DB Host: fbstest.lab Service/SID: FBS

Sourcing the RUN File System ...

[applmgr@fbstest ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@fbsebs scripts]$ perl adpreclone.pl appsTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.28

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server....

Running perl /u01/app/FBS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

wlsDomainName: EBS_domain

WLS Domain Name is VALID.

Running:

perl /u01/app/FBS/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/app/FBS/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/app/FBS/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml showProgress

Setting the wls environment

Beginning application tier Stage - Wed Jan 8 12:44:27 2025

/u01/app/FBS/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/app/FBS/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/app/FBS/fs1/FMW_Home/oracle_common/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar:/u01/app/FBS/fs1/FMW_Home/oracle_common/modules/oracle.odl_11.1.1/ojdl.jar:/u01/app/FBS/fs1/FMW_Home/oracle_common/modules/oracle.dms_11.1.1/dms.jar::/u01/app/FBS/fs1/EBSapps/comn/java/classes:/u01/app/FBS/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/app/FBS/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/app/FBS/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/app/FBS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/app/FBS/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/app/FBS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/app/FBS/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml -stage /u01/app/FBS/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/admin/log/clone/StageAppsTier_01081244.log

- 20% completed

Completed Stage...

Wed Jan 8 12:50:55 2025

11.2 Take the RMAN Backup of CDB Database

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

Make sure CDB database is in archive mode.

Source CDB environment file

cd $ORACLE_HOME

. <CDB_NAME>_hostname.env

[oracle@fbstest backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Apr 2 13:52:55 2022

Version 19.10.0.0.0

connected to target database: FUNCDB (DBID=3473472359)

RMAN> run {

allocate channel c1 type disk;

allocate channel c2 type disk;

BACKUP as compressed backupset FULL FILESPERSET 10 FORMAT '/media/sf_19c_EBS12210_Backup/FBS_D_%s_%p_%t.bak' DATABASE;

BACKUP as compressed backupset filesperset 10 FORMAT '/media/sf_19c_EBS12210_Backup/FBS_A_%s_%p_%t.bak' ARCHIVELOG ALL skip inaccessible;

BACKUP FORMAT '/media/sf_19c_EBS12210_Backup/FBS_C_%s_%p_%t.bak' CURRENT CONTROLFILE;

RELEASE CHANNEL c1;

RELEASE CHANNEL c2;

}2> 3> 4> 5> 6> 7> 8> 9>

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=41 device type=DISK

allocated channel: c2

channel c2: SID=42 device type=DISK

Starting backup at 02-APR-22

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00039 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.260.1096979491

input datafile file number=00025 name=+EBS_DATA/FBS/DATAFILE/system.271.1096980051

input datafile file number=00052 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.276.1096980259

input datafile file number=00041 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.284.1096980625

input datafile file number=00033 name=+EBS_DATA/FBS/DATAFILE/system.290.1096980849

input datafile file number=00056 name=+EBS_DATA/FBS/DATAFILE/apps_ts_interface.295.1096980987

input datafile file number=00013 name=+EBS_DATA/FBS/DATAFILE/system.301.1096981141

input datafile file number=00049 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.308.1096981299

input datafile file number=00067 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tools.310.1096981331

channel c1: starting piece 1 at 02-APR-22

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00016 name=+EBS_DATA/FBS/DATAFILE/system.262.1096979661

input datafile file number=00019 name=+EBS_DATA/FBS/DATAFILE/system.265.1096979789

input datafile file number=00023 name=+EBS_DATA/FBS/DATAFILE/system.269.1096979971

input datafile file number=00050 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.274.1096980179

input datafile file number=00047 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.281.1096980489

input datafile file number=00053 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.288.1096980777

input datafile file number=00043 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.294.1096980951

input datafile file number=00009 name=+EBS_DATA/FBS/DATAFILE/system.297.1096981037

input datafile file number=00066 name=+EBS_DATA/FBS/DATAFILE/sysaux.303.1096981191

input datafile file number=00061 name=+EBS_DATA/FBS/DATAFILE/apps_ts_queues.311.1096981345

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_3_1_1100958796.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:26:46

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00037 name=+EBS_DATA/FBS/DATAFILE/apps_undots1.304.1096981217

input datafile file number=00048 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.278.1096980351

input datafile file number=00062 name=+EBS_DATA/FBS/DATAFILE/apps_ts_media.283.1096980579

input datafile file number=00042 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.289.1096980813

input datafile file number=00028 name=+EBS_DATA/FBS/DATAFILE/system.296.1096981011

input datafile file number=00065 name=+EBS_DATA/FBS/DATAFILE/sysaux.302.1096981165

input datafile file number=00034 name=+EBS_DATA/FBS/DATAFILE/ctxd.314.1096981369

input datafile file number=00064 name=+EBS_DATA/FBS/DATAFILE/olap.316.1096981379

input datafile file number=00035 name=+EBS_DATA/FBS/DATAFILE/owapub.319.1096981387

input datafile file number=00060 name=+EBS_DATA/FBS/DATAFILE/apps_ts_queues.309.1096981315

channel c1: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_4_1_1100958796.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:37:13

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00015 name=+EBS_DATA/FBS/DATAFILE/system.261.1096979615

input datafile file number=00018 name=+EBS_DATA/FBS/DATAFILE/system.264.1096979753

input datafile file number=00022 name=+EBS_DATA/FBS/DATAFILE/system.268.1096979925

input datafile file number=00027 name=+EBS_DATA/FBS/DATAFILE/system.273.1096980133

input datafile file number=00040 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.280.1096980443

input datafile file number=00031 name=+EBS_DATA/FBS/DATAFILE/system.287.1096980731

input datafile file number=00044 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.293.1096980925

input datafile file number=00010 name=+EBS_DATA/FBS/DATAFILE/system.298.1096981063

input datafile file number=00059 name=+EBS_DATA/FBS/DATAFILE/apps_ts_archive.305.1096981243

input datafile file number=00063 name=+EBS_DATA/FBS/DATAFILE/odm.318.1096981385

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_5_1_1100960404.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:28:14

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00038 name=+EBS_DATA/FBS/DATAFILE/apps_undots1.277.1096980295

input datafile file number=00021 name=+EBS_DATA/FBS/DATAFILE/system.267.1096979879

input datafile file number=00026 name=+EBS_DATA/FBS/DATAFILE/system.272.1096980097

input datafile file number=00032 name=+EBS_DATA/FBS/DATAFILE/system.279.1096980397

input datafile file number=00045 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.286.1096980697

input datafile file number=00057 name=+EBS_DATA/FBS/DATAFILE/apps_ts_summary.292.1096980899

input datafile file number=00011 name=+EBS_DATA/FBS/DATAFILE/system.299.1096981089

input datafile file number=00029 name=+EBS_DATA/FBS/DATAFILE/system.306.1096981267

input datafile file number=00036 name=+EBS_DATA/FBS/DATAFILE/portal.312.1096981361

input datafile file number=00055 name=+EBS_DATA/FBS/DATAFILE/apps_ts_interface.317.1096981383

channel c1: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_6_1_1100961031.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:38:23

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00017 name=+EBS_DATA/FBS/DATAFILE/system.263.1096979707

input datafile file number=00020 name=+EBS_DATA/FBS/DATAFILE/system.266.1096979833

input datafile file number=00024 name=+EBS_DATA/FBS/DATAFILE/system.270.1096980017

input datafile file number=00051 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.275.1096980215

input datafile file number=00046 name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.282.1096980543

input datafile file number=00014 name=+EBS_DATA/FBS/DATAFILE/system.285.1096980661

input datafile file number=00054 name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.291.1096980873

input datafile file number=00012 name=+EBS_DATA/FBS/DATAFILE/system.300.1096981115

input datafile file number=00030 name=+EBS_DATA/FBS/DATAFILE/system.307.1096981283

input datafile file number=00058 name=+EBS_DATA/FBS/DATAFILE/apps_ts_nologging.313.1096981365

channel c2: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_7_1_1100962099.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:35:53

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=+EBS_DATA/FUNCDB/system01.dbf

input datafile file number=00003 name=+EBS_DATA/FUNCDB/sysaux01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_9_1_1100964254.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:08:05

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00004 name=+EBS_DATA/FUNCDB/undotbs01.dbf

input datafile file number=00007 name=+EBS_DATA/FUNCDB/users01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_10_1_1100964740.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00005 name=+EBS_DATA/FUNCDB/pdbseed/system01.dbf

input datafile file number=00008 name=+EBS_DATA/FUNCDB/pdbseed/undotbs01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_11_1_1100964744.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:03:45

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00006 name=+EBS_DATA/FUNCDB/pdbseed/sysaux01.dbf

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_12_1_1100964970.bak tag=TAG20220402T135313 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:55

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_8_1_1100963337.bak tag=TAG20220402T135313 comment=NONE

channel c2: backup set complete, elapsed time: 00:36:58

Finished backup at 02-APR-22

Starting backup at 02-APR-22

current log archived

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=6 RECID=2 STAMP=1100958116

channel c1: starting piece 1 at 02-APR-22

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=1 sequence=9 RECID=4 STAMP=1100965556

channel c2: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_A_14_1_1100965558.bak tag=TAG20220402T154557 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:07

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=1 sequence=7 RECID=1 STAMP=1100958110

input archived log thread=1 sequence=8 RECID=3 STAMP=1100958117

channel c2: starting piece 1 at 02-APR-22

channel c2: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_A_15_1_1100965566.bak tag=TAG20220402T154557 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_A_13_1_1100965558.bak tag=TAG20220402T154557 comment=NONE

channel c1: backup set complete, elapsed time: 00:01:53

Finished backup at 02-APR-22

Starting backup at 02-APR-22

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

including current control file in backup set

channel c1: starting piece 1 at 02-APR-22

channel c1: finished piece 1 at 02-APR-22

piece handle=/media/sf_19c_EBS12210_Backup/FBS_C_16_1_1100965672.bak tag=TAG20220402T154751 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 02-APR-22

Starting Control File and SPFILE Autobackup at 02-APR-22

piece handle=/u01/app/FBS/db/tech_st/19c/dbs/c-3473472359-20220402-00 comment=NONE

Finished Control File and SPFILE Autobackup at 02-APR-22

released channel: c1

released channel: c2

After completing the backup, copy the backup to target server. In my case I am using shared file system so no need for any copy.

Note: if you have more CPU threads you can increase number or channels.

11.3 Copy the Source binaries to Target

Perform the following steps to copy the source application binaries and database binaries to the target node.

11.3.1 On the source database node, tar 19.0.0(19c) binaries

I will tar backup and copy on /media/sf_19c_EBS12210_Backup

tar -zcvf /u01/backup/19c_home.tar.gz 19c

11.3.2 On the application node, tar only the EBSapps directory of RUN FS(fs2 in my case) from the source file system.

tar -zcvf /u01/backup/EBSapps_fs1_run.tar.gz EBSapps

11.4 Prepare Target Server

Clean up the target database and application node if it already exists

Make sure all pre-reqs are installed on target server and respective directories are present.

Untar the Source system tar file on Target system

From Oracle user:

mkdir -p /u01/app/FBS/db/tech_st

Copy the Oracle Home tar from source to target and untar.

[oracle@ebsdomo DATABASE]$ cd /u01/app/FBS/db/tech_st

[oracle@ebsdomo FBS]$ cp /u01/backup/19c_home.tar.gz .

[oracle@ebsdomo FBS]$ tar -zxvf 19c_home.tar.gz

Once Untar is done remove the tar file

rm -rf 19c_home.tar.gz

From applmgr user

mkdir -p /u01/app/FBS

[applmgr@ebsdomo BEE]$ cd /u01/app/FBS

[applmgr@ebsdomo FBS]$ mkdir fs1 fs2 fs_ne

[applmgr@ebsdomo fs1]$ cd /u01/app/EBs/fs1

cp /u01/backup/EBSapps_fs1_run.tar.gz .

untar the EBSapps.

tar -zxvf EBSapps_fs1_run.tar.gz

rm -rf EBSapps_fs1_run.tar.gz

I am copy in fs2 as in my source fs2 was the run file system

11.5 Configure Oracle Home on the target database node.

Before running adcfgclone.pl to configure $Oracle_Home, clean up the oraInventory directory.

11.5.1 Create pairsfile.txt File (I am not doing this)

Create a <NEW_ORACLE_HOME>/appsutil/clone/pairsfile.txt text file.

New Oracle Home = /u01/app/FBS/db/tech_st/19c

For single-node database, if you want to generate the context file non-interactively, you can use the following content:

s_undo_tablespace=<Source (PDB) system undo tablespace name>

s_db_oh=<Location of new ORACLE_HOME>

s_dbhost=<Target hostname>

s_dbSid=<Target PDB name>

s_pdb_name=<Target PDB name>

s_cdb_name=<Target CDB SID>

s_base=<Base directory for DB Oracle Home>

s_dbuser=<DB User>

s_dbgroup=<DB group> (Not applicable on Windows)

s_dbhome1=<Data directory>

s_display=<Display>

s_dbCluster=false

s_isDBCluster=n

s_dbport=<DB port>

s_port_pool=<Port pool number>

Note: If there are data tops other than the one defined in s_dbhome1, you should define them by adding the context variables s_dbhome2, s_dbhome3 and s_dbhome4.

11.5.2 Create the DB context file:

$ cd <NEW ORACLE_HOME>/appsutil/clone/bin

$ perl adclonectx.pl \

contextfile=<Source database context file>\

template=<NEW ORACLE_HOME>/appsutil/template/adxdbctx.tmp \

[pairsfile=<if Pairs file generated in above step

[oracle@ebsdomo appsutil]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin

[oracle@ebsdomo bin]$ perl adclonectx.pl contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml template=/u01/app/FBS/db/tech_st/19c/appsutil/template/adxdbctx.tmp

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.26

Running:

/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -classpath /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jlib/ojdbc8.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jlib/java::/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../../../jlib/orai18n.jar oracle.apps.ad.context.CloneContext -e /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml -tmpl /u01/app/FBS/db/tech_st/19c/appsutil/template/adxdbctx.tmp

Enter the APPS password :

Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/CloneContext_0210114134.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [ebsdomo] :

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 : /u01/app/FBS/db

Target Instance is RAC (y/n) [n] : n

Target System CDB Name : cdbfbs

Target System PDB Name : FBS

Oracle OS User [oracle] :

Oracle OS Group [oinstall] : dba

Role separation is supported y/n [n] ? : n

Number of DATA_TOP's on the Target System [2] :

Target System DATA_TOP Directory 1 [/u01/app/FBS/db/cdbfbs] :

Target System DATA_TOP Directory 2 [/u01/app/FBS/db/data] :

Specify value for OSBACKUPDBA group [dba] :

Specify value for OSDGDBA group [dba] :

Specify value for OSKMDBA group [dba] :

Specify value for OSRACDBA group [dba] :

Target System RDBMS ORACLE_HOME Directory [/u01/app/FBS/db/19.0.0] : /u01/app/FBS/db/tech_st/19c

Do you want to preserve the Display [localhost:10.0] (y/n) : n

Target System Display [ebsdomo:0.0] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : y

Validating if the source port numbers are available on the target system..

Complete port information available at /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/out/FBS_ebsdomo/portpool.lst

New context path and file name [/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml] :

The new database context file has been created :

/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Check Clone Context logfile /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/CloneContext_0210114134.log for details.

11.5.3 Configure the database technology stack or Oracle Home on target

Navigate to <ORACLE_HOME>/appsutil/clone/bin and run Rapid Clone (adcfgclone.pl utility) with the following parameters to configure the database technology stack:

$ perl adcfgclone.pl dbTechStack <Complete path to the target context file>

[oracle@ebsdomo bin]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin

[oracle@ebsdomo bin]$ unset which

[oracle@ebsdomo bin]$ export CV_ASSUME_DISTID=OEL7.9

[oracle@ebsdomo bin]$ perl adcfgclone.pl dbTechStack /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.86

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/adclone.pl java=/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre mode=apply stage=/u01/app/FBS/db/tech_st/19c/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml showProgress contextValidated=false

Beginning rdbms home Apply - Mon Feb 10 11:49:45 2025

/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/app/FBS/db/tech_st/19c/oui -classpath /u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/ojdbc8.jar::/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/java:/u01/app/FBS/db/tech_st/19c/appsutil/clone/../../jlib/orai18n.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/ewt3.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/share.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/srvm.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml -stage /u01/app/FBS/db/tech_st/19c/appsutil/clone -showProgress

APPS Password : Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/ApplyDBTechStack_02101149.log

| 0% completed

Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/ApplyDBTechStack_02101149.log

\ 0% completed

Completed Apply...

Mon Feb 10 11:52:22 2025

Running:

/u01/app/FBS/db/tech_st/19c/bin/sqlplus -s /nolog @/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/sqlCmd.sql > /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/get_ad_codelevel.log 2>&1

Running ETCC to check status of DB technology patches...

Version of /u01/app/FBS/db/tech_st/19c/appsutil/etcc/checkDBpatch.sh is 120.127

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Using context file from command line argument:

/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Starting Database EBS Technology Codelevel Checker, Version 120.127

Mon Feb 10 11:52:22 EAT 2025

Log file for this session: /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/log/checkDBpatch_15903.log

Identifying database release.

Database release set to 19.24.0.0.

Multitenant identified.

- Container database (CDB) identified via s_cdb_name is cdbfbs

- Pluggable database (PDB) identified via s_pdb_name is FBS

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.

+---------------------------------------------------------------------------------------+

Bugfix file /u01/app/FBS/db/tech_st/19c/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml: 120.0.12020000.85

This file will be used for identifying missing bugfixes.

Mapping file /u01/app/FBS/db/tech_st/19c/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.61

This file will be used for mapping bugfixes to patches.

+---------------------------------------------------------------------------------------+

Always use the latest version of ETCC available in patch 17537119,

as new bugfixes will not be checked by older versions of the utility.

You should apply the latest recommended RU, BP, or PSU as appropriate.

+---------------------------------------------------------------------------------------+

Checking Bugfix XML file for tag 19.24.0.0_RU.

Obtained list of bugfixes to be applied and list to be rolled back.

Validating OPatch version:

The OPatch utility is version 12.2.0.1.43.

DB-ETCC is compatible with this OPatch version.

Checking for applied patch history:

Found patch history in the inventory.

Checking mapping XML file for tag 19.24.0.0.240716DBRU.

All the required one-off bugfixes are present in database ORACLE_HOME.

+---------------------------------------------------------------------------------------+

[WARNING] 36912597 - DATABASE RELEASE UPDATE 19.25.0.0.241015 is not applied.

This is the recommended database Release Update. You should install it now

and then rerun this script to check for any further fixes available.

- Filename: p36912597_190000_Linux-x86-64.zip

Alternatively, you can remain on your existing Release Update and apply all

the patches listed above from the consolidated zip file, which is only shown

when patches need to be installed.

+---------------------------------------------------------------------------------------+

[WARNING] Database not available. DB-ETCC results cannot be stored.

+---------------------------------------------------------------------------------------+

Finished checking fixes for database : Mon Feb 10 11:52:42 EAT 2025

Log file for this session: /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/log/checkDBpatch_15903.log

This file should be reviewed for errors after the ETCC run.

=========================================================================================

Ignore the ETCC warning.

11.5.4 Create listener.ora and tnsnames.ora files:

Set below before running

export ORACLE_HOME=/u01/app/FBS/db/tech_st/19c

export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/site_perl/5.28.1:$ORACLE_HOME/appsutil/perl

export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

cd $ORACLE_HOME/appsutil

./txkSetCfgCDB.env -dboraclehome=<ORACLE_HOME>

$ cd <ORACLE_HOME>/appsutil/bin

$ perl txkGenCDBTnsAdmin.pl -dboraclehome=<ORACLE_HOME> -cdbname=<Name of the target container database> \

-cdbsid=<SID of the target container database> -dbport=<Target DB port> -outdir=$ORACLE_HOME/appsutil/log \

-israc=<yes/no> [-virtualhostname=<virtual hostname>]

[oracle@ebsdomo~]$ export ORACLE_HOME=/u01/app/FBS/db/tech_st/19c

[oracle@ebsdomo ~]$ export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

[oracle@ebsdomo ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

[oracle@ebsdomo ~]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.2:$ORACLE_HOME/perl/site_perl/5.28.2:$ORACLE_HOME/appsutil/perl

[oracle@ebsdomo ~]$ export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

[oracle@ebsdomo ~]$ cd /u01/app/FBS/db/tech_st/19c/appsutil

[oracle@ebsdomo bin]$ chmod 755 txkSetCfgCDB.env

[oracle@ebsdomo appsutil]$ ./txkSetCfgCDB.env -dboraclehome=/u01/app/FBS/db/tech_st/19c

Oracle Home being passed: /u01/app/FBS/db/tech_st/19c

[oracle@ebsdomo bin]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/bin

[oracle@ebsdomo bin]$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/u01/app/FBS/db/tech_st/19c -cdbname=cdbfbs -cdbsid=cdbfbs -dbport=1551 -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log -israc=no

Script Name : txkGenCDBTnsAdmin.pl

Script Version : 120.0.12020000.12

Started : Mon Feb 10 12:02:27 EAT 2025

Log File : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/txkGenCDBTnsAdmin.log

-----------

Values used

-----------

Database Oracle Home : /u01/app/FBS/db/tech_st/19c

CDB NAME : cdbfbs

CDB SID : cdbfbs

Database port : 1551

OUT Directory : /u01/app/FBS/db/tech_st/19c/appsutil/log

Is RAC? : no

Virtual Hostname :

Logical Hostname :

Script execution mode : generate

=========================

Validating oracle home...

=========================

Oracle Home: /u01/app/FBS/db/tech_st/19c exists.

===========================

Validating out directory...

===========================

Out directory: /u01/app/FBS/db/tech_st/19c/appsutil/log exists.

===================================

Validating script execution mode...

===================================

Script execution mode: generate

Script execution mode is valid.

============================

Inside getDBHostDetails()...

============================

DB Hostname : ebsdomo

DB Domain : finsys.co.ke

Logical hostname is not passed, hence using physical hostname details.

Logical Hostname : ebsdomo

Logical Domain : finsys.co.ke

=====================

Inside getDBPort()...

=====================

DB Port passed as an argument, using the same.

DB Port: 1551

========================

Inside getDBVersion()...

========================

DB_VERSION = db190

======================================

Inside generateCDBTNSAdminContent()...

======================================

Creating the directory: /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_bkp

Creating the directory: /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp

listener_template: listener_ora_cdb_db19.tmp

sqlnet_template: sqlnet_ora_cdb_db19.tmp

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/template/listener_ora_cdb_db19.tmp

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/listener.ora

===================================

Inside replaceContextVariables()...

===================================

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/network/admin/listener.ora

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_bkp/listener.ora

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/listener.ora

TARGET : /u01/app/FBS/db/tech_st/19c/network/admin/listener.ora

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/template/tnsnames_ora_cdb_db121.tmp

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/tnsnames.ora

===================================

Inside replaceContextVariables()...

===================================

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/network/admin/tnsnames.ora

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_bkp/tnsnames.ora

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/tnsnames.ora

TARGET : /u01/app/FBS/db/tech_st/19c/network/admin/tnsnames.ora

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/template/sqlnet_ora_cdb_db19.tmp

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/sqlnet.ora

===================================

Inside replaceContextVariables()...

===================================

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/network/admin/sqlnet.ora

TARGET : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_bkp/sqlnet.ora

Copying the file

----------------

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Mon_Feb_10_12_02_27_2025/tns_admin_cdb_temp/sqlnet.ora

TARGET : /u01/app/FBS/db/tech_st/19c/network/admin/sqlnet.ora

==============================

Inside updateCDBSqlNetOra()...

==============================

Updating the IFILE entry...

Exiting from the script.

Ended: Mon Feb 10 12:02:27 EAT 2025

11.5.5 If this is a repeated cloned instance, use the CONTEXT_FILE backup to configure the target database binaries(Not Needed as I am doing on new Server):

cd <RDBMS ORACLE_HOME>/appsutil/clone/bin

perl adcfgclone.pl dbTechStack <Full Path of CONTEXT_FILE backup location>

11.5.6 If this is a repeated cloned instance, revert the dbs and TNS files so that all configuration files and init parameters are intact after configuration(Not Needed as I am doing on new Server).

1.6 Start the listener.

$ cd <ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>

$ ./adcdblnctl.sh start <CDB SID>

[oracle@ebsdomo scripts]$ cd $ORACLE_HOME/appsutil/scripts/FBS_ebsdomo

[oracle@ebsdomo BEE_ebsdomo]$ ls

adautocfg.sh adcdblnctl.sh addbctl.sh adexecsql.pl adstopcdb.sql adstrtcdb.sql

adcdbctl.sh adchknls.pl addlnctl.sh adpreclone.pl adstopdb.sql adstrtdb.sql

[oracle@ebsdomo FBS_ebsdomo]$ ./addlnctl.sh start cdbfbs

Logfile: /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/addlnctl.txt

You are running addlnctl.sh version 120.4

grep: /u01/app/FBS/db/tech_st/19c/network/admin/FBS_ebsdomo/listener.ora: No such file or directory

Starting listener process cdbfbs ...

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-FEB-2025 12:04:41

Starting /u01/app/FBS/db/tech_st/19c/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/FBS/db/tech_st/19c/network/admin/listener.ora

Log messages written to /u01/app/FBS/db/tech_st/19c/log/diag/tnslsnr/ebsdomo/cdbfbs/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdomo.finsys.co.ke)(PORT=1551)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebsdomo.finsys.co.ke)(PORT=1551)))

STATUS of the LISTENER

------------------------

Alias cdbfbs

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 10-FEB-2025 12:04:43

Uptime 0 days 0 hr. 0 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/FBS/db/tech_st/19c/network/admin/listener.ora

Listener Log File /u01/app/FBS/db/tech_st/19c/log/diag/tnslsnr/ebsdomo/cdbfbs/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdomo.finsys.co.ke)(PORT=1551)))

The listener supports no services

The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/addlnctl.txt for more information ...

Note: If the source Oracle E-Business Suite instance is at the R12.TXK.C.DELTA.12 codelevel, the above commands may exit with status 1, waiting for the PDB service to start. This error can be ignored as the database is not yet restored.

11.7 Restore and Recover the database

After you configure $Oracle_Home, start the target database restore by using that backup that you took earlier:

11.7.1 Before restoring, check that the following parameters are correct in the target node.

db_file_name_convert

log_file_name_convert

I will copy the source cdb pfile and use it for target

[oracle@ebsdomo dbs]$ cp initfbscdb.ora initcdbfbs.ora

cd $ORACLE_HOME/dbs

vi initBEECDB.ora

add below lines

DB_FILE_NAME_CONVERT=(+EBS_DATA,+EBS_DATA)

LOG_FILE_NAME_CONVERT=(+EBS_DATA,+EBS_DATA)

*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fbstest.finsys.co.ke)(PORT=1531)))'

*.db_name='CDBFBS'

Replace funcdb with cdbfbs

and FBSCDB with CDBFBS

mkdir -p /u01/app/FBS/db/admin/fbscdb/adump

11.7.2 Start the target database in a nomount state and run the following RMAN command to restore the database:

cd /u01/app/FBS/db/tech_st/19c

Source CDB environment file

. CDBFBS_ebsdomo.env

sqlplus '/as sysdba'

startup nomount pfile='/u01/app/FBS/db/tech_st/19c/dbs/initCDBFBS.ora'

rman auxiliary /

run

{

allocate auxiliary channel c1 device type disk;

allocate auxiliary channel c2 device type disk;

duplicate database to '<CDB NAME>' backup location '<RMAN backup location>' nofilenamecheck;

release channel c1;

release channel c2;

}

[oracle@ebsdomo dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 3 17:08:02 2022

Version 19.10.0.0.0

connected to target database: BEECDB (not mounted)

RMAN> exit

Recovery Manager complete.

[oracle@ebsdomo dbs]$ rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Apr 3 17:08:15 2022

Version 19.10.0.0.0

connected to auxiliary database: BEECDB (not mounted)

RMAN> run

{

allocate auxiliary channel c1 device type disk;

allocate auxiliary channel c2 device type disk;

duplicate database to 'BEECDB' backup location '/media/sf_19c_EBS12210_Backup' nofilenamecheck;

release channel c1;

release channel c2;

}2> 3> 4> 5> 6> 7> 8>

allocated channel: c1

channel c1: SID=223 device type=DISK

allocated channel: c2

channel c2: SID=23 device type=DISK

Starting Duplicate Db at 03-APR-22

searching for database ID

found backup of database ID 3473472359

contents of Memory Script:

{

sql clone "create spfile from memory";

}

executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:

{

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 2147482136 bytes

Fixed Size 9136664 bytes

Variable Size 436207616 bytes

Database Buffers 1677721600 bytes

Redo Buffers 24416256 bytes

allocated channel: c1

channel c1: SID=4 device type=DISK

allocated channel: c2

channel c2: SID=24 device type=DISK

contents of Memory Script:

{

sql clone "alter system set db_name =

''FUNCDB'' comment=

''Modified by RMAN duplicate'' scope=spfile";

sql clone "alter system set db_unique_name =

''beecdb'' comment=

''Modified by RMAN duplicate'' scope=spfile";

shutdown clone immediate;

startup clone force nomount

restore clone primary controlfile from '/media/sf_19c_EBS12210_Backup/FBS_C_16_1_1100965672.bak';

alter clone database mount;

}

executing Memory Script

sql statement: alter system set db_name = ''FUNCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''beecdb'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 2147482136 bytes

Fixed Size 9136664 bytes

Variable Size 436207616 bytes

Database Buffers 1677721600 bytes

Redo Buffers 24416256 bytes

allocated channel: c1

channel c1: SID=4 device type=DISK

allocated channel: c2

channel c2: SID=22 device type=DISK

Starting restore at 03-APR-22

channel c2: skipped, AUTOBACKUP already found

channel c1: restoring control file

channel c1: restore complete, elapsed time: 00:00:10

output file name=+EBS_DATA/BEECDB/control01.ctl

output file name=+EBS_DATA/BEECDB/control02.ctl

Finished restore at 03-APR-22

database mounted

RMAN-05529: warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:

{

set until scn 5965174432198;

set newname for datafile 1 to

"+EBS_DATA/funcdb/system01.dbf";

set newname for datafile 3 to

"+EBS_DATA/funcdb/sysaux01.dbf";

set newname for datafile 4 to

"+EBS_DATA/funcdb/undotbs01.dbf";

set newname for datafile 5 to

"+EBS_DATA/funcdb/pdbseed/system01.dbf";

set newname for datafile 6 to

"+EBS_DATA/funcdb/pdbseed/sysaux01.dbf";

set newname for datafile 7 to

"+EBS_DATA/funcdb/users01.dbf";

set newname for datafile 8 to

"+EBS_DATA/funcdb/pdbseed/undotbs01.dbf";

set newname for datafile 9 to

"+EBS_DATA";

set newname for datafile 10 to

"+EBS_DATA";

set newname for datafile 11 to

"+EBS_DATA";

set newname for datafile 12 to

"+EBS_DATA";

set newname for datafile 13 to

"+EBS_DATA";

set newname for datafile 14 to

"+EBS_DATA";

set newname for datafile 15 to

"+EBS_DATA";

set newname for datafile 16 to

"+EBS_DATA";

set newname for datafile 17 to

"+EBS_DATA";

set newname for datafile 18 to

"+EBS_DATA";

set newname for datafile 19 to

"+EBS_DATA";

set newname for datafile 20 to

"+EBS_DATA";

set newname for datafile 21 to

"+EBS_DATA";

set newname for datafile 22 to

"+EBS_DATA";

set newname for datafile 23 to

"+EBS_DATA";

set newname for datafile 24 to

"+EBS_DATA";

set newname for datafile 25 to

"+EBS_DATA";

set newname for datafile 26 to

"+EBS_DATA";

set newname for datafile 27 to

"+EBS_DATA";

set newname for datafile 28 to

"+EBS_DATA";

set newname for datafile 29 to

"+EBS_DATA";

set newname for datafile 30 to

"+EBS_DATA";

set newname for datafile 31 to

"+EBS_DATA";

set newname for datafile 32 to

"+EBS_DATA";

set newname for datafile 33 to

"+EBS_DATA";

set newname for datafile 34 to

"+EBS_DATA";

set newname for datafile 35 to

"+EBS_DATA";

set newname for datafile 36 to

"+EBS_DATA";

set newname for datafile 37 to

"+EBS_DATA";

set newname for datafile 38 to

"+EBS_DATA";

set newname for datafile 39 to

"+EBS_DATA";

set newname for datafile 40 to

"+EBS_DATA";

set newname for datafile 41 to

"+EBS_DATA";

set newname for datafile 42 to

"+EBS_DATA";

set newname for datafile 43 to

"+EBS_DATA";

set newname for datafile 44 to

"+EBS_DATA";

set newname for datafile 45 to

"+EBS_DATA";

set newname for datafile 46 to

"+EBS_DATA";

set newname for datafile 47 to

"+EBS_DATA";

set newname for datafile 48 to

"+EBS_DATA";

set newname for datafile 49 to

"+EBS_DATA";

set newname for datafile 50 to

"+EBS_DATA";

set newname for datafile 51 to

"+EBS_DATA";

set newname for datafile 52 to

"+EBS_DATA";

set newname for datafile 53 to

"+EBS_DATA";

set newname for datafile 54 to

"+EBS_DATA";

set newname for datafile 55 to

"+EBS_DATA";

set newname for datafile 56 to

"+EBS_DATA";

set newname for datafile 57 to

"+EBS_DATA";

set newname for datafile 58 to

"+EBS_DATA";

set newname for datafile 59 to

"+EBS_DATA";

set newname for datafile 60 to

"+EBS_DATA";

set newname for datafile 61 to

"+EBS_DATA";

set newname for datafile 62 to

"+EBS_DATA";

set newname for datafile 63 to

"+EBS_DATA";

set newname for datafile 64 to

"+EBS_DATA";

set newname for datafile 65 to

"+EBS_DATA";

set newname for datafile 66 to

"+EBS_DATA";

set newname for datafile 67 to

"+EBS_DATA";

restore

clone database

;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

Starting restore at 03-APR-22

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00001 to +EBS_DATA/funcdb/system01.dbf

channel c1: restoring datafile 00003 to +EBS_DATA/funcdb/sysaux01.dbf

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_9_1_1100964254.bak

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00011 to +EBS_DATA

channel c2: restoring datafile 00021 to +EBS_DATA

channel c2: restoring datafile 00026 to +EBS_DATA

channel c2: restoring datafile 00029 to +EBS_DATA

channel c2: restoring datafile 00032 to +EBS_DATA

channel c2: restoring datafile 00036 to +EBS_DATA

channel c2: restoring datafile 00038 to +EBS_DATA

channel c2: restoring datafile 00045 to +EBS_DATA

channel c2: restoring datafile 00055 to +EBS_DATA

channel c2: restoring datafile 00057 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_7_1_1100962099.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_9_1_1100964254.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:04:16

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00012 to +EBS_DATA

channel c1: restoring datafile 00014 to +EBS_DATA

channel c1: restoring datafile 00017 to +EBS_DATA

channel c1: restoring datafile 00020 to +EBS_DATA

channel c1: restoring datafile 00024 to +EBS_DATA

channel c1: restoring datafile 00030 to +EBS_DATA

channel c1: restoring datafile 00046 to +EBS_DATA

channel c1: restoring datafile 00051 to +EBS_DATA

channel c1: restoring datafile 00054 to +EBS_DATA

channel c1: restoring datafile 00058 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_8_1_1100963337.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_7_1_1100962099.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:22:13

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00010 to +EBS_DATA

channel c2: restoring datafile 00015 to +EBS_DATA

channel c2: restoring datafile 00018 to +EBS_DATA

channel c2: restoring datafile 00022 to +EBS_DATA

channel c2: restoring datafile 00027 to +EBS_DATA

channel c2: restoring datafile 00031 to +EBS_DATA

channel c2: restoring datafile 00040 to +EBS_DATA

channel c2: restoring datafile 00044 to +EBS_DATA

channel c2: restoring datafile 00059 to +EBS_DATA

channel c2: restoring datafile 00063 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_6_1_1100961031.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_8_1_1100963337.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:23:13

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00028 to +EBS_DATA

channel c1: restoring datafile 00034 to +EBS_DATA

channel c1: restoring datafile 00035 to +EBS_DATA

channel c1: restoring datafile 00037 to +EBS_DATA

channel c1: restoring datafile 00042 to +EBS_DATA

channel c1: restoring datafile 00048 to +EBS_DATA

channel c1: restoring datafile 00060 to +EBS_DATA

channel c1: restoring datafile 00062 to +EBS_DATA

channel c1: restoring datafile 00064 to +EBS_DATA

channel c1: restoring datafile 00065 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_5_1_1100960404.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_6_1_1100961031.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:22:53

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00005 to +EBS_DATA/funcdb/pdbseed/system01.dbf

channel c2: restoring datafile 00008 to +EBS_DATA/funcdb/pdbseed/undotbs01.dbf

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_11_1_1100964744.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_5_1_1100960404.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:18:01

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00006 to +EBS_DATA/funcdb/pdbseed/sysaux01.dbf

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_12_1_1100964970.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_12_1_1100964970.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:00:46

channel c1: starting datafile backup set restore

channel c1: specifying datafile(s) to restore from backup set

channel c1: restoring datafile 00009 to +EBS_DATA

channel c1: restoring datafile 00016 to +EBS_DATA

channel c1: restoring datafile 00019 to +EBS_DATA

channel c1: restoring datafile 00023 to +EBS_DATA

channel c1: restoring datafile 00043 to +EBS_DATA

channel c1: restoring datafile 00047 to +EBS_DATA

channel c1: restoring datafile 00050 to +EBS_DATA

channel c1: restoring datafile 00053 to +EBS_DATA

channel c1: restoring datafile 00061 to +EBS_DATA

channel c1: restoring datafile 00066 to +EBS_DATA

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_4_1_1100958796.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_11_1_1100964744.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:01:27

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00013 to +EBS_DATA

channel c2: restoring datafile 00025 to +EBS_DATA

channel c2: restoring datafile 00033 to +EBS_DATA

channel c2: restoring datafile 00039 to +EBS_DATA

channel c2: restoring datafile 00041 to +EBS_DATA

channel c2: restoring datafile 00049 to +EBS_DATA

channel c2: restoring datafile 00052 to +EBS_DATA

channel c2: restoring datafile 00056 to +EBS_DATA

channel c2: restoring datafile 00067 to +EBS_DATA

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_3_1_1100958796.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_3_1_1100958796.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:19:57

channel c2: starting datafile backup set restore

channel c2: specifying datafile(s) to restore from backup set

channel c2: restoring datafile 00004 to +EBS_DATA/funcdb/undotbs01.dbf

channel c2: restoring datafile 00007 to +EBS_DATA/funcdb/users01.dbf

channel c2: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_D_10_1_1100964740.bak

channel c2: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_10_1_1100964740.bak tag=TAG20220402T135313

channel c2: restored backup piece 1

channel c2: restore complete, elapsed time: 00:00:25

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_D_4_1_1100958796.bak tag=TAG20220402T135313

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:22:38

Finished restore at 03-APR-22

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=67 STAMP=1101061183 file name=+EBS_DATA/funcdb/system01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=68 STAMP=1101061183 file name=+EBS_DATA/funcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=69 STAMP=1101061183 file name=+EBS_DATA/funcdb/undotbs01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=70 STAMP=1101061183 file name=+EBS_DATA/funcdb/pdbseed/system01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=71 STAMP=1101061184 file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=72 STAMP=1101061184 file name=+EBS_DATA/funcdb/users01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=73 STAMP=1101061184 file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=74 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.273.1101059827

datafile 10 switched to datafile copy

input datafile copy RECID=75 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383

datafile 11 switched to datafile copy

input datafile copy RECID=76 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051

datafile 12 switched to datafile copy

input datafile copy RECID=77 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307

datafile 13 switched to datafile copy

input datafile copy RECID=78 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843

datafile 14 switched to datafile copy

input datafile copy RECID=79 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307

datafile 15 switched to datafile copy

input datafile copy RECID=80 STAMP=1101061184 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383

datafile 16 switched to datafile copy

input datafile copy RECID=81 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825

datafile 17 switched to datafile copy

input datafile copy RECID=82 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305

datafile 18 switched to datafile copy

input datafile copy RECID=83 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383

datafile 19 switched to datafile copy

input datafile copy RECID=84 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825

datafile 20 switched to datafile copy

input datafile copy RECID=85 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305

datafile 21 switched to datafile copy

input datafile copy RECID=86 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049

datafile 22 switched to datafile copy

input datafile copy RECID=87 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383

datafile 23 switched to datafile copy

input datafile copy RECID=88 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825

datafile 24 switched to datafile copy

input datafile copy RECID=89 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305

datafile 25 switched to datafile copy

input datafile copy RECID=90 STAMP=1101061185 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841

datafile 26 switched to datafile copy

input datafile copy RECID=91 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049

datafile 27 switched to datafile copy

input datafile copy RECID=92 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383

datafile 28 switched to datafile copy

input datafile copy RECID=93 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699

datafile 29 switched to datafile copy

input datafile copy RECID=94 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053

datafile 30 switched to datafile copy

input datafile copy RECID=95 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621

datafile 31 switched to datafile copy

input datafile copy RECID=96 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383

datafile 32 switched to datafile copy

input datafile copy RECID=97 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051

datafile 33 switched to datafile copy

input datafile copy RECID=98 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843

datafile 34 switched to datafile copy

input datafile copy RECID=99 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699

datafile 35 switched to datafile copy

input datafile copy RECID=100 STAMP=1101061186 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733

datafile 36 switched to datafile copy

input datafile copy RECID=101 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827

datafile 37 switched to datafile copy

input datafile copy RECID=102 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101697

datafile 38 switched to datafile copy

input datafile copy RECID=103 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101047

datafile 39 switched to datafile copy

input datafile copy RECID=104 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1059841

datafile 40 switched to datafile copy

input datafile copy RECID=105 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1058383

datafile 41 switched to datafile copy

input datafile copy RECID=106 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1059843

datafile 42 switched to datafile copy

input datafile copy RECID=107 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1058699

datafile 43 switched to datafile copy

input datafile copy RECID=108 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1159827

datafile 44 switched to datafile copy

input datafile copy RECID=109 STAMP=1101061187 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1158383

datafile 45 switched to datafile copy

input datafile copy RECID=110 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1157051

datafile 46 switched to datafile copy

input datafile copy RECID=111 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1157307

datafile 47 switched to datafile copy

input datafile copy RECID=112 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1159827

datafile 48 switched to datafile copy

input datafile copy RECID=113 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1158699

datafile 49 switched to datafile copy

input datafile copy RECID=114 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101843

datafile 50 switched to datafile copy

input datafile copy RECID=115 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101825

datafile 51 switched to datafile copy

input datafile copy RECID=116 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101307

datafile 52 switched to datafile copy

input datafile copy RECID=117 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101841

datafile 53 switched to datafile copy

input datafile copy RECID=118 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101827

datafile 54 switched to datafile copy

input datafile copy RECID=119 STAMP=1101061188 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101307

datafile 55 switched to datafile copy

input datafile copy RECID=120 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.32501057899

datafile 56 switched to datafile copy

input datafile copy RECID=121 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.26701059843

datafile 57 switched to datafile copy

input datafile copy RECID=122 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1057051

datafile 58 switched to datafile copy

input datafile copy RECID=123 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.28901058433

datafile 59 switched to datafile copy

input datafile copy RECID=124 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1059415

datafile 60 switched to datafile copy

input datafile copy RECID=125 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1158699

datafile 61 switched to datafile copy

input datafile copy RECID=126 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1160667

datafile 62 switched to datafile copy

input datafile copy RECID=127 STAMP=1101061189 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1108699

datafile 63 switched to datafile copy

input datafile copy RECID=128 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469

datafile 64 switched to datafile copy

input datafile copy RECID=129 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717

datafile 65 switched to datafile copy

input datafile copy RECID=130 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699

datafile 66 switched to datafile copy

input datafile copy RECID=131 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239

datafile 67 switched to datafile copy

input datafile copy RECID=132 STAMP=1101061190 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1100127

contents of Memory Script:

{

set until scn 5965174432198;

recover

clone database

delete archivelog

;

}

executing Memory Script

executing command: SET until clause

Starting recover at 03-APR-22

starting media recovery

channel c1: starting archived log restore to default destination

channel c1: restoring archived log

archived log thread=1 sequence=9

channel c1: reading from backup piece /media/sf_19c_EBS12210_Backup/FBS_A_14_1_1100965558.bak

channel c1: piece handle=/media/sf_19c_EBS12210_Backup/FBS_A_14_1_1100965558.bak tag=TAG20220402T154557

channel c1: restored backup piece 1

channel c1: restore complete, elapsed time: 00:00:03

archived log file name=/u01/app/FBS/db/tech_st/19c/dbs/arch1_9_1099181806.arc thread=1 sequence=9

channel clone_default: deleting archived log(s)

archived log file name=/u01/app/FBS/db/tech_st/19c/dbs/arch1_9_1099181806.arc RECID=1 STAMP=1101061219

media recovery complete, elapsed time: 00:00:07

Finished recover at 03-APR-22

released channel: c1

released channel: c2

Oracle instance started

Total System Global Area 2147482136 bytes

Fixed Size 9136664 bytes

Variable Size 436207616 bytes

Database Buffers 1677721600 bytes

Redo Buffers 24416256 bytes

contents of Memory Script:

{

sql clone "alter system set db_name =

''BEECDB'' comment=

''Reset to original value by RMAN'' scope=spfile";

sql clone "alter system reset db_unique_name scope=spfile";

}

executing Memory Script

sql statement: alter system set db_name = ''BEECDB'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance started

Total System Global Area 2147482136 bytes

Fixed Size 9136664 bytes

Variable Size 436207616 bytes

Database Buffers 1677721600 bytes

Redo Buffers 24416256 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "BEECDB" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 1024

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ( '+EBS_DATA/funcdb/redo01.log' ) SIZE 1000 M REUSE,

GROUP 2 ( '+EBS_DATA/funcdb/redo02.log' ) SIZE 1000 M REUSE,

GROUP 3 ( '+EBS_DATA/funcdb/redo03.log' ) SIZE 1000 M REUSE

DATAFILE

'+EBS_DATA/funcdb/system01.dbf',

'+EBS_DATA/funcdb/pdbseed/system01.dbf',

'+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.273.1101059827'

CHARACTER SET AL32UTF8

contents of Memory Script:

{

set newname for tempfile 1 to

"+EBS_DATA/funcdb/temp01.dbf";

set newname for tempfile 2 to

"+EBS_DATA/funcdb/pdbseed/temp012022-03-13_01-57-38-003-am.dbf";

set newname for tempfile 3 to

"+EBS_DATA";

set newname for tempfile 4 to

"+EBS_DATA";

set newname for tempfile 5 to

"+EBS_DATA";

switch clone tempfile all;

catalog clone datafilecopy "+EBS_DATA/funcdb/sysaux01.dbf",

"+EBS_DATA/funcdb/undotbs01.dbf",

"+EBS_DATA/funcdb/pdbseed/sysaux01.dbf",

"+EBS_DATA/funcdb/users01.dbf",

"+EBS_DATA/funcdb/pdbseed/undotbs01.dbf",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101058697",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101057047",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1101059841",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1101059843",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1101059827",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1101058383",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1101057051",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1101057307",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1101059827",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101059843",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101059825",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101057307",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101059841",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101059827",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101057307",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1101057899",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1101059843",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1101057051",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1101058433",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1101059415",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1101060667",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239",

"+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101060127";

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +EBS_DATA/funcdb/temp01.dbf in control file

renamed tempfile 2 to +EBS_DATA/funcdb/pdbseed/temp012022-03-13_01-57-38-003-am.dbf in control file

renamed tempfile 3 to +EBS_DATA in control file

renamed tempfile 4 to +EBS_DATA in control file

renamed tempfile 5 to +EBS_DATA in control file

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/sysaux01.dbf RECID=1 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/undotbs01.dbf RECID=2 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf RECID=3 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/users01.dbf RECID=4 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf RECID=5 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383 RECID=6 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051 RECID=7 STAMP=1101061295

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307 RECID=8 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843 RECID=9 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307 RECID=10 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383 RECID=11 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825 RECID=12 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305 RECID=13 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383 RECID=14 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825 RECID=15 STAMP=1101061296

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305 RECID=16 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049 RECID=17 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383 RECID=18 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825 RECID=19 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305 RECID=20 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841 RECID=21 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049 RECID=22 STAMP=1101061297

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383 RECID=23 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699 RECID=24 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053 RECID=25 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621 RECID=26 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383 RECID=27 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051 RECID=28 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843 RECID=29 STAMP=1101061298

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699 RECID=30 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733 RECID=31 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827 RECID=32 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101058697 RECID=33 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101057047 RECID=34 STAMP=1101061299

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1101059841 RECID=35 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1101058383 RECID=36 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1101059843 RECID=37 STAMP=11010612

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1101058699 RECID=38 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1101059827 RECID=39 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1101058383 RECID=40 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1101057051 RECID=41 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1101057307 RECID=42 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1101059827 RECID=43 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1101058699 RECID=44 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101059843 RECID=45 STAMP=1101061300

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101059825 RECID=46 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101057307 RECID=47 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101059841 RECID=48 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101059827 RECID=49 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101057307 RECID=50 STAMP=1101061301

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1101057899 RECID=51 STAMP=1101061

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1101059843 RECID=52 STAMP=1101061

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1101057051 RECID=53 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1101058433 RECID=54 STAMP=1101062

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1101059415 RECID=55 STAMP=11010613

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1101058699 RECID=56 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1101060667 RECID=57 STAMP=110106130

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101058699 RECID=58 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469 RECID=59 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717 RECID=60 STAMP=1101061302

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699 RECID=61 STAMP=1101061303

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239 RECID=62 STAMP=1101061303

cataloged datafile copy

datafile copy file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101060127 RECID=63 STAMP=1101061303

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=1101061295 file name=+EBS_DATA/funcdb/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=1101061295 file name=+EBS_DATA/funcdb/undotbs01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=3 STAMP=1101061295 file name=+EBS_DATA/funcdb/pdbseed/sysaux01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=4 STAMP=1101061295 file name=+EBS_DATA/funcdb/users01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=5 STAMP=1101061295 file name=+EBS_DATA/funcdb/pdbseed/undotbs01.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=6 STAMP=1101061295 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.286.1101058383

datafile 11 switched to datafile copy

input datafile copy RECID=7 STAMP=1101061295 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.342.1101057051

datafile 12 switched to datafile copy

input datafile copy RECID=8 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.322.1101057307

datafile 13 switched to datafile copy

input datafile copy RECID=9 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.266.1101059843

datafile 14 switched to datafile copy

input datafile copy RECID=10 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.321.1101057307

datafile 15 switched to datafile copy

input datafile copy RECID=11 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.324.1101058383

datafile 16 switched to datafile copy

input datafile copy RECID=12 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.312.1101059825

datafile 17 switched to datafile copy

input datafile copy RECID=13 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.333.1101057305

datafile 18 switched to datafile copy

input datafile copy RECID=14 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.327.1101058383

datafile 19 switched to datafile copy

input datafile copy RECID=15 STAMP=1101061296 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.306.1101059825

datafile 20 switched to datafile copy

input datafile copy RECID=16 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.332.1101057305

datafile 21 switched to datafile copy

input datafile copy RECID=17 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.339.1101057049

datafile 22 switched to datafile copy

input datafile copy RECID=18 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.326.1101058383

datafile 23 switched to datafile copy

input datafile copy RECID=19 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.296.1101059825

datafile 24 switched to datafile copy

input datafile copy RECID=20 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.331.1101057305

datafile 25 switched to datafile copy

input datafile copy RECID=21 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.271.1101059841

datafile 26 switched to datafile copy

input datafile copy RECID=22 STAMP=1101061297 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.338.1101057049

datafile 27 switched to datafile copy

input datafile copy RECID=23 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.291.1101058383

datafile 28 switched to datafile copy

input datafile copy RECID=24 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.313.1101058699

datafile 29 switched to datafile copy

input datafile copy RECID=25 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.341.1101057053

datafile 30 switched to datafile copy

input datafile copy RECID=26 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.257.1101057621

datafile 31 switched to datafile copy

input datafile copy RECID=27 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.281.1101058383

datafile 32 switched to datafile copy

input datafile copy RECID=28 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.337.1101057051

datafile 33 switched to datafile copy

input datafile copy RECID=29 STAMP=1101061298 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/system.268.1101059843

datafile 34 switched to datafile copy

input datafile copy RECID=30 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/ctxd.288.1101058699

datafile 35 switched to datafile copy

input datafile copy RECID=31 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/owapub.280.1101058733

datafile 36 switched to datafile copy

input datafile copy RECID=32 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/portal.258.1101057827

datafile 37 switched to datafile copy

input datafile copy RECID=33 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.284.1101097

datafile 38 switched to datafile copy

input datafile copy RECID=34 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_undots1.340.1101047

datafile 39 switched to datafile copy

input datafile copy RECID=35 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.272.1159841

datafile 40 switched to datafile copy

input datafile copy RECID=36 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.278.1158383

datafile 41 switched to datafile copy

input datafile copy RECID=37 STAMP=1101061299 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.269.1159843

datafile 42 switched to datafile copy

input datafile copy RECID=38 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_data.305.1158699

datafile 43 switched to datafile copy

input datafile copy RECID=39 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.274.1109827

datafile 44 switched to datafile copy

input datafile copy RECID=40 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.282.1108383

datafile 45 switched to datafile copy

input datafile copy RECID=41 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.343.1107051

datafile 46 switched to datafile copy

input datafile copy RECID=42 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.259.1107307

datafile 47 switched to datafile copy

input datafile copy RECID=43 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.276.1109827

datafile 48 switched to datafile copy

input datafile copy RECID=44 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tx_idx.283.1108699

datafile 49 switched to datafile copy

input datafile copy RECID=45 STAMP=1101061300 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101043

datafile 50 switched to datafile copy

input datafile copy RECID=46 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.304.1101025

datafile 51 switched to datafile copy

input datafile copy RECID=47 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.330.1101007

datafile 52 switched to datafile copy

input datafile copy RECID=48 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.270.1101041

datafile 53 switched to datafile copy

input datafile copy RECID=49 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.275.1101027

datafile 54 switched to datafile copy

input datafile copy RECID=50 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.323.1101007

datafile 55 switched to datafile copy

input datafile copy RECID=51 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.325.1057899

datafile 56 switched to datafile copy

input datafile copy RECID=52 STAMP=1101061301 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_interface.267.1059843

datafile 57 switched to datafile copy

input datafile copy RECID=53 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_summary.334.1157051

datafile 58 switched to datafile copy

input datafile copy RECID=54 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_nologging.289.1058433

datafile 59 switched to datafile copy

input datafile copy RECID=55 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_archive.277.1159415

datafile 60 switched to datafile copy

input datafile copy RECID=56 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.295.1108699

datafile 61 switched to datafile copy

input datafile copy RECID=57 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_queues.262.1100667

datafile 62 switched to datafile copy

input datafile copy RECID=58 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_media.311.1101699

datafile 63 switched to datafile copy

input datafile copy RECID=59 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/odm.290.1101059469

datafile 64 switched to datafile copy

input datafile copy RECID=60 STAMP=1101061302 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/olap.293.1101058717

datafile 65 switched to datafile copy

input datafile copy RECID=61 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.292.1101058699

datafile 66 switched to datafile copy

input datafile copy RECID=62 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/sysaux.263.1101060239

datafile 67 switched to datafile copy

input datafile copy RECID=63 STAMP=1101061303 file name=+EBS_DATA/BEECDB/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_tools.264.1101127

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

contents of Memory Script:

{

sql clone "alter pluggable database all open";

}

executing Memory Script

sql statement: alter pluggable database all open

Cannot remove created server parameter file

Finished Duplicate Db at 03-APR-22

Start the new target CDB in open mode

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

BEECDB READ WRITE

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 FBS READ WRITE NO

SQL>

11.8 Target PDB Steps

export ORACLE_SID=<CDB SID>

If the Target PDB name needs to be changed to a value different from the Source PDB Name, perform the following steps

11.8.1 Verify if any service already exists with the Target PDB name.

Run the following commands:

$ sqlplus / as sysdba

SQL> alter session set container="<SOURCE PDB_NAME>";

SQL> select count(*) from cdb_services c, service$ s

where upper(s.name) = upper('<TARGET PDB_NAME>')

and s.deletion_date is null

and s.name = c.name;

[oracle@ebsdomo dbs]$ export ORACLE_SID=cdbfbs

[oracle@ebsdomo dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:08:59 2022

Version 19.10.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> alter session set container="FBS";

Session altered.

SQL> select count(*) from cdb_services c, service$ s where upper(s.name) = upper('<TARGET PDB_NAME>') and s.deletion_date is null and s.name = c.name;

COUNT(*)

----------

11.8.2 If any service already exists with the Target PDB name, delete it as follows: (Not needed as no services with SOURCE PDB name exists)

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter session set container="<SOURCE PDB_NAME>";

SQL> dbms_service.delete_service('<TARGET PDB_NAME>');

11.8.3 Run the following steps to rename the PDB.

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter pluggable database "<SOURCE PDB NAME>" close;

SQL> alter pluggable database "<SOURCE PDB NAME>" unplug into '<ORACLE_HOME>/dbs/<SOURCE PDB NAME>.xml';

SQL> drop pluggable database "<SOURCE PDB NAME>";

SQL>create pluggable database "<NEW PDB NAME>" using '<ORACLE_HOME>/dbs/<SOURCE PDB NAME>.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_<SOURCE PDB NAME>','ebs_<TARGET PDB NAME>','<SOURCE PDB NAME>_ebs_patch','<TARGET PDB NAME>_ebs_patch');

SQL> alter pluggable database "<TARGET PDB NAME>" open read write;

[oracle@ebsdomo dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:11:39 2022

Version 19.10.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> alter pluggable database "FBS" close;

Pluggable database altered.

SQL> alter pluggable database "FBS" unplug into '/u01/app/FBS/db/tech_st/19c/dbs/FBS.xml';

Pluggable database altered.

SQL> drop pluggable database "FBS";

Pluggable database dropped.

SQL> create pluggable database "FBS" using '/u01/app/FBS/db/tech_st/19c/dbs/FBS.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_FBS','ebs_BEE','FBS_ebs_patch','FBS_ebs_patch');

Pluggable database created.

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

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

4 BEE READ WRITE NO

Note:

The PDB name should not be more than 8 characters.

The PDB should be renamed only using the above approach to retain the case of the PDB name.

11.8.4 Startup the PDB and save its state by running the following commands:

export ORACLE_SID=<CDB SID>

$ sqlplus / as sysdba

SQL> alter pluggable database all open; (in case of a single-node database)

SQL> alter pluggable database all open instances=all; (in case of an Oracle RAC database)

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

SQL> alter pluggable database all open;

Pluggable database altered.

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

Pluggable database altered.

11.8.5 Run the library update script against the Oracle database.

export ORACLE_SID=<CDB SID>

$ 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, or dll for Windows.

[oracle@ebsdomo dbs]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/install/

[oracle@ebsdomo install]$ ls

adlnkoh.sh FBS_ebsdomo

[oracle@ebsdomo install]$ cd FBS_ebsdomo/

[oracle@ebsdomo FBS_ebsdomo]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 3 19:57:18 2022

Version 19.10.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> @adupdlib.sql so

PL/SQL procedure successfully completed.

11.9 Set the Target UTL_FILE_DIR Values in Oracle Database

Connect CDB databse and set below parameter

alter system reset db_domain scope=spfile;

Restart CDB Listener

Restart DATABASE

Starting with Oracle Database 19c, UTL_FILE_DIR is not a supported database initialization parameter. Therefore, additional steps must be performed to retain the functionality provided by this parameter with Oracle E-Business Suite instance.

Perform the following steps to set the target UTL_FILE_DIR values in the database.

Source the environment file.

$ cd <ORACLE_HOME>

$ source <CONTEXT_NAME>.env

11.9.1 Obtain the existing value for the UTL_FILE_DIR using the following commands:

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=getUtlFileDir

This will create a text file <DB_NAME>_utlfiledir.txt under the <ORACLE_HOME>/dbs directory with references to the target Oracle home.

[oracle@ebsdomo FBS_ebsdomo]$ perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml -oraclehome=/u01/app/FBS/db/tech_st/19c -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log -mode=getUtlFileDir

Enter the APPS Password:

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.31

Started : Mon Feb 10 13:16:17 EAT 2025

Log File : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Mon_Feb_10_13_16_14_2025/txkCfgUtlfileDir.log

Context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml exists.

==============================================================================

Successfully generated the below file with UTL_FILE_DIR content:

/u01/app/FBS/db/tech_st/19c/dbs/FBS_utlfiledir.txt

==============================================================================

Completed : Mon Feb 10 13:16:18 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

Review the <DB_NAME>_utlfiledir.txt file and edit the values, if required.

Note: Before proceeding to the next step, ensure to create the physical directories for all directory paths being specified in the <DB_NAME>_utlfiledir.txt file.

cd $ORACLE_HOME/dbs

cat FBS_utlfiledir.txt

edit FBS_utlfiledir.txt as it would be having source instance details. I will replace FBS with BEE and create directories. You can set based on your needs.

Now make the directory structures.

mkdir -p /u01/app/EBS/db/tech_st/temp/FBS

mkdir -p /u01/app/EBS/db/tech_st/19c/appsutil/outbound/FBS_ebsdomo

mkdir -p /u01/app/EBS/db/tech_st/temp/FBS

11.9.2 Run the following command to store the updated values for UTL_FILE_DIR in the database:

$ cd <ORACLE_HOME>/appsutil/bin

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log \

-mode=setUtlFileDir

This command will validate the directory paths provided in the <DB_NAME>_utlfiledir.txt for existence and will also create directory objects for all the physical directory paths.

[oracle@ebsdomo 19c]$ . FBS_ebsdomo.env

[oracle@ebsdomo 19c]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/bin

[oracle@ebsdomo bin]$ perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml -oraclehome=/u01/app/FBS/db/tech_st/19c -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log -mode=setUtlFileDir

Enter the APPS Password:

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.31

Started : Mon Feb 10 13:21:41 EAT 2025

Log File : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Mon_Feb_10_13_21_38_2025/txkCfgUtlfileDir.log

Context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml exists.

Enter the ebs_system Password:

Completed : Mon Feb 10 13:21:57 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

11.9.3 Run the followind command to create the directory object for the outbound directory (pointed to by the s_outbound_dir context variable in the database tier context file).

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> \

-oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=createDirObject

When prompted for the OS path for the directory object to be created, enter the value of the s_outbound_dir context variable in the database tier context file.

source <CONTEXT_NAME>.env

[oracle@ebsdomo bin]$ grep -i s_outbound_dir /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

<OUTBOUND_DIR oa_var="s_outbound_dir">/u01/app/EBS/db/tech_st/19c/appsutil/outbound/EBS_ebsdomo</OUTBOUND_DIR>

Enter the APPS Password:

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.31

Started : Mon Feb 10 13:24:36 EAT 2025

Log File : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Mon_Feb_10_13_24_34_2025/txkCfgUtlfileDir.log

Context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml exists.

Enter the ebs_system Password:

Enter the OS path for which directory object needs to be created: /u01/app/FBS/db/tech_st/19c/appsutil/outbound/FBS_ebsdomo

Completed : Mon Feb 10 13:25:37 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

11.9.4 Sync up the value of UTL_FILE_DIR in the database tier context file by running the following command:

$ perl <ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=<DB Context File> -oraclehome=<ORACLE_HOME> -outdir=<ORACLE_HOME>/appsutil/log -mode=syncUtlFileDir -skipautoconfig=yes

source <CONTEXT_NAME>.env

Enter the APPS Password:

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12020000.31

Started : Mon Feb 10 13:28:45 EAT 2025

Log File : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Mon_Feb_10_13_28_42_2025/txkCfgUtlfileDir.log

Context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Completed : Mon Feb 10 13:28:47 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

11.10 Configure the Target Database

Run the adcfgclone utility to configure the target database.

$ cd <ORACLE_HOME>/appsutil/clone/bin

$ perl adcfgclone.pl dbconfig <Target Database context file>

The target database context file is <ORACLE_HOME>/appsutil/<Target context_name>.xml.

Note: The dbconfig option will configure the database with the required settings for the new target, but it will not recreate the control files.

[oracle@ebsdomo 19c]$ . FBS_ebsdomo.env

[oracle@ebsdomo 19c]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin

[oracle@ebsdomo bin]$ perl adcfgclone.pl dbconfig /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.86

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/adclone.pl java=/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre mode=apply stage=/u01/app/FBS/db/tech_st/19c/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml showProgress contextValidated=false

Beginning dbconfig Apply - Mon Feb 10 13:31:19 2025

/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -Doracle.jdbc.DateZeroTime=true -Doracle.jdbc.DateZeroTimeExtra=true -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/app/FBS/db/tech_st/19c/oui -classpath /u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/ojdbc8.jar::/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/java:/u01/app/FBS/db/tech_st/19c/appsutil/clone/../../jlib/orai18n.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/ewt3.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/share.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/oui/srvm.jar:/u01/app/FBS/db/tech_st/19c/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml -stage /u01/app/FBS/db/tech_st/19c/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/ApplyDatabase_02101331.log

| 0% completed

Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_ebsdomo/ApplyDatabase_02101331.log

- 30% completed

Completed Apply...

Mon Feb 10 13:33:10 2025

Running:

/u01/app/FBS/db/tech_st/19c/bin/sqlplus -s /nolog @/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/sqlCmd.sql > /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/get_ad_codelevel.log 2>&1

Running ETCC to check status of DB technology patches...

Version of /u01/app/FBS/db/tech_st/19c/appsutil/etcc/checkDBpatch.sh is 120.127

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Using context file from command line argument:

/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebsdomo.xml

Starting Database EBS Technology Codelevel Checker, Version 120.127

Mon Feb 10 13:33:10 EAT 2025

Log file for this session: /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/log/checkDBpatch_21697.log

Identifying database release.

Database release set to 19.24.0.0.

Multitenant identified.

- Container database (CDB) identified via s_cdb_name is cdbfbs

- Pluggable database (PDB) identified via s_pdb_name is FBS

Connecting to database.

Database connection successful.

Database FBS is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema: APPS

- APPLSYS schema: APPLSYS

Checking for existence DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Bugfix file /u01/app/FBS/db/tech_st/19c/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml: 120.0.12020000.85

This file will be used for identifying missing bugfixes.

Mapping file /u01/app/FBS/db/tech_st/19c/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.61

This file will be used for mapping bugfixes to patches.

+---------------------------------------------------------------------------------------+

Always use the latest version of ETCC available in patch 17537119,

as new bugfixes will not be checked by older versions of the utility.

You should apply the latest recommended RU, BP, or PSU as appropriate.

+---------------------------------------------------------------------------------------+

Identified database DST version: 43

Checking Bugfix XML file for tag 19.24.0.0_RU.

Obtained list of bugfixes to be applied and list to be rolled back.

Validating OPatch version:

The OPatch utility is version 12.2.0.1.43.

DB-ETCC is compatible with this OPatch version.

Checking for applied patch history:

Found patch history in the inventory.

Checking mapping XML file for tag 19.24.0.0.240716DBRU.

All the required one-off bugfixes are present in database ORACLE_HOME.

+---------------------------------------------------------------------------------------+

[WARNING] 36912597 - DATABASE RELEASE UPDATE 19.25.0.0.241015 is not applied.

This is the recommended database Release Update. You should install it now

and then rerun this script to check for any further fixes available.

- Filename: p36912597_190000_Linux-x86-64.zip

Alternatively, you can remain on your existing Release Update and apply all

the patches listed above from the consolidated zip file, which is only shown

when patches need to be installed.

+---------------------------------------------------------------------------------------+

Finished checking fixes for database FBS: Mon Feb 10 13:33:30 EAT 2025

Log file for this session: /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/log/checkDBpatch_21697.log

This file should be reviewed for errors after the ETCC run.

=========================================================================================

11.11 Configure Target Application Node

Before starting adcfgclone.pl, clean up the PATCH FS, FS_NE, and oraInventory directories if it already a test instance and we are refreshing it. Else in case of new server create these directories.

Run the following commands to configure the application:

cd <COMMON_TOP>/clone/bin

perl ./adcfgclone.pl appsTier dualfs

[applmgr@ebsdomo bin]$ cd /u01/app/FBS/fs1/EBSapps/comn/clone/bin/

[applmgr@ebsdomo bin]$ perl ./adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.86

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 /u01/app/FBS/fs1/EBSapps/comn/clone/bin/CloneContext_0211104717.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [ebsdomo] :

Target System Database SID : FBS

Target System Database Server Node [ebsdomo] :

Target System Database Domain Name [finsys.co.ke] :

Target System Base Directory : /u01/app/FBS

Target System Base Directory set to /u01/app/FBS

Target System Current File System Base set to /u01/app/FBS/fs1

Target System Other File System Base set to /u01/app/FBS/fs2

Target System Fusion Middleware Home set to /u01/app/FBS/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /u01/app/FBS/fs2/FMW_Home

Target System Web Oracle Home set to /u01/app/FBS/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /u01/app/FBS/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/app/FBS/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /u01/app/FBS/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/app/FBS/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /u01/app/FBS/fs2/EBSapps/comn

Target System Instance Home Directory [/u01/app/FBS] :

Target System Current File System Instance Top set to /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo

Do you want to preserve the Display [fbsebs:0.0] (y/n) : n

Target System Display [ebsdomo: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] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : y

Validating if the source port numbers are available on the target system..

Complete port information available at /u01/app/FBS/fs1/EBSapps/comn/clone/bin/out/FBS_ebsdomo/portpool.lst

Target System proxy port [80] :

EBS_APPLPTMP consists of below directory.

1. /u01/app/FBS/db/tech_st/temp/FBS

Choose a value which will be set as APPLPTMP on the target node [1] :

The new APPL_TOP context file has been created :

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/appl/admin/FBS_ebsdomo.xml

Check Clone Context logfile /u01/app/FBS/fs1/EBSapps/comn/clone/bin/CloneContext_0211104717.log for details.

Creating Patch file system context file.....

Log file located at /u01/app/FBS/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0211105219.log

Target System Other File System Instance Top set to /u01/app/FBS/fs2/inst/apps/FBS_ebsdomo

Validating if the source port numbers are available on the target system..

Complete port information available at /u01/app/FBS/fs1/EBSapps/comn/clone/bin/out/FBS_ebsdomo/portpool.lst

The new APPL_TOP context file has been created :

/u01/app/FBS/fs2/inst/apps/FBS_ebsdomo/appl/admin/FBS_ebsdomo.xml

Check Clone Context logfile /u01/app/FBS/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0211105219.log for details.

FMW Pre-requisite check log file location : /u01/app/FBS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/log/clone/run/RCloneApplyAppstier_02111052.log

Configuring: Patch file system....

LogFile located at /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/log/clone/patch/RCloneApplyAppstier_02111116.log

Do you want to startup the Application Services for FBS? (y/n) [n] : y

Starting application Services for FBS:

You are running adstrtal.sh version 120.24.12020000.11

The logfile for this session is located at /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adstrtal.log

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/jtffmctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running jtffmctl.sh version 120.3.12020000.4

Validating Fulfillment patch level via /u01/app/FBS/fs1/EBSapps/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for FBS on port 9310 ...

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adopmnctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adopmnctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adapcctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

You are running adapcctl.sh version 120.0.12020000.6

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adapcctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adnodemgrctl.sh start -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running adnodemgrctl.sh version 120.11.12020000.12

Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS

Perl script txkChkEBSDependecies.pl got executed successfully

Starting the Node Manager...

Refer /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adnodemgrctl.txt for details

NodeManager log is located at /u01/app/FBS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adnodemgrctl.txt for more information ...

.end std out.

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/rgf/TXK/txkChkEBSDependecies_Tue_Feb_11_11_58_47_2025/txkChkEBSDependecies_Tue_Feb_11_11_58_47_2025.log

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adalnctl.sh start

Timeout specified in context file: 100 second(s)

script returned:

****************************************************

adalnctl.sh version 120.3.12020000.4

Checking for FNDFS executable.

Starting listener process APPS_FBS.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adalnctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adcmctl.sh start

Timeout specified in context file: 1000 second(s)

script returned:

****************************************************

You are running adcmctl.sh version 120.19.12020000.7

Starting concurrent manager for FBS ...

Starting FBS_0211@FBS Internal Concurrent Manager

Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adcmctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/adadminsrvctl.sh start -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running adadminsrvctl.sh version 120.10.12020000.11

Starting WLS Admin Server...

Refer /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/app/FBS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adadminsrvctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting forms_server1...

Server specific logs are located at /u01/app/FBS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/forms_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adformsctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting oafm_server1...

Server specific logs are located at /u01/app/FBS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oafm_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adoafmctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)

script returned:

****************************************************

You are running admanagedsrvctl.sh version 120.14.12020000.12

Starting oacore_server1...

Server specific logs are located at /u01/app/FBS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server1/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adoacorectl.txt for more information ...

.end std out.

.end err out.

****************************************************

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/app/FBS/fs1/inst/apps/FBS_ebsdomo/logs/appl/admin/log/adstrtal.log for more information ...

If this is a repeated cloning instance, you can also use the backup of a CONTEXT_FILE. Run the following command:

perl ./adcfgclone.pl appsTier <location of CONTEXT_FILE backup> dualfs

11.12 Start Application Services and Validate

You can now start all application services of the target clone instance validate the services.

Reference:

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

Pages

11 Oracle EBS 12.2.14 Clone with 19c Database

No comments:

Post a Comment