DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, June 20, 2018

Adop Phase Cleanup issue 

This is caused when cleanup phase is performed, the nodes are populated with standby hostname.

Which is failing the cleanup opertions, the below steps are to re-populate to nodes

SOLUTION: 
Due to the method required for "cleaning out" / "re-synchronizing" the following tables, it is EXPECTED / REQUIRED that the Applications have been shutdown.

The only thing running should be the Database Tier. 

Note:

A full backup should also be taken before any testing begins.


1. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env:
sqlplus applsys/pwd

create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;
create table fnd_nodes_bk as select * from fnd_nodes;
create table adop_valid_nodes_bk as select * from adop_valid_nodes;

2. Truncate the following tables:

truncate table fnd_oam_context_files;

truncate table fnd_nodes;

truncate table adop_valid_nodes;


3. Run AutoConfig on the DB tier
Confirm Autoconfig completes successfully

4. Run Autoconfig on the run file system. (APPS Tier)
Confirm Autoconfig completes successfully

5. Run Autoconfig on the patch file system (Apps Tier)

Due to the method required for "cleaning out" / "re-synchronizing" the following tables, it is EXPECTED / REQUIRED that the Applications have been shutdown.

The only thing running should be the Database Tier.


Before running Autoconfig on the patch file system the ebs_login trigger MUST be disabled
After the successful completion of Autoconfig the ebs_login trigger MUST be re-enabled.

This needs to be done as the SYSTEM schema user.

a. Disable the ebs_login trigger using the following SQL.

SQL> alter trigger ebs_logon disable;

At this time Run autoconfig with the patch env sourced.
Make sure Autoconfig completes ok


b. Enable the ebs_login trigger using the following SQL.

SQL> alter trigger ebs_logon enable;


6. After Autoconfig has been run successfully on all nodes, run the following two (2) queries in order to verify the tables have been correctly populated:

SQL>

set pagesize 5
set linesize 132
col node_name format a15
col server_id format a8
col server_address format a15
col platform_code format a4
col webhost format a12
col domain format a20
col virtual_ip format a12

select node_id, platform_code, support_db D, support_cp C, support_admin A,
support_forms F, support_web W, node_name, server_id,
server_address, domain, webhost, virtual_ip, status
from fnd_nodes
order by node_id;

SQL>

set pagesize 5
set linesize 132

col NAME format A20
col VERSION format A12
col PATH format A110
col STATUS format A10

select NAME,VERSION,PATH, STATUS
from FND_OAM_CONTEXT_FILES;


Once complete please retest the adop phase=cleanup .