adop prepare phase failed with below error
[ERROR] ETCC not run in the database node <node name>
Validating system setup.
Node registry is valid.
[WARNING] SYS.DUAL table has incorrect privileges
Shut down the application tier services and then run the following commands in the order shown
sqlplus / as sysdba @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
sqlplus apps/ @ $AD_TOP/sql/adutlrcmp.sql
[ERROR] ETCC not run in the database node calrdbuat03
The EBS Technology Codelevel Checker needs to be run on the database node.
It is available as Patch 17537119.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
The node name in table APPS.TXK_TCC_RESULTS and /etc/hosts can be different, causing an adop failure to identify the database host name correctly.
Solution:
- Validate /etc/hosts file has entries with a correct format. IP Address hostname.domain hostname.
- Validate entries in APPS.TXK_TCC_RESULTS and make updates if needed
- update APPLSYS.TXK_TCC_RESULTS set node_name=’uatfin’ where node_name =’uatfin.node.com’;
- Validate the s_dbhost value in the database context file ${CONTEXT_FILE} and ensured it has only NODE_NAME and not the domain. Validate the same in applications context file ${CONTEXT_FILE} as well.
- Downloaded the latest version of ETCC and ran on DB node.
- Ran autoconfig on DB node.
- Ran autoconfig on Apps node.
- Retry prepare phase