APPS DBA Interview Questions Oracle DBA1. Where is Concurrent Manager Log file location Ans By default standard location is APPLCSFAPPLLOG, in some cases it can go to FNDTOPlog as well. How you put Applications 1. Maintenance modeSupported Virtualization and Partitioning Technologies for Oracle Database and RAC Product Releases. Installing Oracle Grid Infrastructure and Oracle Real Application Clusters. This chapter explains how to install Oracle Real Application Clusters Oracle RAC and. Ans Use adadmin to change maintenance mode in EBS. If you dont want to put EBS in maintenance mode you can use adpatch optionshotpatch feature. Can you apply patch without putting Applications 1. Maintenance mode Ans Yes, use optionshotpatch as mentioned above with adpatch. IajAnngmA6I/UJ6QBk-q7wI/AAAAAAAAAsA/k42sltMqe7U/s1600/asm_add_6.jpg' alt='How To Apply Patch On Rac Database' title='How To Apply Patch On Rac Database' />What is adsplice utility Ans Adsplice in oracle apps is utility to add a new product to EBS5. How can you license a product after installationAns You can use ad utility adlicmgr to license product in Oracle Apps. What is MRC What you do as Apps DBA for MRC Ans MRC also called as Multiple Reporting Currency in Oracle Apps. By default you have currency in US Dollars but if your organizations operating books are in other currency then you as apps DBA need to enable MRC in Apps. Where is Jserv configuration files stored Ans Jserv configuration files are stored in IASORACLEHOMEApacheJservetc. Where is applications startstop scripts stored Ans Applications startstop scripts are in directory COMMONTOPadminscriptsCONTEXTNAME9. How to check if Oracle Apps 1. System is Rapid Clone enabledAns For system to be Rapid Clone enabled, it should be Autoconfig enabled. You should have Rapid Clone Patches applied. What is your Oracle Apps 1. Webserver Version and how to find it Ans In order to find version under IASORACLEHOMEApacheApachebin Execute. Where is database plssql cache stored Ans plssql session cache are stored under IASORACLEHOME Apachemodplsqlcache directory. What is RRAFNDFSAns Report Review Agent RRA also referred by executable FNDFS is default text viewer in Oracle Applications 1. How to confirm if Report Server is Up Running Ans Report Server is started by executable rwmts. Node this file is under ORACLEHOMEbin Execute command on your server like ps ef grep rwmts. How to confirm if Apps Listener is Up Running Ans lsnrctl start APPSSID replace SID with your Instance Name so if your SID is VISION then use lsnrctl status APPSVISION1. Oracle Database 11g Release 2 RAC On Linux 6. Using VirtualBox. Oracle Database. List of Bugs Fixed. Release 2 10. 2. 0. Patch Set 3. February 2008. This document lists the generic bugs fixed in the Oracle Database 10 g. Can you apply patch without putting Applications 11i in Maintenance mode Ans Yes, use optionshotpatch as mentioned above with adpatch. Applying CPU Patch in a DataGuard Physical Standby Database Configuration I seen lot of questions in OTN on patching of DataGuard, Recently I have applied CPU Patch. This Document shows the step by step of installing and setting up 2Node EBusiness Suites R 12. R1 RAC database managed by 11gR2 Grid Infrastructure. Managing Oracle Software and Applying Patches. Century 1081 Pool Pump Duty Manual. Oracle issues product fixes for its software called patches. When you apply the patch to your Oracle software. Oracle Accreditation Program Increase your productivity by using Oracles Accreditation Program our new framework to accelerate your knowledge of our Oracle. Helmuts RAC JEE Blog. Please use the menu bar to navigate through around 400 RAC Linux Virtualbox Java EE articles Menu and widgets. How will you find total number of invalid objects in database Ans SQLPLUS select count from dbaobjects where status like INVALID 1. How to compile Invalid Objects in database Ans You can use adadmin utility to compile or you can use utlrp. Oracle Database to compile Invalid Database Objects. What is difference between adpatch opatch Ans adpatch is utility to apply oracle apps Patches whereas opatch is utility to apply database patches. Can you use both adpatch opatch in AppsAns Yes you have to use both in apps, for apps patches you will use adpatch utility and for applying database patch in apps you will use opatch utility. What is forms server executable Name Ans f. Where is HTML Cache stored in Oracle Apps Server Ans Oracle HTML Cache is available at COMMONTOPpages for some previous versions you might find it in OAHTMLpages. What is GWYUID Ans GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUBPUB2. What are. odf file in apps patchAns odf stands for Object Description Files used to create tables other database objects while applying a patch. Does APPSMRC Schema exist for MRC in 1. Ans No, appsmrc schema is dropped with 1. Cheats Counter Strike Condition Zero Gratis. Upgrade 1. 1. Install. This is replaced by more Integrated Architecture. Find application server versionAns FNDPRODUCTGROUPS2. How will you find the Apache, forms, reports version in an EBS suiteAns http v Apachef. Formsar. 60run Reports. Find jinitiator version Ans Client side Control panel. Server side SIDhostname. List some ad utilities and their functionsAns adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker. List out the modules related to oracle Apps DBA Ans FND Application Object Library, AU Application Utilities, AD Application DBA2. What are profile options, what are various types of profile options Ans User, application, responsibility and site. If the patch is running in Pre Install mode, where would the patch history files be stored in Oracle Applications R1. UNIX operating system A ADTOPadmin. B APPLTOPadmin. C TEMPrun. Installer. D APPLTOPadminE COMMONTOPadminAns D3. In which three cases is it most effective to run validation on the APPS schema in the Oracle Applications R1. E Business Suite setup Choose three. A before performing an export or import. B after a patch or multiple patches are applied. C Immediately after an upgrade or after applying a maintenance pack. D after converting to multiple organizations or multiple reporting currencies. E whenever you receive a run time error that suggests that a problem is caused by the ADDDL package. Ans B,C,E3. 2. The AD Administration task utility Compile APPS Schema is similar to the Validate APPS Schema task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple workers in an attempt to move them back to the valid object state. This task is most often run when custom packages are moved into the APPS schema, and during the upgrade process. The Compile APPS Schema task can be toggled to compile all objects or just the invalid objects. Choose three correct benefits of using this task. Choose three. A increases run time performance in the applications. B corrects all corrupt schema package bodies and headers. C finds truly invalid objects before users get a run time error. D allows new custom or patched packages to be immediately validated. Ans A,C,D3. 3. Which two tasks can you perform with the Application DBA AD Controller utility Choose two. A Restart a failed patch. B Review the worker status. C Assign a job to the worker. D Restart a completed worker. E Restart a terminated worker. Ans B,E3. 4. You downloaded an HRMS patch from Oracle Meta. Link, and you run Auto. Patch to apply it to the Oracle Applications R1. If Auto. Patch shows an error in one of the workers jobs, how do you determine the source of the errorA Check the Auto. Format Factory For Windows 7 Full Version'>Format Factory For Windows 7 Full Version. Patch log file for the source of the error. B Review adworkxxx. APPLTOPadminlog. C Use the AD Controller utility, and choose the Review worker status. D Search the Oracle Meta. Link Web site for the worker control number. Ans B3. 5. In Oracle Applications R1. E Business Suite, what is the best method to relink the Application DBA AD executable programs A Use AD Administration adadmin. B Use the AD Controller utility adctrl. C Use Auto. Config to relink adautocfg. D Use the AD relink command line utility adrelink. Ans D3. 6. One of the special AD Controller utilities, Show Worker Status, collects worker status information from the FNDINSTALLPROCESSES temp table. It tracks multiple workers for five categories Worker, Code,Context, File Name, and Status. The seven statuses are Failed. Completed. Waiting. FixedRestart. Running. Assigned. Restarted. Choose the sequence that would place the process statuses in the proper flow order when an in processing error is received. A 5, 1, 4, 6, 7, 3, 2. B 1, 3, 4, 6, 7, 5, 2. C 3, 6, 5, 1, 4, 7, 2. D 7, 3, 6, 5, 4, 1, 2. E 6, 1, 4, 3, 5, 7, 2. Ans C3. 7. Oracle Applications Release 1. Context files to store all application specific configuration information.