10. adpatch 补丁应用指南（常见问题处理）

手册

adpatch补丁应用指南（常见问题处理）

(仅供内部使用)

拟制：日期： 审核：日期： 批准：日期：

手册

目录

1

11i和R12 adpatch常见问题................................................................................................... 6 1.1 打补丁时如何最小化风险 ....................................................................................... 6 1.2 如何减少系统停机时间 ........................................................................................... 7 1.3 如何制定补丁计划 ................................................................................................... 8 1.4 如何查看补丁日志和位置和含义 ......................................................................... 10

1.4.1 补丁日志路径 ................................................................................................. 10 1.4.2 补丁日志分类 ................................................................................................. 10 1.4.3 其他信息 ......................................................................................................... 11 1.5 如何查看补丁是否已经打过 ................................................................................. 12

1.5.1 快速方法 ......................................................................................................... 12 1.5.2 常见问题 ......................................................................................................... 12 1.6 如何解决打补丁的性能问题 ................................................................................. 13

1.6.1 合理选择adworker个数 ............................................................................... 13 1.6.2 开始补丁之前，relink ad可执行文件 .......................................................... 13 1.6.3 如果文档/README中有说明，禁用fast validation for PL/SQL recompilations 13 1.6.4 修正数据库初始化参数 ................................................................................. 14 1.6.5 确保统计数据收集模式请求有定期运行 ..................................................... 14 1.6.6 尝试将adpatch batchsize从100增加到1000 ............................................. 14 1.6.7 如果找不到问题的原因，可以到社区发帖或者提SR ................................ 14 1.7 应用补丁没有64bit版本 ...................................................................................... 15 1.8 如何解决补丁过程中的relink错误 ...................................................................... 15 1.9 如何解决更新补丁后的无效对象 ......................................................................... 17

1.9.1 对照EBS interoperability notes确保所有要求的补丁都已经安装 ............. 17 1.9.2 确保RDBMS可执行文件没有renlink错误 .................................................. 18 1.9.3 确保数据库初始化参数按照下面文章设置 ................................................. 18 1.9.4 使用adadmin验证APPS schema .................................................................. 18 1.9.5 确保APPS有足够的权限访问数据库对象 ................................................... 18 1.9.6 有下面的错误： ............................................................................................. 18 1.9.7 使用adadmin重新apps schema的授权和同义词 ...................................... 19 1.9.8 使用adadmin查找缺少的文件 ..................................................................... 19 1.9.9 使用adadmin编译apps schema ................................................................... 19 1.9.10 获取无效对象列表及相关错误 ..................................................................... 19 1.9.11 检查数据库组件 ............................................................................................. 20 1.9.12 java类无效？ ................................................................................................. 20 1.9.13 升级过程中或者升级后需要卸载/重新安装/升级 XML DB ....................... 20 1.9.14 表/视图丢失？ ............................................................................................... 20 1.9.15 queue失效？ ................................................................................................. 20 1.9.16 Intermedia组件失效？ .................................................................................. 21 1.9.17 缺少程序包？ ................................................................................................. 21 1.9.18 package定义和body不同步？ ..................................................................... 21

手册

1.9.19 package显示有效，但实际无效 ................................................................... 21 1.9.20 表或视图丢失列 ............................................................................................. 21 1.9.21 参考troubleshooting guide ............................................................................ 23 1.9.22 如果找不到问题的原因，可以到社区发帖或者提SR ................................ 23 1.10 如何解决库文件Libraries (.pll/.plx)的错误 ........................................................... 23

1.10.1 确保已经安装补丁所有的前置条件 ............................................................. 24 1.10.2 查看adwork日志 ........................................................................................... 24 1.10.3 在MOS中使用下面条件搜索 ....................................................................... 24 1.10.4 查看对应的产品模块是否有无效对象 ......................................................... 25 1.10.5 错误cannot load library unit APPS.xxx (referenced by APPS.xxx) .................. 25 1.10.6 ERROR [code=11] generating library \from input file $APPL_TOP/au/12.0.0/resource/.pll ...................................... 25 1.10.7 ORA-06501: PL/SQL: program error ................................................................ 26 1.10.8 补丁已经更新完，如何手工重新生成library .............................................. 26 1.11 如何解决英文form（.fmb）编译报错 ................................................................. 27

1.11.1 确保已经安装补丁所有的前置条件 ............................................................. 27 1.11.2 确保先解决library的报错 ............................................................................ 28 1.11.3 查看adwork日志 ........................................................................................... 28 1.11.4 在MOS中使用下面条件搜索 ....................................................................... 29 1.11.5 查看对应的产品模块是否有无效对象 ......................................................... 29 1.11.6 问题可能原因是OS中缺少rpm包 .............................................................. 29 1.11.7 form版本和package版本不一致 ................................................................. 30 1.11.8 手工生成form ................................................................................................ 30 1.12 如何解决NLS form（.fmb）编译报错 .................................................................. 31

1.12.1 确认英文form是否报错 ............................................................................... 31 1.12.2 确认library是否报错 .................................................................................... 31 1.12.3 查看adwork日志 ........................................................................................... 32 1.12.4 在MOS中使用下面条件搜索 ....................................................................... 33 1.12.5 问题可能原因是OS中缺少rpm包 .............................................................. 33 1.13 如何解决.ldt (FNDLOAD)文件运行失败 ................................................................ 33

1.13.1 确保已经安装补丁所有的前置条件 ............................................................. 34 1.13.2 如何查看错误 ................................................................................................. 34 1.13.3 在MOS中使用下面条件搜索 ....................................................................... 35 1.13.4 ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column ..................................................................................................................... 35 1.13.5 ORA-12705: Cannot access NLS data files or invalid environment specified .. 35 1.13.6 加载.ldt文件时检查数据库alert日志 ......................................................... 36 1.13.7 检查.ldt文件 .................................................................................................. 36 1.13.8 启用FNDLOAD debug ..................................................................................... 36 1.13.9 使用其他debug方法 ..................................................................................... 37 1.14 如何解决.sql文件运行失败 .................................................................................. 37

1.14.1 确保已经安装补丁所有的前置条件 ............................................................. 37 1.14.2 查看adwork日志 ........................................................................................... 37 1.14.3 在MOS中使用下面条件搜索 ....................................................................... 38

手册

1.14.4 手工运行sql脚本 .......................................................................................... 38 1.14.5 查看数据库alert日志 ................................................................................... 38 1.14.6 使用其他debug方法 ..................................................................................... 38 1.14.7 查看对应的产品模块是否有无效对象 ......................................................... 39 1.15 如何解决.odf文件运行失败 ................................................................................. 39

1.15.1 确保已经安装补丁所有的前置条件 ............................................................. 39 1.15.2 查看adwork日志 ........................................................................................... 39 1.15.3 在MOS中使用下面条件搜索 ....................................................................... 40 1.15.4 查看数据库alert日志 ................................................................................... 40 1.15.5 如果有错误Unable to find existing index on the same columns................... 40 1.15.6 如果有错误The index cannot be created as the table has duplicate keys. ... 41 1.15.7 如果有错误AD Worker - aduobbrt2: INFO: ORA-03211: The segment does not exist or is not in a valid state ..................................................................................... 41 1.15.8 如果有错误ORA-00054: resource busy and acquire with NOWAIT specified 42

1.15.9 如果运行poxcom.odf报错ORA-00911: invalid character ............................ 42 1.15.10 手工加载.odf文件 ................................................................................. 42 1.16 如何解决.xdf文件运行失败 .................................................................................. 43

1.16.1 确保已经安装补丁所有的前置条件 ............................................................. 43 1.16.2 查看adwork日志 ........................................................................................... 43 1.16.3 在MOS中使用下面条件搜索 ....................................................................... 44 1.16.4 查看数据库alert日志 ................................................................................... 44 1.16.5 如果有错误Error message is ORA-01430 ...................................................... 44 1.16.6 如果出现错误ORA-12514, TNS:listener does not currently know of service requested in connect descriptor ..................................................................................... 45 1.16.7 如果出现错误A Different index with same column name exists .................. 46 1.16.8 java设置可能会导致的其他错误 ................................................................. 46 1.16.9 手工加载.xdf文件 .......................................................................................... 46 1.17 如何解决XLIFFImporter (.xlf)文件运行失败 ......................................................... 47

1.17.1 查看adwork日志 ........................................................................................... 47 1.17.2 如果安装NLS补丁时出现错误 ..................................................................... 47 1.17.3 如果出现错误jre: No such file or directory ................................................... 49 1.17.4 运行Performance issues on all XLIFFImporter.class job时出现性能问题 .... 50 1.17.5 如果出现错误oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket ............................... 50 1.17.6 确保数据库字符集和应用字符集是同步的 ................................................. 51 1.18 如何解决XLIFFLoader (.xlf)文件运行失败 ............................................................ 51

1.18.1 如果有错误No template found with application short name ....................... 52 1.18.2 如果有错误java.io.UTFDataFormatException: Invalid UTF8 encoding .......... 54 1.18.3 如果有错误No translatable template defined for this template code .......... 56 1.18.4 如果有错误Exception in thread \java.lang.NoSuchMethodError: sun.io.ByteToCharMS936.getIndex1()[S .......................................................................... 57 1.19 如何解决File in patch is not a known Oracle Applications file .............................. 58

1.19.1 原因1：补丁找不到在file driver中引用的文件......................................... 59

手册

1.19.2 错误可能是因为缺少补丁的前置条件 ......................................................... 59 1.19.3 寻找oracle support支持 ............................................................................... 59 1.19.4 手工编辑.drv文件包含缺少的文件 .............................................................. 60 1.20 如何解决This patch is not compatible with your current codelines ..................... 60

1.20.1 确认当前安装补丁的版本是正确的 ............................................................. 60 1.20.2 确认当前ORACLE_HOME环境变量是正确的 .............................................. 61 1.20.3 由于lock导致的原因 .................................................................................... 61 1.20.4 运行adadmin/ maintain snapshot information然后重新安装补丁 ............ 61 1.20.5 极少数情况下错误会指向C codelevel.......................................................... 61 1.21 如何解决安装补丁后，java class版本和补丁readme中说的不一致 ............... 62

1.21.1 原因 ................................................................................................................. 62 1.21.2 解决步骤 ......................................................................................................... 63 1.22 如何解决安装补丁后自助界面的字体异常问题 ................................................. 63 1.23 如何确定adpatch worker的数量 ......................................................................... 64

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库10. adpatch 补丁应用指南（常见问题处理）在线全文阅读。