http://www.2cto.com/os/201402/279033.html

Contents

Document Control................................................................................................................................ii

总体说明...................................................................................................................................................1

文档目的...........................................................................................................................................1

内容....................................................................................................................................................1

(一)打Patch之前准备.......................................................................................................................2

(二)打patch步骤................................................................................................................................4

(三)打patch步骤实例.......................................................................................................................5

(七)参考文档....................................................................................................................................28

Open and ClosedIssues for this Deliverable..............................................................................29

Open Issues...................................................................................................................................29

Closed Issues................................................................................................................................29

 

 

体说明

 

文档目的

本文档针对EBS环境迁打patch步骤做了详细记录可供打patch参考

需要更多迁移技巧和方法的学习可以参考Oralce的官方文档

 

内容

打patch步骤说明及详细记录

参考文档

 

(一)打Patch之前准备

1.1 确认系统使用版本

1.用SQL获取

SELECT app.application_short_name, app.application_name,pi.patch_level
FROM fnd_product_installations pi,fnd_application_vl app
WHERE app.application_id =pi.application_id

2.系统:HELP/About

\

1.2 确认系统中是否已经打过此Patch

SELECT * FROMad_bugs t WHERE t.bug_number = "Patch编号'

 

1.3 到metalink上下载patch

    1. 比对系统已安装模块版本与Patch版本,下载对应版本的Patch文件。注意:有的Patch是中英文的,需要将两个文件全部下载。

      1.4查看下载到的patch包里的 REANME

      1.看有没有前置Patch,如果没有前置Patch,可以按照下面步骤安装;如果存在前置Patch,需要按照本文档所有步骤先安装所有涉及的前置步骤,然后安装当前Patch。

      (二)打patch步骤

      1. 本地解压Patch安装包,上传到服务器patch文件夹里(没有可以新建)

      2. 用系统应用用户登陆 Linux(是系统应用用户,不是数据库用户);

      3. 停系统应用;

      4. 用adadmin启用系统维护模式;

      5. 用adpatch安装Patch,先安装英文Patch,(如果有中文patch)后安装简体中文Patch;

      6. 用SQL查询Patch是否已经安装进去

      7. 用adadmin停用系统维护模式;

      8. 重启系统应用;

      9. 登陆,查看Form能否正常打开,问题是否解决;

         

        (三)打patch步骤实例

        说明:红色底色的为说明;黄色底色的为需要输入的命令;绿色底色的为注释

        未加底色的为程序运行输出。

        一).步骤概览

        一.解压上传patch

        1.略

         

        二.停应用

        1. 切换目录 cd $ADMIN_SCRIPTS_HOME

        2. 停应用 adstpall.shapps/[apps password]

           

          三.启用维护模式

          1.运行adadmin

          2.Your default directory is'/u01/test/apps/apps_st/appl'.

          Is this the correct APPL_TOP[Yes] ?Yes

          3.Filename [adadmin.log] :patch10036698.log

          4.You can be notified by email if a failure occurs.

          Do you wish to activate thisfeature [No] ?No

          5.Please enter the batchsize [1000] :1000

          6.You are about to use or modify Oracle Applications product tables

          in your ORACLE database 'TEST'

          using ORACLE executables in'/u01/test/apps/tech_st/10.1.2'.

          Is this the correct database[Yes] ?Yes

          7.Enter the password for your 'SYSTEM' ORACLE schema:manager

          8.Enter the ORACLE password of Application Object Library [APPS] :apps

          9.在出现的选项中选择选择:5. Change Maintenance Mode

          10.继续选择:1. Enable Maintenance Mode

          11.之后所有选择直接回车退出

           

          四.安装Patch

          1.运行 adpatch

          2.Your default directory is'/u01/dev/apps/apps_st/appl'.

          Is this the correct APPL_TOP[Yes] ?Yes

          3.Filename [adpatch.log] : patch10036698.log

          You can be notified by emailif a failure occurs.

          4.Do you wish to activate this feature [No] ?No

          5.Please enter the batchsize [1000] : 1000

          6.You are about to apply a patch to the installation of OracleApplications

          in your ORACLE database 'DEV'

          using ORACLE executables in'/u01/dev/apps/tech_st/10.1.2'.

           

          Is this the correct database[Yes] ?Yes

          7.AutoPatch needs the password for your 'SYSTEM' ORACLE schema

          in order to determine yourinstallation configuration.

           

          Enter the password for your'SYSTEM' ORACLE schema: manager

          8.Enter the ORACLE password of Application Object Library [APPS] :apps

          9.Enter thedirectory where your Oracle Applications patch has been unloaded

           

          The default directory is[/home/applprod/patch/9287896] :/home/applprod/patch/9287896

          10.Pleaseenter the name of your AutoPatch driver file :u9287896.drv

          以下的可能会没有直接跳过

          11.Do you wish to apply this patch now [No] ?Yes

          12.Enter the number of parallel workers [32] :16

           

          英文Patch安装完成后,如果有中文Patch,需要继续安装中文patch,转到中文patch的目录,$cd /home/applprod/patch/9287896_ZHS,具体步骤与英文Patch相同。

           

          五.关闭维护模式

          同启用维护模式。在10中选择 2. Disable Maintenance Mode

           

          1. 重启应用

            1. 切换目录 cd $ADMIN_SCRIPTS_HOME

            2.启应用 adstrtal.shapps/[apps password]

             

            二).过程详解

             

            3.1 Patch包解压,上传

            解压

            \

            上传<喎�"http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KCjxwPjxpbWcgc3JjPQ=="http://www.2cto.com/uploadfile/Collfiles/20140218/201402180911174.jpg" alt="\">

            2.2停应用

            (1)切换到目录$ADMIN_SCRIPTS_HOME

            (2)运行停应用脚本adstpall.sh apps/[apps password]

            Last login: Fri Jan24 17:52:58 2014 from 10.8.21.100

            • 切换目录

              [appluat@ebsapp ~]$ cd $ADMIN_SCRIPTS_HOME

            • 停应用

              [appluat@ebsappscripts]$ adstpall.shapps/apps

              Youare running adstpall.sh version 120.10.12010000.4

              Thelogfile for this session is located at/u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adstpall.log

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/jtffmctl.shstop

              scriptreturned:

              ****************************************************

              Youare running jtffmctl.sh version 120.3

              Shuttingdown Fulfillment Server for UAT on port 9301 ...

              jtffmctl.sh:exiting with status 0

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adcmctl.shstop

              scriptreturned:

              ****************************************************

              Youare running adcmctl.sh version 120.17.12010000.5

              Shuttingdown concurrent managers for UAT ...

              ORACLEPassword:

              Submittedrequest 616685 for CONCURRENT FND SHUTDOWN

              adcmctl.sh:exiting with status 0

              adcmctl.sh:check the logfile /u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adcmctl.txtfor more information ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adoafmctl.shstop

              scriptreturned:

              ****************************************************

              Youare running adoafmctl.sh version 120.8

              StoppingOPMN managed OAFM OC4J instance ...

              adoafmctl.sh:exiting with status 0

              adoafmctl.sh:check the logfile /u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adoafmctl.txtfor more information ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adformsctl.shstop

              scriptreturned:

              ****************************************************

              Youare running adformsctl.sh version120.16.12010000.3

              StoppingOPMN managed FORMS OC4J instance ...

              adformsctl.sh:exiting with status 0

              adformsctl.sh:check the logfile /u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adformsctl.txtfor more information ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adoacorectl.shstop

              scriptreturned:

              ****************************************************

              Youare running adoacorectl.sh version 120.13

              StoppingOPMN managed OACORE OC4J instance ...

              adoacorectl.sh:exiting with status 0

              adoacorectl.sh:check the logfile /u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adoacorectl.txtfor more information ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adapcctl.shstop

              scriptreturned:

              ****************************************************

              Youare running adapcctl.sh version 120.7.12010000.2

              StoppingOPMN managed Oracle HTTP Server (OHS) instance ...

              opmnctl:stopping opmn managed processes...

              adapcctl.sh:exiting with status 0

              adapcctl.sh:check the logfile/u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adapcctl.txt for moreinformation ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adalnctl.shstop

              scriptreturned:

              ****************************************************

              adalnctl.shversion 120.3

              Shuttingdown listener process APPS_UAT.

              adalnctl.sh:exiting with status 0

              adalnctl.sh:check the logfile /u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adalnctl.txtfor more information ...

              .endstd out.

              .enderr out.

              ****************************************************

              Executingservice control script:

              /u01/UAT/inst/apps/UAT_ebsapp/admin/scripts/adopmnctl.shstop

              scriptreturned:

              ****************************************************

              Youare running adopmnctl.sh version 120.6.12010000.5

              StoppingOracle Process Manager (OPMN) and themanaged processes ...

              opmnctl:stopping opmn and all managed processes...

              adopmnctl.sh:exiting with status 0

              adopmnctl.sh:check the logfile/u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adopmnctl.txt for moreinformation ...

              .endstd out.

              .enderr out.

              ****************************************************

              Allenabled services on this node are stopped.

              adstpall.sh:Exitingwith status 0

              adstpall.sh:check the logfile/u01/UAT/inst/apps/UAT_ebsapp/logs/appl/admin/log/adstpall.log for moreinformation ...

              [appluat@ebsappscripts]$

               

               

              3.2 启用维护模式

              Last login: Sat Feb 15 10:58:03 2014 from 10.8.21.81

              • 启用维护模式

                [appluat@ebsapp ~]$ adadmin

                Copyright(c) 2002 Oracle Corporation

                Redwood Shores, California, USA

                OracleApplications AD Administration

                Version 12.0.0

                NOTE: You may not use this utility for custom development

                unless you have writtenpermission from Oracle Corporation.

                Your default directory is "/u01/UAT/apps/apps_st/appl'.

              • 确认目录

                Is this the correct APPL_TOP [Yes] ? YES

                AD Administration records your AD Administration session in a textfile

                you specify. Enter your ADAdministration log file name or press [Return]

                to accept the default file name shown in brackets.

              • 输入生成的日志文件名

                Filename [adadmin.log] : patch10036698001.log

                ************* Start of AD Administration session *************

                AD Administration version: 12.0.0

                AD Administration started at: Sat Feb 15 2014 11:00:22

                APPL_TOP is set to /u01/UAT/apps/apps_st/appl

                You can be notified by email if a failure occurs.

              • 确认激活操作

                Do you wish to activate this feature [No] ? NO

              • 输入批大小

                Please enter the batchsize [1000] : 1000

                Please enter the name of the Oracle Applications System that this

                APPL_TOP belongs to.

                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 with a letter.

                Sample Applications System names are: "prod","test", "demo" and

                "Development_2".

                Applications System Name [UAT] : UAT *

                NOTE: If you do not currently have certain types of files installed

                in this APPL_TOP, you may not be able to perform certain tasks.

                Example 1: If you don't have files used for installing or upgrading

                the database installed in this area, you cannot install or upgrade

                the database from this APPL_TOP.

                Example 2: If you don't have forms files installed in this area, youcannot

                generate them or run them from this APPL_TOP.

                Example 3: If you don't have concurrent program files installed inthis area,

                you cannot relink concurrent programs or generate reports from thisAPPL_TOP.

                Do you currently have files used for installing or upgrading thedatabase

                installed in this APPL_TOP [YES] ? YES *

                Do you currently have Java and HTML files for HTML-basedfunctionality

                installed in this APPL_TOP [YES] ? YES *

                Do you currently have Oracle Applications forms files installed

                in this APPL_TOP [YES] ? YES *

                Do you currently have concurrent program files installed

                in this APPL_TOP [YES] ? YES *

                Please enter the name Oracle Applications will use to identify thisAPPL_TOP.

                The APPL_TOP name you select must be unique within an OracleApplications

                System, must be from 1 to 30 characters long, may only contain

                alphanumeric and underscore characters, and must start with aletter.

                Sample APPL_TOP Names are: "prod_all","demo3_forms2", and "forms1".

                APPL_TOP Name [ebsapp] : ebsapp *

                You are about to use or modify Oracle Applications product tables

                in your ORACLE database 'UAT'

                using ORACLE executables in '/u01/UAT/apps/tech_st/10.1.2'.

              • 确认数据库路径

                Is this the correct database [Yes] ? YES

                AD Administration needs the password for your 'SYSTEM' ORACLE schema

                in order to determine your installation configuration.

              • 输入system用户密码

                Enter the password for your 'SYSTEM' ORACLE schema: manager

                The ORACLE username specified below for Application Object Library

                uniquely identifies your existing product group: APPLSYS

              • 输入apps用户密码

                Enter the ORACLE password of Application Object Library [APPS]: apps

                 

                AD Administration is verifying your username/password....Unable toconnect.

                 

                AD Administration error:

                The following ORACLE error:

                 

                ORA-01017: invalid username/password; logon denied

                 

                 

                occurred while executing the SQL statement:

                 

                CONNECT APPLSYS/*****

                 

                Error: The given ORACLE password is not the correct password.

                Please re-enter the ORACLE username and password.

                 

                Enter the ORACLE password of Application Object Library [APPS]:

                 

                AD Administration is verifying your username/password.

                The status of various features in this run of AD Administration is:

                 

                <-Featureversion in->

                Feature Active? APPLTOP Data model Flags

                ------------------------------ ------- -------- ----------- -----------

                CHECKFILE Yes 1 1 Y N N Y N Y

                PREREQ Yes 6 6 Y N N Y N Y

                CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N

                PATCH_TIMING Yes 2 2 Y N N Y N Y

                PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y

                SCHEMA_SWAP Yes 1 1 Y N N Y Y Y

                JAVA_WORKER Yes 1 1 Y N N Y N Y

                CODELEVEL Yes 1 1 Y N N Y N Y

                 

                 

                 

                Identifier for the current session is 36769

                 

                Reading product information from file...

                 

                Reading language and territory information from file...

                 

                Reading language information from applUS.txt ...

                 

                AD Administration warning:

                Product Data File

                /u01/UAT/apps/apps_st/appl/admin/zfaprod.txt

                does not exist for product"zfa".

                This product is registered in the database but the

                above file does not exist in APPL_TOP. The product

                will be ignored without error.

                 

                 

                AD Administration warning:

                Product Data File

                /u01/UAT/apps/apps_st/appl/admin/zsaprod.txt

                does not exist for product"zsa".

                This product is registered in the database but the

                above file does not exist in APPL_TOP. The product

                will be ignored without error.

                 

                 

                AD Administration warning:

                Product Data File

                /u01/UAT/apps/apps_st/appl/admin/jtsprod.txt

                does not exist for product"jts".

                This product is registered in the database but the

                above 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, 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 CHINESE

                 

                Setting 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 eachother.

                Reading topfile.txt ...

                 

                Saving product information.

                 

                AD code level : [B.3]

                 

                AD AdministrationMain Menu

                --------------------------------------------------

                 

                1. Generate Applications Files menu

                 

                2. Maintain Applications Files menu

                 

                3. Compile/Reload Applications DatabaseEntities menu

                 

                4. Maintain Applications Database Entitiesmenu

                 

                5. Change Maintenance Mode

                 

                6. Exit AD Administration

                 

              • 选择更改模式

                Enter your choice [6] : 5

                 

                ChangeMaintenance Mode

                ----------------------------------------

                 

                Maintenance Mode is currently: [Disabled].

                 

                Maintenance mode should normally be enabled when patching

                Oracle Applications and disabled when users are logged on

                to the system. See the OracleApplications Maintenance

                Utilities manual for more information about maintenance mode.

                 

                Please select an option:

                 

                1. Enable Maintenance Mode

                 

                2. Disable Maintenance Mode

                 

                1. Return to Main Menu

                  • 选择启用维护模式

                     

                    Enter your choice [3] : 1

                     

                    sqlplus -s &un_apps/*****@/u01/UAT/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

                     

                    Successfully enabled Maintenance Mode.

                  • 返回

                    Review the messages above, then press [Return] to continue.”回车”

                     

                     

                    Backing up restart files, if any......Done.

                     

                    ChangeMaintenance Mode

                    ----------------------------------------

                     

                    Maintenance Mode is currently: [Enabled].

                     

                     

                    Maintenance mode should normally be enabled when patching

                    Oracle Applications and disabled when users are logged on

                    to the system. See the OracleApplications Maintenance

                    Utilities manual for more information about maintenance mode.

                     

                     

                    Please select an option:

                     

                    1. Enable Maintenance Mode

                     

                    2. Disable Maintenance Mode

                     

                    3. Return to Main Menu

                     

                     

                  • 返回

                    Enter your choice [3] : ”回车”

                     

                    AD AdministrationMain Menu

                    --------------------------------------------------

                     

                    1. Generate Applications Files menu

                     

                    2. Maintain Applications Files menu

                     

                    3. Compile/Reload Applications DatabaseEntities menu

                     

                    4. Maintain Applications Database Entitiesmenu

                     

                    5. Change Maintenance Mode

                     

                    6. Exit AD Administration

                  • 退出

                    Enter your choice [6] : “回车”

                     

                    Backing up restart files, if any......Done.

                     

                    There is no timing information available for the current session.

                     

                    AD Administration is complete.

                     

                    Errors and warnings are listed in the log file

                    /u01/UAT/apps/apps_st/appl/admin/UAT/log/patch10036698001.log

                     

                    and in other log files in the same directory.

                     

                    [appluat@ebsapp ~]$

                    3.3安装Patch

                     

                    Last login: Sat Feb 15 10:59:402014 from 10.8.21.81

                    • 切换到patch文件夹目录

                      [appluat@ebsapp ~]$cd /u01/UAT/patch/10036698

                    • 安装patch

                      [appluat@ebsapp 10036698]$adpatch

                       

                      Copyright (c) 2002 OracleCorporation

                      Redwood Shores,California, USA

                       

                      Oracle ApplicationsAutoPatch

                       

                      Version 12.0.0

                       

                      NOTE: You may not use thisutility for custom development

                      unless you have written permission fromOracle Corporation.

                       

                       

                      Attention: AutoPatch no longerchecks for unapplied pre-requisite patches.

                      You must use OAM Patch Wizardfor this feature. Alternatively, you can

                      review the README forpre-requisite information.

                       

                       

                      Your default directory is'/u01/UAT/apps/apps_st/appl'.

                    • 确认路径

                      Is this the correct APPL_TOP[Yes] ?YES

                       

                      AutoPatch records yourAutoPatch session in a text file

                      you specify. Enter your AutoPatch log file name or press[Return]

                      to accept the default file nameshown in brackets.

                    • 输入一个日志名字

                      Filename [adpatch.log] :10036698002.log

                       

                      You can be notified by email ifa failure occurs.

                    • 是否激活

                      Do you wish to activate thisfeature [No] ?NO

                    • 批大小

                      Please enter the batchsize[1000] :1000

                       

                       

                      Please enter the name of theOracle Applications System that this

                      APPL_TOP belongs to.

                       

                      The Applications System namemust be unique across all Oracle

                      Applications Systems at yoursite, must be from 1 to 30 characters

                      long, may only containalphanumeric and underscore characters,

                      and must start with a letter.

                       

                      Sample Applications Systemnames are: "prod", "test", "demo" and

                      "Development_2".

                       

                      Applications System Name [UAT]: UAT *

                       

                       

                      NOTE: If you do not currentlyhave certain types of files installed

                      in this APPL_TOP, you may notbe able to perform certain tasks.

                       

                      Example 1: If you don't havefiles used for installing or upgrading

                      the database installed in thisarea, you cannot install or upgrade

                      the database from thisAPPL_TOP.

                       

                      Example 2: If you don't haveforms files installed in this area, you cannot

                      generate them or run them fromthis APPL_TOP.

                       

                      Example 3: If you don't haveconcurrent program files installed in this area,

                      you cannot relink concurrentprograms or generate reports from this APPL_TOP.

                       

                       

                      Do you currently have filesused for installing or upgrading the database

                      installed in this APPL_TOP[YES] ? YES *

                       

                       

                      Do you currently have Java andHTML files for HTML-based functionality

                      installed in this APPL_TOP[YES] ? YES *

                       

                       

                      Do you currently have OracleApplications forms files installed

                      in this APPL_TOP [YES] ? YES *

                       

                       

                      Do you currently have concurrentprogram files installed

                      in this APPL_TOP [YES] ? YES *

                       

                       

                      Please enter the name OracleApplications will use to identify this APPL_TOP.

                       

                      The APPL_TOP name you selectmust be unique within an Oracle Applications

                      System, must be from 1 to 30characters long, may only contain

                      alphanumeric and underscorecharacters, and must start with a letter.

                       

                      Sample APPL_TOP Names are:"prod_all", "demo3_forms2", and "forms1".

                       

                      APPL_TOP Name [ebsapp] : ebsapp*

                       

                       

                       

                      You are about to apply a patchto the installation of Oracle Applications

                      in your ORACLE database 'UAT'

                      using ORACLE executables in'/u01/UAT/apps/tech_st/10.1.2'.

                    • 确认数据库

                      Is this the correct database[Yes] ?YES

                       

                      AutoPatch needs the passwordfor your 'SYSTEM' ORACLE schema

                      in order to determine yourinstallation configuration.

                    • 输入system用户密码

                      Enter the password for your'SYSTEM' ORACLE schema: manager

                       

                       

                      The ORACLE username specifiedbelow for Application Object Library

                      uniquely identifies yourexisting product group: APPLSYS

                    • 输入apps用户密码

                      Enter the ORACLE password ofApplication Object Library [APPS] : apps

                       

                      AutoPatch is verifying yourusername/password.

                      The status of various featuresin this run of AutoPatch is:

                       

                      <-Feature version in->

                      Feature Active? APPLTOP Data model Flags

                      ------------------------------ ------- -------- ----------- -----------

                      CHECKFILE Yes 1 1 Y N N Y N Y

                      PREREQ Yes 6 6 Y N N Y N Y

                      CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N

                      PATCH_TIMING Yes 2 2 Y N N Y N Y

                      PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y

                      SCHEMA_SWAP Yes 1 1 Y N N Y Y Y

                      JAVA_WORKER Yes 1 1 Y N N Y N Y

                      CODELEVEL Yes 1 1 Y N N Y N Y

                       

                       

                       

                      Identifier for the currentsession is 36770

                       

                      Reading product informationfrom file...

                       

                      Reading language and territory informationfrom file...

                       

                      Reading language informationfrom applUS.txt ...

                       

                      AutoPatch warning:

                      Product Data File

                      /u01/UAT/apps/apps_st/appl/admin/zfaprod.txt

                      does not exist for product "zfa".

                      This product is registered inthe database but the

                      above file does not exist inAPPL_TOP. The product

                      will be ignored without error.

                       

                       

                      AutoPatch warning:

                      Product Data File

                      /u01/UAT/apps/apps_st/appl/admin/zsaprod.txt

                      does not exist for product "zsa".

                      This product is registered inthe database but the

                      above file does not exist inAPPL_TOP. The product

                      will be ignored without error.

                       

                       

                      AutoPatch warning:

                      Product Data File

                      /u01/UAT/apps/apps_st/appl/admin/jtsprod.txt

                      does not exist for product "jts".

                      This product is registered inthe database but the

                      above file does not exist inAPPL_TOP. The product

                      will be ignored without error.

                       

                       

                      Reading database to see whatindustry is currently installed.

                       

                      Reading FND_LANGUAGES to seewhat is currently installed.

                      Currently, the followinglanguages are installed:

                       

                      Code Language Status

                      ---- ------------------------------------------------

                      US American English Base

                      ZHS Simplified Chinese Install

                       

                      Reading language informationfrom applZHS.txt ...

                       

                      Your base language will beAMERICAN.

                       

                      Your other languages to installare: SIMPLIFIED CHINESE

                       

                      Setting up module information.

                      Reading database forinformation about the modules.

                      Saving module information.

                      Reading database forinformation about the products.

                      Reading database forinformation about how products depend on each other.

                      Reading topfile.txt ...

                       

                      Saving product information.

                       

                      AD code level : [B.3]

                       

                       

                       

                      Trying to obtain a lock...

                       

                       

                      Attempting to instantiate the current-viewsnapshot...

                       

                      Was already instantiated. So no instantiationdone this time.

                       

                       

                      **************** S T A R T O F U P L O A D ****************

                       

                      Start date: Sat Feb 15 201411:02:52

                       

                       

                       

                      0 "left over"javaupdates.txt files uploaded to DB: Sat Feb 15 2014 11:02:52

                       

                      0 patches uploaded from theADPSV format patch history files: Sat Feb 15 2014 11:02:52

                       

                       

                      Uploading information aboutfiles copied during the previous runs ...

                       

                      0 "left over"filescopied_<session_id>.txt files uploaded to DB: Sat Feb 15 201411:02:52

                       

                      ****************** E N D O F U P L O A D ******************

                       

                       

                       

                       

                      End date: Sat Feb 15 201411:02:52

                       

                       

                       

                       

                      Enter the directory where yourOracle Applications patch has been unloaded

                    • 输入patch所在文件夹

                      The default directory is[/u01/UAT/patch/10036698] :/u01/UAT/patch/10036698

                    • 输入patch驱动文件(一般是patch文件里的u+patch号.drv)

                      Please enter the name of yourAutoPatch driver file :u10036698.drv

                       

                      Getting Oracle ApplicationsRelease...

                       

                      Current installed releaseis 12.1.3

                       

                      Reading patch driver file...

                       

                      Parsing and loading patch driver file...

                      56 lines processed.

                       

                      Not checking patch integrity as integritychecking flag is turned off.

                       

                      Successfully read patch driverfile.

                       

                      Determining target release...

                       

                      Current target release is 12.1.3

                       

                       

                      Determining which bug fixes toapply...

                       

                      Done determining which bugfixes to apply.

                       

                       

                      Log and Info File sync point:

                      Sat Feb 15 2014 11:03:25

                       

                      Turning off actions thatreference unrecognized products.

                       

                       

                      Log and Info File sync point:

                      Sat Feb 15 2014 11:03:25

                       

                      End of unrecognized productschecking.

                       

                       

                      AutoPatch will run in serialmode.

                       

                       

                      Did not need to apply newapplterr.txt.

                       

                      Skipping...

                      Applying new applprod.txt (if any) forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Version checking for driver files forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Copy driver files into installation area forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      ForceCopy driver files into installation areafor Specified driver

                      since no such action is present for thisdriver file

                       

                      Screening out files not validfor this installation...

                       

                      Determining valid on-sitefiles...

                       

                      Skipping...

                      Extract object modules from libraries forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Version checking for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine directories to create for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine executables to link for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine forms to generate for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine Oracle Reports libraries to generatefor Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine reports to generate for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Determine if need to generate message filesfor Specified driver

                      since no such action is present for thisdriver file

                       

                      Looking for active bug fixeswith no active actions...

                       

                      Skipping...

                      Display customized files changed by patch forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Copy files into installation area forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      ForceCopy files into installation area forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Archive object modules into product librariesfor Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Create Directories for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Relink for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Perform second half of mirrored copies forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Updating Oracle ApplicationsJava files if necessary...

                       

                      ** Backing up$JAVA_TOP/META-INF/JRIMETA.DAT...

                       

                      Copying JRIMETA.DAT to JRIMETA.DAT.BackedupByAdpatch...

                      Copied JRIMETA.DAT toJRIMETA.DAT.BackedupByAdpatch.

                       

                      ** Successfully backed up JRIMETA.DAT.

                       

                       

                      Running adjcopy.class:

                       

                      adjava -mx512m -nojitoracle.apps.ad.jri.adjcopy @/u01/UAT/apps/apps_st/appl/admin/UAT/out/apps.cmd

                       

                      Successfully ran adjcopy.class

                       

                      Removed touch file.

                       

                      Removed apps.cmd.

                       

                      ** Successfully performed jcopy actions.

                       

                       

                      Skipping ...

                      Running AutoConfig to instantiate templateswhich affect

                      the generation of JAR files since none ofthese templates

                      were patched during this run of adpatch.

                       

                       

                       

                      ** Generating the product JAR files...

                       

                      Signing product JAR files in JAVA_TOP -

                      /u01/UAT/apps/apps_st/comn/java/classes

                      using entity PROD_ebstest and certificate 1.

                       

                      Successfully createdjavaVersionFile.

                       

                      Generating product JAR files in JAVA_TOP -

                      /u01/UAT/apps/apps_st/comn/java/classes withcommand:

                       

                      adjava -mx512m -nojit oracle.apps.ad.jri.adjmx@/u01/UAT/apps/apps_st/appl/admin/UAT/out/genjars.cmd

                       

                       

                       

                      Successfully generated product JAR filesin JAVA_TOP -

                      /u01/UAT/apps/apps_st/comn/java/classes.

                       

                      Copying Registry.dat from the Forms Javadirectory to /u01/UAT/apps/apps_st/comn/java/classes ...

                       

                      ** Successfully generated the product JARfiles.

                       

                       

                      Checking to see if adjborg.txt or any filesincluded in

                      adjborg.txt were copied by this patch...

                       

                      Neither adjborg.txt nor any file included in

                      adjborg.txt was copied by this patch.

                       

                      Checking to see if adjborg2.txt or any filesincluded in

                      adjborg2.txt were copied by this patch...

                       

                      Neither adjborg2.txt nor any file includedin

                      adjborg2.txt was copied by this patch.

                       

                      Skipping...

                      Compile JSP files for Specified driver

                      since no such action is present for thisdriver file

                      or this APPL_TOP does notimplement the "web" server type

                       

                      Skipping...

                      Run SQL scripts and EXEC commands forSpecified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Compile invalid objects for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate forms library files for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate forms menu files for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate forms for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate reports libraries for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate reports for Specified driver

                      since no such action is present for this driverfile

                       

                      Skipping...

                      Generate Messages for Specified driver

                      since no such action is present for thisdriver file

                       

                      Skipping...

                      Generate Workflow resource files for Specifieddriver

                      since no such action is present for thisdriver file

                       

                      Skipping ...

                      Running AutoConfig since none of its templateswere

                      patched during this run of adpatch.

                       

                      Saving Patch Historyinformation to Database...

                       

                      Trying to obtain a lock...

                       

                      > Inserted 1 patch historyrecords (total).

                       

                      Gathering Statistics forAD_PATCH_HIST_TEMP

                       

                      Done Gathering Statistics forAD_PATCH_HIST_TEMP

                       

                      >>> Inserted 1 bughistory records for this patch (total).

                      >>>>> Inserted 0action history records for this bug (total).

                       

                      Gathering Statistics forAD_PATCH_HIST_TEMP

                       

                      Done Gathering Statistics forAD_PATCH_HIST_TEMP

                       

                      >>> Inserted 3 bughistory records for this patch (total).

                      >>>>> Inserted 0action history records for this bug (total).

                       

                       

                       

                      Updating the current-view snapshot...

                       

                      Uploading Java objects to patchhistory tables...

                       

                      Number of lines processed = 2

                      Updating the current-view snapshot...

                       

                      Completed uploading Javaobjects to patch history tables.

                       

                      Done saving Patch History information.

                       

                       

                      About to do IREP processing...

                       

                      Attempting to process IREP files ...

                       

                      Successfully processed IREP files.

                       

                      Done IREP processing.

                       

                       

                      Copying applprod.tmp toapplprod.txt (if needed)...

                       

                      Did not need to copy applprod.tmp toapplprod.txt.

                       

                      Copyingadmin/<sid>/applterr.txt to admin/applterr.txt (if needed)...

                       

                      Did not need to copyadmin/UAT/applterr.txt to admin/applterr.txt.

                       

                       

                      There is no timing informationavailable for the current session.

                       

                       

                      AutoPatch is complete.

                       

                      AutoPatch may have writteninformational messages to the file

                      /u01/UAT/apps/apps_st/appl/admin/UAT/log/10036698002.lgi

                       

                      Errors and warnings are listedin the log file

                      /u01/UAT/apps/apps_st/appl/admin/UAT/log/10036698002.log

                       

                      and in other log files in thesame directory.

                       

                      You have new mail in/var/spool/mail/appluat

                      [appluat@ebsapp 10036698]$

                       

                      3.4检查是否已经安装进去

                      SELECT * FROM ad_bugs tWHERE t.bug_number ='10036698';

                       

                      加载中...

                       

                      3.5关闭维护模式

                      1.跟启用维护模式相同最后选择的地方选择关闭

                       

                      AD Administration Main Menu

                      --------------------------------------------------

                       

                      1. Generate Applications Files menu

                       

                      2. Maintain Applications Files menu

                       

                      3. Compile/Reload Applications DatabaseEntities menu

                       

                      4. Maintain Applications Database Entitiesmenu

                       

                      5. Change Maintenance Mode

                       

                      6. Exit AD Administration

                       

                      • 选择更改模式

                        Enter your choice [6] : 5

                         

                        ChangeMaintenance Mode

                        ----------------------------------------

                         

                        Maintenance Mode is currently: [Disabled].

                         

                        Maintenance mode should normally be enabled when patching

                        Oracle Applications and disabled when users are logged on

                        to the system. See the OracleApplications Maintenance

                        Utilities manual for more information about maintenance mode.

                         

                        Please select an option:

                         

                        1. Enable Maintenance Mode

                         

                        2. Disable Maintenance Mode

                         

                        1. Return to Main Menu

                          • 选择关闭维护模式

                             

                            Enter your choice [3] : 2

                             

                            3.6 重启应用

                            Last login: Sat Feb 15 11:04:372014 from 10.8.21.81

                            • 切换到脚本目录

                              [appluat@ebsapp ~]$ cd $ADMIN_SCRIPTS_HOME

                            • 重启

                              [appluat@ebsapp scripts]$ adstrtal.sh apps/apps

                              3.7登陆查看是否成功

                              查看FORM是否能正常打开。问题是否已经解决

                               

                               

                               

                              (七)参考文档

                              在实际应用中,环境和版本与本文可能不同,如果想了解更多的内容请参考以下文档:

                              文档名称