R12.2 Apps DBA. Powered by Blogger.

R12.2 Patch Seems to be Stuck And Not Progressing

No comments :
While applying some R12.2 patch it seems to be stuck for long time and don't progress.
ERROR:
No information is logged in the log files.
CHANGES
 In reviewing the patch/worker logs it appears to be running compile objects such as ADZDUTLRECMP.sql.
CAUSE
Compiling STUB invalid objects
STUB are objects related to the editioning capabilities of the database.
SOLUTION
To implement the solution, please execute the following steps :
In R12.2, different than other releases, the stubs objects are not displayed in the dba_objects, so querying this table will not show all the invalid objects
The following query can be used to display the invalid objects:

select * from
  (
    select
        eusr.user_name owner
      , count(decode(obj.type#,88,NULL,decode(obj.status,1,NULL,1))) Actual
      , count(decode(obj.type#,88,decode(obj.status,1,NULL,1),NULL)) Stub
      , count(decode(obj.type#,88,decode(obj.status,1,NULL,1),decode(obj.status,1,NULL,1))) Total
    from
        sys.obj$ obj
      , sys.obj$ bobj
      , (
            select
                xusr.user#
              , xusr.ext_username user_name
              , ed.name edition_name
            from
                (select * from sys.user$ where type# = 2) xusr
              , (select * from sys.obj$ where owner# = 0 and type# = 57) ed
            where xusr.spare2 = ed.obj#
            union
            select
                busr.user#
              , busr.name user_name
              , ed.name edition_name
            from
                (select * from sys.user$ where type# = 1 or user# = 1) busr
              , (select * from sys.obj$ where owner# = 0 and type# = 57) ed
            where ed.name = 'ORA$BASE'
        ) eusr
    where obj.owner# = eusr.user#
      and bobj.obj#(+) = obj.dataobj#
      and obj.type# not in (0, 10)
      and ( obj.type# <> 88 or (obj.type# = 88 and bobj.type# <> 10) )
      and obj.remoteowner is null
    group by eusr.user_name
  ) x
where total > 0
order by 1
/
---
The patch will proceed only when the number of invalids displayed is close to zero.
The following is a sample output from the query:
OWNER    ACTUAL       STUB      TOTAL
---------- ---------- ----------
APPS         2      19296      19298
Note that there are 19296 invalid stub objects to be compiled yet.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.