Prepare phase failed With Error “ETCC Not Run In The Database Node”

We might some time get into below issue after clone or after installing AD and TXK patches.

 

 

Error:

 

ETCC not run in the database node [Node Name]

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

It is available as Patch 17537119.

 

Reason:

 

It might be due to mismatch in host name between APPS.FND_NODES and APPLSYS.TXK_TCC_RESULTS tables.

 

Solution:

 

1. Backup applsys.txk_tcc_results table.

 

2. Update table using the SQL statement below.

 

Source Entry in Cloned Environment:

 

SQL> select NODE_NAME,DATABASE_NAME from TXK_TCC_RESULTS;

 

NODE_NAME        DATABASE_NAME

————            —————-

oradbprod          ORAPROD

 

 

UPDATE applsys.txk_tcc_results SET NODE_NAME =’oradbdev’;

 

UPDATE applsys.txk_tcc_results SET DATABASE_NAME =’ORADEV’;

 

Now its updated

 

SQL> select NODE_NAME,DATABASE_NAME from TXK_TCC_RESULTS;

 

NODE_NAME       DATABASE_NAME

————           —————

oradbdev          ORADEV

 

3. Run ADOP again to validate it fixes the issue.

 

Reference :Running ADOP Fails With Error “ETCC Not Run In The Database Node” (Doc ID 2191678.1)