Patch

Adpatch

 AutoPatch - utility to apply patches for EBS

Options:
apply=n                                - test mode - generate only log file without apply
preinstall=y                          - preinstall mode -
options=noautoconfig          - to avoid autoconfig
options=nocheckfile            - do not check already executed exec, sql and exectier - cause performance issue
options=nocompiledb          - do not compile invalids in database
options=nocompilejsp         - do not compile jsp
options=nocopyportion       - do not execute copy driver portion
options=nodatabaseportion - do not execute database driver portion
options=nogenerateportion - do not execute generate driver portion
options=hotpatch                - apply patch without maintance mode
options=integrity                - check patch integrity - cause performance issue
options=nomaintainmrc      - do not execute maintain MRC schema - for translation and documentation patches
options=noprereq                - do not check prereq
options=validate                 - validate all schemas in database
options=nojcopy                 - do not copy new java class from the patch
options=noforcecopy          - checks for file version and copy only the new version from patch
options=nolink                    - do not relink executables
options=nogenform             - do not generate form files
options=nogenrep                - do not generate report files

Maintance Mode:
sqlplus apps/apps  @$APPL_TOP/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE ENABLE
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
Output: MAINT/NORMAL

adadmin -> 5.Change Maintenance Mode -> 1.Enable Maintenance mode/2.Disable Maintenance mode

Apply prereq patch when main patch fails

1. adctrl->option 3(tell all works to quit)->option 5(tell manager that all worker have quit)
2. sqlplus apps/apps
3. alter table ad_deferred_jobs rename to ad_deferred_jobs_old;
4. alter table fnd_install_processes rename to fnd_install_processes_old;
5. mv $APPL_TOP/admin/<SID>/restart $APPL_TOP/admin/<SID>/restart_old
6. apply prereq patch
7. sqlplus apps/apps
8. alter table ad_deferred_jobs_old rename to ad_deferred_jobs;
9. alter table fnd_install_processes_old rename to fnd_install_processes;
10. mv $APPL_TOP/admin/<SID>/restart_old $APPL_TOP/admin/<SID>/restart
11. apply main patch
12. adctrl->option 2(change status to fixed/restart)

Log file:
$APPL_TOP/admin/$SID/log/

Tables:
ad_bugs || ad_applied_patches || ad_patch_run_bugs || ad_patch_runs || ad_patch_drivers

 

Opatch 

Apply Patch on RAC database

 

1. Check Oracle service status
crs_stat -t

2. Stop database instance one by one
srvctl stop instance -i prod1 -d prod
srvctl stop instance -i prod2 -d prod
3. Stop ASM instance on each node one by one
srvctl stop asm -n rac-node1
srvctl stop asm -n rac-node2
4. Stop nodapplications one by one on each node
srvctl stop nodeapps -n rac-node1
srvctl stop nodeapps -n rac-node2
5. Check status again
crs_stat -t
6. Apply patch
opatch apply