1. What are the different types of patches?
One-off, mini packs, family packs, maintenance packs, rollup patches, consolidated patches.
2. What is a one-off patch?
A one-off patch is a small patch of (20-90K size) without any pre-req.
3. What is a mini pack?
A mini pack is one which will upgrade any product patch set level to next level like AD.H to AD.I
4. What is Family pack?
A Family pack is one which will upgrade the patch set level of all the products in that family to particular patchsetlevel.
5. What is Maintenance pack?
A maintenance pack will upgrade applications from one version to another like 12.1.0 to 12.1.1
6. What is a Rollup patch?
A rollup patch is one which will deliver bug fixes identified after the release of any major application versions like 12.1.0/12.1.1
7. What is consolidated patch?
Consolidated patches will come into pictures after upgrades from one version of applications to another, all post upgrade patches will a consolidated and given as consolidated patch.
8. How u will find whether a patch is applied/not?
Query ad bugs.
9. What is the other table where u can query what are the patches applied?
Ad_applied_patches
10. What is the difference between ad_bugs and ad_applied_patches?
A patch can deliver solution for more than one bug, so ad_applied_patches may not give u the perfect information as in case of ad_bugs.
11. How u apply a patch?
adpatch
12. What inputs you need to apply a patch other than driver name and etc?
Apps and system passwords
13. What are the table u r adpatch will create and when?
Adpatch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g and u drivers.
14. What is the significance of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table?
FND_INSTALL_PROCESSES table will store the worker information like what job is assigned to which worker and its status. AD_DEFERRED_JOBS will come into picture when some worker is failed, it will be moved to AD_DEFERRED_JOBS table, from where again adpatch will take that job and try to resign, after doing this 3 times if still that worker is failing, then adpatch will stop patching and throw the error that particular worker has failed. We need to trouble shoot and restart the worker.
15. If it is a multi-node installation which driver we need to apply on which node?
c,d,g on concurrent node and c, g on web node. If it is u-driver we need to apply on all nodes.
16. While applying an application patch is that necessary that u r database and listener should be up?
Yes. Why because adpatch will connect to database and update so many tables etc…..
17. While applying a patch if that patch is failing because of a pre-req then how you will apply that pre-req patch and resume with the current patch?
We need to take the backup of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables and restart directory at APPL_TOP/admin/SID and then use adctrl to quit all the workers. Then apply the pre-req patch, after that rename u r restart directory to its original name and create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables from the backup tables. Start adpatch session and take the options want to continue
Previous session.
18. Where would you find .rf9 file, and what exactly it does?
These files are used during restart of patch in case of patch failure because of some reason.
19. What c-driver will do?
C-drive copies the files from patch unzipped directory to required location in your application file system. Before copying it will check the file version of the existing file at the file system with the file version of the file in the patch. If the patch file versions higher than what it is at file system level then only c-driver will copy that files.
20. How adpatch will know the file versions of the patch delivered files?
With each patch a file with name f<patch_number>.ldt is delivered, which contain the file versions of the files delivered with the patch. Adpatch will use this file to compare the file versions of files it’s delivering with the file on file system.
21. What is the worker log file name and its location?
adwork01, adwork02…… and location is APPL_TOP/admin/SID/log
22. How you will know, what are the files the patch is going to change just my unzipping the patch?
When you unzip a patch it will keep all the files related to a particular product under that directory inside your patch directory for example if the patch delivering files related to FND product then it will create a sub directory under the patch directory with the name FND in which it will put all related files to that product.
23. What is the adpatch log file location?
APPL_TOP/admin/SID/log
24. What is the significance of backup directory under your patch directory?
When we apply a patch it will keep the copy of the files which its going to change in file system. with the name backup under patch dir.
25. What are the different modes you can run your adpatch?
1. Interactive –default mode
2. Non interactive –Use defaults files to store prompt values (adpatch defaultsfile=<filename> interactive=no)
3. Test –Without actually applying a patch just to check what its doing.(adpatch apply=no)
4. Pre-install –(adpatch preinstall=y) This mode will be useful to decrease upgrade downtime as its applies bus fixes without running SQL,EXEC and generate portion of patch.
26. Is that necessary to enable maintenance mode while applying a patch?
We can even apply a patch without enabling maintenance mode with the following option:
$ adpatch options=hot patch
27. How to find out what are the RDBMS patches applied to an oracle home?
1. opatch –lsinventory
2. “$RDBMS_ORACLE_HOME/.patch_storage” directory contains the directories with the rdbms patch number, which are applied to this oracle.
28.Is it necessary to shutdown database while applying a database patch?
Yes.
29.While applying a RDBMS patch using Opatch you are getting the error, unable to read inventory/inventory is corrupted/ORACLE_HOME is not registered, what you will do, and how you will apply the patch?
We will check the inventory directory permission; try to apply the patch after giving 777 permissions to that inventory directory. If still it won’t work we will apply patch with the following command: $ Opatch apply –no_inventory
30.How to find out which patch driver is applied (like c,d,g or u)?
Query ad_patch_drivers.
31. How to find out whether a language patch is applied for a particular patch?
Query ad_patch_driver_langs.
32.How To get information related to how many time driver file is applied for bugs
select * from AD_PATCH_RUN_BUGS where BUG_ID in (select BUG_ID from AD_BUGS where BUG_NUMBER = ''
33. How To find latest patchset level for module installed
select APP_SHORT_NAME, max(PATCH_LEVEL) from AD_PATCH_DRIVER_MINIPKS GROUP BY APP_SHORT_NAME
How to find out Patch level of mini Pack
Select product_version,patch_level from FND_PROUDCT_INSTALLATIONS where patch_level like '%&shortname%';
Replace short name by name of Oracle Apps Minipack for which you want to find out Patch level . ex.
AD -for Applications DBA
34.I am applying a patch , can I open another session and run adadmin ?
Yes, unless you are running a process where workers are involved
35.I am applying a patch , can I open another session in another node and run adpatch?
No
36.How to find opatch Version ?
opatch is utility to apply database patch , In order to find opatch version execute"$ORACLE_HOME/OPatch/opatch version"
37. How to merge patches and what type of patches can be merged?
admrgpch. We can merge any kind of application patches, if any of the patch contain a u-driver then merged patch will contain u_merged.drv otherwise c_merged.drv, d_merged.drv and g_merged.drv.
38.What is FNDLOAD ?
FNDLOAD is a utility which is similar to sqlloder but loads code objects into database, where as SQLLOADER loads data objects into database.
39. How adpatch will know the file versions of the patch delivered files?
With each patch a file with name f.ldt is delivered , which contain the file versions of the files dilivered with the patch. Adpatch will use this file to compare the file versions of files its delivering with the file on file system
40.How to find out which patch driver is applied(like c,d,g or u)?
query ad_patch_drivers.
42. How to find out whether a language patch is applied for a particular patch?
Query ad_patch_driver_langs.
43. When a patch delivers java files what extra file u will get when u unzip the patch, other then u r dirver and readme files?
j.zip52. :
44. What are the ways to reduce patch timing?
Merging patches via admrgpch
Use various adpatch options like nocompiledb or nocompilejsp
Use defaults file
Staged APPL_TOP during upgrades
Increase batch size (Might result into negative )
45. How you put Applications 11i in Maintenance mode ?
Use adadmin to change Maintenance mode is Oracle Apps. With AD.I you need to enable maintenance mode in order to apply apps patch via adpatch utility..
Also you can use the script $AD_TOP/patch/115/sql/ adsetmmd.sql
46. What are various options available with adpatch ?
Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion,generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate
47.What is difference between adpatch & opatch?
adpatch is utility to apply oracle apps Patches whereas
# opatchis utility to apply database patches
48.While applying Apps patch using adpatch, if you want to hide the apps password, how will that be possible?
Use adpatch flags=hidepw while applying patches in apps to hide apps or system password being displayed on screen.
49. What is .pls files which you see with apps?
.PLS file stands for plsql files. In apps patch these files contain code to create package spec or package body or both.
50. What are .ldt & .lct files which you see in apps patch or with FNDLOAD?
.ldt & .lct stands for Loader data file & Loader configuration files, used frequently in migrating customization, profile options, configuration data etc. across Instances.
51. What are .odf file in apps patch?
odf stands for Object Description Files used to create tables & other database objects while applying a patch.
52.When you apply C driver patch does it require database to be Up & Why?
Yes, database & db listener should be UP when you apply any driver patch in apps. Even if driver is not updating any database object connection is required to validate apps & other schema and to upload patch history information in database tables.
53. Can C driver in apps patch create Invalid Object in database?
No, C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified.
54.Types of Driver Files within the patch directory?
Copy(c),database(d), and generate(g) driver file prior to 11.5.8
From 11.5.9 Unified(u) driver file instead of (c+d+g) driver files.
One-off, mini packs, family packs, maintenance packs, rollup patches, consolidated patches.
2. What is a one-off patch?
A one-off patch is a small patch of (20-90K size) without any pre-req.
3. What is a mini pack?
A mini pack is one which will upgrade any product patch set level to next level like AD.H to AD.I
4. What is Family pack?
A Family pack is one which will upgrade the patch set level of all the products in that family to particular patchsetlevel.
5. What is Maintenance pack?
A maintenance pack will upgrade applications from one version to another like 12.1.0 to 12.1.1
6. What is a Rollup patch?
A rollup patch is one which will deliver bug fixes identified after the release of any major application versions like 12.1.0/12.1.1
7. What is consolidated patch?
Consolidated patches will come into pictures after upgrades from one version of applications to another, all post upgrade patches will a consolidated and given as consolidated patch.
8. How u will find whether a patch is applied/not?
Query ad bugs.
9. What is the other table where u can query what are the patches applied?
Ad_applied_patches
10. What is the difference between ad_bugs and ad_applied_patches?
A patch can deliver solution for more than one bug, so ad_applied_patches may not give u the perfect information as in case of ad_bugs.
11. How u apply a patch?
adpatch
12. What inputs you need to apply a patch other than driver name and etc?
Apps and system passwords
13. What are the table u r adpatch will create and when?
Adpatch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g and u drivers.
14. What is the significance of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table?
FND_INSTALL_PROCESSES table will store the worker information like what job is assigned to which worker and its status. AD_DEFERRED_JOBS will come into picture when some worker is failed, it will be moved to AD_DEFERRED_JOBS table, from where again adpatch will take that job and try to resign, after doing this 3 times if still that worker is failing, then adpatch will stop patching and throw the error that particular worker has failed. We need to trouble shoot and restart the worker.
15. If it is a multi-node installation which driver we need to apply on which node?
c,d,g on concurrent node and c, g on web node. If it is u-driver we need to apply on all nodes.
16. While applying an application patch is that necessary that u r database and listener should be up?
Yes. Why because adpatch will connect to database and update so many tables etc…..
17. While applying a patch if that patch is failing because of a pre-req then how you will apply that pre-req patch and resume with the current patch?
We need to take the backup of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables and restart directory at APPL_TOP/admin/SID and then use adctrl to quit all the workers. Then apply the pre-req patch, after that rename u r restart directory to its original name and create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables from the backup tables. Start adpatch session and take the options want to continue
Previous session.
18. Where would you find .rf9 file, and what exactly it does?
These files are used during restart of patch in case of patch failure because of some reason.
19. What c-driver will do?
C-drive copies the files from patch unzipped directory to required location in your application file system. Before copying it will check the file version of the existing file at the file system with the file version of the file in the patch. If the patch file versions higher than what it is at file system level then only c-driver will copy that files.
20. How adpatch will know the file versions of the patch delivered files?
With each patch a file with name f<patch_number>.ldt is delivered, which contain the file versions of the files delivered with the patch. Adpatch will use this file to compare the file versions of files it’s delivering with the file on file system.
21. What is the worker log file name and its location?
adwork01, adwork02…… and location is APPL_TOP/admin/SID/log
22. How you will know, what are the files the patch is going to change just my unzipping the patch?
When you unzip a patch it will keep all the files related to a particular product under that directory inside your patch directory for example if the patch delivering files related to FND product then it will create a sub directory under the patch directory with the name FND in which it will put all related files to that product.
23. What is the adpatch log file location?
APPL_TOP/admin/SID/log
24. What is the significance of backup directory under your patch directory?
When we apply a patch it will keep the copy of the files which its going to change in file system. with the name backup under patch dir.
25. What are the different modes you can run your adpatch?
1. Interactive –default mode
2. Non interactive –Use defaults files to store prompt values (adpatch defaultsfile=<filename> interactive=no)
3. Test –Without actually applying a patch just to check what its doing.(adpatch apply=no)
4. Pre-install –(adpatch preinstall=y) This mode will be useful to decrease upgrade downtime as its applies bus fixes without running SQL,EXEC and generate portion of patch.
26. Is that necessary to enable maintenance mode while applying a patch?
We can even apply a patch without enabling maintenance mode with the following option:
$ adpatch options=hot patch
27. How to find out what are the RDBMS patches applied to an oracle home?
1. opatch –lsinventory
2. “$RDBMS_ORACLE_HOME/.patch_storage” directory contains the directories with the rdbms patch number, which are applied to this oracle.
28.Is it necessary to shutdown database while applying a database patch?
Yes.
29.While applying a RDBMS patch using Opatch you are getting the error, unable to read inventory/inventory is corrupted/ORACLE_HOME is not registered, what you will do, and how you will apply the patch?
We will check the inventory directory permission; try to apply the patch after giving 777 permissions to that inventory directory. If still it won’t work we will apply patch with the following command: $ Opatch apply –no_inventory
30.How to find out which patch driver is applied (like c,d,g or u)?
Query ad_patch_drivers.
31. How to find out whether a language patch is applied for a particular patch?
Query ad_patch_driver_langs.
32.How To get information related to how many time driver file is applied for bugs
select * from AD_PATCH_RUN_BUGS where BUG_ID in (select BUG_ID from AD_BUGS where BUG_NUMBER = ''
33. How To find latest patchset level for module installed
select APP_SHORT_NAME, max(PATCH_LEVEL) from AD_PATCH_DRIVER_MINIPKS GROUP BY APP_SHORT_NAME
How to find out Patch level of mini Pack
Select product_version,patch_level from FND_PROUDCT_INSTALLATIONS where patch_level like '%&shortname%';
Replace short name by name of Oracle Apps Minipack for which you want to find out Patch level . ex.
AD -for Applications DBA
34.I am applying a patch , can I open another session and run adadmin ?
Yes, unless you are running a process where workers are involved
35.I am applying a patch , can I open another session in another node and run adpatch?
No
36.How to find opatch Version ?
opatch is utility to apply database patch , In order to find opatch version execute"$ORACLE_HOME/OPatch/opatch version"
37. How to merge patches and what type of patches can be merged?
admrgpch. We can merge any kind of application patches, if any of the patch contain a u-driver then merged patch will contain u_merged.drv otherwise c_merged.drv, d_merged.drv and g_merged.drv.
38.What is FNDLOAD ?
FNDLOAD is a utility which is similar to sqlloder but loads code objects into database, where as SQLLOADER loads data objects into database.
39. How adpatch will know the file versions of the patch delivered files?
With each patch a file with name f.ldt is delivered , which contain the file versions of the files dilivered with the patch. Adpatch will use this file to compare the file versions of files its delivering with the file on file system
40.How to find out which patch driver is applied(like c,d,g or u)?
query ad_patch_drivers.
42. How to find out whether a language patch is applied for a particular patch?
Query ad_patch_driver_langs.
43. When a patch delivers java files what extra file u will get when u unzip the patch, other then u r dirver and readme files?
j.zip52. :
44. What are the ways to reduce patch timing?
Merging patches via admrgpch
Use various adpatch options like nocompiledb or nocompilejsp
Use defaults file
Staged APPL_TOP during upgrades
Increase batch size (Might result into negative )
45. How you put Applications 11i in Maintenance mode ?
Use adadmin to change Maintenance mode is Oracle Apps. With AD.I you need to enable maintenance mode in order to apply apps patch via adpatch utility..
Also you can use the script $AD_TOP/patch/115/sql/ adsetmmd.sql
46. What are various options available with adpatch ?
Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion,generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate
47.What is difference between adpatch & opatch?
adpatch is utility to apply oracle apps Patches whereas
# opatchis utility to apply database patches
48.While applying Apps patch using adpatch, if you want to hide the apps password, how will that be possible?
Use adpatch flags=hidepw while applying patches in apps to hide apps or system password being displayed on screen.
49. What is .pls files which you see with apps?
.PLS file stands for plsql files. In apps patch these files contain code to create package spec or package body or both.
50. What are .ldt & .lct files which you see in apps patch or with FNDLOAD?
.ldt & .lct stands for Loader data file & Loader configuration files, used frequently in migrating customization, profile options, configuration data etc. across Instances.
51. What are .odf file in apps patch?
odf stands for Object Description Files used to create tables & other database objects while applying a patch.
52.When you apply C driver patch does it require database to be Up & Why?
Yes, database & db listener should be UP when you apply any driver patch in apps. Even if driver is not updating any database object connection is required to validate apps & other schema and to upload patch history information in database tables.
53. Can C driver in apps patch create Invalid Object in database?
No, C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified.
54.Types of Driver Files within the patch directory?
Copy(c),database(d), and generate(g) driver file prior to 11.5.8
From 11.5.9 Unified(u) driver file instead of (c+d+g) driver files.
No comments:
Post a Comment