Oracle EBS R12.1.3 打patch出現hang住的現象如何解決

一般打patch到後期，游標控制權都會自動釋放給使用者 ， 但有時候打patch到中途或最後編譯無效物件的時候，會停滯不前 。  如果是比較明顯的錯誤， 我們可以透過打patch的介面看到， 也可以透過 adctrl 來檢視 。 下面是一個例子：

..........

Processing a batch
...: Wed Feb 08 2012 21:33:49

Processing a batch
...: Wed Feb 08 2012 21:33:51

Processing a batch
...: Wed Feb 08 2012 21:33:53

Processing the last batch...: Wed Feb 08 2012 21:33:57
Done updating the checkfile repository...

STOP_TASK: [Running database update commands] [] [Wed Feb 08 2012 21:33:59]

About to turn off bugs with no active actions: Wed Feb 08 2012 21:33:59

Start of adpunb(): Wed Feb 08 2012 21:33:59
Active bugs at start: 1
Bugs turned off: 0
Outer loop iterations: 26143
Actions scanned: 2

End of adpunb(): Wed Feb 08 2012 21:33:59

Done turning off bugs with no active actions: Wed Feb 08 2012 21:33:59
Done running SQL scripts and EXEC commands.

STOP_TASK: [Run SQL scripts and EXEC commands] [] [Wed Feb 08 2012 21:34:00]

STRT_TASK: [Compile invalid objects in DB] [] [Wed Feb 08 2012 21:34:00]

Compiling invalid objects...

STRT_TASK: [Run ST parallel compile (APPS)] [] [Wed Feb 08 2012 21:34:00]

sqlplus -s APPS/***** @/data/d1/sit/applsit/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 8 0 NONE FALSE
Connected.
Arguments are:
AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 8, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
Connected.
Running utl_recomp.recomp_parallel(8), if it exists

OWNER NUM_INVALID
------------------------------ -----------
PUBLIC 774
MSC 2
APPLSYSPUB 1
ICARE_ICAREBI 4005
APPS 40899
DMSYS 10
6 rows selected.
Elapsed: 00:00:00.32
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.02
STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...

 

 

應該是打patch的最後一步了， 執行adutlrcmp.sql 編譯patch安裝中無效資料庫物件,從log看,目前你apps schema下有40899個, 可以隔段時候用 dba使用者連到資料庫上,執行以下的sql看看非法物件有沒有變少,
select owner, count(*) tsum from dba_objects where status <> 'VALID' group by owner;

如果機器配置不高(記憶體小於4G), PGA小於2G ,跑起來會比較慢。   通常會建議打這個升級包前，修改 $RDBMS_ORACLE_HOME/dbs/init.ora 檔案，把SGA和PGA的引數調到至少2G, 再加上下面一

條引數   _disable_fast_validate=TRUE   。   

 

打好patch後，再把上面新加的引數注掉就行了，  如果你現在不想等，可以中止當前的 patch程式，修

改引數，重啟DB， 再次adpatch的時候會提示是否繼續當前的patch,  可以選擇繼續當前的 patch程式即可。