Otherwise, the patch should be applied in normal mode. Please check the read me of the patch you are applying in pre install mode. It would typically show the files and file versions installed by the patch. By checking the file versions in the read me is the easy way to verify if the patch is installed.

AutoPatch stores patch information in the database automatically each time it successfully applies a patch. However, if the patch is not applied successfully, or when you run AutoPatch in pre-install mode, patch history is not written directly to the database, but instead is written to these patch information files:. Each time you run AutoPatch, it checks this directory for the existence of the patch information files.

If it finds them, it automatically uploads the information they contain to the patch history database. If the upload is successful, AutoPatch then deletes the files from the directory. The AutoPatch log file records whether the upload was successful or unsuccessful. Most of the questions is frequently asked by any of interviewer.

Oracle Apps DBA Training

The explanation is very descriptive. I have few questions. Can you please answer. If funtional team need to run the one concurrent request and the report output needs immediately, As as DBA how we approach. How to identify and how to improve the performance.

Thanks a lot in Advance. Srinivas — Thanks for your comment. I will include your questions in above post with answers. Very nice explanation.

Oracle apps DBA interview questions

Thorough ones. Desire to have more. Please continue to share your knowledge. Name optional. Email optional. The list is updated frequently, so keep coming for updated version of this page. 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. GUEST account is used to obtain the decrypted value of the apps password for internal processes i. 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. This configuration file specifies the maximum number of HTTP requests that can be processed simultaneously, logging details, and certain limits and time outs. The parameters defined in this file can be tweaked, which will impact the performance of http apache server.

One reason can be huge log file of above 2 gb because of which Apache process is unable to write to it coz of OS limitations. After clonning or installing an Oracle Applications Release About Latest Posts. Brijesh Gogia. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies and to write about them.

You can connect with me on LinkedIn. When to use which table? So this table holds information about all bug fixes that have been applied. Even if this patch have been included in other patch. If 2 patches happen to have the same name but are different in content eg. Explain briefly, how the connection of the forms server works? The forms server is that server which the forms are hosted. The forms server can be hosted from more than one node and the load balancing can be implemented with the forms. The forms user interface is used in the desktop clients for working in Oracle Applications.

The forms listener is already started, and listens for these requests. Forms runtime engine loads module s needed to run the requested form. There are different components with RapidClone that are used when cloning an Oracle Applications instance. These are:.

Oracle EBS Interview Question And Answers

This is used for cold backup. When running this command you will have to recreate the control files manually. The preinstall mode is used when Oracle may require the install of a patch before running AutoInstall to install or upgrade Oracle Applications. Otherwise, the patch should be applied in normal mode. Please check the read me of the patch you are applying in pre install mode. It would typically show the files and file versions installed by the patch. By checking the file versions in the read me is the easy way to verify if the patch is installed. AutoPatch stores patch information in the database automatically each time it successfully applies a patch.

However, if the patch is not applied successfully, or when you run AutoPatch in pre-install mode, patch history is not written directly to the database, but instead is written to these patch information files:.

Visitor's Counter (Since 25th Dec 2007)

Each time you run AutoPatch, it checks this directory for the existence of the patch information files. If it finds them, it automatically uploads the information they contain to the patch history database. If the upload is successful, AutoPatch then deletes the files from the directory. The AutoPatch log file records whether the upload was successful or unsuccessful. Most of the questions is frequently asked by any of interviewer. The explanation is very descriptive. I have few questions. Can you please answer.

• free download motocross for mobile.
• Oracle Apps DBA Interview Questions & Answers.
• graffiti fonts for android phones!
• free online dating sites app!
• Oracle Apps DBA Related Tutorials!
• Oracle Application DBA Posts: Apps Interview Questions (11i &R12)?
• kindle books on samsung galaxy ace.

If funtional team need to run the one concurrent request and the report output needs immediately, As as DBA how we approach. How to identify and how to improve the performance. Thanks a lot in Advance. Srinivas — Thanks for your comment. I will include your questions in above post with answers.

Very nice explanation. Thorough ones.

• Please Search In This Blog?
• download ifile cho iphone 3g 3.1.3.
• See a Problem?;
• Oracle Apps DBA Interview Questions!
• pokemon crystal for blackberry curve 9220.
• CRACKING the Oracle Apps DBA INTERVIEW: 325 Frequently Asked Questions.
• t mobile windows phone apps!

Desire to have more. Please continue to share your knowledge. Name optional. Email optional. You don't have to do any thing manually for Global oraInventory. AD Identification. How will you take the forms trace? List some profile options with their function? What is. List out the modules related to oracle Apps DBA? Where is Concurrent Manager log file location? What is multi node system? Whats main concurrent Manager types.

Can you apply patch without putting Applications 11i in Maintenance mode? Where is Jserv configuration files stored?