Oracle Apps/DBA: 4.b Clone an EBS R12.1.3 application along with Database 19.26.0.0

Source Environment:
EBS: R12.1.3
DB: 19.0.0.0
SID: FBS
Server: fbstest.finsys.co.ke
DB OS user: oracle
Apps OS user: applmgr
OEL Version: 8.10
Target Environment:
EBS: R12.1.3
DB: 19.26.0.0
SID: VIS
Server: ebstest.finsys.co.ke
DB OS user: oracle
Apps OS user: applmgr
OEL Version: Any (but mine is on 8.10)

In case your target machine is new, please perform all pre-requisite required for an EBS environment.
Pre-req Steps:
On the source application tier below patches should be applied. If it is not applied cloning will have errors.
4.1 Apply below patches on the application tier. Please read the Readme and follow the instructions carefully. These are critical before starting the cloning process.

23569686-R12.AD.B.delta.8
27102203-TXK AutoConfig Template Rollup patch
27135427-12.1 RAPIDCLONE CONSOLIDATED FIXES AUG/2018
Verify the below bugs as well.
select bug_number from ad_bugs where bug_number in ('9171651','9833058','12404574','12598630','15969020'

,'16958896','13942692','8919489');

4.1.1 Now run autoconfig on the application tier.

4.1.2 Logout from applmgr and source the Environment again.

4.1.3 Recreate appsutil and copy to DB server Oracle Home

[applmgr@fbstest ~ ]$cd $APPL_TOP

[applmgr@fbstest ~ ]$. APPSFBS_fbstest.env

[applmgr@fbstest ~ ]$perl $AD_TOP/bin/admkappsutil.pl

Starting the generation of appsutil.zip

Log file located at /u01/apps/FBS/inst/apps/FBS_fbstest/admin/log/MakeAppsUtil_12011758.log

output located at /u01/apps/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

Copy the apputil.zip file to Database oracle home On DB-Tier:

Source the DB environment and start the listener.

[oracle@fbstest ~ ]$. fbscdb.env

[oracle@fbstest ~ ]$cd $ORACLE_HOME

[oracle@fbstest 19c ]$mv appsutil.zip appsutil.zip_orig

[oracle@fbstest 19c ]$cp /u01/apps/FBS/inst/apps/FBS_fbstest/admin/out/appsutil.zip .

unzip -o appsutil.zip

[oracle@fbstest 19c 08:42 PM]$cd $ORACLE_HOME/appsutil/bin

Now Run adconfig on DB Tier from same location as above

[oracle@fbstest bin]$ perl adconfig.pl contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbstest.xml

Enter the APPS user password:

The log file for this session is located at: /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_fbstest/02201341/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

	Using ORACLE_HOME location : /u01/app/FBS/db/tech_st/19c

	Classpath                   : :/u01/app/FBS/db/tech_st/19c/jdbc/lib/ojdbc8.jar:/u01/app/FBS/db/tech_st/19c

/appsutil/java/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/appsutil/java:/u01/app/FBS/db/tech_st/19c/jlib/netcfg.jar:

/u01/app/FBS/db/tech_st/19c/jlib/ldapjclnt19.jar

	Using Context file          : /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbstest.xml

Context Value Management will now update the Context file

	Updating Context file...COMPLETED

	Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db19

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Make sure the soft link below is present on the target system

For Linux 7 and 8

# cd /usr/lib

# ln -s libdb-5.3.so libdb-4.3.so

# cd /usr/lib

# ln -s libXm.so.4.0.4 libXm.so.2

For Linux 6 and 5

# unlink /usr/lib/libXtst.so.6

# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

The pre-Clone Steps source system

4.2 Run ad pre-clone on DB node.

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

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE

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

CDBFBS	  READ WRITE

SQL> show pdbs;

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED

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

	 2 PDB$SEED			  READ ONLY  NO

	 3 FBS				  READ WRITE NO

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

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

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@fbstest ~]$ . FBS_fbstest.env

[oracle@fbstest ~]$ cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

[oracle@fbstest FBS_fbstest]$ perl adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adpreclone Version 120.20.12010000.5

Enter the APPS User Password:

Running:

perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/adclone.pl java=/u01/app/FBS/db/tech_st

/19c/jdk/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_fbstest.xml showProgress

stty: 'standard input': Inappropriate ioctl for device

APPS Password :

stty: 'standard input': Inappropriate ioctl for device

Beginning database tier Stage - Thu Feb 20 14:07:23 2025

/u01/app/FBS/db/tech_st/19c/jdk/jre/bin/java -Xmx600M -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/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_fbstest.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_fbstest/StageDBTier_02201407.log

/ 50% completed

Completed Stage...

Thu Feb 20 14:07:36 2025

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

4.2.4 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

rman target /

run {

allocate channel c1 type disk;

allocate channel c2 type disk;

BACKUP as compressed backupset FULL FILESPERSET 10 FORMAT

'/u01/backup/FBS_D_%s_%p_%t.bak' DATABASE;

BACKUP as compressed backupset filesperset 10 FORMAT

'/u01/backup/FBS_A_%s_%p_%t.bak' ARCHIVELOG ALL skip

inaccessible;

BACKUP FORMAT '/u01/backup/FBS_C_%s_%p_%t.bak'

CURRENT CONTROLFILE;

RELEASE CHANNEL c1;

RELEASE CHANNEL c2;

}

[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: CDBFBS (DBID=3473472359)

RMAN> run {

allocate channel c1 type disk;

allocate channel c2 type disk;

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

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

BACKUP FORMAT '/u01/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=/u01/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=/u01/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=/u01/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=/u01/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=/u01/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/CDBFBS/system01.dbf

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

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

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

piece handle=/u01/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/CDBFBS/undotbs01.dbf

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

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

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

piece handle=/u01/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/CDBFBS/pdbseed/system01.dbf

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

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

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

piece handle=/u01/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/CDBFBS/pdbseed/sysaux01.dbf

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

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

piece handle=/u01/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=/u01/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=/u01/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=/u01/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=/u01/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=/u01/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=/oraapps122/DATABASE/FBS/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.

4.2.5 C opy the Source binaries to Target

Perform the following steps to copy the source application binaries and

database binaries to the target node.

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

I will tar backup and copy on /u01/backup

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

4.3 Run ad pre-clone on the Application node.

[applmgr@fbstest ~ 09:35 PM]$. APPSFBS_fbstest.env

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

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adpreclone Version 120.20.12010000.5
Running:
perl /u01/app/FBS/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/u01/app/FBS/apps/tech_st/10.1.3/appsutil/jdk mode=stage 
stage=/u01/app/FBS/apps/apps_st/comn/clone component=appsTier method= appctx=/u01/app/FBS/inst/apps/FBS_fbstest/appl
/admin/FBS_fbstest.xml showProgress 
stty: 'standard input': Inappropriate ioctl for device
APPS Password : 
stty: 'standard input': Inappropriate ioctl for device
method defaulted to CUSTOM
Beginning application tier Stage - Thu Feb 20 14:16:37 2025
/u01/app/FBS/apps/tech_st/10.1.3/appsutil/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui -
classpath /u01/app/FBS/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/u01/app/FBS/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:
/u01/app/FBS/apps/apps_st/comn/java/classes:/u01/app/FBS/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:
/u01/app/FBS/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/u01/app/FBS/apps/tech_st/10.1.3/oui/jlib/share.jar:
/u01/app/FBS/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/u01/app/FBS/apps/tech_st/10.1.3/jlib/ojmisc.jar  
oracle.apps.ad.clone.StageAppsTier -e /u01/app/FBS/inst/apps/FBS_fbstest/appl/admin/FBS_fbstest.xml 
-stage /u01/app/FBS/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM   -showProgress
Log file located at /u01/app/FBS/inst/apps/FBS_fbstest/admin/log/StageAppsTier_02201416.log
  -     80% completed       
Completed Stage...
Thu Feb 20 14:17:09 2025

4.4 Copy the application tier file system

Log on to the source system application tier nodes as the APPLMGR user and shut down the application tier server processes. Copy the following application tier directories from the source node to the target application tier node:

[APPL_TOP]

[COMMON_TOP]

Applications Technology Stack:

[OracleAS Tools ORACLE_HOME]

[OracleAS Web IAS_ORACLE_HOME]

Make tar ball backup for Datafile folder and Application files.

[oracle@fbstest db 10:04 PM]$pwd

/u01/app/FBS/db

[oracle@fbstest db 10:04 PM]$tar -zcvf /u01/backup/db_19c.tar.gz apps_st

No need for INST_TOP from the Application node.

[applmgr@fbstest FBS 10:06 PM]$ls -ltr

total 8

drwxrwxr-x. 4 applmgr oinstall 4096 Nov 25 22:56 apps

drwxrwxr-x. 3 applmgr oinstall 4096 Nov 25 22:56 inst

[applmgr@fbstest FBS 10:06 PM]$tar -zcvf /u01/backup/appp_ebs121_19c.tar.gz apps

4.5 Create /etc/oraInst.loc file

[root@fbsebs]# cat /etc/oraInst.loc

inventory_loc=/u01/app/inventory

inst_group=dba

4.6 Configure Oracle Home on the target database node.

[oracle@fbsebs 19c]$ pwd
/u01/app/FBS/db/tech_st/19c
[oracle@fbsebs 19c]$ tar -zxvf /u01/backup/19c_home.tar.gz

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

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

4.6.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@fbsebs bin]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/
[oracle@fbsebs bin]$ ls
adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl  CloneContext_0221113100.log
[oracle@fbsebs bin]$ perl adclonectx.pl contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbstest.xml
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle E-Business Suite Rapid Clone
                                 Version 12.0.0
                      adclonectx Version 120.23.12010000.4
Running: 
/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -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 oracle.apps.ad.context.CloneContext  -e 
/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbstest.xml
Enter the APPS password : apps
Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/CloneContext_0221113249.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [fbsebs] : 
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/apps_st/cdbfbs] : 
Target System DATA_TOP Directory 2 [/u01/app/FBS/db/apps_st/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/db/tech_st/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 [fbsebs:0.0] : 
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 10
Report file located at /u01/app/FBS/db/tech_st/19c/appsutil/temp/portpool.lst
Complete port information available at /u01/app/FBS/db/tech_st/19c/appsutil/temp/portpool.lst
New context path and file name [/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml] : 
Creating the new Database Context file from :
  /u01/app/FBS/db/tech_st/19c/appsutil/template/adxdbctx.tmp
The new database context file has been created :
  /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml
Log file located at /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/CloneContext_0221113249.log
contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml
Check Clone Context logfile /u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/CloneContext_0221113249.log for details.

4.6.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:

[applmgr@fbsebs ~]$ cd /u01/app/FBS/

[applmgr@fbsebs FBS]$ ls

appp_ebs121.tar.gz db utlfiledir

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

[oracle@fbsebs bin]$ ls

adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl CloneContext_0221113100.log CloneContext_0221113249.log

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

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

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.17

Enter the APPS password :

Running Rapid Clone with command:

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_fbsebs.xml showProgress contextValidated=false noprompt

Running:

stty: 'standard input': Inappropriate ioctl for device

APPS Password :

stty: 'standard input': Inappropriate ioctl for device

Beginning rdbms home Apply - Fri Feb 21 11:43:14 2025

/u01/app/FBS/db/tech_st/19c/appsutil/clone/bin/../jre/bin/java -Xmx600M -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/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_fbsebs.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_fbsebs/ApplyDBTechStack_02211143.log

| 0% completed

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

- 0% completed

Completed Apply...

Fri Feb 21 11:45:40 2025

Ignore the ETCC warning.

4.6.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@fbsebs bin]$ export ORACLE_HOME=/u01/app/FBS/db/tech_st/19c

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

[oracle@fbsebs bin]$ export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

[oracle@fbsebs bin]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.38.2:$ORACLE_HOME/perl/site_perl/5.38.2:$ORACLE_HOME/appsutil/perl

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

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

[oracle@fbsebs appsutil]$ chmod 755 txkSetCfgCDB.env

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

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

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

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

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_2025/txkGenCDBTnsAdmin.log

Program : started @ Fri Feb 21 11:53:09 2025

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_2025/txkGenCDBTnsAdmin.log

Script Name : txkGenCDBTnsAdmin.pl

Script Version : 120.0.12010000.9

Started : Fri Feb 21 11:53:09 EAT 2025

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

-----------

Values used

-----------

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

CDB NAME : cdbfbs

CDB SID : cdbfbs

Database port : 1531

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

Is RAC? : no

Virtual Hostname :

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

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.

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

Inside getDBHostDetails()...

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

DB Hostname : fbsebs

DB Domain : finsys.co.ke

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

Inside getDBPort()...

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

DB Port passed as an argument, using the same.

DB Port: 1531

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

Inside generateCDBTNSAdminContent()...

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

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

Creating the directory: /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_2025/tns_admin_cdb_bkp/listener.ora

Copying the file

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

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_2025/tns_admin_cdb_bkp/tnsnames.ora

Copying the file

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

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_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_Fri_Feb_21_11_53_09_2025/tns_admin_cdb_bkp/sqlnet.ora

Copying the file

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

SOURCE : /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_CDB_TNS_ADMIN_Fri_Feb_21_11_53_09_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: Fri Feb 21 11:53:09 EAT 2025

4.6.4 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>

4.6.5 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).

4.7 Start the listener.

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

$ ./adcdblnctl.sh start <CDB SID>

[oracle@fbsebs bin]$ cd /u01/app/FBS/db/tech_st/19c/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]$ ./addlnctl.sh start cdbfbs

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

You are running addlnctl.sh version 120.1.12010000.4

Starting listener process cdbfbs ...

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-FEB-2025 11:56:54

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/FBS_fbsebs/listener.ora

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

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fbsebs.finsys.co.ke)(PORT=1531)))

STATUS of the LISTENER

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

Alias cdbfbs

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 21-FEB-2025 11:56:54

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

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

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fbsebs.finsys.co.ke)(PORT=1531)))

Services Summary...

Service "FBS" has 1 instance(s).

Instance "FBS", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/app/FBS/db/tech_st/19c/appsutil/log/FBS_fbsebs/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.

4.8 Restore and Recover the database

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

[oracle@fbsebs FBS_fbsebs]$ cd /u01/app/FBS/

[oracle@fbsebs FBS]$ tar -zxvf /u01/backup/db_121.tar.gz

4.8.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@fbsebs dbs]$ cp initcdbfbs.ora initFBS.ora

cd $ORACLE_HOME/dbs

vi initFBS.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=fbsebs.finsys.co.ke)(PORT=1531)))'

*.db_name='FBS'

Replace cdbfbs with cdbfbs

and FBS with FBS

mkdir -p /oraapps122/DATABASE/admin/beecdb/adump

4.8.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_fbstest.env

sqlplus '/as sysdba'

startup nomount pfile='/u01/app/FBS/db/tech_st/19c/dbs/initcdbcfbs.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@fbsebs dbs]$ rman target /

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

Version 19.26.0.0.0

connected to target database: cdbfsb (not mounted)

RMAN> exit

Recovery Manager complete.

[oracle@fbsebs dbs]$ rman auxiliary /

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

Version 19.26.0.0.0

connected to auxiliary database: cdbfsb (not mounted)

RMAN> run

{

allocate auxiliary channel c1 device type disk;

allocate auxiliary channel c2 device type disk;

duplicate database to 'cdbfsb' backup location '/u01/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-FEB-25

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 =

''cdbfbs'' comment=

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

sql clone "alter system set db_unique_name =

''cdbfsb'' comment=

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

shutdown clone immediate;

startup clone force nomount

restore clone primary controlfile from '/u01/backup/FUAT_C_16_1_1100965672.bak';

alter clone database mount;

}

executing Memory Script

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

sql statement: alter system set db_unique_name = ''cdbfsb'' 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-FEB-25

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/cdbfsb/control01.ctl

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

Finished restore at 03-FEB-25

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/cdbfbs/system01.dbf";

set newname for datafile 3 to

"+EBS_DATA/cdbfbs/sysaux01.dbf";

set newname for datafile 4 to

"+EBS_DATA/cdbfbs/undotbs01.dbf";

set newname for datafile 5 to

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

set newname for datafile 6 to

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

set newname for datafile 7 to

"+EBS_DATA/cdbfbs/users01.dbf";

set newname for datafile 8 to

"+EBS_DATA/cdbfbs/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-FEB-25

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/cdbfbs/system01.dbf

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

channel c1: reading from backup piece /u01/backup/FUAT_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 /u01/backup/FUAT_D_7_1_1100962099.bak

channel c1: piece handle=/u01/backup/FUAT_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 /u01/backup/FUAT_D_8_1_1100963337.bak

channel c2: piece handle=/u01/backup/FUAT_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 /u01/backup/FUAT_D_6_1_1100961031.bak

channel c1: piece handle=/u01/backup/FUAT_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 /u01/backup/FUAT_D_5_1_1100960404.bak

channel c2: piece handle=/u01/backup/FUAT_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/cdbfbs/pdbseed/system01.dbf

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

channel c2: reading from backup piece /u01/backup/FUAT_D_11_1_1100964744.bak

channel c1: piece handle=/u01/backup/FUAT_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/cdbfbs/pdbseed/sysaux01.dbf

channel c1: reading from backup piece /u01/backup/FUAT_D_12_1_1100964970.bak

channel c1: piece handle=/u01/backup/FUAT_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 /u01/backup/FUAT_D_4_1_1100958796.bak

channel c2: piece handle=/u01/backup/FUAT_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 /u01/backup/FUAT_D_3_1_1100958796.bak

channel c2: piece handle=/u01/backup/FUAT_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/cdbfbs/undotbs01.dbf

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

channel c2: reading from backup piece /u01/backup/FUAT_D_10_1_1100964740.bak

channel c2: piece handle=/u01/backup/FUAT_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=/u01/backup/FUAT_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-FEB-25

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/cdbfbs/system01.dbf

datafile 3 switched to datafile copy

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

datafile 4 switched to datafile copy

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

datafile 5 switched to datafile copy

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

datafile 6 switched to datafile copy

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

datafile 7 switched to datafile copy

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

datafile 8 switched to datafile copy

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

datafile 9 switched to datafile copy

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

datafile 10 switched to datafile copy

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

datafile 11 switched to datafile copy

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

datafile 12 switched to datafile copy

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

datafile 13 switched to datafile copy

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

datafile 14 switched to datafile copy

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

datafile 15 switched to datafile copy

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

datafile 16 switched to datafile copy

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

datafile 17 switched to datafile copy

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

datafile 18 switched to datafile copy

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

datafile 19 switched to datafile copy

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

datafile 20 switched to datafile copy

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

datafile 21 switched to datafile copy

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

datafile 22 switched to datafile copy

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

datafile 23 switched to datafile copy

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

datafile 24 switched to datafile copy

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

datafile 25 switched to datafile copy

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

datafile 26 switched to datafile copy

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

datafile 27 switched to datafile copy

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

datafile 28 switched to datafile copy

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

datafile 29 switched to datafile copy

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

datafile 30 switched to datafile copy

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

datafile 31 switched to datafile copy

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

datafile 32 switched to datafile copy

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

datafile 33 switched to datafile copy

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

datafile 34 switched to datafile copy

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

datafile 35 switched to datafile copy

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

datafile 36 switched to datafile copy

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

datafile 37 switched to datafile copy

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

datafile 38 switched to datafile copy

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

datafile 39 switched to datafile copy

input datafile copy RECID=104 STAMP=1101061187 file name=+EBS_DATA/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101843

datafile 50 switched to datafile copy

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

datafile 51 switched to datafile copy

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

datafile 52 switched to datafile copy

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

datafile 53 switched to datafile copy

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

datafile 54 switched to datafile copy

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

datafile 55 switched to datafile copy

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

datafile 56 switched to datafile copy

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

datafile 57 switched to datafile copy

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

datafile 58 switched to datafile copy

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

datafile 59 switched to datafile copy

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

datafile 60 switched to datafile copy

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

datafile 61 switched to datafile copy

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

datafile 62 switched to datafile copy

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

datafile 63 switched to datafile copy

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

datafile 64 switched to datafile copy

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

datafile 65 switched to datafile copy

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

datafile 66 switched to datafile copy

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

datafile 67 switched to datafile copy

input datafile copy RECID=132 STAMP=1101061190 file name=+EBS_DATA/cdbfsb/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-FEB-25

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 /u01/backup/FUAT_A_14_1_1100965558.bak

channel c1: piece handle=/u01/backup/FUAT_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-FEB-25

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 =

''cdbfsb'' 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 = ''cdbfsb'' 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 "cdbfsb" RESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 1024

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

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

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

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

DATAFILE

'+EBS_DATA/cdbfbs/system01.dbf',

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

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

CHARACTER SET AL32UTF8

contents of Memory Script:

{

set newname for tempfile 1 to

"+EBS_DATA/cdbfbs/temp01.dbf";

set newname for tempfile 2 to

"+EBS_DATA/cdbfbs/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/cdbfbs/sysaux01.dbf",

"+EBS_DATA/cdbfbs/undotbs01.dbf",

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

"+EBS_DATA/cdbfbs/users01.dbf",

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

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

renamed tempfile 2 to +EBS_DATA/cdbfbs/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/cdbfbs/sysaux01.dbf RECID=1 STAMP=1101061295

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

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

cataloged datafile copy

datafile copy file name=+EBS_DATA/cdbfsb/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/cdbfbs/sysaux01.dbf

datafile 4 switched to datafile copy

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

datafile 6 switched to datafile copy

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

datafile 7 switched to datafile copy

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

datafile 8 switched to datafile copy

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

datafile 10 switched to datafile copy

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

datafile 11 switched to datafile copy

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

datafile 12 switched to datafile copy

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

datafile 13 switched to datafile copy

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

datafile 14 switched to datafile copy

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

datafile 15 switched to datafile copy

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

datafile 16 switched to datafile copy

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

datafile 17 switched to datafile copy

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

datafile 18 switched to datafile copy

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

datafile 19 switched to datafile copy

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

datafile 20 switched to datafile copy

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

datafile 21 switched to datafile copy

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

datafile 22 switched to datafile copy

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

datafile 23 switched to datafile copy

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

datafile 24 switched to datafile copy

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

datafile 25 switched to datafile copy

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

datafile 26 switched to datafile copy

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

datafile 27 switched to datafile copy

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

datafile 28 switched to datafile copy

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

datafile 29 switched to datafile copy

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

datafile 30 switched to datafile copy

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

datafile 31 switched to datafile copy

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

datafile 32 switched to datafile copy

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

datafile 33 switched to datafile copy

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

datafile 34 switched to datafile copy

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

datafile 35 switched to datafile copy

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

datafile 36 switched to datafile copy

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

datafile 37 switched to datafile copy

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

datafile 38 switched to datafile copy

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

datafile 39 switched to datafile copy

input datafile copy RECID=35 STAMP=1101061299 file name=+EBS_DATA/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/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/cdbfsb/28182BC4CF6C4887E053B340D20A8B55/DATAFILE/apps_ts_seed.265.1101043

datafile 50 switched to datafile copy

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

datafile 51 switched to datafile copy

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

datafile 52 switched to datafile copy

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

datafile 53 switched to datafile copy

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

datafile 54 switched to datafile copy

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

datafile 55 switched to datafile copy

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

datafile 56 switched to datafile copy

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

datafile 57 switched to datafile copy

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

datafile 58 switched to datafile copy

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

datafile 59 switched to datafile copy

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

datafile 60 switched to datafile copy

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

datafile 61 switched to datafile copy

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

datafile 62 switched to datafile copy

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

datafile 63 switched to datafile copy

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

datafile 64 switched to datafile copy

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

datafile 65 switched to datafile copy

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

datafile 66 switched to datafile copy

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

datafile 67 switched to datafile copy

input datafile copy RECID=63 STAMP=1101061303 file name=+EBS_DATA/cdbfsb/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-FEB-25

Start the new target CDB in open mode

[oracle@fbsebs db]$ mkdir -p admin/cdbfbs/adump

[oracle@fbsebs db]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 21 12:40:07 2025

Version 19.26.0.0.0

Connected to an idle instance.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 1.2885E+10 bytes

Fixed Size 13925264 bytes

Variable Size 1442840576 bytes

Database Buffers 1.1409E+10 bytes

Redo Buffers 19628032 bytes

Database mounted.

Database opened.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

CDBFBS READ WRITE

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 FBS READ WRITE NO

SQL>

4.9 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

4.9.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@fbsebs db]$ export ORACLE_SID=cdbfbs

[oracle@fbsebs db]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 21 12:43:04 2025

Version 19.26.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.26.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(*)

----------

SQL>

4.9.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>');

4.9.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@fbsebs 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.26.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_FBS','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

3 FBS READ WRITE NO

SQL>

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.

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

4.9.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@fbsebs db]$ cd /u01/app/FBS/db/tech_st/19c/appsutil/install/

[oracle@fbsebs install]$ ls

adlnkoh.sh FBS_fbsebs

[oracle@fbsebs install]$ cd FBS_fbsebs/

[oracle@fbsebs FBS_fbsebs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 21 12:50:06 2025

Version 19.26.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.26.0.0.0

SQL> @adupdlib.sql so

PL/SQL procedure successfully completed

4.10 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

4.10.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@fbstest BEE_fbstest]$ perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.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.15

Started : Mon Apr 4 11:14:10 IST 2022

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

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

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

Successfully generated the below file with UTL_FILE_DIR content:

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

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

Completed : Mon Apr 4 11:14:19 IST 2022

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 BEE_utlfiledir.txt

edit BEE_utlfiledir 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.

/u01/app/FBS/db/temp/FBS

/u01/app/FBS/db/tech_st/temp/FBS

/u01/app/FBS/db/tech_st/19c/appsutil/outbound/FBS_fbstest

/u01/app/FBS/db/tech_st/temp/FBS

/u01/app/FBS/utlfiledir

4.10.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@fbsebs19c]$ . cdbfbs_fbstest.env

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

SQL> alter system set LOCAL_LISTENER="fbsebs:1531" scope=both;

System altered.

SQL> show parameter local_listener;

NAME TYPE VALUE

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

local_listener string fbsebs:1531

[oracle@fbsebs bin]$ perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.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:

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_13_44_2025/txkCfgUtlfileDir.log

Program : started @ Fri Feb 21 14:13:47 2025

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_13_44_2025/txkCfgUtlfileDir.log

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12010000.9

Started : Fri Feb 21 14:13:47 EAT 2025

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

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

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

Successfully generated the below file with UTL_FILE_DIR content:

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

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

Completed : Fri Feb 21 14:13:50 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

4.10.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@fbstest bin]$ grep -i s_outbound_dir /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml

<OUTBOUND_DIR oa_var="s_outbound_dir">/u01/app/FBS/db/tech_st/19c/appsutil/outbound/FBS_fbsebs.xml</OUTBOUND_DIR>

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

Enter the full path of Oracle Home: ? /u01/app/FBS/db/tech_st/19c/

Enter the APPS Password:

Enter the SYSTEM Password:

Enter the OS path for which directory object needs to be created: /u01/app/FBS/utlfiledir

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_22_47_2025/txkCfgUtlfileDir.log

Program : started @ Fri Feb 21 14:24:08 2025

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_22_47_2025/txkCfgUtlfileDir.log

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12010000.9

Started : Fri Feb 21 14:24:08 EAT 2025

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

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

Completed : Fri Feb 21 14:24:11 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

4.10.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:

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_26_19_2025/txkCfgUtlfileDir.log

Program : started @ Fri Feb 21 14:26:22 2025

*** Log File = /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_26_19_2025/txkCfgUtlfileDir.log

Script Name : txkCfgUtlfileDir.pl

Script Version : 120.0.12010000.9

Started : Fri Feb 21 14:26:22 EAT 2025

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

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

sh: which: line 1: syntax error: unexpected end of file

sh: error importing function definition for `which'

Execute SYSTEM command : /u01/app/FBS/db/tech_st/19c/perl/bin/perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/adconfig.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml ************** -log=/u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_26_19_2025/acfg_log_Fri_Feb_21_14_26_19_2025.log

The log file for this session is located at: /u01/app/FBS/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Fri_Feb_21_14_26_19_2025/acfg_log_Fri_Feb_21_14_26_19_2025.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /u01/app/FBS/db/tech_st/19c

Classpath : :/u01/app/FBS/db/tech_st/19c/jdbc/lib/ojdbc8.jar:/u01/app/FBS/db/tech_st/19c/appsutil/java/xmlparserv2.jar:/u01/app/FBS/db/tech_st/19c/appsutil/java:/u01/app/FBS/db/tech_st/19c/jlib/netcfg.jar:/u01/app/FBS/db/tech_st/19c/jlib/ldapjclnt19.jar

sh: which: line 1: syntax error: unexpected end of file

sh: error importing function definition for `which'

/bin/sh: which: line 1: syntax error: unexpected end of file

/bin/sh: error importing function definition for `which'

Using Context file : /u01/app/FBS/db/tech_st/19c/appsutil/FBS_fbsebs.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

sh: which: line 1: syntax error: unexpected end of file

sh: error importing function definition for `which'

Updating rdbms version in Context file to db19

sh: which: line 1: syntax error: unexpected end of file

sh: error importing function definition for `which'

sh: which: line 1: syntax error: unexpected end of file

sh: error importing function definition for `which'

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed with errors.

Completed : Fri Feb 21 14:27:00 EAT 2025

Successfully Completed the script

ERRORCODE = 0 ERRORCODE_END

4.12 Copy the tar files to the target machine and extract them. I am creating the directory structure as required. You can give any directory structure.

In my target machine, I have created below directory structure and will copy the source tar files to respective folders

[applmgr@fbsebs FBS]$ pwd
/u01/app/FBS
[applmgr@fbsebs FBS]$ ls -ltr
total 8646916
drwxr-xr-x 4 applmgr oinstall         36 Feb 17 16:07 apps
-rw-r--r-- 1 applmgr oinstall 8854438290 Feb 19 10:10 appp_ebs121.tar.gz
drwxrwxrwx 2 applmgr dba              86 Feb 21 10:11 utlfiledir
drwxr-xr-x 8 oracle  oinstall         93 Feb 21 12:40 db

[applmgr@fbsebs FBS]$ tar -zxvf /u01/backup/appp_ebs121_19c.tar.gz

4.12 Use adcfgclone script to configure the target application.

Make sure the port pool given here is the same as given during DB tier configuration.

[applmgr@fbsebs bin]$ sqlplus apps/apps

SQL> exec fnd_conc_clone.setup_clean

Run autoconfig.sh on db node.

Run autocnfig.sh on apps node.

To avoid the below error related to listener.ora not found

[applmgr@fbsebs bin]$ cd /u01/app/FBS/apps/apps_st/comn/clone/bin/
[applmgr@fbsebs bin]$ ls
adaddnode.pl  adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl  CloneContext_0221143127.log  CloneContext_0221143959.log
[applmgr@fbsebs bin]$ perl adcfgclone.pl appsTier
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adcfgclone Version 120.31.12010000.17
Enter the APPS password : 
Running:
/u01/app/FBS/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/app/FBS/apps/apps_st/comn/clone/jlib/java:/u01/app/FBS/apps/apps_st
/comn/clone/jlib/xmlparserv2.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e 
/u01/app/FBS/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_31427.lst -stage 
/u01/app/FBS/apps/apps_st/comn/clone  2> /tmp/adcfgclone_31427.err; echo $? > /tmp/adcfgclone_31427.res
Log file located at /u01/app/FBS/apps/apps_st/comn/clone/bin/CloneContext_0221152043.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [fbsebs] : 
Target System Database SID : FBS
Target System Database Server Node [fbsebs] : 
Target System Database Domain Name [finsys.co.ke] : 
Target System Base Directory : /u01/app/FBS
Target System Tools ORACLE_HOME Directory [/u01/app/FBS/apps/tech_st/10.1.2] : 
Target System Web ORACLE_HOME Directory [/u01/app/FBS/apps/tech_st/10.1.3] : 
Target System APPL_TOP Directory [/u01/app/FBS/apps/apps_st/appl] : 
Target System COMMON_TOP Directory [/u01/app/FBS/apps/apps_st/comn] : 
Target System Instance Home Directory [/u01/app/FBS/inst] : 
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 to preserve the Display [fbstest:0.0] (y/n)  : n
Target System Display [fbsebs:0.0] : 
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /u01/app/FBS/inst/apps/FBS_fbsebs. A directory with this name already exists and is not empty.
Do you want to continue (y/n)   : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 10
Checking the port pool 10
done: Port Pool 10 is free
Report file located at /u01/app/FBS/inst/apps/FBS_fbsebs/admin/out/portpool.lst
Complete port information available at /u01/app/FBS/inst/apps/FBS_fbsebs/admin/out/portpool.lst
RC-40201: Unable to connect to Database FBS.
Target System proxy port [80] : 
Creating the new APPL_TOP Context file from :
  /u01/app/FBS/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
  /u01/app/FBS/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml
Log file located at /u01/app/FBS/apps/apps_st/comn/clone/bin/CloneContext_0221152043.log
Check Clone Context logfile /u01/app/FBS/apps/apps_st/comn/clone/bin/CloneContext_0221152043.log for details.
Running Rapid Clone with command:
perl /u01/app/FBS/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/FBS/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/FBS/apps/apps_st/comn/clone 
component=appsTier method=CUSTOM appctxtg=/u01/app/FBS/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml showProgress contextValidated=true noprompt
Running:
perl /u01/app/FBS/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/FBS/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/FBS/apps/apps_st/comn/clone 
component=appsTier method=CUSTOM appctxtg=/u01/app/FBS/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml showProgress contextValidated=true noprompt
stty: 'standard input': Inappropriate ioctl for device
APPS Password : 
stty: 'standard input': Inappropriate ioctl for device
Beginning application tier Apply - Fri Feb 21 15:22:02 2025
/u01/app/FBS/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /u01/app/FBS/apps/apps_st
/comn/clone/jlib/xmlparserv2.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/java:/u01/app/FBS/apps
/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/oui/share.jar:
/u01/app/FBS/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u01/app/FBS/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e 
/u01/app/FBS/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml -stage /u01/app/FBS/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /u01/app/FBS/inst/apps/FBS_fbsebs/admin/log/ApplyAppsTier_02211522.log
  \     71% completed       
Completed Apply...
Fri Feb 21 15:27:24 2025
Do you want to startup the Application Services for FBS? (y/n) [y] : y
Starting application Services for FBS:
Running:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adopmnctl.txt for more information ...  
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_FBS.
adalnctl.sh: exiting with status 1
adalnctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adalnctl.txt for more information ...  
.end std out.
grep: /u01/app/FBS/inst/apps/FBS_fbsebs/ora/10.1.2/network/admin/listener.ora: No such file or directory
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.4
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adapcctl.txt for more information ...  
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance  ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adoacorectl.txt for more information ...  
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh  version 120.16.12010000.3
Starting OPMN managed FORMS OC4J instance  ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program : /u01/app/FBS/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Fri Feb 21 15:27:41 2025
*** Log File = /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/rgf/TXK/txkChkFormsDeployment_Fri_Feb_21_15_27_41_2025/txkChkFormsDeployment_Fri_Feb_21_15_27_41_2025.log 
File "/u01/app/FBS/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...
=============================================
*** Latest formsapp.ear has been deployed ***
=============================================
Program : /u01/app/FBS/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Fri Feb 21 15:27:41 2025
Perl script txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adformsctl.txt for more information ...  
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/rgf/TXK/txkChkFormsDeployment_Fri_Feb_21_15_27_41_2025/txkChkFormsDeployment_Fri_Feb_21_15_27_41_2025.log 
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance  ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adoafmctl.txt for more information ...  
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Starting concurrent manager for FBS ...
Starting FBS_0221@FBS Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adcmctl.txt for more information ...  
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/app/FBS/inst/apps/FBS_fbsebs/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /u01/app/FBS/apps/apps_st/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.
****************************************************
adstrtal.sh: Exiting with status 1
adstrtal.sh: check the logfile /u01/app/FBS/inst/apps/FBS_fbsebs/logs/appl/admin/log/adstrtal.log for more information ...

[applmgr@fbsebs scripts]$ adstpall.sh apps/apps

[applmgr@fbsebs scripts]$ adstrtal.sh apps/apps

4.13 Validate the services and our cloned environment is ready.

For E-Business Suite Release 12.1

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE)

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE)

Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)

Pages

4.b Clone an EBS R12.1.3 application along with Database 19.26.0.0

4.1 Apply below patches on the application tier. Please read the Readme and follow the instructions carefully. These are critical before starting the cloning process.

4.1.1 Now run autoconfig on the application tier.

4.1.2 Logout from applmgr and source the Environment again.

4.1.3 Recreate appsutil and copy to DB server Oracle Home

4.2 Run ad pre-clone on DB node.

4.2.4 Take the RMAN Backup of CDB Database

No comments:

Post a Comment