80. Why does a worker fail in Oracle Apps Patch and few scenarios in which it failed for you?
Apps Patch worker can fail in case it doesn't find expected data, object, files or anything which driver is trying to update/edit/modify. Possible symptoms may be underlying tables/objects are invalid, a prerequisite patch is missing, login information is incorrect, inconsistency in seed data.
81. What is difference between mod_osso & mod_ose in Oracle HTTP Server?
mod_osso is Oracle Single Sign-On Module where as mod_ose is module for Oracle Servlet Engine.
82. What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms?
Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file.
83. What is ps -ef or ps command in Unix? for work ex < 1 yr
ps in unix/linux is a utility to find status of process. Used mainly to find if service/process is running or not.
84. Find application server version?
FND_PRODUCT_GROUPS
85. How will you find the Apache, forms, reports version in an EBS suite?
http –v – Apache
f60gen – Forms
ar60run – Reports
86. Find jinitiator version?
Client side – Control panel
Server side – SID_hostname.xml (s_jinit_ver_)
87. List some ad utilities and their functions?
adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker
88. List out the modules related to oracle Apps DBA?
FND – Application Object Library, AU – Application Utilities, AD – Application DBA
89. What are profile options, what are various types of profile options?
User, application, responsibility and site
90. What are the different types of oracle patches available?
One-off, mini, diagnostics, cu, rup, language, help, platform specific, OS, OPatch, Interoperability, family pack and maintenance pack.
Showing posts with label Oracle r12 Apps dba interview questions. Show all posts
Showing posts with label Oracle r12 Apps dba interview questions. Show all posts
Tuesday, May 20, 2014
Monday, May 19, 2014
Oracle Apps DBA Interview Questions part 6
41. How to confirm if Apps Listener is Up & Running?
lsnrctl start APPS_$SID (replace SID with your Instance Name) so if your SID is VISION then use lsnrctl status APPS_VISION
42. What is Web Listener?
Web Listener is Web Server listener which is listening for web Services (HTTP) request. This listener is started by adapcctl.sh & defined by directive (Listen, Port) in httpd.conf for Web Server.
43. How will you find total number of invalid objects in database?
SQLPLUS> select count(*) from dba_objects where status like 'INVALID';
44. How to compile Invalid Objects in database?
You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects.
45. How to compile JSP in Oracle Apps?
You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl --compile --quiet
46. What is difference between adpatch & opatch?
# adpatch is utility to apply oracle apps Patches whereas
# opatch is utility to apply database patches
47. Can you use both adpatch & opatch in Apps?
Yes you have to use both in apps, for apps patches you will use adpatch utility and for applying database patch in apps you will use opatch utility.
48. Where will you find forms configuration details apart from xml file?
Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg for forms client connection used each time a user initiates forms connection.
49. What is forms server executable Name?
f60srvm
50. What are different modes of forms in which you can start Forms Server and which one is default?
You can start forms server in SOCKET or SERVLET by default Forms are configured to start in socket mode.
lsnrctl start APPS_$SID (replace SID with your Instance Name) so if your SID is VISION then use lsnrctl status APPS_VISION
42. What is Web Listener?
Web Listener is Web Server listener which is listening for web Services (HTTP) request. This listener is started by adapcctl.sh & defined by directive (Listen, Port) in httpd.conf for Web Server.
43. How will you find total number of invalid objects in database?
SQLPLUS> select count(*) from dba_objects where status like 'INVALID';
44. How to compile Invalid Objects in database?
You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects.
45. How to compile JSP in Oracle Apps?
You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is
perl ojspCompile.pl --compile --quiet
46. What is difference between adpatch & opatch?
# adpatch is utility to apply oracle apps Patches whereas
# opatch is utility to apply database patches
47. Can you use both adpatch & opatch in Apps?
Yes you have to use both in apps, for apps patches you will use adpatch utility and for applying database patch in apps you will use opatch utility.
48. Where will you find forms configuration details apart from xml file?
Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg for forms client connection used each time a user initiates forms connection.
49. What is forms server executable Name?
f60srvm
50. What are different modes of forms in which you can start Forms Server and which one is default?
You can start forms server in SOCKET or SERVLET by default Forms are configured to start in socket mode.
Oracle Apps DBA Interview Questions part 5
30. Where is database plssql cache stored?
plssql & session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory
31. How to determine Oracle Apps 11i Version?
select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
11.5.9 or 11.5.10.2
32. What is content of dbc file & why is it important?
DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file. Typical entry in dbc file is
GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST
33. There are lot of dbc file under $FND_SECURE, How is it determined that which dbc file to use from $FND_SECURE?
This value is determined from profile option "Applications Database ID"
34. What is RRA/FNDFS?
Report Review Agent (RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files & log files.
35. What is PCP is Oracle Applications 11i?
PCP is acronym for Parallel Concurrent Processing. Usually you have one Concurrent Manager executing your requests but you can configure Concurrent Manager running on two machines. So for some of your requests primary CM Node is on machine1 and secondary CM node on machine2 and for some requests primary CM is on machine2 & secondary CM on machine1.
36. Why I need two Concurrent Processing Nodes or in what scenarios PCP is used?
If you are running GL month end reports or taxation reports annually these reports might take couple of days. Some of these requests are very resource intensive so you can have one node running long running resource intensive requests while other processing your day to day short running requests. Another scenario is when your requests are very critical and you want high resilience for your Concurrent Processing Node, you can configure PCP. So if node1 goes down you still have CM node available processing your requests.
37. How to confirm if Report Server is Up & Running?
Report Server is started by executable rwmts60 on concurrent manager Node & this file is under $ORACLE_HOME/bin Execute command on your server like
ps -ef | grep rwmts60
38. What is difference between ICM, Standard Managers and CRM in Concurrent Manager?
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down, it checks & tries to restart them. You can say it is an administrator to other concurrent managers. Standard Manager: These are normal managers which performs actions on the requests and does batch or single request processing. CRM is acronym for Conflict Resolution Manager and is used to resolve conflicts between managers & requests. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are assigned to CRM for incompatibilities & conflict resolution.
39. What is use of Apps listener?
Apps Listener usually run on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS & FNDSM.
40. How to start Apps listener?
In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name)
plssql & session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory
31. How to determine Oracle Apps 11i Version?
select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
11.5.9 or 11.5.10.2
32. What is content of dbc file & why is it important?
DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file. Typical entry in dbc file is
GUEST_USER_PWD
APPS_JDBC_URL
DB_HOST
33. There are lot of dbc file under $FND_SECURE, How is it determined that which dbc file to use from $FND_SECURE?
This value is determined from profile option "Applications Database ID"
34. What is RRA/FNDFS?
Report Review Agent (RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files & log files.
35. What is PCP is Oracle Applications 11i?
PCP is acronym for Parallel Concurrent Processing. Usually you have one Concurrent Manager executing your requests but you can configure Concurrent Manager running on two machines. So for some of your requests primary CM Node is on machine1 and secondary CM node on machine2 and for some requests primary CM is on machine2 & secondary CM on machine1.
36. Why I need two Concurrent Processing Nodes or in what scenarios PCP is used?
If you are running GL month end reports or taxation reports annually these reports might take couple of days. Some of these requests are very resource intensive so you can have one node running long running resource intensive requests while other processing your day to day short running requests. Another scenario is when your requests are very critical and you want high resilience for your Concurrent Processing Node, you can configure PCP. So if node1 goes down you still have CM node available processing your requests.
37. How to confirm if Report Server is Up & Running?
Report Server is started by executable rwmts60 on concurrent manager Node & this file is under $ORACLE_HOME/bin Execute command on your server like
ps -ef | grep rwmts60
38. What is difference between ICM, Standard Managers and CRM in Concurrent Manager?
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down, it checks & tries to restart them. You can say it is an administrator to other concurrent managers. Standard Manager: These are normal managers which performs actions on the requests and does batch or single request processing. CRM is acronym for Conflict Resolution Manager and is used to resolve conflicts between managers & requests. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are assigned to CRM for incompatibilities & conflict resolution.
39. What is use of Apps listener?
Apps Listener usually run on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS & FNDSM.
40. How to start Apps listener?
In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name)
Oracle Apps DBA Interview Questions part 2
1. What is FNDSM?
FNDSM is executable & core component in GSM (Generic Service Management Framework). You start FNDSM services via APPS listener on all Nodes in Application Tier in E-Business Suite.
2. What is iAS Patch ?
iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shipped as Shell scripts & you apply iAS patches by executing Shell script.
Explain Architecture of Oracle Apps 11i?
Apps 11i is Mutli Tier architecture with Desktop Tier (Client Tier), Middle Tier (Application Tier) and Database Tier.
3. What are various components in Application/Middle Tier?
In Application Tier various components are Web Server, Forms Server, Reports Server, Concurrent Manager, Admin Server & Discoverer Server.
4. What is APPL_TOP, COMN_TOP, ORA_TOP.....?
XXX_TOP is top level directory in Oracle Application 11i for respective Component.
5. What is US directory in $AD_TOP or under various product TOP's?
US directory is default language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for Arabic.
6. What are the main concurrent Manager types?
ICM - Internal Concurrent Manager which manages concurrent managers
Standard Managers - Manages processing of requests
CRM - Conflict Resolution Managers, resolve conflicts in case of incompatibility
7. Where is Concurrent Manager Log file location?
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well
8. Where would I find .rf9 file, and what exactly it does?
These files are used during restart of a patch in case of patch failure because of some reason.
9. Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why is it used?
This file is defined by environment variable FORMS60_WEB_CONFIG_FILE. This is usually in directory $OA_HTML/bin on forms tier. This file is used by any forms client session. When a user tries to access forms, f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
10. What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is database, Concurrent Manager on one machine and Forms Server, Web Server on second machine.
FNDSM is executable & core component in GSM (Generic Service Management Framework). You start FNDSM services via APPS listener on all Nodes in Application Tier in E-Business Suite.
2. What is iAS Patch ?
iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shipped as Shell scripts & you apply iAS patches by executing Shell script.
Explain Architecture of Oracle Apps 11i?
Apps 11i is Mutli Tier architecture with Desktop Tier (Client Tier), Middle Tier (Application Tier) and Database Tier.
3. What are various components in Application/Middle Tier?
In Application Tier various components are Web Server, Forms Server, Reports Server, Concurrent Manager, Admin Server & Discoverer Server.
4. What is APPL_TOP, COMN_TOP, ORA_TOP.....?
XXX_TOP is top level directory in Oracle Application 11i for respective Component.
5. What is US directory in $AD_TOP or under various product TOP's?
US directory is default language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for Arabic.
6. What are the main concurrent Manager types?
ICM - Internal Concurrent Manager which manages concurrent managers
Standard Managers - Manages processing of requests
CRM - Conflict Resolution Managers, resolve conflicts in case of incompatibility
7. Where is Concurrent Manager Log file location?
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well
8. Where would I find .rf9 file, and what exactly it does?
These files are used during restart of a patch in case of patch failure because of some reason.
9. Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why is it used?
This file is defined by environment variable FORMS60_WEB_CONFIG_FILE. This is usually in directory $OA_HTML/bin on forms tier. This file is used by any forms client session. When a user tries to access forms, f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
10. What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is database, Concurrent Manager on one machine and Forms Server, Web Server on second machine.
Oracle Apps DBA Interview Questions part 1
Oracle apps dba interview questions and answers part 1
Oracle apps dba interview questions and answers
1) Describe the architecture of Oracle Applications?
• Oracle Applications follow a 3 Tier architecture
- Database Tier
- Middle Tier
- Desktop Tier
• Database tier contains RDBMS database called as oracle database server.
• Database tier stores all the data needed by oracle applications.
• Middle tier or Application Tier containing various servers configured with listeners like web server, forms server, admin server, reports server.
• Database server communicates with middle tier, doesn’t directly communicate with desktop tier.
• Desktop tier contains client desktop where users access oracle applications through web browsers.
2) How do you delete a responsibility from oracle applications?
• Responsibility is a level of authority given to Oracle Applications users.
• It is a collection of requests, forms and menus attached to user.
• Records are used for monitoring and security purpose so we can’t disable responsibilities.
• However, responsibilities can be disabled by assigning an end date to the effective period.
• We can delete a responsibility from both backend and frontend.
3) What are the components of Oracle Applications technology layer?
Oracle Applications technology layer comprises the following products
• Oracle Applications DBA (AD)
• Oracle Applications object library (FND)
• Oracle Common Modules (AK)
• Oracle Applications Utilities (AU)
• Oracle Alert (ALR)
• Oracle Workflow (WF)
• Oracle Applications Framework (FWK)
• Oracle XML Publisher (XML)
4) How many Oracle Homes are there in Oracle Applications and what is the importance of each one of them?
Oracle Applications have three Oracle Homes
• Oracle Home is an environment where oracle products run.
• Database Oracle Home in the database tier that acts as the Oracle Home for the Oracle database.
• Oracle Home in the application tier called as 8.0.6 Oracle Home. It is called the technology stack Oracle Home and used by forms, reports and discoverer.
• IAS Oracle Home, used by the Oracle HTTP Server (Web Listener).
• We can run multiple releases of same products simultaneously by using multiple oracle homes.
5) Can I enable real application clusters in the database tier along with oracle applications?
• Yes, real application clusters can also be configured with Oracle Applications
• RAC allows multiple instances to mount and open a single database.
• RAC requires shared disk storage and a dedicated network interconnect.
• When any one of the node fails, database services can be still available on remaining nodes.
• In that case, more than one instance of Oracle runs and the data file are stored at a central location accessible from the entire instance.
6) Where are Apache log files and configuration files stored and list each of them?
• Apache log files are stored in $IAS_ORACLE_HOME/Apache/Apache/logs.
• The log files are error_log, error_log_pls, access_log and access_log_pls.
• Apache configuration files are stored in $IAS_ORACLE_HOME/Apche/Apache/conf directory.
• The main configuration files are httpd.conf, apps.conf, httpd_pls.conf,oprocmgr.conf, and oracle_apache.conf.
7) How to recreate a DBC file and where is it located?
• Running Autoconfig will recreate the DBC file
• DBC is a database connect descriptor file which stores database connection information used by application tier (web browsers) to connect to database.
• The file is located in FND_SECURE directory.
• you can also create the DBC file by running the script adgendbc.sh
• We can find the above script at $COMMON_TOP/admin/install directory.
8) List out the important configuration files in APPL_TOP?
Important configuration files available in the APPL_TOP are
• APPLSYS.env/APPSORA.env
• Adovars.env
• SID.xml
• Adconfig.txt
• Adjareas.txt
• Topfile.txt
• Appsweb.cfg
• Hostname_SID.dbc
• Adpltfrm.txt
• Adjborg.txt
• Adjborg2.txt
9) Which utility is used for changing the password of the application users and how it runs?
• The password of the application users can be changed using the FNDCPASS utility.
• You must have system and applications password for running FNDCPASS.
• FNDCPASS will run in the following manner:
• FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME.
• FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
• FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME.
10) What are the scripts do you use while Apps cloning?
• A type of script that’s made a comeback in hot scripts is clone script.
• adpreclone.pl prepares the source system and adcfgclone.pl configures the target system.
• Both the scripts are located in $COMMON_TOP/admin/scripts/contextname directory.
• Adpreclone.pl collects information about the database.
• It also creates generic templates of files containing source specified hardcore values.
Subscribe to:
Posts (Atom)