Introduction :
The Technology Codelevel Checker (ETCC) utility provides two scripts to ensure all the necessary database and application tier patches are installed on a 12.2 system. Oracle strongly recommends the use of this utility to ensure that all required database and application tier bug fixes have been installed. The scripts are usually updated on a quarterly basis, to include the latest defect patches released for the 12.2 database and apps tiers.
– checkDBpatch.sh (checkDBpatch.cmd on Windows)
This is the Database EBS Technology Codelevel Checker (DB-ETCC). It determines if all the needed bugfixes exist in the specified database ORACLE_HOME.
– checkMTpatch.sh (checkMTpatch.cmd on Windows)
This is the Middle Tier EBS Technology Codelevel Checker (MT-ETCC). It determines if all the needed bugfixes exist in the middle tier file system.
Instructions to execute the scripts [DB Tier] :
To run the DB Technology Codelevel Checker (DB-ETCC) :
1. Download the Patch 17537119
2. Read the instructions in the readme file.
3. Follow the steps below :
Source the correct environment after logging.
– Run the script and Supply the values the script prompts for, if using the interactive mode.
UNIX:
Interactive mode:
$ ./checkDBpatch.sh
Non-interactive mode:
$ ./checkDBpatch.sh contextfile=<full path to database context file>
Windows:
Interactive mode:
C:\>checkDBpatch.cmd
Non-interactive mode:
C:\>checkDBpatch.cmd contextfile=<full path to database context file>
4. Take the appropriate actions based on the results provided in the script.
Instructions to execute the scripts [Apps Tier] :
To run the MT Technology Codelevel Checker (MT-ETCC) :
1. Download the Patch 17537119
2. Read the instructions in the readme file.
3. Follow the steps below :
Source the correct environment after logging.
UNIX:
Interactive mode:
$ ./checkMTpatch.sh
Non-interactive mode:
$ (echo <appspass>) |./checkMTpatch.sh contextfile=<full path to middle tier context file>
Windows:
Interactive mode:
C:\>checkMTpatch.cmd
Non-interactive mode:
C:\>(echo <appspass>)| checkMTpatch.cmd contextfile=<full path to middle tier context file>
4. Take the appropriate actions based on the results provided in the script.
