Oracle EBS refresh

[satish]

Hi erman,

Need your expertise for below questions on ebs database refresh.

1.Say i have applied patches on application node and i did not copy the apps file system and cloned only database retaining the target apps file system. In what ways it will effect ,will it fail while running autoconfig on apps tier.

what my assumption is "we will miss out the bug fixes on target node if we do not copy the apps file system from source" apart from this there will be no problem.

2.During patching of source applications ,if the patch would have touched my database ,say creating new sequence,updating any profiles,etc... ,In this case ,will cloning only db part be successful ,keeping the target apps filesystem intact or will it fail.

Thanks for all your support

[ErmanArslansOracleBlog]

Satish,

If you patch, then you need to refresh the patched components.
If you know what the patch is really doing, then you may customize your cloning act.
However, knowing what a patch does, requires deep analysis.. You need to check the patch driver files, patched files and everyting.

Having an environment , where the apps tier is coming from the past(in terms of patching) and db is coming from the future is too risky.

Apps code and db code depend on eachother.
Some apps patches modify apps tier according to the database objects they are planning to create..
So apps code and db code should be aligned.

So if you use adpatch or adop, then clone everyting. (adpatch/adop means apps/product patch..)

if you patch with opatch, then you may choose to clone the patched items only. (Oracle homes and etc..)

You got the idea right?

[satish]

Thanks erman.Got it