ORACLE EBS打补丁报告

ORACLE EBS 打补丁报告作者:创建日期:May 11, 2011最后更新:May 15, 2012控制码:1.0 版本:1.0Note: Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools-OptionsView and checking the Bookmarks option in the Show region.审批签字:Note: To add additional approval lines, press Tab from the last cell in the table above. Copy Number_Note: You can delete any elements of this cover page that you do not need for your document. For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute.文档控制修改记录3日期作者版本修改参考审阅姓名职位分发拷贝姓名地点1234Note: The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.目录文档控制iiEBS系统打补丁1Note: To update the table of contents, put the cursor anywhere in the table and press F9. To change the number of levels displayed, select the menu option InsertIndex and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.EBS系统打补丁 14EBS系统打补丁EBS系统补丁工具分类 对于EBS系统，常用的打补丁命令有：adpatch、opatch 、admrgpch Category 1: adpatch应用补丁使用adpatch打补丁 Category 2: opatch关系型数据库的补丁和应用的ORACLE_HOME(10.1.2、10.1.3)的补丁使用opatch打补丁 Category 3: admrgpch当系统需要打很多应用补丁的时候，可以选择使用合并打补丁的方式，此时使用admrgpchadpatch使用adpatch打补丁，需要先关闭应用，打开维护模式、adpatch打补丁 Step 1: 关闭应用以应用操作系统用户appltest06登录操作系统，执行stopAPP.sh Step 2: 打开维护模式以应用操作系统用户appltest06登录操作系统，使用adadmin命令打开维护模式$adadmin选择： 5. Change Maintenance Mode1. Enable Maintenance Mode Step 3: adpatch打补丁 进入补丁目录，根据README.txt提示信息，使用adpatch打补丁 Step 4: 关闭维护模式$adadmin选择： 5. Change Maintenance Mode2. Disable Maintenance Mode Step 5: 启动应用opatch对于数据库的补丁、应用ORACLE_HOME(10.1.2、10.1.3)的补丁如果是数据库补丁，需要先关闭应用、在关闭数据库，再使用opatch打补丁如果是应用ORALCE_HOME补丁，仅需要关闭应用，再使用opatch打补丁1. 设置PATH环境变量$export PATH=$ORACLE_HOME/OPatch:$PATH2. 确认opatch可用oratest06ebstest database$ which opatch/u01/TEST06/db/tech_st/11.1.0/OPatch/opatch或者appltest06ebstest 9817770$ which opatch/u01/TEST06/apps/tech_st/10.1.2/OPatch/opatch3. 进入补丁目录，根据README.txt提示信息，使用opatch打补丁4. 启动服务即可adadmin命令介绍adadmin命令appltest06ebstest $ iduid=601(appltest06) gid=601(appltest06) groups=501(appl12i),601(appltest06)appltest06ebstest $ adadmin Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications AD Administration Version 12.0.0NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation.Your default directory is /u01/TEST06/apps/apps_st/appl.Is this the correct APPL_TOP Yes ? 回车AD Administration records your AD Administration session in a text fileyou specify. Enter your AD Administration log file name or press Returnto accept the default file name shown in brackets.Filename adadmin.log : 回车* Start of AD Administration session *AD Administration version: 12.0.0AD Administration started at: Tue Feb 28 2012 17:22:02APPL_TOP is set to /u01/TEST06/apps/apps_st/applYou can be notified by email if a failure occurs.Do you wish to activate this feature No ? 回车Please enter the batchsize 1000 : 回车Please enter the name of the Oracle Applications System that thisAPPL_TOP belongs to.The Applications System name must be unique across all OracleApplications Systems at your site, must be from 1 to 30 characterslong, may only contain alphanumeric and underscore characters,and must start with a letter.Sample Applications System names are: prod, test, demo and Development_2.Applications System Name TEST06 : TEST06 *NOTE: If you do not currently have certain types of files installedin this APPL_TOP, you may not be able to perform certain tasks.Example 1: If you dont have files used for installing or upgradingthe database installed in this area, you cannot install or upgradethe database from this APPL_TOP.Example 2: If you dont have forms files installed in this area, you cannotgenerate them or run them from this APPL_TOP.Example 3: If you dont have concurrent program files installed in this area,you cannot relink concurrent programs or generate reports from this APPL_TOP.Do you currently have files used for installing or upgrading the databaseinstalled in this APPL_TOP YES ? YES *Do you currently have Java and HTML files for HTML-based functionalityinstalled in this APPL_TOP YES ? YES *Do you currently have Oracle Applications forms files installedin this APPL_TOP YES ? YES *Do you currently have concurrent program files installedin this APPL_TOP YES ? YES *Please enter the name Oracle Applications will use to identify this APPL_TOP.The APPL_TOP name you select must be unique within an Oracle ApplicationsSystem, must be from 1 to 30 characters long, may only containalphanumeric and underscore characters, and must start with a letter.Sample APPL_TOP Names are: prod_all, demo3_forms2, and forms1.APPL_TOP Name ebstest : ebstest *You are about to use or modify Oracle Applications product tablesin your ORACLE database TEST06using ORACLE executables in /u01/TEST06/apps/tech_st/10.1.2.Is this the correct database Yes ? 回车AD Administration needs the password for your SYSTEM ORACLE schemain order to determine your installation configuration.Enter the password for your SYSTEM ORACLE schema: 输入system密码，缺省密码为manager,回车The ORACLE username specified below for Application Object Libraryuniquely identifies your existing product group: APPLSYSEnter the ORACLE password of Application Object Library APPS : 输入apps密码，缺省密码为apps,回车AD Administration is verifying your username/password.The status of various features in this run of AD Administration is: Feature Active? APPLTOP Data model Flags- - - - -CHECKFILE Yes 1 1 Y N N Y N YPREREQ Yes 6 6 Y N N Y N YCONCURRENT_SESSIONS No 2 2 Y Y N Y Y NPATCH_TIMING Yes 2 2 Y N N Y N YPATCH_HIST_IN_DB Yes 6 6 Y N N Y N YSCHEMA_SWAP Yes 1 1 Y N N Y Y YJAVA_WORKER Yes 1 1 Y N N Y N YCODELEVEL Yes 1 1 Y N N Y N YIdentifier for the current session is 18760Reading product information from file.Reading language and territory information from file.Reading language information from applUS.txt .AD Administration warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/zfaprod.txt does not exist for product zfa.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.AD Administration warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/zsaprod.txt does not exist for product zsa.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.AD Administration warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/jtsprod.txt does not exist for product jts.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.Reading database to see what industry is currently installed.Reading FND_LANGUAGES to see what is currently installed.Currently, the following languages are installed:Code Language Status- - -US American English Base ZHS Simplified Chinese Install Reading language information from applZHS.txt .Your base language will be AMERICAN.Your other languages to install are: SIMPLIFIED CHINESESetting up module information.Reading database for information about the modules.Saving module information.Reading database for information about the products.Reading database for information about how products depend on each other.Reading topfile.txt .Saving product information.AD code level : B.3 AD Administration Main Menu - 1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD AdministrationEnter your choice 6 :选择要进入的选项，然后回车即可。adpatch过程介绍以p9817770_R12.ATG_PF.B_R12_LINUX.zip为例：下载上传补丁到应用服务器上，并解压应用补丁appltest06ebstest patches$ ls9817770 p9817770_R12.ATG_PF.B_R12_LINUX.zip进入补丁目录，打补丁appltest06ebstest patches$ cd 9817770appltest06ebstest 9817770$ lsad b9817770.ldt fnd marker1.txt README.html u9817770.drvalr f9817770.ldt j9817770_fnd.zip patch_metadata.xml README.txtappltest06ebstest 9817770$adpatch Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications AutoPatch Version 12.0.0NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation.Attention: AutoPatch no longer checks for unapplied pre-requisite patches.You must use OAM Patch Wizard for this feature. Alternatively, you canreview the README for pre-requisite information.Your default directory is /u01/TEST06/apps/apps_st/appl.Is this the correct APPL_TOP Yes ? 回车AutoPatch records your AutoPatch session in a text fileyou specify. Enter your AutoPatch log file name or press Returnto accept the default file name shown in brackets.Filename adpatch.log : u9817770.log 输入日志名称，建议以补丁号为日志，回车You can be notified by email if a failure occurs.Do you wish to activate this feature No ? 回车Please enter the batchsize 1000 : 回车Please enter the name of the Oracle Applications System that thisAPPL_TOP belongs to.The Applications System name must be unique across all OracleApplications Systems at your site, must be from 1 to 30 characterslong, may only contain alphanumeric and underscore characters,and must start with a letter.Sample Applications System names are: prod, test, demo and Development_2.Applications System Name TEST06 : TEST06 *NOTE: If you do not currently have certain types of files installedin this APPL_TOP, you may not be able to perform certain tasks.Example 1: If you dont have files used for installing or upgradingthe database installed in this area, you cannot install or upgradethe database from this APPL_TOP.Example 2: If you dont have forms files installed in this area, you cannotgenerate them or run them from this APPL_TOP.Example 3: If you dont have concurrent program files installed in this area,you cannot relink concurrent programs or generate reports from this APPL_TOP.Do you currently have files used for installing or upgrading the databaseinstalled in this APPL_TOP YES ? YES *Do you currently have Java and HTML files for HTML-based functionalityinstalled in this APPL_TOP YES ? YES *Do you currently have Oracle Applications forms files installedin this APPL_TOP YES ? YES *Do you currently have concurrent program files installedin this APPL_TOP YES ? YES *Please enter the name Oracle Applications will use to identify this APPL_TOP.The APPL_TOP name you select must be unique within an Oracle ApplicationsSystem, must be from 1 to 30 characters long, may only containalphanumeric and underscore characters, and must start with a letter.Sample APPL_TOP Names are: prod_all, demo3_forms2, and forms1.APPL_TOP Name ebstest : ebstest *You are about to apply a patch to the installation of Oracle Applicationsin your ORACLE database TEST06using ORACLE executables in /u01/TEST06/apps/tech_st/10.1.2.Is this the correct database Yes ? AutoPatch needs the password for your SYSTEM ORACLE schemain order to determine your installation configuration.Enter the password for your SYSTEM ORACLE schema: 输入system密码，缺省密码为manager,回车The ORACLE username specified below for Application Object Libraryuniquely identifies your existing product group: APPLSYSEnter the ORACLE password of Application Object Library APPS : 输入apps密码，缺省密码为apps,回车AutoPatch is verifying your username/password.The status of various features in this run of AutoPatch is: Feature Active? APPLTOP Data model Flags- - - - -CHECKFILE Yes 1 1 Y N N Y N YPREREQ Yes 6 6 Y N N Y N YCONCURRENT_SESSIONS No 2 2 Y Y N Y Y NPATCH_TIMING Yes 2 2 Y N N Y N YPATCH_HIST_IN_DB Yes 6 6 Y N N Y N YSCHEMA_SWAP Yes 1 1 Y N N Y Y YJAVA_WORKER Yes 1 1 Y N N Y N YCODELEVEL Yes 1 1 Y N N Y N YIdentifier for the current session is 18763Reading product information from file.Reading language and territory information from file.Reading language information from applUS.txt .AutoPatch warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/zfaprod.txt does not exist for product zfa.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.AutoPatch warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/zsaprod.txt does not exist for product zsa.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.AutoPatch warning: Product Data File /u01/TEST06/apps/apps_st/appl/admin/jtsprod.txt does not exist for product jts.This product is registered in the database but theabove file does not exist in APPL_TOP. The productwill be ignored without error.Reading database to see what industry is currently installed.Reading FND_LANGUAGES to see what is currently installed.Currently, the following languages are installed:Code Language Status- - -US American English Base ZHS Simplified Chinese Install Reading language information from applZHS.txt .Your base language will be AMERICAN.Your other languages to install are: SIMPLIFIED CHINESESetting up module information.Reading database for information about the modules.Saving module information.Reading database for information about the products.Reading database for information about how products depend on each other.Reading topfile.txt .Saving product information.AD code level : B.3Trying to obtain a lock. Attempting to instantiate the current-view snapshot. Was already instantiated. So no instantiation done this time. * S T A R T O F U P L O A D *Start date: Tue Feb 28 2012 17:53:300 left over javaupdates.txt files uploaded to DB: Tue Feb 28 2012 17:53:300 patches uploaded from the ADPSV format patch history files: Tue Feb 28 2012 17:53:30Uploading information about files copied during the previous runs .0 left over filescopied_.txt files uploaded to DB: Tue Feb 28 2012 17:53:30 * E N D O F U P L O A D *End date: Tue Feb 28 2012 17:53:30Enter the directory where your Oracle Applications patch has been unloadedThe default directory is /u01/software/patches/9817770 : 回车Please enter the name of your AutoPatch driver file : u9817770.drv输入u9817770.d