Oracle is designing many brand new tools to help customers and to increase the productivity of Oracle E-Business Suite (EBS) DBAs. One such tool is EBS 12.2 Upgrade Readiness Checker Tool – Database Tier (EURC-DT) that help customers to produce a report for migrating to 12.2 in the E-business suite from 11i or 12.1.3 version.
Let’s see more details about this tool.
About EURC-DT:
EBS 12.2 Upgrade Readiness Checker Tool – Database Tier (EURC-DT) tool performs checks based on key technical requirements needed for the 12.2 upgrades. This will give you instructions on what activities needs to be performed in the form of an Html report.
This tool
- Can be used when upgrading to Oracle E-Business Suite Release 12.2 from any previous release.
- Is available for all platforms on which Oracle E-Business Suite is supported.
- Verifies that pre-upgrade technical steps have been performed.
- Provides both a summary report and detailed log files for all checks performed.
- Is compatible with Oracle Database 19c, 12cR1, and 11gR2.
How to download EURC-DT?
Oracle provides this tool in the form of a small generic Patch 32288423 which can be downloaded from My Oracle Support (MOS). Customers can use MOS credentials to download the tool and run on any platform. This patch is not needed to apply using any tool in the environment. It just needs to be unzipped in a directory. This patch contains 2 files, an XML file and a Perl file script.
Pre-requisites:
Perl should be installed in the database server.
Create patching stage directory in Database. Ex: <RDBMS ORACLE_HOME>/appsutil/temp/eurc-dt
Download ETCC Patch 17537119 in the patching stage area as this tool uses internally.
Download the EURC-DT tool in the patching stage area and unzip it.
System and apps password is required.
How to run?
This tool needs to be run in the database tier with environment file sourced. If your environment is multitenant and EBS running in PDB, you will need to source the PDB environment file before running the script.
EURC-DT can be run in 2 different modes: Check (Default) and fix
Mode=check – This mode performs check in the to be upgraded E-business suite database and generates a report.
- perl eurc_dt.pl mode=check
Mode=fix- This mode performs recompiles invalid objects and rebuilds unusable indexes.
- perl eurc_dt.pl mode=fix
Log files:
Item | Location or Description |
Log file Directory | <patching stage area>/<ORACLE_SID>_eurc-dt/ |
Log File Name Format | <ORACLE_SID>_eurc-dt.log |
Report Name Format | <ORACLE_SID>_EURC-DT_Report.html |