Clone R12.2.5

[Sri]

Hi Erman,

We have cloned the prod instance to our test.After cloning,All our changes made to /u01/ROOK/fs_ne/EBSapps/appl/ad/custom/adop_sync.drv v in our test environment was gone.How can we avoid this

Thanks for your support

[ErmanArslansOracleBlog]

1)It is a multi node system?
2)What are your AD and TXK levels?
3)Do you observe the same problem after running autoconfig?

[Sri]

Hi Erman,

Thank you

Prod is multi node
test is single node
we are on R12.2.5 and we are on delta 7
we have cloned from prod to test
will adcfgclone.pl create the adop_sync.drv file?

[ErmanArslansOracleBlog]

Please answer the following question:

1)Do you observe the same problem after running autoconfig?

[Sri]

Thanks for the update erman,

we dont see this problem after running autoconfig.I think adcfgclone will not create this file.but need your expertise

[ErmanArslansOracleBlog]

yes..i think the same.. adcdgclone doesn't take custom env file into account as well..
In clone directory, there is a class which has adop_sync.drv in it..

[applmgr@ermansrv1 clone]$ grep -R adop_sync.drv *
Binary file jlib/java/oracle/apps/ad/tools/configuration/ADOPCustomSyncUp.class matches

But, I tnhink this class file is for the use of adop.. It parses the adop_sync.drv and take actions during adop runs..

[Sri]

Thanks erman

[ErmanArslansOracleBlog]

There is a bug.. probably , the issue is known in Oracle side..

Bug 16936933 : QRE1222.5:TXK:ADOP_SYNC.DRV IS MISSING ON THE CLONES

This bug is fixed in  Patch R12.TXK.C.delta.10: R12.TXK.C.DELTA.10. (and also in DELTA 9)

So, if you apply the latest TXK and AD(which is delta 10 currently), your issue will be solved..


 

[ErmanArslansOracleBlog]

Do you have "adop_sync_drv.tmp"  exists under the fs1 and fs2 of the target/clone env?

[Sri]

Thanks for the update erman.

we do have the file in our target dev instance

[apps@erpappst]$ locate adop_sync_drv.tmp
/u01/ROOK/fs1/EBSapps/appl/ad/12.0.0/admin/template/adop_sync_drv.tmp
/u01/ROOK/fs2/EBSapps/appl/ad/12.0.0/admin/template/adop_sync_drv.tmp

Thank you

[Sri]

Hi Erman,

Also,ADOP_SYNC.DRV was existing in target,but the entries which we placed inside it are missing.This is the actual issue for which i have raised this post.

can i edit in ADOP_SYNC_DRV.tmp in prod and place the entries there so that when ever we clone to any test instances,entries will not be lost in target?will this work

Thank you

[ErmanArslansOracleBlog]

I think it will work.. Because adop_sync is expected to be copied by the template file during cloning.. This should be done automatic.
So, that will work, but when you change adop_sync.drv in PROD , do not forget to reflect the same change to the template file.

[Sri]

thanks for the update erman.i will try this in next clone and update the outcome here