Running Oracle ETCC for E-Business Suite - DB Tier

This is for EBS 12.2

Download ETCC from Metalink 17537119

Unzip into its own directory onto the database server

If you have no idea how to run it you will need the path to the context file. 

If you are not experienced you need to know how to find it. 

If you have the environment set then just do 


[oracle@ebsvdbr4 ETCC]$ export |grep -i CONTEXT_FILE

declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"

now we can run ETCC Database checker

[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh                                                                                                                                                    
 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28
Enter the full path to the DB Context file :^C
[oracle@ebsvdbr4 ETCC]$ export |grep -i CON
declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"
declare -x CONTEXT_NAME="VIS_ebsvdbr4"
declare -x HISTCONTROL="ignoredups"
[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28

*** Here paste in the path to the Context File **** 


Enter the full path to the DB Context file :/u02/oracle/VIS/11.2.0/appsutil/VIS_                                                                                                             ebsvdbr4.xml

Using database context file:
/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml

Bugfix XML file version: 120.0.12020000.27
This file will be used as the reference for identifying missing bugfixes.

Identifying database release.
Setting database release to 11.2.0.3.

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

[WARNING]

Oracle Database 11.2.0.3 is no longer recommended  for use with Oracle
E-Business Suite Release 12.2. Details of bugfixes and patches
are no longer maintained for this version, so ETCC output may be out of date and
inapplicable.

For recommended database versions, refer to  My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".

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

Database connection successful.

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

Started prerequisite patch testing : Wed Nov 18 05:29:57 EST 2015

Log file for this session : ./checkDBpatch_43824.log

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is at the required version.

Found patch records in the inventory.

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

Stored Technology Codelevel Checker results in the database successfully.

Finished prerequisite patch testing : Wed Nov 18 05:30:06 EST 2015


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

Yes I know 11.2.0.3 is not supported.  I am upgrading to 12.1.0.2 but before I do that I need to put all the interop patches needed on.  Here I am just showing how to run ETCC