之前写过一篇关于Oracle Apps使用hotpatch模式打patch的文章:Oracle EBS使用adpatch工具打patch过程(hotpatch mode) ,今天记录下如何使用Maintainance Mode如何来打Oracle EBS的Patch。
1. 通过SQL检查,系统是否已经打了这个Patch
select * from ad_bugs WHERE bug_number = '14037116';
或者
Select * from ad_applied_patches where patch_name like '%14037116%';
2. Metalink下载patch
登陆到Metalink(https://support.oracle.com),Oracle内部用户可以使用ARU来下载。
点击Patches & Updates 页签,在"Patch Search"区,输入你的Patch号,Search,
找到你的Patch之后,特别注意,需要仔细查看Patch的Release,Platform/Language...以及阅读Read Me信息(看是否有需要关联下载的Patch)
然后下载Patch到本机,
3. 上传&解压
打patch前,最好备份可能会被覆盖的文件。仔细阅读Readme文件。
上传patch文件到服务器端的Patch目录下,然后使用unzip命令解压,eg. unzip p14037116_R12.INV.B_R12_LINUX.zip
4.Enable the Maintenance Mode
Unix控制台下执行"adadmin"命令(执行过程中需要输入数据库system用户和apps用户的密码)
5. adpatch
进入解压后的patch目录,执行命令:
$ adpatch
运行过程中需要回答一些adpatch的问题,比如
APPL_TOP目录是否正确
指定adpatch日志的名称,默认为adpatch.log
Instance名称是否正确
...
adpatch运行完之后,如果没有看到“autopatch is complete”样式的消息,那说明你的patch没有打成功
adpatch的日志默认位于$APPL_TOP/admin/<SID>/log
6. 通过SQL检查确认系统已经成功的打上了Patch
select * from ad_bugs WHERE bug_number = '14037116';
或者
Select * from ad_applied_patches where patch_name like '%14037116%';
7.Disable Maintainance Mode
adadmin > 5.Change Maintenance Mode. > 2.Disable Maintenance mode.
-----------------------------------------------------------------------------
How to apply NLS patches in R12
The same way you apply an application patch. Just make sure you apply the base language patch before applying NLS patches.
Steps to apply a patch:
- Stop all application services (keep the database and the database listener up and running)
- Download the patch from Metalink
- Copy the patch file to any directory (i.e. /u04/patches)
- As 'applmgr' do the following:
- Source the environment file
- $ cd /u04/patches
- Type 'unzip <patch_number>.zip'
- cd <patch_number>
- Type 'adpatch'
- When it prompts you to enter the patch driver, type 'u<patch_number>.drv'
Apply the patch on the database tier first then on the application tier.
Do not forget to 'Enable Maintenance Mode' from adadmin before applying the patch. Once you apply the patch successfully, 'Disable Maintenance Mode' from adadmin.
To apply NLS patch:
- Download the patch from Metalink
- Copy the patch file to any directory (i.e. /u04/patches)
- As 'applmgr' do the following:
- Source the environment file
- $ cd /u04/patches
- Type 'unzip <patch_number>_<lang>.zip'
- cd <patch_number>_<lang>
- Type 'adpatch'
- When it prompts you to enter the patch driver, type 'u<patch_number>.drv'
For more details about applying patches, please refer to:
"Oracle Applications Maintenance Utilities" manual
http://download.oracle.com/docs/cd/B40089_09/current/acrobat/r12adutil.pdf
How to apply EBS 12i pathces in both Linux and Windows
http://forums.oracle.com/forums/thread.jspa?messageID=2101092
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7872433
===EOF===
分享到:
相关推荐
信息安全_数据安全_Passwords_and_Patching:The_Forgo 数据泄露 安全分析 安全管理 威胁情报 安全分析
Practical Oracle Database Appliance... Patching the Oracle Database Appliance Business Values for the ODA Virtualization and the ODA e-Business Suite and the ODA Oracle Enterprise Manager and the ODA
有五种方法可供使用的热修补库!
补丁管理 Ansible play 来管理修补 Linux 服务器(最终也是 Windows) 指示 命令行使用 在命令行中,您需要将 hosts 的值指定为 extra_vars 条目: ansible-playbook PatchSystems.yaml -e "hosts=<valid>" ...
os_patching 该模块包含一组任务和自定义事实,以允许自动化和修补程序报告。 当前,修补程序可在Linux(Redhat,Suse和Debian衍生产品)和Windows(已测试Server 2008到2019)上运行。 在后台,它使用操作系统...
拼图求解器 一个基本的求解器,它将使用多线程随机模拟来收集最长的路径,从而计算出最佳移动(它认为)。 讨论线程 建筑(Windows / Linux) 对于Windows,请确保使用Cygwin 安装make和g++ 。...
使您无需触摸代码本身即可对特定代码进行更改。 例如,如果您需要更改其他人编辑的代码或可以从某些来源“更新”的代码,这可能会很有用。 创建该库是为了修改WebAsyst Shop-Script5源(现在已经是6),但是为了不...
如果你研究过Oracle Forms,使用过Application Server和Developer Suite来开发、配置部署form和report,并且曾经作为一名Oracle DBA,经历过许多管理和维护的工作如patching和cloning的话,那么你就已经能够掌握了...
Practical Oracle E-Business Suite provides detailed instructions for the Installation of EBS R12.2 in single and multi-node configurations, the logic and methodology used in EBS patching, and cloning ...
This book helps database and system administrators succeed in managing Oracle Application Express (APEX) environments. Focus is on creating the right combination of scalability, high-availability, ...
Anti-Patching: None Metamorph Security: ENABLED Memory Guard: ENABLED When Debugger Found: Display Message Application compression: ENABLED Resources compression: DISABLED SecureEngine compression: ...
Title: Expert Oracle Exadata, 2nd Edition Author: Andy Colvin, Frits Hoogland, Karl Arao, Kerry Osborne, Martin Bach, Randy Johnson, Tanel Põder Length: 672 pages Edition: 2 Language: English ...
为此,提出了一种P2P VoD冷热播频道间协作策略,通过利用“热播”频道中具有富余服务能力的节点为“冷播”频道节点提供patching服务,从而连接“冷播”频道各个独立的“播放链”,进而减轻了多频道P2P点播系统中由于...
LeetCode Patching Array 完整C++代码,本人在vim + g++上跑出
Anti-Patching: None Metamorph Security: ENABLED Memory Guard: ENABLED When Debugger Found: Display Message Application compression: ENABLED Resources compression: DISABLED SecureEngine compression: ...
version_patching:包含在旧的Matlab版本中不可用的功能(以防万一,只有那些版本) 以下目录与该类有关: 数据:包含数据(来自整个处理链中的导入数据) 元数据:包含元数据文件 地块:包含通过各种处理方法生成的...
Patching Applications from Apple's AppStore IOS程序破解教程
beggenner to dongle cracking
针对现有VOD系统中组播技术应用的缺陷和不足,提出了一种将覆盖网络组播技术与Patching算法结合应用于VOD系统的方案。该方案充分利用了覆盖网络组播技术的优点,结合VOD系统特性及Patching补偿流技术,在合理的利用...