Synchronize FND_NODES ADOP_VALID_NODES FND_OAM_CONTEXT_FILES in 12.2 when adop fails. 

by

Here will discuss how to Synchronize FND_NODES ADOP_VALID_NODES FND_OAM_CONTEXT_FILES in 12.2

How to Synchronize FND_NODES ADOP_VALID_NODES FND_OAM_CONTEXT_FILES.

Error 1:-

adop phase=prepare

FATAL ERROR

PROGRAM : (/data01/ad/12.0.0/bin/adzdoptl.pl)
TIME : Fri Oct 2 22:06:45 2015
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: adop is not able to detect any valid application tier nodes in ADOP_VALID_NODES table.

Ensure autoconfig is run on all nodes.

[STATEMENT] Please run adopscanlog utility, using the command
“adopscanlog -latest=yes”
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 255 (Fail)

Error 2

adop phase=apply / actualize_all

[APPLY PHASE]

FATAL ERROR

AutoConfig could not successfully execute the following scripts:

Directory: /fs#/FMW_Home/webtier/perl/bin/perl -I /fs#/FMW_Home/webtier/perl/lib/5.10.0 -I /fs#/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /fs#/EBSapps/appl/au/12.0.0/perl -I /fs#/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi //fs#/inst/apps//admin/install

txkGenADOPWrapper.pl INSTE8_APPLY 1

SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type(”) FROM DUAL
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “APPS.AD_ZD_ADOP”, line 3049

Error 1: adop phase=prepare


In this case, The fnd_nodes table has NULL for domain entry of this valid server.

Example Data Supporting the Conclusion
---------------
[table.applsys.fnd_nodes]

NODE     PLAT    D C A F W    NODE_NAME    SERVER_ADDRESS     DOMAIN    WEBHOST                              VIRTUAL_IP        S
---------------------------------------------------------------------------------------------------------------------------------------------------------
12,121     2234    N Y Y Y Y    Prdappl1   ###.###.###.4455     NULL        Prdappl1.<domain>       NULL               Y

Error 2: adop phase=apply / actualize_all


[table.applsys.fnd_oam_context_files]

NAME S_CONTEXTFILE S_CONTEXTTYPE S_CONTEXTNAME Version Number SERIAL APPL_TOP_NAME HOST SHARED_FILE_SYSTEM EDITION

---------------------------------------------------------------------------------------------------------------------------------------------------------

<SID_hostname> ./<SID_hostname>.xml APPL_TOP Context <SID_hostname> 125.501.12020000.85 7999 AT_<hostname> <hostname> false run
<SID_hostname> ./<SID_hostname>.xml APPL_TOP Context <SID_hostname> 125.501.12020000.85 7999 AT_<hostname> <hostname> false run
<SID_hostname> ./<SID_hostname>.xml APPL_TOP Context <SID_hostname> 125.501.12020000.85 8001 AT_<hostname> <hostname> false patch
<SID_hostname> ./<SID_hostname>.xml Database Context <SID_hostname> 125.62.12020000.11 0 NULL <hostname> NULL database

Solution: –

Follow the below action plan to resolve the issue.

A. Backup the following tables, and if on AD/TXK 8 or higher before adop_valid_nodes & fnd_nodes clean:

  1. fnd_oam_context_files
  2. fnd_nodes
  3. adop_valid_nodes
SQL> create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;

      SQL> create table fnd_nodes_bk as select * from fnd_nodes;

         SQL> create table adop_valid_nodes_bk as select * from adop_valid_nodes;

      If on AD/TXK 8 or higher:

      SQL> create table ad_nodes_config_status_bk as select * from ad_nodes_config_status;

,

B. Truncate the following tables. 

SQL> truncate table fnd_oam_context_files;

      SQL> truncate table fnd_nodes;

      SQL> truncate table adop_valid_nodes;

      If on AD/TXK 8 or higher:

      SQL> truncate table ad_nodes_config_status;

C. Run AutoConfig on the dbTier


$cd <RDBMS_ORACLE_HOME>/appsutil/scripts/<SID>_<HOSTNAME>/
$./adautocfg.sh

Make sure autoconfig completed successfully.

D.  Run Autoconfig on the run file system and patch file system.

cd $ADMIN_SCRIPTS_HOME

$ ./adautocfg.sh

After Autoconfig has been run successfully on all nodes (dbTier & appsTier), run the following two queries to verify the tables have been correctly populated.

SQL>select node_id, platform_code, support_db , support_cp , support_admin , support_forms , support_web , node_name, server_id,server_address, domain, webhost, virtual_ip, status from fnd_nodes order by node_id;

SQL>select NAME,VERSION,PATH, STATUS from FND_OAM_CONTEXT_FILES;

Similar Post: –

 

Leave a Comment