If you're looking for Oracle EBS Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Oracle EBS has a market share of about 8.2%. So, You still have opportunity to move ahead in your career in Oracle EBS Development. Mindmajix offers Advanced Oracle EBS Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Oracle EBS Developer.
Q. What is purpose of applsyspub user in Oracle EBS?
APPLSYSPUB is an initial, pre-authentication user with minimal privileges to assist with APPS (FND) user authentication. Usernames and passwords are stored in the FND_USER table, we need to have a pre-connection to the database. This connection is established using APPLSYSPUB user. After successfull login, associated database login will switch to APPS user from APPLSYSPUB user. APPLSYSPUB has only Read-Only privileges on a few tables and views for signing on to Applications.
APPLSYSPUB is an initial, pre-authentication user with minimal privileges to assist with APPS (FND) user authentication. Usernames and passwords are stored in the FND_USER table, we need to have a pre-connection to the database. This connection is established using APPLSYSPUB user. After successfull login, associated database login will switch to APPS user from APPLSYSPUB user. APPLSYSPUB has only Read-Only privileges on a few tables and views for signing on to Applications.
Q. What is purpose of Applications Listener in Oracle EBS?
During concurrent managers startup ICM instructs Applications Listener to spawn FNDSM (Service manager) process.
You can confirm this by checking listener.ora configuration file on apps tier, which is located under directory $ORACLE_HOME/network/admin:
SID_LIST_APPS_PROD =
During concurrent managers startup ICM instructs Applications Listener to spawn FNDSM (Service manager) process.
You can confirm this by checking listener.ora configuration file on apps tier, which is located under directory $ORACLE_HOME/network/admin:
SID_LIST_APPS_PROD =
(SID_LIST =
( SID_DESC = ( SID_NAME = FNDSM )
( ORACLE_HOME = /u01/app/apps/fs1/EBSapps/10.1.2 )
( PROGRAM = /u01/app/apps/fs1/EBSapps/appl/f
(envs=’MYAPPSORA=/u01/app/apps/fs1/EBS
Q. Is it possible to run two adpatch sessions simultaneously for one EBS instance?
It’s possible to run several adpatch sessions, but they will eventually fail. At different stages of work you may get different errors. One of them related to FND_INSTALL_PROCESSES table which is created to keep track of what jobs adpatch workers are doing. Sample error message:
The table FND_INSTALL_PROCESSES created by AutoPatch already exists.
If you are sure you do not want to keep the information from the failed
AutoPatch session,you may drop FND_INSTALL_PROCESSES table and
continue with AutoPatch.
If you choose not to drop FND_INSTALL_PROCESSES table, AutoPatch
cannot continue successfully.
It’s possible to run several adpatch sessions, but they will eventually fail. At different stages of work you may get different errors. One of them related to FND_INSTALL_PROCESSES table which is created to keep track of what jobs adpatch workers are doing. Sample error message:
The table FND_INSTALL_PROCESSES created by AutoPatch already exists.
If you are sure you do not want to keep the information from the failed
AutoPatch session,you may drop FND_INSTALL_PROCESSES table and
continue with AutoPatch.
If you choose not to drop FND_INSTALL_PROCESSES table, AutoPatch
cannot continue successfully.
Q. What is procedure of patching in case of multi-node EBS installation and non-shared application tier?
In this case you have to apply patches on every application node. Also the answer depends on EBS release number. If it’s 11i, then you have to start patching from node where administration server is located. Reason for that – adpatch runs database part of unified driver only on node where administration server is located.
Release R12 eliminated need for DBAs to pay attention at patching sequence. Here is quote from R12 concepts: “There is no concept of an Administration server in Release 12. By default, patching can be undertaken from any application tier node.”
In this case you have to apply patches on every application node. Also the answer depends on EBS release number. If it’s 11i, then you have to start patching from node where administration server is located. Reason for that – adpatch runs database part of unified driver only on node where administration server is located.
Release R12 eliminated need for DBAs to pay attention at patching sequence. Here is quote from R12 concepts: “There is no concept of an Administration server in Release 12. By default, patching can be undertaken from any application tier node.”
Q. Is it required to run autoconfig on all nodes in case of Shared Application Tier multi-node installation?
Yes. All configuration files created by AutoConfig are stored under the Instance Home. So to update all Instance Homes it’s required to run autoconfig on each node.
For more information visit Mindmajix
Yes. All configuration files created by AutoConfig are stored under the Instance Home. So to update all Instance Homes it’s required to run autoconfig on each node.
For more information visit Mindmajix
I found your blog very interesting and very informative. I think your blog is great information source & I like your way of writing and explaining the topics.The Oracle relational database management system (RDBMS) was the initial product offering and is at the center of most Oracle product installations. This product is designed to provide the facilities to store and retrieve information in a variety of formats Readmore..
ReplyDeleteThank for the great information....
ReplyDeleteOracle DBA Training Online