DBA > Interview Resource

Oracle DBA Interview questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16 

(Continued from previous part...)

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 (defined by environment variable FORMS60_WEB_CONFIG_FILE) for forms client connection used each time a user initiates forms connection.


What is forms server executable Name ?

f60srvm


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 defualt Forms are configured to start in socket mode.


How you will start Discoverer in Oracle Apps 11i ?

In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME or startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier)


How many ORACLE HOME are Oracle Apps and whats significance of each ?

There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database Tier.
# ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports and discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
# ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by Web Listener and contains Apache.
# ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.


Where is HTML Cache stored in Oracle Apps Server ?

Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages


Where is plssql cache stored in Oracle Apps ?

Usually two type of cache session and plssql stored under $IAS_ORACLE_HOME/Apache/modplsql/cache


What happens if you don't give cache size while defining Concurrent Manager ?

Lets first understand what is cache size in Concurrent Manager. When Manager picks request from FND CONCURRENT REQUESTS Queues, it will pick up number of requests defined by cache size in one shot and will work on them before going to sleep. If you don't define cache size while defining CM then it will take default value 1, i.e. picking up one request per cycle.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16