All phasis are aborted only cleanup is completed

[latifa]

Hello Erman,

During upgrade to 12.2.4, I am facing a situation where adop status is showing all phases as "SESSION ABORTED" only cleanup is "COMPLETED".
Before this status, I was doing cutover; it doesn't work, hanging all the time even I resized tempfiles. I have done an abort and then cleanup_full and after that fs_clone.
Should I continue applying other patches or restart the prepare phase ?
How can I know that every is OK. I ckecked ad_bugs table. all the patchs are applied.
However, adopreports results for Online patch status is :

BUG_NUMBER          APPLIED_FILE_SYSTEM          STATUS         APPLIED_NODE
==============================================================================
19689290            /opt/application/V12/fs1     SUCCESS        udkfinp03
19679769            /opt/application/V12/fs1     SUCCESS        udkfinp03
19689161            /opt/application/V12/fs1     SUCCESS        udkfinp03
19684688_F          /opt/application/V12/fs1     SKIPPED        udkfinp03
19681454            /opt/application/V12/fs1     SUCCESS        udkfinp03
19245366_F          /opt/application/V12/fs1     SUCCESS        udkfinp03
19684688            /opt/application/V12/fs1     SUCCESS        udkfinp03
19245366            /opt/application/V12/fs1     SUCCESS        udkfinp03


Thank you in advance for your help.

Latifa

NB: Here it is the output of : adop -status

opfinbac@udkfinp03:/opt/application/V12/fs_ne/EBSapps/log/adop/8/abort_20170112_105703/DBOFINP_udkfinp03$ adop -status


Enter the APPS password:
Connected.

==============================================================
ADOP (C.Delta.7)
Session Id: 8
Command: status
Output: /opt/application/V12/fs_ne/EBSapps/log/status_20170112_161057/adzdshowstatus.out
===============================================================

Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
udkfinp03       master     PREPARE         SESSION ABORTED 2017/01/09 16:22:30  2017/01/09 18:45:47  2:23:17
                           APPLY           SESSION ABORTED 2017/01/09 18:54:17  2017/01/10 09:52:28  14:58:11adzdshowstatus.out
                           FINALIZE        SESSION ABORTED 2017/01/10 10:00:31  2017/01/10 10:01:01  0:00:30
                           CUTOVER         SESSION ABORTED 2017/01/10 10:11:50  2017/01/12 10:58:43  48:46:53
                           CLEANUP         COMPLETED       2017/01/12 12:53:40  2017/01/12 12:57:13  0:03:33

File System Synchronization Type: Full

adop exiting with status = 0 (Success)

[ErmanArslansOracleBlog]

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

[latifa]

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:

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.

[ErmanArslansOracleBlog]

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

--

[latifa]

Hello Erman,

 

Cutover phase ended with following:

 

Checking for existing adop sessions.

    Continuing with existing session [Session ID: 9].

        Session Id            :   9

        Prepare phase status  :   COMPLETED

        Apply phase status    :   COMPLETED

        Cutover  phase status :   RUNNING

        Abort phase status    :   NOT COMPLETED

        Session status        :   RUNNING

    [ERROR]     Unable to continue as an existing adop session was found.

 

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

 

to get the list of the log files along with snippet of the error message corresponding to each log file.

 

adop exiting with status = 1 (Fail)

 

 

adop –status

 

Session Id: 9

Command: status

Output: /opt/application/V12/fs_ne/EBSapps/log/status_20170113_172506/adzdshowstatus.out

===============================================================

 

Node Name       Node Type  Phase           Status          Started              Finished             Elapsed

--------------- ---------- --------------- --------------- -------------------- -------------------- ------------

udkfinp03       master     PREPARE         COMPLETED       2017/01/13 09:15:15  2017/01/13 09:23:26  0:08:11

                           APPLY           COMPLETED       2017/01/13 09:29:59  2017/01/13 15:44:28  6:14:29

                           FINALIZE        COMPLETED       2017/01/13 15:48:39  2017/01/13 15:49:08  0:00:29

                           CUTOVER         FAILED          2017/01/13 16:02:02  2017/01/13 17:17:42  1:15:40

                           CLEANUP         NOT STARTED

File System Synchronization Type: Full

 

adop exiting with status = 0 (Success)

 

Adctrl status: workers status even cutover down still showing this status (even I killed processes)

 

        Control

Worker  Code      Context            Filename                    Status

------  --------  -----------------  --------------------------  --------------

     1  Done      AutoPatch R120     ADZDWRKR.sql                Assigned     

     2  Done      AutoPatch R120                                 Wait         

     3  Done      AutoPatch R120                                 Wait         

     4  Done      AutoPatch R120                                 Wait         

     5  Done      AutoPatch R120                                 Wait         

     6  Done      AutoPatch R120                                 Wait         

     7  Done      AutoPatch R120                                 Wait         

     8  Done      AutoPatch R120                                 Wait         

     9  Done      AutoPatch R120                                 Wait         

    10  Done      AutoPatch R120                                 Wait         

    11  Done      AutoPatch R120                                 Wait         

    12  Done      AutoPatch R120                                 Wait         

    13  Done      AutoPatch R120                                 Wait         

    14  Done      AutoPatch R120                                 Wait          

    15  Done      AutoPatch R120                                 Wait         

    16  Done      AutoPatch R120                                 Wait         

    17  Done      AutoPatch R120                                 Wait         

    18  Done      AutoPatch R120                                 Wait         

    19  Done      AutoPatch R120                                 Wait         

    20  Done      AutoPatch R120                                 Wait         

    21  Done      AutoPatch R120                                 Wait         

    22  Done      AutoPatch R120                                 Wait         

    23  Done      AutoPatch R120                                 Wait         

    24  Done      AutoPatch R120                                 Wait         

    25  Done      AutoPatch R120                                 Wait         

    26  Done      AutoPatch R120                                 Wait         

    27  Done      AutoPatch R120                                 Wait         

    28  Done      AutoPatch R120                                 Wait         

    29  Done      AutoPatch R120                                 Wait         

    30  Done      AutoPatch R120                                 Wait         

    31  Done      AutoPatch R120                                 Wait         

    32  Done      AutoPatch R120                                 Wait         

    33  Done      AutoPatch R120                                 Wait         

    34  Done      AutoPatch R120                                 Wait         

    35  Done      AutoPatch R120                                 Wait         

    36  Done      AutoPatch R120                                 Wait         

    37  Done      AutoPatch R120                                 Wait         

    38  Done      AutoPatch R120                                 Wait         

    39  Done      AutoPatch R120                                 Wait         

    40  Done      AutoPatch R120                                 Wait         

    41  Done      AutoPatch R120                                 Wait         

    42  Done      AutoPatch R120                                 Wait         

    43  Done      AutoPatch R120                                 Wait         

    44  Done      AutoPatch R120                                 Wait         

    45  Done      AutoPatch R120                                 Wait         

    46  Done      AutoPatch R120                                 Wait         

    47  Done      AutoPatch R120                                 Wait         

    48  Done      AutoPatch R120                                 Wait 

 

 

What I should do ? No Way to stop these workers !

Regards,

Latifa

 

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 7:46 AM
To: DRIF, Latifa
Subject: Re: All phasis are aborted only cleanup is completed

 

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

 

--

Erman Arslan, MBA 

Applications and Database Operations Manager

Oracle Certified Expert, Certified Exadata and Linux Administrator

 

Author,  Practical Oracle E-Business Suite

Blog:     ermanarslan.blogspot.com

Forum:  http://ermanarslan.blogspot.com/p/forum.html

 

Mobile: [phone]

 

---

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-tp1900p1904.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.

[ErmanArslansOracleBlog]

Hi Latifa,

According to the email that you sent to me, it seems it is working now.
(your email: It works now .I kept running cutover phase while restarting the hanging worker (via adctrl) until they meet together to start working in the same time.)

Interesting solution :)
Good. Keep going.

Why didn't you just use option 3?

--In adctrl, select Option 3 and enter 'all' for the worker number. Each worker stops when it either completes or fails its current job.

[latifa]

Hi Erman,

 

I have done many attempts, status always not permitting to let it quit … It was hanging … I even tried “option 8” .

 

Actually, cutover is going on but it looks like that it will take long time and I didn’t use a virtual machine so I will be awake until late I think J …

 

I have a question: Why the script  “ADZDWRKR.sql”  takes so long time ? Even I have changed the parameter: alter system set max_dump_file_size=unlimited scope=both;

 

Regards

Latifa

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 7:23 PM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hi Latifa,

According to the email that you sent to me, it seems it is working now.
(your email: It works now .I kept running cutover phase while restarting the hanging worker (via adctrl) until they meet together to start working in the same time.)

Interesting solution :)
Good. Keep going.

Why didn't you just use option 3?

--In adctrl, select Option 3 and enter 'all' for the worker number. Each worker stops when it either completes or fails its current job.

---

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-tp1900p1907.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.

[ErmanArslansOracleBlog]

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.

[latifa]

Hi Erman,

 

I checked the active sessions and it looks a bit strange and I don’t know ; I would like to know your opinion because I think that are 3 similar sessions and two among them are from the previous sessions. Please find the joined document .  

 

Regards,

Latifa

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 9:26 PM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.

---

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-tp1900p1909.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.

[latifa]

Hi,

 

One more information : after check shell sessions, the following doesn’t exist any more:

 

opfinbac  8566 23366   0 16:09:23 ?           0:00 sqlplus -s /nolog

 

and I think it corresponds to SID = 259 which is not present.

 

Regards,

Latifa

 

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 9:26 PM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.

---

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-tp1900p1909.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.

[ErmanArslansOracleBlog]

Hi Latifa,

With this kind of an approach, you can't just be sure which sessions are exactly doing what, exactly waiting for what and the relation between their Session ids and OS process ids.

You can get that info by joining v$process and v$session.
concantrate on the wait events of these session to see if they are waiting for any db resources. (This might give you a clue)
You should write your control query accordingly.
Bytheway,
Don't you have a tool like Toad, which can assist you on finding the sessions, checking their waits and displaying the OS process id..?

On the other hand, the queries that you sent, seem normal.
It seems that online patching is trying to revise some indexes and it checks the data dictionary for that.

However,  gathering the following stats may increase the speed of those queries.. (if they are the actual causes ofcourse)

exec DBMS_STATS.GATHER_DICTIONARY_STATS;
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

ofcourse these stats gathering should have been done before the problematic phase of adop.
Anyways, I hope you are doing fine, but if you need more assistance, send me the v$ession joined v$process outputb(with waits) + patch number + adworker statuses (a screenshot) + adworker logs + AWR taken in the problematic time interval.

[ErmanArslansOracleBlog]

Also, you said that your are upgrading to 12.2.4, but the following patch that I see in your outputs is for 12.2.5?

19681454: ORACLE E-BUSINESS SUITE APPLICATIONS TECHNOLOGY ONLINE HELP FOR 12.2.5

So, if you need further assistance, tell me your purpose of applying these patches once again (this time give a little detail as well) and also send me the document/documents that you are following.

 

[latifa]

Hi,

 

finally Cutover finished at 6 o’clock AM !! ~14 hours !!

 

Regards,

Latifa

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Friday, January 13, 2017 9:26 PM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hmm, maybe an internal update to the ad_adop_sessions table could the job, but anyways, you managed to workaround it.

For ADZDWRKR; check Database session for understanding what ADZDWRKR.sql does.
It does things like MV recreations.. So maybe that's where it is spending time.

As I said, check the db sessions , the active ones and see what they are doing.

---

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-tp1900p1909.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.

[ErmanArslansOracleBlog]

Hmm..

I don't your environment, but it seems a little bit long :)

If it didn't encounter any errors, then it is at least something to be happy.

This issue is closed then.

However, you can do patch analysis and drill down to the jobs that have been executed for a long duration of time. You can use Patch Reporting Utilities for this.
These patch reporting tools gives you the ability to check the exceptions that are encountered while applying patches and patch-related timing information.

To use the Applied Patches Reporting tool, you log in to EBS and use the Patching and Utilities link
defined in the System Administrator responsibility under Oracle Applications Manager.

Also, as I mentioned earlier, please do your plan to execute the following in a appropriate time;

exec DBMS_STATS.GATHER_DICTIONARY_STATS;
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

These will give you benefit in dictionary related queries. (like the ones you saw in your last cutover session)

[latifa]

Hi Erman,

 

Thank you very much for your help and advises. However, I try to access to the admin console and I encountered a problem:

 

 

I tried to modify security site list in the Java panel but it wasn’t enough.

 

Regarding the upgrade document I will try to send the list of patches we have applied.

 

Thanks in advance for your help.

 

Regards,

Latifa

 

 

 

 

From: ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] [mailto:ml-node+[hidden email]]
Sent: Monday, January 16, 2017 8:52 AM
To: DRIF, Latifa
Subject: RE: All phasis are aborted only cleanup is completed

 

Hmm..

I don't your environment, but it seems a little bit long :)

If it didn't encounter any errors, then it is at least something to be happy.

This issue is closed then.

However, you can do patch analysis and drill down to the jobs that have been executed for a long duration of time. You can use Patch Reporting Utilities for this.
These patch reporting tools gives you the ability to check the exceptions that are encountered while applying patches and patch-related timing information.

To use the Applied Patches Reporting tool, you log in to EBS and use the Patching and Utilities link
defined in the System Administrator responsibility under Oracle Applications Manager.

Also, as I mentioned earlier, please do your plan to execute the following in a appropriate time;

exec DBMS_STATS.GATHER_DICTIONARY_STATS;
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

These will give you benefit in dictionary related queries. (like the ones you saw in your last cutover session)

---

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-tp1900p1916.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.

[ErmanArslansOracleBlog]

Look what the document says; Discoverer Plus 11g with Java 7 seeing "Missing Manifest Attribute" Or "Application Blocked by Security Setting" (Doc ID 1614898.1)

Note: That document is written for discoverer, but it should be applicable for you as well.

In Java 7 releases prior to u51, java returnes a warning "Unsigned or self-signed applications may not be supported in future JDK update releases" message.
Beginning with Java 7 u51 security has been tightened.

Discoverer Plus will launch by adding Discoverer server to the "Exception Site List" on the client PC (Control Panel -> Java -> Security tab -> Edit Site List).
  -or-
By setting Java Security on the client PC to Medium (Contorl Panel -> Java -> Security tab -> move slide to Medium).
  -or-
Use a Java 7 version prior to u51.

Note:  When using E-Business Suite (EBS) R12, please use the JRE version RE 1.7.0_67 (7u67) or JRE 1.7.0_65 (7u65) as documented in Note 393931.1 (Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12)

Take a look at this document as well: JRE Security Warning: Running applications by UNKNOWN publishers will be blocked (Doc ID 1592981.1)