Oracle Apps DBA - ERROR: ETCC does not exist under appsutil/etcc/checkDBpatch.sh to avoid ADOP related issues.

$ cd /db/orauat/UAT/12.1.0/appsutil/

$mkdir etcc

$ cd /db/DBpatch/

$ cp -r p17537119_R12_GENERIC.zip /db/orauat/UAT/12.1.0/appsutil/etcc/

$ cd /db/orauat/UAT/12.1.0/appsutil/etcc/

$ unzip -o p17537119_R12_GENERIC.zip

 

run checkDBpatch.sh on db node

 

[oracle@ebs122 etcc]$ sh checkDBpatch.sh

 

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

 |    Copyright (c) 2005, 2019 Oracle and/or its affiliates.     |

 |                     All rights reserved.                      |

 |             Oracle E-Business Suite Release 12.2              |

 |          Database EBS Technology Codelevel Checker            |

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

 

Using context file from currently set database environment:

/db/orauat/UAT/12.1.0/appsutil/UAT_ebs122.xml

 

 

Starting Database EBS Technology Codelevel Checker, Version 120.72

Fri Mar 20 21:47:50 IST 2020

Log file for this session : /db/orauat/UAT/12.1.0/appsutil/etcc/log/checkDBpatch_10561.log

 

Identifying database release.

Database release set to 12.1.0.2.

 

Connecting to database.

Database connection successful.

 

Database UAT is in READ WRITE mode.

 

Identifying APPS and APPLSYS schema names.

 - APPS schema : APPS

 - APPLSYS schema : APPLSYS

 

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

 

Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.50

This file will be used for identifying missing bugfixes.

 

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.25

This file will be used for mapping bugfixes to patches.

 

 

[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

 Check if a newer version is available in patch 17537119.

 

Checking Bugfix XML file for 12.1.0.2

 

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

Now checking Database ORACLE_HOME.

 

The opatch utility is version 12.1.0.1.10.

DB-ETCC is compatible with this opatch version.

 

Found patch records in the inventory.

 

Checking Mapping XML file for 12.1.0.2

 

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

 

Stored Technology Codelevel Checker results in the database UAT successfully.

 

Finished checking fixes for Oracle Database: Fri Mar 20 21:48:11 IST 2020

 

Log file for this session: /db/orauat/UAT/12.1.0/appsutil/etcc/log/checkDBpatch_10561.log

 

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

[oracle@ebs122 etcc]$

 

- Run preclone now 

 

[oracle@ebs122 etcc]$ cd /db/orauat/UAT/12.1.0/appsutil/scripts/UAT_ebs122/

[oracle@ebs122 UAT_ebs122]$

[oracle@ebs122 UAT_ebs122]$ perl adpreclone.pl dbTier

 

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA

 

                        Oracle E-Business Suite Rapid Clone

 

                                 Version 12.2

 

                      adpreclone Version 120.31.12020000.25

 

Enter the APPS User Password:

Verifying if Database Patch checker (ETCC) exists in /db/orauat/UAT/12.1.0/appsutil/etcc

 

 

Running:

perl /db/orauat/UAT/12.1.0/appsutil/bin/adclone.pl java=/db/orauat/UAT/12.1.0/appsutil/jre mode=stage stage=/db/orauat/UAT/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/db/orauat/UAT/12.1.0/appsutil/UAT_ebs122.xml showProgress

 

 

Beginning database tier Stage - Fri Mar 20 21:49:14 2020

 

/db/orauat/UAT/12.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/db/orauat/UAT/12.1.0/oui -classpath /db/orauat/UAT/12.1.0/lib/xmlparserv2.jar:/db/orauat/UAT/12.1.0/jdbc/lib/ojdbc6.jar:/db/orauat/UAT/12.1.0/appsutil/java:/db/orauat/UAT/12.1.0/oui/jlib/OraInstaller.jar:/db/orauat/UAT/12.1.0/oui/jlib/ewt3.jar:/db/orauat/UAT/12.1.0/oui/jlib/share.jar:/db/orauat/UAT/12.1.0/oui/jlib/srvm.jar:/db/orauat/UAT/12.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /db/orauat/UAT/12.1.0/appsutil/UAT_ebs122.xml -stage /db/orauat/UAT/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress

APPS Password :

Log file located at /db/orauat/UAT/12.1.0/appsutil/log/UAT_ebs122/StageDBTier_03202149.log

 

  -     79% completed

 

Completed Stage...

Fri Mar 20 21:49:42 2020

[oracle@ebs122 UAT_ebs122]$