Oracle Apps DBA
10+ Oracle Apps DBA Interview Questions and Answers
Q1. What is oracle application database administrator?
An Oracle Application Database Administrator is responsible for managing and maintaining the Oracle database used by Oracle Applications.
Responsible for installation, configuration, and upgrading of Oracle database
Ensures database security and performance optimization
Manages backup and recovery processes
Performs database monitoring and troubleshooting
Responsible for user management and access control
Works closely with developers and system administrators
Provides support and r...read more
Q2. If one of the application top get deleted how to restore?
To restore a deleted application top, use adadmin utility to recreate the application top.
Use adadmin utility to recreate the application top
Select option 2 (Maintain Applications Files menu)
Select option 1 (Maintain Applications Files)
Select option 2 (Copy Oracle Applications Files to the File System)
Enter the application short name and version to recreate the application top
Q3. Can we apply ebs patches using adpatch in EBS 12.2?
Yes, we can apply EBS patches using adpatch in EBS 12.2.
Adpatch is the standard utility for applying patches in EBS.
It can be used to apply patches to both the application and database tiers.
Adpatch can be run in interactive or non-interactive mode.
It is recommended to apply patches in a test environment before applying them in production.
Adpatch logs can be found in the $APPL_TOP/admin/
/log directory.
Q4. Issue faced on client side and resolution for that.
Client faced issue with concurrent request and resolved by increasing the number of processes.
Client reported slow performance while running concurrent requests.
Checked the number of processes and found it to be less than required.
Increased the number of processes and tested the concurrent request again.
Performance improved and issue resolved.
Q5. Start stop sequence of erp application and database. Impact if sequence get wrong
Start stop sequence of ERP app and DB. Impact if sequence gets wrong.
Start DB first, then ERP app
Stop ERP app first, then DB
Wrong sequence can cause data corruption or loss
May result in incomplete transactions or errors during startup
Q6. How user login flow happens for ERP?
User login flow for ERP involves authentication, authorization, and session management.
User enters credentials on login page
Credentials are verified against database
If credentials are valid, user is authenticated and authorized to access ERP modules
A session is created for the user
User can access ERP modules until session expires or user logs out
Share interview questions and help millions of jobseekers 🌟
Q7. What is load balancer? Use of it!
A load balancer is a device that distributes network traffic across multiple servers to improve performance and availability.
Load balancers can improve website or application performance by distributing traffic evenly across multiple servers.
They can also improve availability by redirecting traffic to healthy servers in case of server failure.
Load balancers can be hardware or software-based and can be configured to use different algorithms for traffic distribution.
Examples of...read more
Q8. Why index rebuild is so important.
Index rebuild is important for improving database performance.
Rebuilding indexes helps to remove fragmentation and improve query performance.
It also helps to reduce disk I/O and improve overall database efficiency.
Regular index rebuilds can prevent index corruption and improve database stability.
Index rebuilds can be scheduled during off-peak hours to minimize impact on users.
Examples of tools for index rebuilds include Oracle Enterprise Manager and SQL*Plus.
Oracle Apps DBA Jobs
Q9. Did you know about oracle secure backup
Yes, Oracle Secure Backup is a tape backup management software for Oracle databases.
Oracle Secure Backup provides centralized management of tape backup and recovery operations for Oracle databases.
It supports various tape devices and media types.
It offers encryption and compression options for backup data.
It can be integrated with Oracle Recovery Manager (RMAN) for seamless backup and recovery.
It also provides reporting and monitoring features for backup operations.
Q10. Why form taking time to load.
Forms may take time to load due to various reasons.
Network latency
Heavy database queries
Large number of concurrent users
Inefficient coding
Insufficient hardware resources
Q11. How to add DMZ node.
To add DMZ node, we need to configure the DMZ server and add it to the existing Oracle E-Business Suite environment.
Configure the DMZ server with the required software and patches.
Create a new context file for the DMZ node.
Update the DMZ context file with the required parameters.
Run the AutoConfig on the DMZ node.
Add the DMZ node to the existing Oracle E-Business Suite environment.
Configure the firewall to allow traffic between the DMZ node and the internal network.
Test the D...read more
Q12. If input/output error encountered.
Input/output error indicates a problem with reading or writing data to a storage device.
Check if the storage device is properly connected and functioning.
Check if the file system is corrupted.
Check if there is enough space on the storage device.
Check if there are any hardware issues with the storage device.
Check if there are any software issues with the operating system or application.
Try to recover the data from backups or use data recovery tools.
Q13. No. EBS 12.2 supports only adop to apply patches
Yes
EBS 12.2 supports the use of adop (Application DBA Online Patching) utility for applying patches
adop is a tool provided by Oracle for patching and maintaining Oracle E-Business Suite (EBS) environments
It allows for online patching, which means that patches can be applied while the system is still running
adop provides features like patching in parallel, patching multiple nodes simultaneously, and rolling back patches if needed
It also provides a unified patching process for ...read more
Q14. How to do troubleshoot EBS R12.2 Login issue?
To troubleshoot EBS R12.2 login issue, check for incorrect login credentials, session timeout, browser cache, and server connectivity.
Verify the correctness of login credentials entered by the user.
Check for session timeout settings in EBS R12.2.
Clear browser cache and cookies to eliminate any login issues caused by stored data.
Ensure proper server connectivity to the EBS R12.2 instance.
Q15. Why report is running slow.
Reports can run slow due to various reasons.
Inefficient SQL queries
Large data sets
Inadequate hardware resources
Poorly designed report layout
Network latency
Lack of indexing
Database contention
Insufficient memory allocation
Outdated software versions
Q16. Difference between R12.1 and R12.2
R12.2 has more features and improvements than R12.1
R12.2 has a new online patching feature
R12.2 has a new user interface
R12.2 has improved security features
R12.2 has enhanced mobile support
R12.2 has a new tool for managing concurrent programs
Q17. How to add RAC node in19c DB?
To add a RAC node in 19c DB, you need to run the 'addNode.sh' script on the new node.
Ensure the new node meets all the prerequisites for adding to the RAC cluster.
Run the 'addNode.sh' script on the new node to add it to the existing RAC cluster.
Verify the addition of the new node by checking the cluster status and resources.
Q18. Oacore issue encountered?
Oacore issue refers to problems encountered in the Oracle Application Framework (OAF) layer of Oracle E-Business Suite.
Oacore issues can cause application performance problems, such as slow page load times or unresponsive pages.
Common causes of Oacore issues include memory leaks, database connectivity problems, and configuration errors.
To troubleshoot Oacore issues, DBAs can use tools like Oracle Enterprise Manager (OEM) and log files to identify the root cause of the problem...read more
Interview experiences of popular companies
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Reviews
Interviews
Salaries
Users/Month