Oracle Apps is widely used by companies worldwide. As organizations continue to rely on these applications for their operations, the need for skilled Oracle Apps DBAs remains high. If you are preparing for a job interview related to Oracle Apps DBA, knowing what to expect during the interview process is essential. This article will give an idea of the commonly asked Oracle Apps interview questions and answers for both freshers and experienced ones.
If you're looking for Oracle Apps DBA Interview Questions for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle Apps DBA has a market share of about 0.8%. So, You still have the opportunity to move ahead in your career in Oracle Apps DBA Development. Mindmajix offers Advanced Oracle Apps DBA Interview Questions 2023 that help you in cracking your interview & acquire a dream career as an Oracle Apps DBA Developer.
|If you want to enrich your career and become a professional in Oracle Apps DBA, then enroll in "Oracle Apps DBA Training". This course will help you to achieve excellence in this domain.|
We have categorized Oracle Apps DBA Interview Questions into 2 levels they are:
Yes, We can run unless you are running a process where workers are involved
No, because it will create tables while running the first session when you start the 2nd session it will fail due to the first
select RELEASE_NAME from fnd_product_groups;
You should see output like
SQL> select * from v$version;
The command returns the release information, such as the following:Oracle9i Enterprise Edition Release 18.104.22.168.0 – ProductionPL/SQL Release 22.214.171.124.0 – ProductionCORE 126.96.36.199.0 ProductionTNS for 32-bit Windows: Version 188.8.131.52.0 – ProductionNLSRTL Version 184.108.40.206.0 – Production
Opatch is a utility to apply database patch, In order to find opatch version execute”$ORACLE_HOME/OPatch/opatch version”
You can check OPatch -lsinventory
select count(*) from dba_objects where status =’INVALID’
|Explore Latest Article on Oracle DBA Interview Questions that help you grab high-paying jobs.|
The top is an operating system command, it will display the top 10 processes that are taking high CPU and memory. 8. What is a patch? A patch can be a solution for a bug/it can be a new feature.
one-off, mini packs, family packs, maintenance packs, rollup patches, consolidated patches.
A one-off patch is a small patch of (20-90K size) without any pre-req’s
A mini pack is one that will upgrade any product patchset level to the next level like AD.H to AD.I
A Family Pack is one that will upgrade the patchset level of all the products in that family to particular patchset level.
A maintenance pack will upgrade applications from one version to another like 11.5.8 to 11.5.9
|Learn Managing Oracle Database Control File|
A rollup patch is one that will deliver bug fixes identified after the release of any major application versions like 11.5.8/11.5.9
Consolidated patches will come into the pictures after upgrades from one version of applications to another, all post-upgrade patches will a consolidated and given as consolidated patch.
A patch can deliver a solution for more than one bug, so ad_applied_patches may not give u the perfect information as in the case of ad_bugs.
Apps and system passwords
A patch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g, and u drivers
FND_INSTALL_PROCESSES table will store the worker information like what job is assigned to which worker and its status. AD_DEFERRED_JOBS will come into the picture when some worker is failed, it will be moved to AD_DEFERRED_JOBS table, from where again adpatch will take that job and try to resign, after doing this 3 times if still that worker is failing, then adpatch will stop patching and throw the error that particular worker has failed. We need to troubleshoot and restart the worker.
c,d,g on concurrent node and c, g on web node. If it is a u-driver we need to apply it on all nodes.
Yes. why because adpatch will connect to the database and update so many tables etc…..
We need to take the backup of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables and restart the directory at APPL_TOP/admin/SID and then use adctrl to quit all the workers. Then apply the pre-req patch, after that rename u r restart directory to its original name, and create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables from the backup tables. Start adpatch session and take the options want to continue the previous session.
Adctrl is one of the adutilities, which is used to check the status of workers and to manage the workers.
Check the status of workers, tell the manager that the worker has quieted, restart a failed worker, etc….
We can skip a worker using option 8 in actual which is hidden. We will go for skipping a worker when we have executed the job which the worker is supposed to do.
With every patch a file called b.ldt file will be delivered which contains the pre-req information. adpatch load this into the database using FNDLOAD and check, whether those pre-req patches were applied or not.
FNDLOAD is a utility that is similar to SQL loader but loads code objects into the database, whereas SQL LOADER loads data objects into the database.
C-drive copies the files from the patch unzipped directory to the required location in your application file system. Before copying it will check the file version of the existing file at the file system with the file version of the file in the patch. If the patch file version is higher than what it is at the file system level then only the c-driver will copy that files.
With each patch, a file with the name f.ldt is delivered, which contains the file versions of the files delivered with the patch. Adpatch will use this file to compare the file versions of files it delivering with the file on the file system.
|Explore Latest Article on Oracle Performance Tuning Interview Questions that help you grab high-paying jobs|
adwork01,adwork02…… and location is APPL_TOP/admin/SID/log
When u unzip a patch it will keep all the files related to a particular product under that directory inside u r patch directory for example if the patch delivering files related to the FND product then it will create a subdirectory under the patch directory with the name FND in which it will put all related files to that product
When we apply a patch it will keep the copy of the files which it's going to change in the file system.
1. Interactive – default mode
2. Non-interactive – Use defaults files to store prompt values
(adpatch defaultsfile= interactive=no)
3. Test – Without actually applying a patch just to check what doing. (adpatch apply=no)
We have our custom scripts that are scheduled to run at a specific time which will monitor whether applications and databases are up/not. And it will mail us if some processes are not running. And we have one script which will check the database alert log for ORA errors and mails it to us. Based on this we will react.
Usually, we will get the ORA errors like unable to extend the tablespace by so and so size. And we will check those tablespaces for space, if space is not there we will resize the data file and add one more datafile.
bytes column in dba_free_spaces and dba_data_files
Temp tablespace is used by so many application programs for sorting and other stuff. Its size is between 3 to 10 GB.
Autoconfig is a utility that is used to maintain the application environment and configuration files.
Context file name and apps password
Context file is a central repository, which stores all application configuration information. The name is like _ .xml
Open any env / configuration files, the first few lines will tell u that these files are maintained by autoconfig.2. Ifcontextname.xmlfile is there in APPL_TOP/admin
Autoconfig will go to each and every top template directory take the templates from there and fill the values from the XML file and create the required files.
Autoconfig will run in 3 phases.
1. INIT – Instantiate the drivers and templates
2. SETUP – Fill the templated with values from XML and create files
3. PROFILE – Update the profile values in the database.
Adconfig will create a restore.sh script at $APPL_TOP/admin//out/. This restore.sh will copy the backed-up files before autoconfig run to its original locations. But the profile values updated in the database can’t be restored back.
adchkcfg.sh script at AD_TOP/bin. This script will run auto-config in test mode and create the difference file which tells us what is going to change when u actually run autoconfig.
Ans: If we have appsutil directory under RDBMS_ORACLE_HOME
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
|Oracle Apps DBA Training||Dec 09 to Dec 24||View Details|
|Oracle Apps DBA Training||Dec 12 to Dec 27||View Details|
|Oracle Apps DBA Training||Dec 16 to Dec 31||View Details|
|Oracle Apps DBA Training||Dec 19 to Jan 03||View Details|
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies