Please advise on this
please let us know if you are following any document reference for above steps.
Is this part of a dr drill activity?
No. I am applying patches in Primary, so want to apply same patch in DR nodes
Can you please let us know below -
1. You architecture (single/multinode apps tiers)
2. DB version.
Can you check entries on dr side in table - ADOP_VALID_NODES
Was autoconfig successful on both db and apps tiers?
I believe you are referring document id -
Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (126.96.36.199) Physical Standby Database (Doc ID 1963472.1)
As per above document, we need to apply patch with below options -
ADOP phase=apply patches=patch number apply_mode=hotpatch options=nodatabaseportion
Please advise how to proceed.
I have followed below steps and its failing
1- Cancel MRP
This is OK
2- Convert standby to snapshot database
3 - exec fnd_conc_clone
4 - exec ad_zd_fixer.clear_valid_nodes_info;
6 - autocnfig on DB and app tiers
7 - apply patch and got below error.
adop phase=apply patches=xxxx apply_mode=downtime
You only need to apply patch using adop if your standby application is connecting to standby database.
Please see section 7 in Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (188.8.131.52) Physical Standby Database (Doc ID 1963472.1)
Can you check the following notes
ADOP Exiting With Status = 9 (Fail) ORA-04043 On ADOP_VALID_NODES Table (Doc ID 2230021.1)
ADOP Patching Cycle Fails With Error 'ERRORMSG: Cannot identify any valid application tier nodes in ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes' (Doc ID 2282694.1)