oracle apps upgrade from 11i to r12 interview questions archives 2

These Oracle Apps DBA Interview Questions have been created specifically to familiarize you with the types of questions you may be asked regarding Oracle Apps DBA during your interview. Good interviewers, in my experience, rarely have a specific question in mind for you to answer during the interview. Instead, questions usually begin with a basic idea of the topic and develop from there based on further discussion and your response. We’ll go over the top 100 Oracle Apps DBA interview questions and their in-depth responses. Oracle Apps DBA scenario-based interview questions, Oracle Apps DBA interview questions for new hires, and Oracle Apps DBA interview questions and answers for seasoned professionals will all be covered.

Oracle Applications users are given a certain level of authority known as responsibility. There are a number of requests, forms, and menus included. Records are used for security and monitoring, so we cannot disable obligations. The effective period can, however, be given an end date in order to disable obligations. We can delete a responsibility from both backend and frontend.

Q4. In Oracle Applications, how many Oracle Homes are there, and what significance does each one have?

You can configure Oracle ApplicationsRAC to support real application clusters, which enables multiple instances to mount and open a single database. RAC requires shared disk storage and a dedicated network interconnect. When a node fails, the remaining nodes may still be able to provide database services. Then, multiple instances of Oracle run concurrently, and the data files are kept in a central location that is accessible to each instance.

Q9. What tool is used to change an application user’s password and how does it work?

Using the FNDCPASS utility, application users can modify their passwords. You must have system and applications password for running FNDCPASS.

Q17. Can I start a new session while using adpatch to apply a patch and run adadmin?

Q18. Can I start a new session in a different node and run adpatch while I’m applying a patch?

No, because the first session will create tables, and the second session will fail because of the first session.

A patch can fix multiple bugs, so the information provided by ad_applied_patches may not be as accurate as that provided by ad_bugs.

Unlike SQL LOADER, which loads data objects into databases, FNDLOAD is a utility that loads code objects into databases. It has the control file . lct and loader files are . ldt.

Context files serve as a central location for storing all application configuration data. The name is like _ . xml.

Every top template directory will be visited by Autoconfig, where the templates will be taken, filled with the values from the xml file, and the necessary files created. Templates are stored in product top/admin/template.

Oracle E-Business Suite Tech Stack R12.1.3 vs R12.2.*

Why Upgrade To EBS R12?

  • Oracle Apps DBA is in great demand and with 12.2 experience
  • Good Salary if you know 12.2 as 11i & 12.0 out of support
  • Customers on R12.1 are also looking to upgrade to R12.2 to take advantage of Online Patching feature
  • What’s New For EBS With Oracle Database 19c

    When you upgrade your Oracle E-Business Suite database to Oracle Database 19c, there are a number of required architecture updates. The main architectural modifications that are necessary are listed as follows:

  • Container Database (CDB) Architecture: With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). As part of the upgrade to Database 19c, you will convert your EBS database to the CDB architecture with a single pluggable database (PDB).
  • PL/SQL File Input/Output Directories: With Database 19c, the UTL_FILE_DIR database initialization parameter has been de-supported. As part of the upgrade to Database 19c, you must migrate all UTL_FILE_DIR database initialization parameters to database directory objects. EBS development has created a utility to migrate and manage your defined PL/SQL file input/output directories.
  • ADG DML Redirection: Previously, you could only update the Global Temp Tables on Active Data Guard standby database. From Oracle 19c, you can also update regular tables.ADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard.
  • 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 kept under each product’s top “mesg” directory?


    Language-specific message files and error messages for the product are found in “mesg.”

    Q34. What is stored in “bin” directory under each product top.


    The “bin” directory houses executable files, such as the APPBCF, APTZGF, and apxamex found in $AP_TOP/bin. ctl apxboav. ctl apxdiner. ctl apxgecmc. ctl apxusbv. ctl APXXTR.

    Q35. How to compile apps schema and when to compile?


    To compile apps schema, use the “adadmin” utility (other approaches include utlrp). sql exists). Typically, you compile apps following the installation of patches, maintenance patches, upgrades, runtime errors caused by AD_DDL packages, or situations where the apps schema contains invalid objects.

    Q36. How many database connections are permitted during a fresh Oracle application installation?


    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 ?


    Put the system in maintenance mode while applying the patch by running

  • $adadmin and then select option 5 (change maintenance mode) after that select options enable/disable maintenance mode. (You can also change system to maintenence mode using $AD_TOP/patch/115/sql/adsetmmd.sql)
  • Q40.By default where adadmin log file will go??


    Q41. How to check what adpatch is doing ??


    The utility “adctrl” is used to check the status of advertising workers, including adpatch.

    Q42. What are various stages of adpatch worker


  • First of all workers will be in “waiting” stage after that jobs will be “assigned” then “running“, If error doesn’t come it will move to “complete” (waiting -> assigned -> running -> complete)
  • If error comes it will go like waiting -> assigned -> running -> failed -> fixed -> restarted -> completed
  • Q43. What is Default number of workers:


    2 times the number of CPU on the database server.

    Q44. Have you ever used adctrl and noticed that the worker status is deferred?


    When you begin applying the patch, the manager gives each employee a job and a unique ID. For each employee, the manager will also add a row to the FND_INSTALL_PROCESSES table with information about who is doing what.

  • these two columns are important for us from the fnd_install_processes. Manager will monitor the workers by these two columns about status of the assigned job.Once worker is done with first job, manager will assign it the second job to do with the status update as .
  • Once all the worker’s status is completed for all the jobs, manager will tell the workers to shutdown and will drop fnd_install_process table.
  • Q45. What will the worker do in this situation if they are working on a specific task, such as updating a table, but the table is locked?


  • That’s the AD_DEFERRED_JOBS table which will be created at the time of FND_INSTALL_PROCESSES and ad_deferred_jobs too will be dropped with FND_INSTALL_PROCESSES. First time when worker checks and find that table is locked, that job fails and manager will automatically defers the job, and it will assigns a new job to the worker.
  • The job which was waiting in ad_deferred_jobs table will be assigned again till time it will not become failed or completed.
  • In such situation above, worker will wait till either the lock is released or timed out is reached and We (DBA) need not to take any action till the job status becomes fails…. once it shows its failed we can fix it and restart it.
  • Q46. Why APPS schema present in the 11i application ??


  • It reduces traffic because all the product schemas will grant full privileges to Apps schema. so it will have full access to the complete Oracle application.
  • All the products like AP,AR,FIN has the code for respective products and APPS will have access to all these code objectives too. Apps will have all the synonyms for base tables and sequences as well.
  • Q47.Why do you need GUEST/ORACLE To connect to database?


  • The GUEST user account is used in the application internally ( it is an application user). One of the major needs of this account is when there is a need to decrypt the APPS password (which is stored in an encrypted format in the apps tables). In order to decrypt the APPS password, the GUEST username/password is used to accomplish this task (using “Guest User Password” profile option).
  • GUEST account is used to obtain the decrypted value of the apps password for internal processes (i.e. when there is a need to connect as apps internally).
  • when the account gets locked/end-dated then you will see a blank page when you try to login to the instance.In that scenario you will have to correct this situation from the back-end as you will not be able to login to the application.
  • You will not find much details about the GUEST account documented anywhere ( may be coz of security reasons).
  • Key points :

  • s_guest_user is GUEST and s_guest_pwd is EXPORT in adconfig xml file.
  • select fnd_web_sec.validate_login(‘GUEST’,’ORACLE’) FROM DUAL; ( to validate if guest user is corrrect)
  • select fnd_profile.value(‘GUEST_USER_PWD’) from dual; (to find the current guest user password)
  • Check the GUEST/ORACLE password is present in DBC file at $FND_TOP/secure directory as well as at $FND_TOP/secure/SID_hostname directory.
  • Q48. What is the purpose of JSERV?


  • Oracle 11i uses Jserv as the servlet engine. R12 uses OC4J as the servlet engine.
  • R12 uses version 10g of the Oracle Application Server, which does not have or use jserv
  • Once you click on the Oracle E-Business Home Page link, the request is forwarded by Apache to Jserv. Jserv sends it to Appslogin servlet.
  • Q49.What is Apache JServ?


    the servlet-request server application that is made entirely of Java and operates independently

    Q50.What is mod_jserv?


    The Apache module responsible for converting HTTP requests into servlet requests, establishing a connection with the appropriate servlet engine, and returning the HTTP response to the client

    oracle apps upgrade from 11i to r12 interview questions archives 2

    Frequently asked Oracle APPS DBA questions and links for answers. Oracle APPS DBA Latest Interview Questions: Click on answers for a full explanation – How many phases are there in the ADOP cycle? – How to apply EBS 12. Answer: Why does Oracle advise using an odd number of voting disks? 2 patches using adop


    How do I upgrade Oracle from EBS 11i to R12?

    Apply the latest AD-TXK RUP. Apply the latest Oracle E-Business Suite Release 12.2 Release Update Pack (RUP). Note: You must apply the 12.2.

    Prepare the database.
    1. Upgrade the database to the most recent certified version or the bare minimum version.
    2. Migrate to a new platform (optional).
    3. Apply the latest database patches.

    Where is start/stop scripts located in 11i?

    Application Tier Scripts The Stop/Start scripts for the E-business service can be found at $ADMIN_SCRIPTS_HOME.

    What is the relation between responsibility menu and request group?

    A request group is attached to a responsibility. The concurrent programs that can be run while utilizing the responsibility to which this request group is attached are specified. You can query a request group by going to System Administrator | Security | Responsibility | Request.

    How do I prepare for Oracle EBS interview?

    Oracle EBS Interview Questions
    1. What is Oracle EBS?
    2. Why patches are required in Oracle EBS?
    3. What are the different control options in inventory?
    4. What is the flow of the service contract?
    5. What is a token?
    6. What is the control file used for?
    7. What are the types of validations in Oracle EBS?
    8. What is multi-org?

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *