25 September, 2020
Q.1) Describe the architecture of Oracle Applications?
Ans) Oracle Applications follow a 3 Tier architecture:
- Database Tier - Middle Tier - Desktop Tier
The database tier contains the RDBMS database called an oracle database server.
The 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, an admin server, reports server.
The database server communicates with the middle-tier, doesn’t directly communicate with the desktop tier.
The desktop tier contains the client desktop where users access oracle applications through web browsers.
Q.2) How do you delete a responsibility from oracle applications?
Ans) - 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
Ans) 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)
Ans) 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.
Ans) - 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.
Ans) - 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.
Ans) - 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
Related Article :-Oracle Fusion HCM Interview Questions
Ans) 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
Ans) - The password of the application users can be changed using the FNDCPASS utility.
- You must have system and applications password for running FNDCPASS.
Ans) - 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.
Ans)- Patch is a program which fixes the bug.
Q.12) There are 4 different types of patches:
Ans) - One-off patch:
- This is the simplest type of patch. It is created to resolve a particular problem. - Mini pack Patch: - It is a collection of one-off patches related to a particular module or product. - Mini Pack version of module is denoted by Alphabetic characters.
- Family pack patch:
- This is a collection of mini pack patches in one family. - Alphabetic characters denote the family pack version.
- Maintenance pack patch:
- This is a collection of family pack patches. - Oracle Applications Release 11.5.10 is an example of Maintenance pack.
Ans) - Shutdown all Oracle Application Processes.
- Apply Inter-Operability Patch(3830807).
- Apply Discoverer Patch(3170128).
- Re link all Oracle Applications executables.
- Finally, Restart Oracle Application Processes.
Ans) Contents of patch:
- Readme files - Driver files - Metadata files - Replacement files
Drivers present in patching:
C driver - It copies all the files and links the executables.
D driver – It is responsible for running SQL scripts that update the database.
G driver - It is responsible for generating forms, reports, and message files.
U driver – It is a united driver containing all copy and database actions.
Ans) - Evaluate log files to determine the cause of the error.
- Repair the cause of the error.
- Now Restart Adpatch.
- Answer 'Yes' when ad patch asks if you want to continue the previous session.
- Adpatch starts from where it left off by skipping all completed jobs.
Ans) - You can reduce the downtime by merging all the patches into one single patch using admergepatch (admrgpch) tool. - You can also apply multiple patches one by one by choosing options nocompiledb, nocompilejsp, and nolink. - Compilation of invalid objects, jsp’s and relinking can be skipped till the last patch is applied. - In the last patch you can compile all of them and then relink. - You can also choose the max number of workers which your CPU permits.
Ans) Running the patch creates the following log files:
Adpatch.log: Information about the patch run will be stored here.
Adpatch.lgi: It contains information about the which has been discarded by adpatch.log For example, the files which has not been copied by the adpatch.
Adrelink.log: Relinking information performed by patch will be stored here.
Adworkxx.log: Workers log details will be stored here.
Ans) AD_APPL_TOPS: It contains information about all APPL_TOP’s using the instance.
AD_BUGS: It stores information about all different bug fixes applied.
AD_PATCH_DRIVER_MINIPACKS: Mini_packs information will be stored here.
AD_PATCH_RUN_BUGS: It stores information about all applied and updated bug fixes.
AD_FILES: It stores information about files.
Ans) - View is used for accessing a particular portion of a table.
- A view is also called a virtual table.
- For recreating the view you can search for the view name in the SQL directory.
- We can recreate the views running scripts located in the Product top/patch/115/sql directory.
- Most views are recreated using sql script.
Ans) - Admrgpch utility is used for merging all the patches.
- Various adpatch options like nocompiledb or nocompilejsp are used for reducing patch timing.
- By Using defaults file.
- By using, staged APPL_TOP for upgradation.
- By increasing the batch size, this might result into negative results.
Ans) 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 and zone properties - Plsql.conf - Wdbsvr.app
Ans) - GSM stands for Generic Service Management Framework.
- Oracle E-Business suite contains many services used to start at their own earlier, but managing these services are distributed across network.
- So, GSM is an extension of concurrent processing which manages all your services.
- With GSM all services are centrally managed.
- FNDSM is executable and core component in GSM.
Ans) - Cursor attributes are used to get information about the current status of your cursor.
Both explicit and implicit cursors have four attributes as shown:
FOUND - It Returns TRUE if record was fetched successfully, FALSE otherwise.
NOTFOUND - Returns TRUE if record was not fetched successfully, FALSE otherwise.
ROWCOUNT - Returns number of records fetched from cursor at that point in time.
ISOPEN - Returns TRUE if cursor is open, FALSE otherwise.
Ans) Execute the following commands:
If the listener is up, you will observe the following output: - Services summary - FNDFS has 1 service handler(s) - FNDSM has 1 service handler(s)
Ans) - Adadmin (Ad administration) is used to perform a number of administrative tasks to maintain the Oracle Applications. - For Oracle Applications to run smoothly Adadmin is used. - Adadmin performs work at both database level and file system level. - Application users are requested to provide all inputs at Adadmin prompt which displays various options from Adadmin menu. - You can run non_interactive tasks and this is really useful for scheduling routine tasks that require no user intervention.
Ans)- Recreate grants and synonyms. - Compile APPS schema - Maintain multiple reporting currencies schema. - Convert to Multi-org. - Generate message files. - Generate form files. - Generate report files.
Ans) - All the files in the patch are copied to APPL_TOP by C driver. - It extracts all the appropriate files from c library. - Oracle applications products are relinked by C driver. - Regenerates the JAR files and compiles the Java server pages(JSP) files. - Compares the files in the patch with the files in the $APPL_TOP. - If all the files in the patch are of higher version, Adpatch copies all the files from patch to $APPL_TOP.
Ans) - Generate driver is named as g<patch number>.drv - It regenerates all forms, reports and pl/sql libraries that have been affected by the patch. - Unified driver is a combination of C,D, & G drivers. - U driver is also named as u<patch_number>.drv - It requires only a single execution of AutoPatch.
Ans)- Forms server is a component of the Oracle Applications server which is used to deploy Forms applications across the web. - It is previously called as WebForms. - It consists of Forms Listener, Runtime engine, Forms CGI. - Forms listener manages connections and Runtime engine. - Runtime engine contains Application logic, Data management, and pl/SQL engine. - It is an optional entry point and used for Load balancing.
Ans)- First, you must log in to Oracle Applications Manager - Then you must navigate to sitemap, then find the Autoconfig. - In Autoconfig you can able to change from socket mode to servlet mode and vice versa - Run the autoconfig from backend and restart the forms server. - Due to many advantages Forms servlet mode is preferred and is always recommended for web deployment.
Ans) - It is a java virtual machine provided for running web-based oracle forms applications inside a client web browser. - It is implemented as a plug-in or ActiveX Object. - It allows you to specify the use of Oracle-certified JVM instead of relying on default JVM provided by the browser. - It is automatically downloaded to a client machine from the application server. - Its installation and update is performed by the standard plug-in mechanism provided by the browser.
Ans) - Web listener accepts the Http requests coming from the client browsers and web server services the request. - Apache server forwards advanced processing requests to the servlet engine. - Servlet engine forwards these requests to the database. - If the Http request needs parsing a JSP file then web listener checks the nature of the request. - It then contacts the Jserv to run a JSP. - The JSP contacts the database for the information and returns an HTML page displayed in the web browser.
Ans) Following maintenance activities are performed from the admin server:
- Applying the patches - Maintaining Oracle Applications - Applying the ad utilities - Upgrading Oracle Applications
Ans) Cloning is the process of creating an identical copy of the Oracle application system.
It is required due to following reasons:
- Creating a test copy of your production system before upgrading. - Moving an existing system to a different machine. - To test some patches - Creating a development copy of your environment to be used by the developers.
Ans) - APPL_TOP - OA_HTML - OA_JAVA - OA_JRE_TOP - COMMON_TOP>/util - COMMON_TOP>/clone - 806 ORACLE_HOME - iAS ORACLE_HOME
Ans) - First, you need to take a complete backup of the application system. - Run the TUMS utility - Review the TUMS report - Maintain the multilingual tables - Rename the custom database objects - Check attachment file upload directory - You need to save the custom.pll