Forgot your password?    
+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Oracle Apps DBA Interview Questions 2

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India

    Oracle Apps DBA Interview Questions 2

    1. What is the purpose of dbc file? How to recreate a dbc file in case it is lost?
    2. What is the purpose of FNDFS and FNDSM?
    3. What is GSM?
    4. How to trace a concurrent request?
    5. What is the purpose of Apps listener?
    6. Steps involved in Apps Cloning including post cloning steps.
    7. How to install a JInitiator manually?
    8. What is Port Pool?
    9. How to drop an apps user?
    10. What is meant by maintaining snapshot information?
    11. What does autoconfig do?
    12. Locations of all log and config files.
    13. What is OATM?
    14. Which view gives the details of CM?
    15. Name and location of log for Workflow Notification Mailer.
    16. How to apply patch without enabling maintenance mode?
    17. What if a patch fails bcoz of a pre-requisite?
    18. How to know the forms version?
    19. In case a worker process fails, how to diagnose?
    20. Difference between forms servlet and socket?
    21. How to increase the number of processes in CM?
    22. How to increase the cache size?
    23. Which is the executable for CM?
    24. ICM log files location.
    25. Apps 11i and R12 installation.
    26. How to calculate the db size?
    27. How to check if standby is in sync with production?
    28. Init parameter used to tune checkpoints.
    29. What is SGA_MAX_SIZE and SGA_TARGET?
    30. Steps involved in RMAN cloning.
    31. How to start spfile from pfile without starting the instance?
    32. What if catalog database is lost?
    33. Relation b/w commit and ckeckpoint.
    34. Relation b/w rollback and ckeckpoint.
    35. Relation b/w logswitch and ckeckpoint.
    36. What if system tablespace is lost?
    37. When is alert log file created? What if it is lost?
    38. What if suddenly listener goes down?
    39. What is ora-01555 error?
    40. What happens when tablespace is put in begin backup mode?
    41. What if top command doesn’t work?
    42. How to determine the number of CPU’s in the box?
    43. How to determine the real memory available?
    44. How to calculate the version of your OS?
    45. What is shmmax?
    46. What are Kernel parameters?
    47. What is RPM?
    48. How to resize a redolog?
    49. What does SAR cmd do?

  2. #2
    Some Interview questions I faced....

    1. What is the significance of file?
    2. Problems you faced related to jerv?
    3. What options you give while patching in you instance?
    4. How would you rename undo tablespace?
    5. What is the template directory in autoconfig?
    6. Why should we give apps password while running autoconfig?
    7. How do you change sga size with spfile? Do you need to bounce the server?
    8. If ICM goes down what happnd to the running request? Can more requests be submitted?
    9. What are the dependency associcated while exporting
    10. What is the difference between weblistener, applistener
    11. What is oacore?
    12. What is the significance of OPMN? What are the component of opmn
    13. Why do you put application in maintenance mode?
    14. How do you check no. of cpu?
    15. When does fnd_intalled_ processes and ad_deffered _jobs gets dropped.
    16. What if we don’t complie the jsp after the patch?
    17. What is port pool? What is the range of port pool?
    18. What is the location of controlfile while taking RMAN backup? how would you change the location?
    19. What is Sso? What are the benefits of using sso?
    20. How do find the concurrent users in forms, concurrent manager?
    21. How do you delete the trace files? For how long do you retain the trace files?
    22. How do you create a new instance while cloning?
    23. If all the users are reporting that is the application is slow, what would be you plan of action? How will you identify the sessions using resources?
    24. How will you trace the user session? What is event 10046?
    25. When you trace users session which utility you use to view the report on user session into readable form?
    26. What are the sort paramenters in tkprof ? and which parameter you usually provide?
    27. Can you run adpactch from other session simultaneously?
    28. How will you clone shared appl top instance?
    29. After cloning apache is not starting what will you do?
    30. What is wf_items?
    31. If a users complains to you that he is having some problem with his workflow, what will you do?
    32. A user is not able to send notification, what will you do?
    33. What are the different components of workflow?
    34. You are not able to view the the concurrent request output files, what could be the possible reason?
    35. How will you do block recovery with rman?
    36. How long does it take the backup script to take backups?
    37. What are your backup policy?
    38. What is the difference between cumulative backup and differential incremental backups?
    39. What is the difference between obsolete and expired backup in rman?
    40. How do you validate backups in you environment?
    41. How do you check corrupt blocks?
    42. How will you rename undo tablespace? What could be the possible you can face while renaming it?
    43. What is ora – 0060? How will you resolve the issue?
    44. How do you schedule the scripts for automatic backup ? how will you make it to give you a report after the backup?
    45. Can you take a cold backup with rman? If yes then how?
    46. How do you gather statistics? How frequently you do that? Who will you identify there is a need to gather statistics?
    47. What is a difference between socket and servlet? What are the advantages of using servlet mode?
    48. How do you troubleshoot the users problems? Who are your users?
    49. What options you give with adpatch while applying a patch?
    50. Have you applied Indian localization patch?
    51. What does adpreclone do?
    52. What will you do if cloning failed while running adcfgclone ?
    53. What are the main components of awr report? Which section you use frequently in awr to identify possible issues?
    54. What is opmn? Which services it manages?
    55. What is exception handling error ?
    56. Can you change the password of the database user using FNDCPASS?
    57. What is sleep, cache in concurrent manager?
    58. Lets say functional guys want to run around 500 request at a particular time, what would be your plan of action?
    59. How will you troubleshoot SSO login issues?
    60. What is difference between session timeout and limit time ?
    61. How will you change the no. of JVM in r12 ?
    62. How will you change the JVM heap size in r12 ? which line you will look for while changing in the file?
    63. How will you find the limits of resources of a user at OS level ?


  3. #3
    Oracle DBA
    Join Date
    Jan 2012
    For question No 11 please refer this url


  4. #4
    Oracle DBA
    Join Date
    Jan 2012
    For question No 12 please refer this url

  5. #5
    Oracle DBA
    Join Date
    Oct 2011
    For ques. 26, refer to link

    database size=control files size+redo log files size+datafiles size+archivelog


    For ques. 27, refer to link


    For ques. 28 fast_start_mttr_target is the initialization param
    The maximum value for FAST_START_MTTR_TARGET is 3600 seconds (one hour). If you set the value to more than 3600, then Oracle rounds it to 3600.
    The following example shows how to set the value of FAST_START_MTTR_TARGET:


    For ques. 29, refer to link


    For ques. 30, refer to link

    Last edited by vipul; 02-19-2012 at 02:36 AM.

  6. #6
    Oracle Administrator
    Join Date
    Oct 2011
    Q1. What is the purpose of dbc file? How to recreate a dbc file in case it is lost?
    Ans: dbc is database connect descriptor file, It stores database connection information used by application tier to connect to
    database. By default located in $FND_TOP/secure directory($FND_SECURE). Typical entries in dbc file are GUEST_USER_PWD, APPS_JDBC_URL,
    DB_HOST etc. DBC file is very important as whenever Java or any other program like forms wants to connect to the database, it uses dbc file.

    Q1.1 There are lot of dbc file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?
    Ans:This could be determined from profile option "Applications Database ID".

    Q2. What is the purpose of FNDFS and FNDSM?
    Ans: FNDFS or the Report Review Agent (RRA) is the default text viewer within Oracle Applications, which allows users to view report output and log
    files. The default viewer must be configured correctly before external editors or browsers are used for viewing requests

    FNDSM is the Service manager. FNDSM is executable & core component in GSM ( Generic Service Management Framework ). You start FNDSM
    services via APPS listener on all Nodes in Application Tier

    Q3. What is GSM?
    Ans: GSM stands for Generic Service Management Framework. Oracle E-Business Suite consist of various compoennts like Forms, Reports, Web Server,
    Workflow, Concurrent Manager .. Earlier each service used to start at their own but managing these services (given that) they can be on various
    machines distributed across network. So Generic Service Management is extension of Concurrent Processing which manages all your services , provide
    fault tolerance (If some service is down ICM through FNDSM & other processes will try to start it even on remote server) With GSM all services are
    centrally managed via this GSM framework.

    Q4. How to trace a concurrent request?
    Ans: Enable Trace by following the below Steps ..........
    Login as Sysadmin -> System Administrator -> Concurrent : Program -> Define
    Press F11 -> Enter the COncurrent Program Name (Eg. Active Users) -> Press Ctrl + F11
    Enable the check box “Enable Trace” above “Copy To” button.
    Click on Save.
    Close the window.
    Select Requests -> Run
    Submit the concurrent request.

    After completion or during execution of the request, you should see a trace file generated on the database server under udump directory.

    SQL to identify the trace file

    select oracle_process_id from fnd_concurrent_requests where request_id=[request_id];

    DB Node
    cd $ORACLE_HOME/admin/[SID]_[hostname]/udump
    ls -latr *[oracle_process_id]*.*

    Alternatively ....
    1. How to Generate Trace File ?

    Enable Tracing For The Concurrent Manager Program

    Select the Enable Trace Checkbox

    Note : Checking the Trace Check box on the Concurrent Program gives an Event 10046 Level 8 trace. So even if the trace is set for Binds and Waits on the Submission form once the concurrent program is encountered in the trace it will reset to level 8 so no binds will be present in the trace after that point.

    Turn On Tracing

    Responsibility- System Administrator
    Navigate: Profiles > System
    Query Profile Option - Concurrent: Allow Debugging
    Set profile value = Yes
    Run Concurrent Program With Tracing Turned On

    •Logon to the Responsibility that runs the Concurrent Program
    •In the Submit Request Screen click on Debug Options (B)
    •Select the Checkbox for SQL Trace


    If the Debug option is greyed out & not updateable set the profile Concurrent: Allow Debugging to Yes

    Q5. What is the purpose of Apps listener?
    Ans: In order for the Application to be able to view the output and log file of the reports after they have been run by the Concurrent Manager, the application listener should be up. Some other tools like ADI also require the listener to be up to retrieve reports output. If the listener is down and you try to view a concurrent request output/log file, you will get the following error:
    Error ......................
    "An error occurred while attempting to establish an application file server connection with the node <HostName>. There may be a network configuration
    problem, or the listener on node <HostName> may not be running. Please contact your system administrator".

    In short
    Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM.
    Last edited by pkumar; 02-19-2012 at 07:39 AM.
    Cheers !

  7. #7
    Oracle DBA
    Join Date
    Jan 2012
    QNO-13 What is OATM ?

    Ans-Oracle Applications Tablespace Model - OATM
    Oracle Applications Tablespace Model - OATM

    The Oracle Applications Tablespace Model was another long awaited feature that got introduced in 11.5.10.Prior to 11.5.10 by default each of the oracle applications product would have two dedicated tablespace holding the data element and the other for storing the index eg GLD (For General Ledger base tables) and GLX (For indexes relation to the General Ledger product).This easily resulted in some 300 odd tablespaces to manage apart from the system, temp and the rollback tablespaces.

    In the new Oracle Applications Tablespace Model (OATM) all these product related tablespaces have been consolidated in two main tablespaces one for holding the base tables and the other for holding the related indexes. Apart from these two tablespace you have an additional ten tablespaces including system tablespace undo tablespace and the temporary tablespace. Thereby reducing the total number of tablespace in the OATM to twelve.

    Apart from the obvious ease of management and administration with a reduced number of tablespace being involved the OATM also provides benefits like efficient space utilization. This is achieved by supporting locally managed tablespaces as opposed to the dictionary managed tablespace in the previous model.

    OATM also supports uniform extent allocation and auto allocate extent management. In uniform extent management all the extents have the same size and result in less fragmentation. Auto allocate extent management allows the system to determine the extent sizes automatically.

    OATM also provides additional benefits when implementing Real Application Clusters (RAC) in Oracle Applications.

    Under the OATM the following twelve tablespaces are created as a default.
    • APPS_TS_TX_DATA - This tablespace hold the translational tables of all Oracle Applications products. For example the GL_JE_HEADERS will be a part of APPS_TX_DATA.
    • APPS_TS_TX_IDX - All the indexes on the product tables are kept under this tablespace.
    • APPS_TS_SEED - The seeded data that is setup and reference data tables and indexes form this tablespace. For example your FND_DATABASES table would reside in the APPS_TS_SEED tablespace.
    • APPS_TS_INTERFACE - All the interface tables are kept in this tablespace for example the GL_INTERFACE table.
    • APPS_TS_SUMMARY - All objects that record summary information are grouped under this tablespace.
    • APPS_TS_NOLOGGING - This tablespace contains the materialized views that are not used for summary purposes and other temporary
    object that do not require redo log entries.
    • APPS_TS_QUEUES - With the support for advanced queuing in Oracle Applications, the advanced queue tables and related objects form a part of this tablespace.
    • APPS_TS_MEDIA - This tablespace holds multimedia objects like graphics sound recordings and spital data.
    • APPS_TS_ARCHIVE - Tables that are obsolete in the current release of Oracle Applications 11i are stored here. These tables are preserved to maintain backward compatibility of custom programs or migration scripts.
    • UNDO - The undo tablespace is used as automatic undo management is enabled by default in 11.5.10.This acts as a replacement to red log files.
    • TEMP - The Temp tablespace is the default temporary tablespace for Oracle Applications.
    • SYSTEM - This is the SYSTEM tablespace used by the Oracle Database.

    For all new installation of 11.5.10 OATM is available as a default install. For prior applications system you can migrate your existing tables spaces to the oracle applications tablespace model.

    The TMU is a Perl based interactive utility that helps in migrating the oracle applications schemas to implement the OATM.

  8. #8
    Oracle DBA
    Join Date
    Jan 2012
    15. Name and location of log for Workflow Notification Mailer.

    Ans: It is under $APPLCSF/$APPLLOG directory (search for FNDCPGSC*.txt).

  9. #9
    Oracle Administrator
    Join Date
    Oct 2011
    *How to resolve the PATCHING problem.
    *What if any worker hangs.
    *What if the PATCH hangs due to PREREQ patch.
    *How to skip a Worker while patching.
    *How to apply multiple patches simultaeneously? What are the measures you will take to speed up the patching process?
    *Why adpreclone is run in cloning?
    *How to clone from multiple nodes to single node.
    *What are the post clone steps.
    *What will you do if you are not sure of the behaviour of applications after running autoconfig.
    *What is the role of the autoconfig.
    *What is the difference between shared appl top and shared application tier file system.
    *How to add a node in applications?
    *What will you do if any SQL is not working.
    *What are the different type of indexes?
    *What is the command to rebuild indexes?
    *What is the recycle bin in ORACLE?
    *What is SHARED POOL?
    *What is REDO LOG BUFFER?
    *What is the procedure for INSTANCE_RECOVERY?
    *What is difference between COMPLETE and INCOMPLETE recovery?

  10. #10
    Oracle Administrator
    Join Date
    Oct 2011
    Bro. If you are having the answers to these posted questions. then please post it here merely posting question will not help? One has to spend a lot of time to dig into these if somebody is not aware of anything. What you say ?
    Cheers !

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Oracle apps dba interview questions
    By mdmasood in forum Oracle Applications Interview Questions
    Replies: 9
    Last Post: 06-13-2013, 01:11 PM
  2. Oracle DBA Interview Questions
    By Hemant in forum Oracle Database Interview Questions
    Replies: 1
    Last Post: 06-06-2012, 04:01 PM
  3. Oracle Apps DBA Interview questions
    By devesh_ocp in forum Oracle Applications Interview Questions
    Replies: 0
    Last Post: 04-26-2012, 11:51 AM
  4. Oracle Interview Questions (Contains DBA and Developer Questions)
    By Pradeep in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-29-2012, 05:13 AM
  5. Here are some possible Oracle DBA Interview Questions:
    By Akhil Kumar in forum Oracle Database Interview Questions
    Replies: 0
    Last Post: 02-12-2012, 04:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics