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:ml-node+[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:
To unsubscribe from All phasis are aborted only cleanup is completed,
click here.
NAML
Free forum by Nabble |