Oracle APPS Interview Questions Part 5

41) What kind of maintenance activities can be performed from admin server?

• Following maintenance activities are performed from admin server
• Applying the patches
• Maintaining Oracle Applications
• Applying the ad utilities
• Upgrading Oracle Applications

42) What is the significance of appsweb.cgf file and where is it located?

• It defines the parameter values used by forms WEB CGI.
• It is the main configuration file used by forms server.
• It contains forms server Name, ServerPort, DomainName
• It stores Database Connection Parameters and Jinitiatorversion.
• It is located at $OA_HTML/bin.

43) What is cloning and why is it required?

• 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.

44) What are the steps to clone from a single node to a multi-node?

• You must login as the owner of file system once the database cloning is done.
• Run the adcfgclone.pl from the common_top/clone bin.
• Accept for target system having more than one application tier server node.
• Collect the details for processing node, admin node, forms node, and web node.
• Now you get a prompt for the various mount point details and it creates the context file for you.
• Follow the same steps from all the nodes.

45) What are the files you need to copy from APPL_TOP for creating a clone application system?

• APPL_TOP
• OA_HTML
• OA_JAVA
• OA_JRE_TOP
• COMMON_TOP>/util
• COMMON_TOP>/clone
• 806 ORACLE_HOME
• iAS ORACLE_HOME

46) Does clone preserve the patch history?

• Yes, Rapid clone preserves the patch history in following locations
• RDBMS ORACLE_HOME: preserves the OUI oraInventory.
• iAS ORACLE_HOME: preserves the OUI oraInventory
• 806 ORACLE_HOME: preserves the patch level and Oracle inventory
• APPL_TOP and Database: preserves the patch level and history tables.

47) What are the pre-upgrade steps that need to be taken for the up gradation of non_11i instance to 11.5.10?

• 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

48) What is ad splice and what does it do?

• Oracle often releases new products known as off cycle products.
• These products are up gradation to the base releases of Oracle applications.
• Ad splice is the utility which takes care of bringing an off cycle product in to oracle applications.
• Ad splice registers off cycle products as active in the system.
• Therefore, ad utilities recognize the off cycle products as valid product for a particular product release.

49) What are the important configuration files which are used by Apache run along with Jserv?

• $APACHE_TOP/Apache/conf/httpd.conf
• $APACHE_TOP/Jserv/etc/Jserv.conf
• $APACHE_TOP/Jserv/etc/Jserv.properties
• $APACHE_TOP/Jserv/etc/zone.properties
• $APACHE_TOP/Apache/conf/oracle_apache.conf
• $APACHE_TOP/Ojsp/conf/ojsp.conf

50) How do I check the version of Apache?

• version of Apache can be checked using the following command
• $IAS_ORACLE_HOME/Apache/Apache/bin/httpd –v

Output is given as below

• httpd –v
• Server version: Oracle HTTP server Powered by Apache/1.3.19(UNIX)
• Server built: Dec 6 2005 13:41:10 (iAS 10.2.2.2 rollup 5)
• From the above output we can know the version of the apache.