Patch Issue

※在打Patch:5903765ATG_PF.H Rollup 6_11i時卡住，訊息如下：

patch log:
FAILED: file ademusr.sql on worker 1 for product ad username APPLSYS.

adwork001.log
Start time for statement below is: Tue Sep 09 2008 11:54:49
GRANT select on GV$LOGFILE to em_oam_monitor_role
AD Worker error:
The following ORACLE error:
ORA-01031: insufficient privileges
occurred while executing the SQL statement:
GRANT select on GV$LOGFILE to em_oam_monitor_role

解決方法：
1.登入DB User，sqlplus /nolog
SQL>connect DB / as sysdba
SQL>grant select on GV_$LOGFILE to system with grant option
SQL>connect system/systempwd.
SQL>grant select on GV$LOGFILE to em_oam_monitor_role.
2.登入AP User，啟動AD工具worker管理員
$adctlr -->2. Tell worker to restart a failed job-->1(指定work001重新啟動)


※在打Patch:5473858 ATG_PF.H Rollup 5_11i時卡住，訊息如下：
patch log:
FAILED: file ademusr.sql on worker 1 for product ad username APPLSYS.

adwork001.log
Start time for statement below is: Tue Sep 16 2008 19:02:49

GRANT select on WF_JAVA_DEFERRED to APPS with grant option

AD Worker error:
The following ORACLE error:

ORA-01720: grant option does not exist for 'SYS.AQ$_JMS_TEXT_MESSAGE'

Cause

Either Patch 5989593, AD: 11i: Remove "REVOKE ALL FROM PUBLIC" from ADGRANTS.SQL, was not applied, or adgrants.sql failed.

Patch 5989593 is a prerequisite for ATG_PF.H.RUP5, and when applying this patch, you are
requested to run adgrants.sql. The version of adgrants.sql supplied in the patch has this statement:
'grant EXECUTE on AQ$_JMS_TEXT_MESSAGE to APPLSYS with GRANT OPTION';
This gives you the grant option that is missing per the error message:
ORA-01720: grant option does not exist for 'SYS.AQ$_JMS_TEXT_MESSAGE'

解決方法：
1. Create $ORACLE_HOME/appsutil/admin on the database server.

2. Copy adgrants.sql (UNIX) from the patchtop(5989593)/admin directory to
    $ORACLE_HOME/appsutil/admin. Or, copy adgrants_nt.sql (Windows) from
    patchtop(5989593)\admin to %ORACLE_HOME%\appsutil\admin.
3. Set the environment to point to ORACLE_HOME on the database server.
4. Use SQL*Plus to run the script:
  UNIX:
    $ sqlplus /nolog
    SQL> connect / as sysdba
    SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql