Adop RUP 10 - Skip worker
Posted by satish on Feb 27, 2023; 2:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adop-RUP-10-Skip-worker-tp11659.html
Dear Erman,
Dear Erman,
We are upgrading R12.1.3 to R12.2.10.
We are applying RUP 10 as instructed in downtime mode using below command.
[applcrp@sssterpdev1 R122]$ ls
EBSapps.env fs1 fs2 fs_ne
[applcrp@sssterpdev1 R122]$ . ./EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/CRP/R122/fs1/EBSapps/appl
PATCH File System : /u01/CRP/R122/fs2/EBSapps/appl
Non-Editioned File System : /u01/CRP/R122/fs_ne
DB Host: sssterpdev1.ssst.org Service/SID: SSSEBSTR
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[applcrp@sssterpdev1 R122]$ adop phase=apply apply_mode=downtime patches=30399999 patchtop=/u01/CRP/R122/fs_ne/EBSapps/patch abandon=yes
: : :
===========================================================================
ADOP (C.Delta.12)
Session ID: 2
Node: sssterpdev1
Phase: apply
Log: /u01/CRP/R122/fs_ne/EBSapps/log/adop/2/20230227_064531/adop.log
===========================================================================
Applying patch 30399999.
Log: /u01/CRP/R122/fs_ne/EBSapps/log/adop/2/20230227_064531/apply/sssterpdev1/30399999/log/u30399999.log
AutoPatch error:
Error running SQL and EXEC commands in parallel
You should check the file
/u01/CRP/R122/fs_ne/EBSapps/log/adop/2/20230227_064531/apply/sssterpdev1/30399999/log/u30399999.log
for errors.
[UNEXPECTED]Error occurred executing "adpatch abandon=yes restart=no workers=16 options=hotpatch console=no interactive=no defaultsfile=/u01/CRP/R122/fs1/EBSapps/appl/admin/SSSEBSTR/adalldefaults.txt patchtop=/u01/CRP/R122/fs_ne/EBSapps/patch/30399999 driver=u30399999.drv logfile=u30399999.log"
[UNEXPECTED]Refer to the log files for more information.
[UNEXPECTED]Apply phase has failed.
[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)
[applcrp@sssterpdev1 R122]$
We opened another sesison
[applcrp@sssterpdev1 u01]$ cd /u01/CRP/R122/
[applcrp@sssterpdev1 R122]$ ls
EBSapps.env fs1 fs2 fs_ne
[applcrp@sssterpdev1 R122]$ . ./EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/CRP/R122/fs1/EBSapps/appl
PATCH File System : /u01/CRP/R122/fs2/EBSapps/appl
Non-Editioned File System : /u01/CRP/R122/fs_ne
DB Host: sssterpdev1.ssst.org Service/SID: SSSEBSTR
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[applcrp@sssterpdev1 R122]$ adctrl
I am trying to skip the failed worker but failed patch is unable to progress.
---------------------------------------------------
1. Show worker status
2. Tell worker to restart a failed job
3. Tell worker to quit
4. Tell manager that a worker failed its job
5. Tell manager that a worker acknowledges quit
6. Restart a worker on the current machine
7. Exit
Enter your choice [1] : 1
Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Done AutoPatch R120 MSDODPCODE.sql FAILED
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
Review the messages above, then press [Return] to continue.
AD Controller Menu
---------------------------------------------------
1. Show worker status
2. Tell worker to restart a failed job
3. Tell worker to quit
4. Tell manager that a worker failed its job
5. Tell manager that a worker acknowledges quit
6. Restart a worker on the current machine
7. Exit
Enter your choice [1] : 8
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 1
Status changed to 'Skip & restart' for worker 1.
Review the messages above, then press [Return] to continue.
Enter your choice [1] : 1
Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Done AutoPatch R120 MSDODPCODE.sql Skip & restart
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
Review the messages above, then press [Return] to continue.
No progress in failed patch session..it just stays with failed status
===========================================================================
Applying patch 30399999.
Log: /u01/CRP/R122/fs_ne/EBSapps/log/adop/2/20230227_064531/apply/sssterpdev1/30399999/log/u30399999.log
AutoPatch error:
Error running SQL and EXEC commands in parallel
You should check the file
/u01/CRP/R122/fs_ne/EBSapps/log/adop/2/20230227_064531/apply/sssterpdev1/30399999/log/u30399999.log
for errors.
[UNEXPECTED]Error occurred executing "adpatch abandon=yes restart=no workers=16 options=hotpatch console=no interactive=no defaultsfile=/u01/CRP/R122/fs1/EBSapps/appl/admin/SSSEBSTR/adalldefaults.txt patchtop=/u01/CRP/R122/fs_ne/EBSapps/patch/30399999 driver=u30399999.drv logfile=u30399999.log"
[UNEXPECTED]Refer to the log files for more information.
[UNEXPECTED]Apply phase has failed.
[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)
[applcrp@sssterpdev1 R122]$
We realized that we should nt skip the worker. Error below
ERROR at line 1:
ORA-33272: Analytic workspace APPS.ODPCODE cannot be opened.
ORA-33288: Another user has incompatible access to analytic workspace
APPS.ODPCODE, and the wait timeout has expired.
ORA-06512: at "SYS.DBMS_AW", line 1067
ORA-06512: at "SYS.DBMS_AW", line 1001
ORA-06512: at "APPS.MSD_AW_LOADER", line 19
ORA-06512: at line 3
one of my collegue say to use options=noparallel but this downtime mode is not considering it.
Do we need to go to patch environment and run adctrl? are we missing something.Can you please guide us?
Thanks,
Satish