Oracle EBS R12 - adpatch在adutlrcmp.sql卡住，utlrp.sql卡住，shutdown immediate又卡住

最新推荐文章于 2024-08-14 10:39:39 发布

t0nsha

最新推荐文章于 2024-08-14 10:39:39 发布

阅读量3.6k

点赞数

分类专栏： Oracle - EBS/APP

本文链接：https://blog.csdn.net/t0nsha/article/details/10011155

版权

本文介绍了在Oracle EBS R12.1.3环境中遇到的adpatch、adutlrcmp.sql和utlrp.sql执行卡住的问题，以及在尝试`shutdown immediate`时遭遇的困扰。提供了链接到相关解决方案的文章，帮助读者理解并解决这类Oracle数据库关闭等待事件，如Library Cache Lock、Library Cache Pin和Library Cache Load Lock。

摘要由CSDN通过智能技术生成

Oracle EBS R12 - adpatch在adutlrcmp.sql卡住，utlrp.sql卡住，shutdown immediate又卡住

Version:
AP: Oracle EBS R12.0.6
DB: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit

adpatch hang在compile invalids阶段，只得ctrl+c中断掉adutlrcmp.sql让adpatch先走下去，最后再执行utlrp.sql手动编译invalids:

...
STRT_TASK: [Compile invalid objects in DB] [] [Fri Aug 16 2013 03:07:08]

Compiling invalid objects...

STRT_TASK: [Run ST parallel compile (APPS)] [] [Fri Aug 16 2013 03:07:08]

sqlplus -s APPS/***** @/dabcdi/applmgr/1200/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 8 0 NONE FALSE

Arguments are:

AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 8, Logic