1.
You have done a single-node installation of Oracle Applications R12 on node 1. Because of some resource issues, you move only DB_ORACLE_HOME(10.2.0.2) and the database (.dbf files) to a new server (node 2). Which statement is correct about uXXXXXX.drv being applied to node 1 and node 2?
2.
Your Oracle Applications system, which is configured across three nodes, is reporting a problem. The solution is to apply patch # 456789. The system is configured such that node 1 houses the database server, node 2 houses the concurrent processing server, and node 3 hosts the Web and the Forms servers. Identify the nodes on which you would run an adpatch session to apply the patch.
3.
Tim has a two-node configuration of Oracle Applications. The configuration of the system is such that the database server, concurrent processing server, and the reports server reside on node 1, whereas the Web server and the Forms server reside on node 2. As an Applications DBA, he is required to patch the Oracle Applications system to fix a bug. To save time, Tim decides to apply the patch on both the nodes simultaneously. Identify the step that he can perform on both the nodes simultaneously as part of the AutoPatch session.
4.
Which piece of information is captured as part of the Patch Impact Analysis of a particular patch?
5.
You have to patch an Oracle Applications environment configured on a UNIX node. To start an AutoPatch session, you log in to the application-tier server node as the applications file system owner. You enter adpatch at the command prompt and get the following error: "-bash: adpatch: command not found" On closer observation, you find that the applications environment is not set. Which file would you run to set the Oracle Applications environment?
6.
Which operating system username would you use to connect to an Oracle Applications system to run an AutoPatch session?
7.
Sam has to apply a patch on his Oracle Applications system. He has already brought down the services on the application tier. The database tier and the database listener are up and running. He goes through the readme of the patch and discovers that three prerequisite patches need to be applied on the system before applying the main patch. Now, Sam needs to check if these prerequisite patches have already been applied to the system, so he decides to extract this information from the database. Identify the tables that would help him in extracting the above information from the database. (Choose all that apply.)
8.
Where is the AutoPatch executable located in Oracle Applications R12?
9.
Which executable is used by Oracle Applications to invoke an AutoPatch session?
10.
As an Applications database administrator (DBA), you have the task of updating the level of Accounts Payable. Oracle recommends applying the patch number 123456. Which program should you use to update the Accounts Payable level?