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
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
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
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
No comments:
Post a Comment