Re: All phasis are aborted only cleanup is completed

Posted by ErmanArslansOracleBlog on Jan 13, 2017; 6:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1904.html

Latifa,

Didn't you see the example usage? You should replace those words starting with $ sign ->

You will replace them according to your env:

So this is the format : select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
You need to replace the release with your, you need to replace the patch no with your etc.

example sql:

If you have a single app tier installation:

select ad_patch.is_patch_applied('R12',-1,'20034256') from dual;

expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted

2017-01-13 1:23 GMT+03:00 latifa [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi,

 

The sql doesn’t work correctly :

 

SQL> select AD_PATCH.IS_PATCH_APPLIED (\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;

select AD_PATCH.IS_PATCH_APPLIED (\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual

                                                                                *

ERROR at line 1:

ORA-00911: invalid character

 

Thanks in advance for your reply.

 

Regards,

Latifa

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:[hidden email][hidden email]]
Sent: Thursday, January 12, 2017 9:05 PM
To: DRIF, Latifa
Subject: Re: All phasis are aborted only cleanup is completed

 

Hi Latifa,

1)

Reference: Useful Scripts for E-Business Suite Applications Analysts (Doc ID 887438.1)
In EBS 12.2 you maynot simply query the AD_BUGS table. This table may have entries for patches that were applied but later the patching cycle was aborted (not really applied).

The way to check whether a patch is really applied is to use the AD_PATCH.IS_PATCH_APPLIED PL/SQL function.

Usage:
select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
example sql:
SELECT adb.bug_number,ad_patch.is_patch_applied('11i', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in ('20034256');

or for single app tier installations:
select ad_patch.is_patch_applied('R12',-1,'20034256') from dual;

expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted


2)

Ref: Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching (adop) Cutover (Doc ID 1584097.1)

If you had not run the cutover phase, you would have been able to roll back the patch application process by running the adop abort phase. However, this is not possible once cutover has been run.

So, if you could rollback the patch application by running adop abort phase, then it means you could not run the cutover phase completely.




3)

Check the patches using the method describe in 1).

Run adop phase=prepare and try to apply those patches again.
Watch out the bug : Bug 18365153 - CUTOVER PROCEEDS WITHOUT ABORTING CM IF CM_WAIT PARAMTER USED
Check all the relevant log files, if the hang will reappear. (exactly during the hang)

--

Read this book for more: https://www.amazon.com/Practical-Oracle-Business-Suite-Implementation/dp/1484214234

---

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/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1901.html

To unsubscribe from All phasis are aborted only cleanup is completed, click here.
NAML

Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l’intention exclusive des destinataires désignés. Il contient des informations confidentielles et pouvant être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de détruire le message. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse de l’émetteur. L'internet ne garantissant pas l'intégrité de ce message lors de son acheminement, Atos (et ses filiales) décline(nt) toute responsabilité au titre de son contenu. Bien que ce message ait fait l’objet d’un traitement anti-virus lors de son envoi, l’émetteur ne peut garantir l’absence totale de logiciels malveillants dans son contenu et ne pourrait être tenu pour responsable des dommages engendrés par la transmission de l’un d’eux.

This message and any attachments (the "message") are intended solely for the addressee(s). It contains confidential information, that may be privileged. If you receive this message in error, please notify the sender immediately and delete the message. Any use of the message in violation of its purpose, any dissemination or disclosure, either wholly or partially is strictly prohibited, unless it has been explicitly authorized by the sender. As its integrity cannot be secured on the internet, Atos and its subsidiaries decline any liability for the content of this message. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.

---

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/All-phasis-are-aborted-only-cleanup-is-completed-tp1900p1902.html

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

--