4u6打6728000补丁时,卡壳了. (问题已解决)

ayoung

[oracle@r1204 ~]$ adctrl

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                                 AD Controller

                                 Version 12.0.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Your default directory is '/d01/oracle/VIS/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

AD Controller records your AD Controller session in a text file
you specify.  Enter your AD Controller log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adctrl.log] :

************* Start of AD Controller session *************
AD Controller version: 12.0.0
AD Controller started at: Fri Mar 06 2009 09:53:29

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Enter the ORACLE username of Application Object Library [APPLSYS] :

Enter the ORACLE password of Application Object Library [APPS] :

AD Controller is verifying your username/password.
The status of various features in this run of AD Controller is:

                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y



                    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] : 1


        Control
Worker  Code      Context            Filename                    Status
------  --------  -----------------  --------------------------  --------------
     1  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     2  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     3  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     4  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     5  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     6  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     7  Run       AutoPatch R120     wfntfcu2.sql                FAILED
     8  Run       AutoPatch R120     wfntfcu2.sql                FAILED

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] : 2

Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : all

Status changed to 'Fixed, restart' for worker 1.
Status changed to 'Fixed, restart' for worker 2.
Status changed to 'Fixed, restart' for worker 3.
Status changed to 'Fixed, restart' for worker 4.
Status changed to 'Fixed, restart' for worker 5.
Status changed to 'Fixed, restart' for worker 6.
Status changed to 'Fixed, restart' for worker 7.
Status changed to 'Fixed, restart' for worker 8.
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] :

ayoung

/d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

- Telling worker to read todo restart file.

Done restarting worker.


Starting up worker 3 again.
- Changing control code to 'Wait'.
- Starting up the process.
- Telling worker to read todo restart file.

Done restarting worker.


Starting up worker 4 again.
- Changing control code to 'Wait'.
- Starting up the process.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Mar 06 2009 10:12:40

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Mar 06 2009 10:12:40

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl

- Telling worker to read todo restart file.

Done restarting worker.


Starting up worker 5 again.
- Changing control code to 'Wait'.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Mar 06 2009 10:12:40

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl

- Starting up the process.
- Telling worker to read todo restart file.

Done restarting worker.

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Mar 06 2009 10:12:40

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Mar 06 2009 10:12:40

APPL_TOP is set to /d01/oracle/VIS/apps/apps_st/appl


Restarted: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

           FAILED: file wfntfcu2.sql on worker  1.
           FAILED: file wfntfcu2.sql on worker  2.
           FAILED: file wfntfcu2.sql on worker  3.
           FAILED: file wfntfcu2.sql on worker  4.
           FAILED: file wfntfcu2.sql on worker  5.
           FAILED: file wfntfcu2.sql on worker  6.
           FAILED: file wfntfcu2.sql on worker  7.
           FAILED: file wfntfcu2.sql on worker  8.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Restarted: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.

There are now 524 jobs remaining (current phase=A89):
    3 running, 0 ready to run and 521 waiting.

    Fixed: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.

There are now 521 jobs remaining (current phase=A89):
    0 running, 0 ready to run and 521 waiting.


ATTENTION: All workers either have failed or are waiting:

           FAILED: file wfntfcu2.sql on worker  1.
           FAILED: file wfntfcu2.sql on worker  2.
           FAILED: file wfntfcu2.sql on worker  3.
           FAILED: file wfntfcu2.sql on worker  4.
           FAILED: file wfntfcu2.sql on worker  5.
           FAILED: file wfntfcu2.sql on worker  6.
           FAILED: file wfntfcu2.sql on worker  7.
           FAILED: file wfntfcu2.sql on worker  8.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.wfn                                              tfcu2.sql


    Fixed: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
    Fixed: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  8 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  2 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  3 for product fnd username APPLSYS.

There are now 525 jobs remaining (current phase=A89):
    4 running, 0 ready to run and 521 waiting.

   FAILED: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  1 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  4 for product fnd username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

           FAILED: file wfntfcu2.sql on worker  1.
           FAILED: file wfntfcu2.sql on worker  2.
           FAILED: file wfntfcu2.sql on worker  3.
           FAILED: file wfntfcu2.sql on worker  4.
           FAILED: file wfntfcu2.sql on worker  5.
           FAILED: file wfntfcu2.sql on worker  6.
           FAILED: file wfntfcu2.sql on worker  7.
           FAILED: file wfntfcu2.sql on worker  8.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.hea                                              d: 无法打开 ‘/tmp/mailthisfl’ 来读取数据: 没有那个文件或目录
tail: 无法打开 ‘/tmp/mailthisfl’ 来读取数据: 没有那个文件或目录


Restarted: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.
Restarted: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  7 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  5 for product fnd username APPLSYS.
   FAILED: file wfntfcu2.sql on worker  6 for product fnd username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

           FAILED: file wfntfcu2.sql on worker  1.
           FAILED: file wfntfcu2.sql on worker  2.
           FAILED: file wfntfcu2.sql on worker  3.
           FAILED: file wfntfcu2.sql on worker  4.
           FAILED: file wfntfcu2.sql on worker  5.
           FAILED: file wfntfcu2.sql on worker  6.
           FAILED: file wfntfcu2.sql on worker  7.
           FAILED: file wfntfcu2.sql on worker  8.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Telling workers to quit...


All workers have quit.

AutoPatch error:

Error running SQL and EXEC commands in parallel


You should check the file
/d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

for errors.

You have new mail in /var/spool/mail/oracle
[oracle@r1204 ~]$
[oracle@r1204 ~]$
[oracle@r1204 ~]$ wfntfcu2.sql
-bash: wfntfcu2.sql: command not found
[oracle@r1204 ~]$ /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log
-bash: /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log: 权限不够
[oracle@r1204 ~]$ vi /d01/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log                                              Time is: Mon Nov 17 2008 08:52:07

Assigned: file asomenu1.ldt on worker  3 for product aso username APPS.

Time is: Mon Nov 17 2008 08:52:07

Assigned: file aspfunc.ldt  on worker  7 for product asp username APPS.

Time is: Mon Nov 17 2008 08:52:07

Completed: file asomenu1.ldt on worker  3 for product aso username APPS.

Time is: Mon Nov 17 2008 08:52:09

Assigned: file asplkup.ldt  on worker  3 for product asp username APPS.

Time is: Mon Nov 17 2008 08:52:09

Completed: file asobilkup.ldt on worker  2 for product aso username APPS.

Time is: Mon Nov 17 2008 08:52:09

Assigned: file aspmenu.ldt  on worker  2 for product asp username APPS.

Time is: Mon Nov 17 2008 08:52:10

Completed: file aspfunc.ldt  on worker  7 for product asp username APPS.

Time is: Mon Nov 17 2008 08:52:10

Assigned: file astdblkp.ldt on worker  7 for product ast username APPS.

Time is: Mon Nov 17 2008 08:52:10

Completed: file asnmenu.ldt  on worker  4 for product asn username APPS.

Time is: Mon Nov 17 2008 08:52:11

Assigned: file astjlkps.ldt on worker  4 for product ast username APPS.

Time is: Mon Nov 17 2008 08:52:11

Completed: file asobimnu.ldt on worker  6 for product aso username APPS.

Time is: Mon Nov 17 2008 08:52:12

Assigned: file astlktps.ldt on worker  6 for product ast username APPS.
                                                                                                            4393,0-1       0%

moonsoft

原帖由 fengzaichui 于 2009-3-6 09:39 发表
是Oracle的一个Bug，要改那个SQL，文档发给Ayang了，请Ayang回头了补上啊。

能发给小生一下吗

vvyjp

共享下吧

hhguoe

我也遇到同样的问题，报了个1级tar，oracle给的解决办法，给大家共享一下。
In the script wfntfcu2.sql, change the SELECT CURSOR by putting " characters around column WL.NLS_LANGUAGE. It will look,like this
after the change

CURSOR c_responded_ntf is
SELECT /*+ ROWID(wc) */ WC.ROWID ID,
WN.CONTEXT,
WC.ACTION_TYPE,
WC.FROM_ROLE,
WC.TO_ROLE,
''''||WL.NLS_LANGUAGE||''''
FROM WF_NOTIFICATIONS WN,
WF_COMMENTS WC,
WF_LANGUAGES WL
WHERE WN.NOTIFICATION_ID = WC.NOTIFICATION_ID
AND WL.CODE = NVL(WC.LANGUAGE,'US')
AND WL.INSTALLED_FLAG = 'Y'
AND WC.ACTION_TYPE IN ('SEND','RESPOND')
ORDER BY WC.NOTIFICATION_ID,WC.COMMENT_DATE;

ayoung

RT

ayoung

RT

ayoung

这关过了.

是新sql文件更新目录错了.

正确目录:
/oracle/VIS/apps/apps_st/appl/fnd/12.0.0./patch/115/sql/wfntfcu2.sql

ayoung

Control
Worker  Code      Context            Filename                    Status
------  --------  -----------------  --------------------------  --------------
     1  Run       AutoPatch R120     fapostimportaad.sql         Running
     2  Run       AutoPatch R120     appostimportaad.sql         Running
     3  Run       AutoPatch R120                                 Wait
     4  Run       AutoPatch R120     arpostimportaad.sql         Running
     5  Run       AutoPatch R120                                 Wait
     6  Run       AutoPatch R120     papostimportaad.sql         Running
     7  Run       AutoPatch R120                                 Wait
     8  Run       AutoPatch R120     cstpostimportaad.sql        Running

Review the messages above, then press [Return] to continue.

ayoung

There are now 3 jobs remaining (current phase=A128):
    0 running, 2 ready to run and 1 waiting.

Assigned: file adobjcmp.sql on worker  1 for product ad  username APPLSYS.
Assigned: file adstatrp.sql on worker  2 for product ad  username APPLSYS.
   FAILED: file adobjcmp.sql on worker  1 for product ad  username APPLSYS.
Deferred: file adobjcmp.sql on worker  1 for product ad  username APPLSYS.               (Deferment number 1 for this job)
Assigned: file adobjcmp.sql on worker  1 for product ad  username APPLSYS.
Completed: file adobjcmp.sql on worker  1 for product ad  username APPLSYS.