Error while applying the patch in Prepare phase 12.2.4 EBS

[Mohammed Kamran]

Hi Erman,

We are getting the below error.

But these are PRODUCTION NODES [UNEXPECTED]Nodes "u01vpire01,u01vpebs02,u01vpebs01" are listed in ADOP_VALID_NODES table but not in FND_NODES

This is PROD Clone copy.

[applmgr@u01vuebs03 scripts]$ cd $PATCH_TOP
[applmgr@u01vuebs03 patch]$ pwd
/u01/app/applmgr/TEST/fs_ne/EBSapps/patch
[applmgr@u01vuebs03 patch]$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials...

Initializing...
Run Edition context : /u01/app/applmgr/TEST/fs2/inst/apps/TEST_u01vuebs03/appl/admin/TEST_u01vuebs03.xml
Patch edition context: /u01/app/applmgr/TEST/fs1/inst/apps/TEST_u01vuebs03/appl/admin/TEST_u01vuebs03.xml
Patch file system freespace: 170.08 GB

Validating system setup...
[UNEXPECTED]Nodes "u01vpire01,u01vpebs02,u01vpebs01" are listed in ADOP_VALID_NODES table but not in FND_NODES table.
[UNEXPECTED]To correct this, run AutoConfig on nodes "u01vpire01,u01vpebs02,u01vpebs01"
[UNEXPECTED]Error while checking if this is a multi node instance


[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 = 2 (Fail)
[applmgr@u01vuebs03 patch]$

[ErmanArslansOracleBlog]

So it seems you couldn't clone your system properly.
What documentation did you follow?
What was your aim?
The document you needed the follow was :

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

For instance, if you are refreshing your clone, you should implement the things in Section 5.1 Refreshing a Target System.. there are actions like "truncate table ADOP_VALID_NODES;" there..

At this point, if your DB is well.. If your DB nodes are autoconfig enabled and if the db nodes are written in fnd_nodes properly;

truncate table ADOP_VALID_NODES;
run adcfgclone.pl on Apps tier once again.  

[Mohammed Kamran]

Hi Erman,

Thanks for the reply.

I have cloned my PROD environment as below.

As we have not applied any patches recently on the PROD and we have same clone copy last 3 months back done.

On the same Clone Copy I have restored the PROD database successfully and then ran the autoconfig on both DB and APPS Tier and the application came up successfully and it fulfilled the requirements of my EBS function team.

Regards,
Mohammed Kamran.

[ErmanArslansOracleBlog]

So you are refreshing your clone. (at least its db tier...)


Do the actions that I sent you in my previous update and retry.

Ref:
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)  - Section 5.1 Refreshing a Target System..(partially..)

[Mohammed Kamran]

Dear Erman,

I think there is bit confusion here actually I am trying to apply the patch and it fails in Prepare phase.

main issue was we were facing an issue in GL while deleting any attachment then I have raised an SR for the same after oracle diagnosis it was advised to apply the patch on it.

Oracle Advised as below.

Could you please implement the solution in Test instance(Clone of Prod):

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 23507881:R12.GL.C
2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
GLASFlowLedgerAdvancedOptionsCO.java to version 120.14.12020000.3
You can use the commands like the following:
strings -a $GL_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.


Regards,
Mohammed Kamran.

[ErmanArslansOracleBlog]

There is no confusion Mohammed.
I understand that you are trying to apply a patch.
But you are failing and that failure is related with your EBS configuration.
FND_NODES is a base table and it is modified/updated during cloning and/or autoconfig related stuff.
As you said the nodes reported in the ADOP_VALID_NODES is production nodes, first; I recommend you to reconfigure your EBS env properly.

Please consider  taking the actions that I sent you in my previous update.

[Mohammed Kamran]

Dear Erman,

Thanks for your prompt response and help.

But when I try below it gives me this output.

connected to EBS application server via apps user.

SQL> truncate table ADOP_VALID_NODES;
truncate table ADOP_VALID_NODES
               *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

[ErmanArslansOracleBlog]

Use the following command;

truncate applsys.ADOP_VALID_NODES

[Mohammed Kamran]

Dear Erman,

Just wanted to clear doubt.

Once the ADOP_VALID_NODES truncated you asked to run the run adcfgclone.pl on Apps tier once again.

1. Do I need to stop the application services?
2. What will happens when I run this will it create new FMW home?
3. Can you provide the the details steps needs to be done.


regards

[ErmanArslansOracleBlog]

What I recommended you is based on the following Oracle Support note:

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)  - Section 5.1 Refreshing a Target System..

Please read the above document, section 5.1 and take your actions accordingly.

adcfgclone.pl is the post clone. Of course, your apps tier services should be down for this. It is like recloning..

[Mohammed Kamran]

Sure Will do and update, Need to check with the Functional team weather they are working on this clone or not.

Thanks for your support brother.

regards,
Mohammed Kamran.

[ErmanArslansOracleBlog]

Okay. good.