Oracle EBS 用自带的命令行进行打patch 步骤如下:
1. 首先将patch upload到instance上面的临时文件夹
2. 通过命令行将ebs application停掉
3. adadmin: change to Maintenance Mode SYSTEM/oracle/manager APPS/apps 将instance切换到维护的模式才能进行打patch
4. adpatch driver=u14570467.drv 其中'uxxxxxxx.drv'是patch里面的文件
打完patch之后,要验证是否打成功可以运行下面两条sql 查看数据库里面是否已经有相关的patch号码和bug号码
SELECT * FROM ad_applied_patches app WHERE app.patch_name = '14570467';
SELECT * FROM ad_bugs ab WHERE ab.bug_number = '14570467';