26. How to run autoconfig in test mode?
Ans :
adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test mode and create the difference file which tells us what is going to change, when u actually run autoconfig.
27. How to find autoconfig is enabled or not for database?
Ans:
If we have appsutil directory under RDBMS_ORACLE_HOME
28. What is AD Administration (or adadmin)?
Ans: AD Administration (adadmin) performs maintenance tasks on an installed Oracle Applications system to ensure that it runs smoothly. The tasks performed with this utility fall into two categories: database and file system.
29. What is for “validating apps schema” option in adadmin?
Ans: It will check for the corrupted objects in apps schema
30. What is “compile apps schema” option in adadmin?
Ans : It will compile the invalid database objects.
31. How to find MRC is enabled or not?
Ans: In adadmin if covert to MRC options is there, then MRC is not enabled, if maintain MRC options is there, then MRC is enabled.
32. How to find Multi-Org is enabled or not?
Ans : In adadmin if covert to Multi org option is there, then Multi-org is not enabled. If maintain multi-org options is there, then Multi-org is enabled.
33. What is the configuration file for adutilities (like adadmin,adconfig etc)?
Ans: adconfig.txt @APPL_TOP/admin
34. Why do you need system password for adadmin?
35. Where is adadmin log file located?
Ans : apachectl @IAS_ORACLE_HOME/Apache/bin
37. How to find adconfig is enabled for oracle operating system user/database?
Ans : If appsutil directory is there in RDBMS_ORACLE_HOME
38. What is licence manager?
Ans : Licence manager(adlicmgr) utility is used to licence/unlicence , enable new languages,enbale country specific functionality.
39. What is the other script by which u can start apache other than adapcctl.sh?
Ans : apachectl @IAS_ORACLE_HOME/Apache/bin
40. What are the post installation task?
Ans : Running adjkey –initialize and then runnning adadmin to regenerate jar files.
41. What are the real time problems you have encountered and how you troubleshooted that?
Ans: 1. Concurrent Program is erroring out with snapshot too old error. To resolve this we have added space to temp tablespace.2. Concurrent Program is erroing out with unable to extent a perticular tablespace by so and so extents. To resolve this we have added on more data file to that tablespace.3. When we are trying to start apache with adapcctl.sh script after a autoconfig run, its saying that “node id is not matching with the application server id”. To resolve this we have updated the server id column in fnd_nodes table with the server id value in dbc file.
42. How to skip copy portion while applying a patch?
Ans : Adpatch options=nocopyportion
43. How to merge patches and what type of patches can be merged?
Ans : 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
44. What are the prompts you get when you invoke adadmin?
45. What does adadmin do when it runs Re-create grants and synonyms for apps schema option?
46. How do you invoke adadmin session in non-interactive mode?
47. On a multi-node architecture, on which node do you invoke ad-utilities?(adadmin,apatch and adconfig)
48. Do you need Oracle EBS database to be up in order to run ad-utilities? Why?
49. What do you do when an adadmin session fails or errors out?
50. Can we invoke more than one adadmin session simultaneously? If so when? If not Why?
AD utilities Interview Questions/FAQs Part1
