3 What is the adpatch log file location?
When u unzip a patch it will keep all the files related to a particular product under that directory inside u r patch directory for example if the patch delivering files related to the FND product then it will create a subdirectory under the patch directory with the name FND in which it will put all related files to that product
3 How adpatch will know the file versions of the patch delivered files?
With each patch, a file with the name f.ldt is delivered, which contains the file versions of the files delivered with the patch. Adpatch will use this file to compare the file versions of files it delivering with the file on the file system.
| Explore Latest Article on Oracle Performance Tuning Interview Questions that help you grab high-paying jobs |
3 What are the types of Concurrent Managers 25?
Ans: Three MASTER CONCURRENT MANAGERS:
We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.
Top 50 Oracle Apps DBA Interview Questions
Yes, We can run unless you are running a process where workers are involved
3 Define the steps for customizing form?
You need to make use of the following steps for the purpose of customizing forms.
3 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= interactive=no) 3. Test – Without actually applying a patch just to check what doing. (adpatch apply=no)
2 Can you name some of the menu options in adctrl?
Check the status of workers, tell the manager that the worker has quieted, restart a failed worker, etc….
What is the purpose of cursors in PL/SQL?
The cursor can be made used for the purpose of handling various row – query associated with PL/SQL. Implicit cursors are available for the purpose of handling all the queries related with oracle. The memory spaces that are unnamed are used by oracle for storing the data that can be used with implicit cursors.
Record group can be considered as a concept used for the purpose of holding sql query that is associated with list related with values. Record group consists of static data and also can access data inside tables of database through sql queries.
This is a kind of field associated with oracle apps that are used for capturing information related with the organization.
2 What is the significance of the FNDINSTALL_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 the 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 troubleshoot and restart the worker.