India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 1 appsdbawiki
Introduction to India Localization Patch:
Pre-Requisite Patch Check:
select * from jai_applied_patches where patch_number = ‘<Patch_Number>’;
Object Details:
Check the status of the objects that will be updated by the patch driver. select owner, object_name, object_type, last_ddl_time, status from all_objects
where object_type like '<OBJ_TYP>' and object_name = ‘<OBJ_NAME>’;
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 2 appsdbawiki
Object Version:
select object_name||';;' ||
decode(object_type,'TRIGGER','en','VIEW','vw','PACKAGE','pls','PACKAGE
BODY','plb','compile')||';;' || jai_get_sql_ver_f(object_name, object_type)
from user_objects
where object_name in ‘(‘<OBJ_NAME>');
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 3 appsdbawiki
Checking FND Version:
select patch_level, application_name
from fnd_product_installations fpi, fnd_application_tl fat where patch_level is not null and fpi.application_id = fat.application_id and patch_level like
'%FND%' ;
Invalid objects:
select count(*) from dba_objects where status='INVALID';
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 4 appsdbawiki
Connection to JA schema:
Object Backup:
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 5 appsdbawiki
Patch Top:
Copy the patch to JA_TOP and unzip it. Change the directory to patch folder. Inside the patch folder you can see a sql supplied by oracle to find out the version of all the objects which patch will be updating.
Patching:
DB, Concurrent Node:
perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=D systempwd=<PWD>
perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=C systempwd=<PWD>
strings -a ja_in_localization_setup_checks_trg.sql | grep Header
Form Node 1:
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 6 appsdbawiki
perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd= <PWD> japwd=<PWD> mode=F systempwd=<PWD> strings -a ja_in_localization_setup_checks_trg.sql | grep Header
Form Node 2:
perl $JA_TOP/inpatch/indpatch.pl drvr_file=8277581.drv fnd_patchset=H appspwd=<PWD> japwd=<PWD> mode=F systempwd=<PWD> strings -a ja_in_localization_setup_checks_trg.sql | grep Header
Backup Folder:
A backup folder will be created inside the patch top. In this location you can find all the objects that are going to be replaced by patching.
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 7 appsdbawiki
Patch Log Location and Log File:
India Localization Patch Tool – 11.5.10.2
Krishnamoorthy Rasappan Page 8 appsdbawiki
and more ….
Monitoring:
There is no tool to monitor India Localization Patch like how we can adctrl for adpatch in EBS. But we can find by checking for the processes running in OS.
