70. What is .pls files which you see with apps?
.PLS file stands for plsql files. In apps patch these files contain code to create package spec or package body or both.
71. What are .ldt & .lct files which you see in apps patch or with FNDLOAD?
.ldt & .lct stands for Loader data file & Loader configuration files, used frequently in migrating customization, profile options, configuration data etc. across Instances.
72. What are .odf file in apps patch?
odf stands for Object Description Files used to create tables & other database objects while applying a patch.
73. Where to find Form Server log files in forms?
Form Server Start up log file default location is $OAD_TOP/admin/log/$CONTEXT_NAME/f60svrm.txt
Forms Run Time Diagnostics default location is $ORACLE_HOME/forms60/log/$CONTEXT_NAME
74. How to convert pll to pld file or pld file to pll ?
pll->pld f60gen module=MSCOSCW3.pll module_type=library userid=apps/<passwd> module_access=file output_file=MSCOSCW1.pld script=yes
pld -> pll f60gen module=MSCOSCW3.pld userid=apps/<passwd> module_type=library module_access=file output_file=MSCOSCW1.pll parse=y batch=yes compile_all=special
75. Does APPS_MRC Schema exist for MRC in 11.5.10 and higher?
No, apps_mrc schema is dropped with 11.5.10 Upgrade & 11.5.10 new Install. This is replaced by more Integrated Architecture.
76. If APPS_MRC schema is not used in 11.5.10 and higher then how MRC is working?
For products like Payable, Receivables which uses MRC and if MRC is enabled then each transaction table in base schema related to currency now has an associated MRC sub tables.
77. When you apply C driver patch does it require database to be Up & Why?
Yes, database & db listener should be UP when you apply any driver patch in apps. Even if driver is not updating any database object connection is required to validate apps & other schema and to upload patch history information in database tables.
78. Can C driver in apps patch create Invalid Object in database?
No, C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified.
79. What is dev60cgi & f60cgi?
cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access forms server . Usually Form Server access directly via http://hostname:port/dev60cgi/f60cgi
Showing posts with label Oracle EBS support. Show all posts
Showing posts with label Oracle EBS support. Show all posts
Monday, May 19, 2014
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 4
21. What is access_log in apache, what entries are recorded in access_log? Where is the default location of this file?
access_log in Oracle Application Server records all users accessing oracle applications 11i. Its file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs.
22. Where is Jserv configuration files stored?
Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/etc.
23. Where is applications start/stop scripts stored?
Applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME
24. What are main configuration files in Web Server (Apache)?
Main configuration files in Oracle Apps Web Server are
httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf, jserv.conf, ssp_init.txt, jserv.properties, zone.properties
plsql.conf, wdbsvr.app, plsql.conf
25. How to check if Apps 11i System is Autoconfig enabled?
Under $AD_TOP/bin check for file adcfginfo.sh and if this exists use adcfginfo.sh contextfile=<CONTEXT> show=enabled
If this file is not there, look for any configuration file under APPL_TOP if system is Autoconfig enabled then you will see entry like
# AutoConfig automatically generates this file. It will be read and.......
26. How to check if Oracle Apps 11i System is Rapid Clone enabled?
For system to be Rapid Clone enabled, it should be Autoconfig enabled. You should have Rapid Clone Patches applied.
27. What is the difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP?
APPS<CONTEXT>.env is main environment file which in turn calls other environment files like <CONTEXT>.env under $APPL_TOP
28. What is your Oracle Apps 11i Webserver Version and how to find it?
In order to find version under IAS_ORACLE_HOME/Apache/Apache/bin
Execute ./httpd -version
29. What is plssql database cache?
In order to improve performance mod_pls (Apache component) caches some database content to file. This plsql cache is used to store session information. plsql cache is used to store plsql cache i.e. used by mod_pls
access_log in Oracle Application Server records all users accessing oracle applications 11i. Its file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/Apache/logs.
22. Where is Jserv configuration files stored?
Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/etc.
23. Where is applications start/stop scripts stored?
Applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CONTEXT_NAME
24. What are main configuration files in Web Server (Apache)?
Main configuration files in Oracle Apps Web Server are
httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf, jserv.conf, ssp_init.txt, jserv.properties, zone.properties
plsql.conf, wdbsvr.app, plsql.conf
25. How to check if Apps 11i System is Autoconfig enabled?
Under $AD_TOP/bin check for file adcfginfo.sh and if this exists use adcfginfo.sh contextfile=<CONTEXT> show=enabled
If this file is not there, look for any configuration file under APPL_TOP if system is Autoconfig enabled then you will see entry like
# AutoConfig automatically generates this file. It will be read and.......
26. How to check if Oracle Apps 11i System is Rapid Clone enabled?
For system to be Rapid Clone enabled, it should be Autoconfig enabled. You should have Rapid Clone Patches applied.
27. What is the difference between two env files in <CONTEXT>.env and APPS<CONTEXT>.env under $APPL_TOP?
APPS<CONTEXT>.env is main environment file which in turn calls other environment files like <CONTEXT>.env under $APPL_TOP
28. What is your Oracle Apps 11i Webserver Version and how to find it?
In order to find version under IAS_ORACLE_HOME/Apache/Apache/bin
Execute ./httpd -version
29. What is plssql database cache?
In order to improve performance mod_pls (Apache component) caches some database content to file. This plsql cache is used to store session information. plsql cache is used to store plsql cache i.e. used by mod_pls
Oracle Apps DBA Interview Questions part 3
11. Can you clone from multi node system to single node system & vice versa?
Yes, this is now supported via Rapid Clone, Check if your system has all prerequisite patches for Rapid Clone and you are on latest rapid clone patch.
12. Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global oraInventory after clone?
Rapid Clone automatically updates Global oraInventory during configuration phase. You don't have to do anything manually for Global oraInventory.
13. What is .dbc file, where is it stored, what is the use of .dbc file?
DBC. as name suggests is a database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE.
14. What things you do to reduce patch timing?
Merging patches via admrgpch
Use various adpatch options like nocompiledb or nocompilejsp
Use defaults file
Staged APPL_TOP during upgrades
Increase batch size (Might result into negative)
15. How you put Applications 11i in Maintenance mode?
Use adadmin to change maintenance mode in EBS. If you don't want to put EBS in maintenance mode you can use adpatch options=hotpatch feature.
16. Can you apply patch without putting Applications 11i in Maintenance mode?
Yes, use options=hotpatch as mentioned above with adpatch.
17. What are various options available with adpatch?
Various options available with adpatch depending on your AD version are
autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseportion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate
18. adident utility is used for what?
adident utility in oracle apps is used to find version of any file . For example “adident Header <filename>”
What is adsplice utility?
adsplice in oracle apps is utility to add a new product to EBS.
How can you license a product after installation?
You can use ad utility adlicmgr to license product in Oracle Apps.
19. What is MRC? What you do as Apps DBA for MRC?
MRC also called as Multiple Reporting Currency in Oracle Apps. By default you have currency in US Dollars but if your organization’s operating books are in other currency then you as apps DBA need to enable MRC in Apps.
20. What is JVM (Java Virtual Machine) and which component uses JVM?
JVM stands for Java Virtual Machine.
Yes, this is now supported via Rapid Clone, Check if your system has all prerequisite patches for Rapid Clone and you are on latest rapid clone patch.
12. Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global oraInventory after clone?
Rapid Clone automatically updates Global oraInventory during configuration phase. You don't have to do anything manually for Global oraInventory.
13. What is .dbc file, where is it stored, what is the use of .dbc file?
DBC. as name suggests is a database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE.
14. What things you do to reduce patch timing?
Merging patches via admrgpch
Use various adpatch options like nocompiledb or nocompilejsp
Use defaults file
Staged APPL_TOP during upgrades
Increase batch size (Might result into negative)
15. How you put Applications 11i in Maintenance mode?
Use adadmin to change maintenance mode in EBS. If you don't want to put EBS in maintenance mode you can use adpatch options=hotpatch feature.
16. Can you apply patch without putting Applications 11i in Maintenance mode?
Yes, use options=hotpatch as mentioned above with adpatch.
17. What are various options available with adpatch?
Various options available with adpatch depending on your AD version are
autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseportion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate
18. adident utility is used for what?
adident utility in oracle apps is used to find version of any file . For example “adident Header <filename>”
What is adsplice utility?
adsplice in oracle apps is utility to add a new product to EBS.
How can you license a product after installation?
You can use ad utility adlicmgr to license product in Oracle Apps.
19. What is MRC? What you do as Apps DBA for MRC?
MRC also called as Multiple Reporting Currency in Oracle Apps. By default you have currency in US Dollars but if your organization’s operating books are in other currency then you as apps DBA need to enable MRC in Apps.
20. What is JVM (Java Virtual Machine) and which component uses JVM?
JVM stands for Java Virtual Machine.
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)