patching

[Latifa]

Hi Erman,

I ma getting the following error in a adworker.log:

AD Worker error:
Error while getting status from ad_util_params

Applying the frensh patch started from more 5 hours ! it's not normal. It's sticking in the first node while others are not strated yet.

What should I do ? Should I stop the patching and reapply again ?

Regards,
Latifa

[Latifa]

Hi Erman,

I canceled twice and it works finally in the third attempt. But I couldn't find the reason why it was hanging !

Regards
Latifa

[ErmanArslansOracleBlog]

In these kinds of situations, you should check the Apps tier OS process, see what it is doing.
Also, it is important to check the db tier as well.
You should find the db session id of that worker and see what it is waiting for. (current wait event)..
Ther can some locks left, there can be a latch wait etc..
For a deeper diag, you should review the sql or command that the worker is executing. You should review the code in it and try the predict what can be the cause accordingly.

[Latifa]

Hi Erman,

thank you very much for your help.

Actually my adop status is completed for all:

PREPARE         COMPLETED      
APPLY           COMPLETED      
FINALIZE        COMPLETED      
CUTOVER         COMPLETED      
CLEANUP         COMPLETED  

The cleanup was released in quick mode.

I have to apply another patch while application must keep running. Should I :
- start another cycle adop from prepare phase and apply the patch
- or apply it in "hotpatch" mode

Regards,
Latifa  

[ErmanArslansOracleBlog]

As usual, i would recommend online patching.. 

However, you can decide it as well

27 Tem 2017 19:46 tarihinde "Latifa [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi Erman,

thank you very much for your help.

Actually my adop status is completed for all:

PREPARE         COMPLETED      
APPLY           COMPLETED      
FINALIZE        COMPLETED      
CUTOVER         COMPLETED      
CLEANUP         COMPLETED  

The cleanup was released in quick mode.

I have to apply another patch while application must keep running. Should I :
- start another cycle adop from prepare phase and apply the patch
- or apply it in "hotpatch" mode

Regards,
Latifa  

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/patching-tp3027p3064.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Latifa]

which means hotpatch option ?

Both are online at least before cutover ...

[Latifa]

Hi Erman,

I have one more question:

I reapplied a patch and that patch runs successfuly.
However when I ask the table ad_bugs, the created_date and LAST_UPDATE_DATE, they remains with the old date of its application ? How can ?

Regards

[Latifa]

how can I update ad_bugs table ?

[ErmanArslansOracleBlog]

what is the situation in ad_applied_patches table?

28 Tem 2017 16:02 tarihinde "Latifa [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

how can I update ad_bugs table ?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/patching-tp3027p3070.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Latifa]

Hi Erman,

In this table, the date is the first one, no changes.

PATCH_NAME      CREATION_ LAST_UPDA
--------------- --------- ---------
22550349        31-MAR-17 31-MAR-17
22550349        31-MAR-17 31-MAR-17
22550349        31-MAR-17 31-MAR-17

Why there is 3 entries (US, French and ? ) ?

Regards,
Latifa

[ErmanArslansOracleBlog]

It is not supported update those table manually.
Create an SR, and get approval from Oracle. Then you can run your update, or Oracle may send you a datafix.

As for hotpatching and/or downtime patching-> you just should not use hotpatch and downtime options unless it is written in readme files or it is written in Oracle Support documents (specifically written for your patch)

[Latifa]

Hi Erman,

Now I am fixed :) Thank yoy for your advise.
I will wait until customer can stop application. then I'll apply my patch (because the reade me doesn't ask to apply it in hotpatch mode) in a regular mode, I mean: prepare, apply, finalize, cutover and cleanup.


Regards,
Latifa