解决EBS编译APPS对象出现错误(原创)

sdsk

　　今天解决一个AP发票验证的性能问题,从metalink上找了补丁,在测试环境上测试一下,问题就接踵而来.
　　1,在apply patch的时候,出现如下提示:
　　The following Oracle Reports objects did not generate successfully:
　　
　　ap      reports/US      APXAPRVL.rdf
　　感觉这个问题影响不大,就选择"Y"继续打完补丁,类似这种问题,可以查看一下后台日志,看看有没有什么具体的原因造成的或看看这个报表的代码,再不行就从metalink上去碰运气了,因为Oracle的打patch而导致另外的问题出现,相信大家都遇到过 :).打完补丁后,看日志没有什么错误提示,凭着直觉去看了一下非法对象,发现问题就出现在这里,一下AP模块有几个package是INVALID的,这几个package和前面提到的报表有一定的关系,导致编译报表出现错误,那就用adadmin--Compile APPS schema, 然后就出现如下错误提示:
　　sqlplus -s APPS/***** @/u02/TEST/app/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 0  0 NONE FALSE
　　
　　An error occurred while running a SQL*Plus script.
　　Continue as if it were successful [No] :
　　一看日志,天呀,错误信息一堆,看着错误以为致命的大问题:
　　********************************adadmin.log*************************
　　sqlplus -s APPS/***** @/u02/TEST/app/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 0  0 NONE FALSE
　　Arguments are:
　　AOL_schema = APPLSYS, AOL_password = *****,
Schema_to_compile = APPS, Schema_to_compile_pw = *****,
SYSTEM_password = *****, Total_workers = 0, Logical_worker_num = 0
Object_type_to_not_compile = NONE
Use_stored_dependencies = FALSE
　　Connected.
　　Running utl_recomp.recomp_parallel(0), if it exists
　　
OWNER          NUM_INVALID
------------------------------ -----------
APPS     15
　　Elapsed: 00:00:00.12
　　PL/SQL procedure successfully completed.
　　Elapsed: 00:00:00.02
　　STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...
　　declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
　　
SP2-0359: memory exhausted
　　An error occurred while running a SQL*Plus script.
Continue as if it were successful [No] : n
　　AD Administration error:
Error running adutlrcmp.sql in adprdcAdUtilrcmp()
　　
An error occurred while compiling invalids using the SYS.UTL_RECOMP() package.
　　********************************alert.log********************************************************
　　CJQ0 started with pid=16, OS id=17554
　　Fri Mar 18 17:34:46 2011
　　ALTER SYSTEM SET max_dump_file_size='2000M' SCOPE=MEMORY;
　　Fri Mar 18 17:34:54 2011
　　Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x7DF6702, ptkin()+350]
　　Errors in file
　　/u02/TEST/db/testdb/11.1.0/admin/TEST_erpdemo/diag/rdbms/test/TEST/trace/TEST_ora_17586.trc  (incident=53020):
　　ORA-07445: exception encountered: core dump [ptkin()+350] [SIGSEGV] [ADDR:0x0] [PC:0x7DF6702] [Address not mapped to object] []
　　Incident details in:
　　/u02/TEST/db/testdb/11.1.0/admin/TEST_erpdemo/diag/rdbms/test/TEST/incident/incdir_53020/TEST_ora_17586_i53020.trc
　　Fri Mar 18 17:34:57 2011
　　Trace dumping is performing id=[cdmp_20110318173457]
　　Fri Mar 18 17:34:57 2011
　　Sweep Incident[53020]: completed
　　**************************************************************************************
　　对于ORA-07445错误,听Oracle的工程师说一半都是OS系统问题导致的? 我个人感觉不是这个方面造成的, 就只能看dump文件了(TEST_ora_17586_i53020.trc),在一目十行的浏览中,一个package划入眼中,怎么这么熟悉,原来这个包也在刚才查出的非法对象中,难道系统是在编译这个包的时候,出现问题,卡住了? 不用EBS的标准工具,手动去编译了一下APPS.FUN_VENDOR_PVT_PKG.
　　Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
　　Connected as apps
　　
　　SQL> ALTER PACKAGE APPS.FUN_VENDOR_PVT_PKG COMPILE;
　　
　　Package altered
　　
　　SQL> ALTER PACKAGE APPS.FUN_VENDOR_PVT_PKG COMPILE BODY;
　　
　　Package body altered
　　
　　SQL>
　　然后再去adadmin, 问题解决了.对于这个包到metalink上去找找了,是个bug,后面会有参考文档.
　　see
　　1.R12:Validating Invoices Performance Takes Very Long Time [ID 1141833.1]
　　2.R12: Invalid Object FUN_VENDOR_PVT_PKG Package Body [ID 1295382.1]
　　3.Package FUN_VENDOR_PVT_PKG is INVALID after R12 upgrade [ID 982428.1]
　　4.Compile Package APPS.FUN_VENDOR_PVT_PKG Exits With Error ORA-3113 [ID 1276977.1]
　　<EOF>