oracle ebs r12財(cái)務(wù)模塊課程打補(bǔ)丁報(bào)告

1、ORACLE EBS打補(bǔ)丁作者:創(chuàng)建日期:最后更新:控制碼: 版本:May May 1.01.011, 201115, 2012審批簽字:Copy Number文檔控制修改審閱分發(fā)拷貝地點(diǎn)1234職位日期作者版本修改參考目錄文檔控制iiEBS系統(tǒng)打補(bǔ)丁1EBS系統(tǒng)打補(bǔ)丁 EBS系統(tǒng)補(bǔ)丁工具分類對(duì)于EBS系統(tǒng)，常用的打補(bǔ)丁命令有：atch、opatch 、admrgpchCategory 1:atch應(yīng)用補(bǔ)丁使用atch打補(bǔ)丁Category 2: opatch關(guān)系型數(shù)據(jù)庫的補(bǔ)丁和應(yīng)用的ORACLE_HOME(10.1.2、10.1.3)的補(bǔ)丁使用opatch打補(bǔ)丁Category 3: adm

2、rgpch當(dāng)系統(tǒng)需要打很多應(yīng)用補(bǔ)丁的時(shí)候，可以選擇使用合并打補(bǔ)丁的方式，此時(shí)使用admrgpchatch使用atch打補(bǔ)丁，需要先關(guān)閉應(yīng)用，打開Step 1: 關(guān)閉應(yīng)用模式、atch打補(bǔ)丁以應(yīng)用操作系統(tǒng)用戶appltest06登錄操作系統(tǒng)，執(zhí)行stopAPP.shStep 2: 打開模式以應(yīng)用操作系統(tǒng)用戶appltest06登錄操作系統(tǒng)，使用adadmin命令打開$adadmin模式選擇：5.Change Maenance Mode1.Enable Maenance ModeStep 3:atch打補(bǔ)丁進(jìn)入補(bǔ)丁目錄，根據(jù)README.txt提示信息，使用atch打補(bǔ)丁Step 4: 關(guān)閉模式$

3、adadmin選擇：5.Change Maenance Mode2.Disable Maenance ModeStep 5: 啟動(dòng)應(yīng)用 opatch對(duì)于數(shù)據(jù)庫的補(bǔ)丁、應(yīng)用ORACLE_HOME(10.1.2、10.1.3)的補(bǔ)丁如果是數(shù)據(jù)庫補(bǔ)丁，需要先關(guān)閉應(yīng)用、在關(guān)閉數(shù)據(jù)庫，再使用opatch打補(bǔ)丁如果是應(yīng)用ORALCE_HOME補(bǔ)丁，僅需要關(guān)閉應(yīng)用，再使用opatch打補(bǔ)丁1.設(shè)置PATH環(huán)境變量$export PATH=$ORACLE_HOME/OPatch:$PATH確認(rèn)opatch可用oratest06ebstest database$ which opatch/u01/TEST06/

4、db/tech_st/11.1.0/OPatch/opatch或者appltest06ebstest 9817770$ which opatch/u01/TEST06/apps/tech_st/10.1.2/OPatch/opatch進(jìn)入補(bǔ)丁目錄，根據(jù)README.txt提示信息，使用opatch打補(bǔ)丁啟動(dòng)服務(wù)即可2.3.4. adadmin命令介紹adadmin命令 appltest06ebstest $ iduid=601(appltest06) gid=601(appltest06) groups=501(appl12i),601(appltest06) appltest06ebstes

5、t $ adadminCopyright (c) 2002 Oracle Corporation Redwood Shores, California, USAOracle Applications AD AdministrationVer12.0.0NOTE: You may not use this utility for custom developmentunless you have written permisfrom Oracle Corporation.Your defauirectory is /u01/TEST06/apps/apps_st/appl.Is this the

6、 correct APPL_TOP Yes ? 回車AD Administration records your AD Administration sesin a text fileyou specify. Enter your AD Administration log file name or press Return to accept the default file name shown in brackets.Filename adadmin.log : 回車* Start of AD Administration ses*AD Administration ver: 12.0.

7、0AD Administration started at: Tue Feb 28 2012 17:22:02APPL_TOP is set to /u01/TEST06/apps/apps_st/applYou can be notified byif a failure occurs.Do you wish to activate this feature No ? 回車Please enter the batchsize 1000 : 回車Please enter the name of the Oracle Applications Systemt thisAPPL_Telongs t

8、o.The Applications System name must be unique across all Oracle Applications Systems at your site, must be from 1 to 30 characters long, may only contain alphanumeric and underscore characters,and must start wiletter.Sample Applications System names are: prod, test, demo and Development_2.Applicatio

9、ns System Name TEST06 : TEST06 *NOTE: If you do not currently have certaypes of files installedhis APPL_TOP, you may not be able to perform certaasks.Example 1: If you don the database installedve files used for installing or upgrading his area, you cannot install or upgradethe database from this AP

10、PL_TOP.Example 2: If you donve forms files installedhis area, you cannotgenerate them or run them from this APPL_TOP.Example 3: If you donve concurrent program files installedhis area,you cannot relink concurrent programsenerate reports from this APPL_TOP.Do you currently have files used for install

11、ing or upgrading the databaseinstalledhis APPL_TOP YES ? YES *Do you currently have Java and HTML files for HTML-based functionalityinstalledhis APPL_TOP YES ? YES *Do you currently have Oracle Applications forms files installed his APPL_TOP YES ? YES *Do you currently have concurrent program files

12、installed his 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 Applications System, must be from 1 to 30 characters long, may only containalphanumeric and underscore characters, and must star

13、t wiletter.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 tables in your ORACLE database TEST06using ORACLE executables in /u01/TEST06/apps/tech_st/10.1.2.Is this the correct database Yes ? 回車A

14、D Administration needs the password for your SYSTEM ORACLE schema in order to determine your installation configuration.Enter the password for your SYSTEM ORACLE schema:輸入system為manager,回車，缺省The ORACLE username specified below for Application Object Library uniquely identifies your existing product

15、group: APPLSYSEnter the ORACLE password of Application Object Library APPS :輸入 apps 密碼，缺省為 apps,回車AD Administration is verifying your username/password.The sus of various featureshis run of AD Administration is: Data mFeatureActive?FlagsCHECKFILE N Y N Y PREREQN Y N Y CONCURRENT_SES Y Y N Y Y N PATC

16、H_TIMINGN N Y N Y PATCH_HIST_IN_DB N N Y N Y SCHEMA_SWAPN N Y Y Y JAVA_WORKER N N Y N YYes11Y NYes66Y NSNo22Yes22YYes66YYes11YYes11YCEVELYes11YN N Y N YIdentifier for the current sesis 18760Reading product information from file.Reading language and territory information from file.Reading language in

17、formation 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 registeredhe database but theabove file does not exist in APPL_TOP. The product will be ignored without error.AD Administration warning

18、:Product Data File/u01/TEST06/apps/apps_st/appl/admin/zsaprod.txt does not exist for product zsa.This product is registeredhe database but theabove file does not exist in APPL_TOP. The product will be ignored without error.AD Administration warning:Product Data File/u01/TEST06/apps/apps_st/appl/admi

19、n/jtsprod.txt does not exist for product jts.This product is registeredhe database but theabove file does not exist in APPL_TOP. The product will be ignored without error.Reading database to see what industry is currently installed.Reading FND_LANGUAGES to see what is currently installed. Currently,

20、 the following languages are installed:CodeLanguageSusUS ZHSAmerican English Simplified ChiBase InstallReading language information from applZHS.txt .Your base language will be AMERICAN.Your other languages to install are: SIMPLIFIED CHISetting up module information.Reading database for information

21、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 cevel : B.3AD Administration Maenu1.Generate Applications Files2.Maain Applica

22、tions Files3.Compile/Reload Applications Database Entities4.Maain Applications Database Entities5.Change Maenance Mode6.Exit AD AdministrationEnter your choice 6 :選擇要進(jìn)入的選項(xiàng)，然后回車即可。atch過程介紹 以p9817770_R12.ATG_PF.B_R12_LINUX.zip為例：上傳補(bǔ)丁到應(yīng)用服務(wù)器上，并解壓應(yīng)用補(bǔ)丁appltest06ebstest patches$ ls9817770 p9817770_R12.ATG_

23、PF.B_R12_LINUX.zip進(jìn)入補(bǔ)丁目錄，打補(bǔ)丁appltest06ebstest patches$ cd 9817770 appltest06ebstest 9817770$ lsadb9817770.ldtfndmarker1.txtREADME.htmlu9817770.drvalrf9817770.ldtj9817770_fnd.zip patch_metadata.xml README.txtappltest06ebstest 9817770$atchCopyright (c) 2002 Oracle Corporation Redwood Shores, Californi

24、a, USAOracle Applications AutoPatchVer12.0.0NOTE: You may not use this utility for custom developmentunless you have written permisfrom Oracle Corporation.Attention: AutoPatch no longer checks for unappd pre-requisite patches. You must use OAM Patch Wizard for this feature. Alternatively, you can re

25、view the README for pre-requisite information.Your defauirectory is /u01/TEST06/apps/apps_st/appl.Is this the correct APPL_TOP Yes ? 回車AutoPatch records your AutoPatch sesin a text fileyou specify. Enter your AutoPatch log file name or press Return to accept the default file name shown in brackets.F

26、ilename 回車atch.log : u9817770.log輸入日志名稱，建議以補(bǔ)丁號(hào)為日志，You can be notified byif a failure occurs.Do you wish to activate this feature No ? 回車Please enter the batchsize 1000 : 回車Please enter the name of the Oracle Applications Systemt thisAPPL_Telongs to.The Applications System name must be unique across

27、all Oracle Applications Systems at your site, must be from 1 to 30 characters long, may only contain alphanumeric and underscore characters,and must start wiletter.Sample Applications System names are: prod, test, demo and Development_2.Applications System Name TEST06 : TEST06 *NOTE: If you do not c

28、urrently have certaypes of files installedhis APPL_TOP, you may not be able to perform certaasks.Example 1: If you don the database installedve files used for installing or upgrading his area, you cannot install or upgradethe database from this APPL_TOP.Example 2: If you donve forms files installedh

29、is area, you cannotgenerate them or run them from this APPL_TOP.Example 3: If you donve concurrent program files installedhis area,you cannot relink concurrent programsenerate reports from this APPL_TOP.Do you currently have files used for installing or upgrading the databaseinstalledhis APPL_TOP YE

30、S ? YES *Do you currently have Java and HTML files for HTML-based functionalityinstalledhis APPL_TOP YES ? YES *Do you currently have Oracle Applications forms files installed his APPL_TOP YES ? YES *Do you currently have concurrent program files installed his APPL_TOP YES ? YES *Please enter the na

31、me Oracle Applications will use to identify this APPL_TOP.The APPL_TOP name you select must be unique within an Oracle Applications System, must be from 1 to 30 characters long, may only containalphanumeric and underscore characters, and must start wiletter.Sample APPL_TOP Names are: prod_all, demo3

32、_forms2, and forms1.APPL_TOP Name ebstest : ebstest *You are about to apply a patch to the installation of Oracle Applications in 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 ORAC

33、LE schema in order to determine your installation configuration.Enter the password for your SYSTEM ORACLE schema:輸入system為manager,回車，缺省The ORACLE username specified below for Application Object Library uniquely identifies your existing product group: APPLSYSEnter the ORACLE password of Application O

34、bject Library APPS :輸入 apps 密碼，缺省為 apps,回車AutoPatch is verifying your username/password.The sus of various featureshis run of AutoPatch is: Data mFeatureActive?FlagsCHECKFILE N Y N Y PREREQN Y N Y CONCURRENT_SES Y Y N Y Y NYes11Y NYes66Y NSNo22PATCH_TIMING N N Y N YPATCH_HIST_IN_DB N N Y N Y SCHEMA_

35、SWAPN N Y Y Y JAVA_WORKER N N Y N YYes22YYes66YYes11YYes11YCEVELYes11YN N Y N YIdentifier for the current sesis 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

36、/apps/apps_st/appl/admin/zfaprod.txt does not exist for product zfa.This product is registeredhe database but theabove file does not exist in APPL_TOP. The product will be ignored without error.AutoPatch warning:Product Data File/u01/TEST06/apps/apps_st/appl/admin/zsaprod.txt does not exist for prod

37、uct zsa.This product is registeredhe database but theabove file does not exist in APPL_TOP. The product will 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 registeredhe database but theabove f

38、ile does not exist in APPL_TOP. The product will 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:CodeLanguageSusUSAmerican EnglishBaseZHSSimplified ChiInst

39、allReading language information from applZHS.txt .Your base language will be AMERICAN.Your other languages to install are: SIMPLIFIED CHISetting up module information.Reading database for information about the modules. Saving module information.Reading database for information about the products.Rea

40、ding database for information about how products depend on each other. Reading topfile.txt .Saving product information.AD cevel : 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 TO FU P L O A D *Sta

41、rt 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 17:53:30SV format patch history files: Tue Feb 28 2012Uploading information about files copied during the previous runs .0 left over filescopied_.txt files uploaded

42、to DB: Tue Feb 28 2012* E N DO FU P L O A D *End date: Tue Feb 28 2012 17:53:30Enter the directory where your Oracle Applications patch has been unloadedThe defauirectory is /u01/software/patches/9817770 : 回車Please enter the name of your AutoPatch driver file : u9817770.drv輸入 u9817770.drv,回車.省略補(bǔ)丁過程A

43、utoPatch is complete.AutoPatay have written informational messages to the file/u01/TEST06/apps/apps_st/appl/admEST06/log/u9817770.lgiErrors and warnings are listedhe log file/u01/TEST06/apps/apps_st/appl/admEST06/log/u9817770.logand in other log fileshe same directory.當(dāng)顯示” AutoPatch is complete”時(shí)，說明

44、補(bǔ)丁已經(jīng)成功。 adctrl命令介紹adctrl命令appltest06ebstest $ adctrlCopyright (c) 2002 Oracle Corporation Redwood Shores, California, USAAD ControllerVer12.0.0NOTE: You may not use this utility for custom developmentunless you have written permisfrom Oracle Corporation.Your defauirectory is /u01/TEST06/apps/apps_st

45、/appl.Is this the correct APPL_TOP Yes ? 回車AD Controller records your AD Controller sesin a text fileyou specify. Enter your AD Controller log file name or press Return to accept the default file name shown in brackets.Filename adctrl.log : 回車* Start of AD Controller ses*AD Controller ver: 12.0.0AD Controller started at: Wed Feb 29 2012 18:16:09APPL_TOP is set to /u01/TEST06/apps/apps_st/applReading product information from file.Reading lan