ETCC not run in the database node

Below error while running adop phase=prepare

 [ERROR]     ETCC not run in the database node ip-172-31-27-116

                The EBS Technology Codelevel Checker needs to be run on the database node.

                It is available as Patch 17537119.

    Encountered the above errors when performing database validations.

    Resolve the above errors and restart adop.

Solution:

1. Execute  ./checkDBpatch.sh after downloaing ETCC patch 17537119 and placing in DB Oracle Home/appsutil/etcc

2. Check Node name should be same on all places:

txk_tcc_results

fnd_nodes

/etc/hosts

3. If nothing work insert below line based on your environment variables:

insert into txk_tcc_results

VALUES('120.0.12020000.60','120.0.12020000.56','ip-172-31-27-116','PROD','RDBMS','19.0.0.0.0.0','/opt/oracle/PROD/19.3.0',SYSDATE,'OK',NULL);

Re Test: adop phase=prepare should work now.

TAGS: adop phase=prepare, txk_tcc_results, fnd_nodes, ETCC