R12数据库打补丁文档.docVIP

R12数据库打补丁文档 停止应用服务 检查appldev的进程是否都已经停止 停止数据库监听 停止数据库 修改数据库配置文件，initDEV.ora，最后加_disable_fast_validate=TRUE和event=31151 trace name context forever, level 0x100 启动数据库和监听 上传补丁9239089到tmp，解压缩unzip –d /tmp/patch 补丁，修改补丁目录权限 Adadmin进入维护模式 根据9239089 readme，oradev创建目录$ORACLE_HOME/appsutil/admin oradev将/tmp/patch/9239089/admin/adgrants.sql拷贝到新目录 Oradev登录sqlplus执行@$ORACLE_HOME/appsutil/admin/adgrants.sql apps 进入补丁目录，Adpatch 打补丁9239089 使用adadmin Compile/Reload Applications Database Entities menu Compile APPS schema编译，Run Invoker Rights processing in incremental mode [No] 上传补丁到/opt/app/patch p9239090_R12_SOLARIS64_1of6.zip p9239090_R12_SOLARIS64_2of6.zip p9239090_R12_SOLARIS64_3of6.zip p9239090_R12_SOLARIS64_4of6.zip p9239090_R12_SOLARIS64_5of6.zip p9239090_R12_SOLARIS64_6of6.zip p9239090_R12_zhs.zip alter tablespace APPS_TS_TX_DATA add datafile /opt/app/dev/db/apps_st/data/a_txn_data05.dbf size 2000M autoextend on maxsize 2000M，防止打补丁时报错表空间不够 打补丁过程中重启worker使用adctrl工具 解压补丁文件，unzip –d /opt/app/patch 压缩文件名 Adpatch,使用10个worker 装英文版后立即装中文版 英文版安装30小时 中文版30worker，1小时 然后安装ONLINE HELP补丁  HYPERLINK mhtml:file://D:\\R12\\安装、补丁\\Oracle%20E-Business%20Suite%20Release%2012.1.3%20Readme%20%5bID%201080973.1%5d.mht!/CSP/ui/flash.html \l tab=PatchHomePage(page=PatchHomePageid=gj46o799()),(page=PatchSearchResultsHomeid=gj46pr1y(search=%3CSearch%3E%0A%20%20%3CFilter%20name=%22patch_number%22%20op=%22IS%22%20value=%229239095%22%20type=%22patch_number%22/%3E%0A%20%20%3CFilter%20name=%22plat \t _blank Patch 9239095 之后安装  HYPERLINK mhtml:file://D:\\R12\\安装、补丁\\Oracle%20E-Business%20Suite%20Release%2012.1.3%20Readme%20%5bID%201080973.1%5d.mht!/CSP/ui/flash.html \l tab=PatchHomePage(page=PatchHomePageid=gj46o799()),(page=PatchSearchResultsHomeid=gj46pr1y(search=%3CSearch%3E%0A%20%20%3CFilter%20name=%22patch_number%22%20op=%22IS%22%20value=%229817770%22%20type=%22patch_number%22/%3E%0A%20%20%3CFilter%20name=%22plat \t _blank Patch 9817770和 HYPERLINK mhtml:file://D:\\R12\\安装、补丁\\Orac