Oracle EBS 12 2 Upgrade Overview by K21Academy
Frequently asked Oracle APPS DBA questions and links for answers. Latest Interview Questions for Oracle APPS DBA Click on answers for a detailed explanation. – What are the different phases of the ADOP cycle Answer – Steps to apply EBS 12.2 patches using adop Answer – Why oracle recommends an odd number of voting disks Answer …
Why Upgrade To EBS R12?
Enroll in Oracle Apps DBA Training from Real-Time Experts
Q31. Where are .fmb (Forms) stored
They will be under $AU_TOP/forms/US.
Q32. When you run f60gen to compile the forms : .fmx will be put to where ?
$PRODUCT_TOP/forms/US/ of respective product of form.
Q33. What is stored in “mesg” directory under each product top ??
“mesg” contains language specific message files and error message for the product.
Q34. What is stored in “bin” directory under each product top
“bin” directory contains executable files like in $AP_TOP/bin you will see APPBCF APTZGF apxamex.ctl apxboav.ctl apxdiner.ctl apxgecmc.ctl apxusbv.ctl APXXTR
Q35. How to compile apps schema and when to compile?
You can use “adadmin” utility to compile apps schema (other methods like utlrp.sql exists). Usually you compile apps after application of the patches, maintanance patch, upgrade, runtime error due to AD_DDL packages or scenarios where there are invalid objects in apps schema.
Q36. How many database connections are allowed during fresh installation of oracle application.
100 Connections. (Number has increased to 250 for Pluggable Databases in 12c)
Q37.Utility used to apply application patch is ?
Q38. For database patch utility used to apply patch is ??
Q39. What are .lgi files for ?
While applying patch put the system in maintenance mode by running.
Q40.By default where adadmin log file will go??
Q41. How to check what adpatch is doing ??
“adctrl” is the utility to do check status of ad worker, including adpatch.
Q42. What are various stages of adpatch worker
Q43. What is Default number of workers:
2 times the number of CPU on the database server.
Q44. Have you ever seen worker status as deferred, while using adctrl ??
Once you start applying patch , manager assigns jobs and unique ID to each worker. Manager will also insert one row into FND_INSTALL_PROCESSES table for each worker with information about who is doing what !
Q45. What happens if worker is working on some particular job say updating some table but that table is locked ??? so what the worker will do in such situation…
Q46. Why APPS schema present in the 11i application ??
Q47.Why do you need GUEST/ORACLE To connect to database?
Key points :
Q48. What is the purpose of JSERV?
Q49.What is Apache JServ?
The 100% pure Java server application that acts as an independent servlet-request server.
Q50.What is mod_jserv?
The Apache module that converts HTTP requests to servlet requests, connecting to the proper servlet engine and sending back the HTTP response to the client.
Why did you decide for a career of a pilot?
Say them that you enjoy flying, and that you believe to be a responsible person. You can also say that you have all skills and strengths needed for this type of work. Alternatively you can refer to an experience that motivated you to pursue the career, such as meeting a pilot when you were young, or having passion for aircraft models since childhood.
The key is to convince them that you really want the job, and did not apply just because you’ve already spent a small fortune on your studies and training.
How do I upgrade Oracle from EBS 11i to R12?
- Plan and prepare for the upgrade. …
- Apply the latest performance patches. …
- Lay down the file system. …
- Perform the upgrade. …
- Apply post-upgrade patches and enable Online Patching.
- Deploy customizations and integrations.
- Perform post-upgrade configurations.
How do I prepare for Oracle Apps interview?
- What is Set-of-books?
- What is a Value Set?
- What are Ad-hoc Reports?
- How to Call Who Columns Into the Form?
- How do you Find that Multiorgan is Installed?
- What are the Types of Concurrent Managers 25?
- How do you Set the Operating Unit Context in a Report?