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步骤说明及详细记录
参考文档
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编号'
-
比对系统已安装模块版本与Patch版本，下载对应版本的Patch文件。注意：有的Patch是中英文的，需要将两个文件全部下载。
1.4查看下载到的patch包里的 REANME
1．看有没有前置Patch，如果没有前置Patch，可以按照下面步骤安装；如果存在前置Patch，需要按照本文档所有步骤先安装所有涉及的前置步骤，然后安装当前Patch。
-
本地解压Patch安装包，上传到服务器patch文件夹里（没有可以新建）
-
用系统应用用户登陆Linux（是系统应用用户，不是数据库用户）；
-
停系统应用；
-
用adadmin启用系统维护模式；
-
用adpatch安装Patch，先安装英文Patch，（如果有中文patch）后安装简体中文Patch；
-
用SQL查询Patch是否已经安装进去
-
用adadmin停用系统维护模式；
-
重启系统应用；
-
登陆，查看Form能否正常打开，问题是否解决；
说明：红色底色的为说明；黄色底色的为需要输入的命令；绿色底色的为注释
未加底色的为程序运行输出。
一）.步骤概览
一．解压上传patch
1.略
二．停应用
-
切换目录 cd $ADMIN_SCRIPTS_HOME
-
停应用 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. 切换目录 cd $ADMIN_SCRIPTS_HOME
2．启应用 adstrtal.shapps/[apps password]
二）.过程详解
3.1 Patch包解压，上传
解压
上传
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
-
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 ~]$
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';
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
-
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是否能正常打开。问题是否已经解决
在实际应用中，环境和版本与本文可能不同，如果想了解更多的内容请参考以下文档：
|
文档名称 |
说明 |
|
|
参考文档手册 |
