Interview questions related to cloning in oracle apps

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

2. What is the location of adpreclone.pl in oracle database?
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

3. What is the location of adcfgclone.pl in oracle database?
$ORACLE_HOME/appsutil/clone/bin

4. What is the location of adpreclone.pl in oracle application?
$INST_TOP/admin/scripts

5. What is the location of adcfgclone.pl for applmgr user?
$COMMON_TOP/clone/bin

6. How often do you clone?
Cloning happens weekly or monthly depending on the organization requirement.

7. When do you run adpreclone on Production?
If any changes made to either TechStack,database or any patches applied.

8. When we run perl adpreclone.pl dbTier why it requires apps password?
It requires a database connection to validate apps schema.

9. When we run perl adpreclone.pl appTier why it will not prompt for apps password?
It doesn’t require db a connection.

10. What happens after running adcfgclone.pl?

• It will take inputs and creates xml file.
• After creating xml file,it runs autoconfig.
• It registers the ORALCE_HOME with GLOBAL INVENTORY.

11. What adpreclone.pl does on appsTier?
It will collects all the information about the source system, creates a cloning stage area, and generates templates and drivers. All of these are to reconfigure the instance on a Target machine.

12. What Perl adcfgclone.pl dbTechStack do?

• Create context file
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Start SQL*NET listener

13. What Perl adcfgclone.pl dbTier do?

• Create context file.
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Recreate controlfile
• Configure database
• Start SQL*NET listener

14. What Perl adcfgclone.pl appsTier do?

• Create context file
• Register ORACLE_HOME
• Relink ORACLE_HOME
• Configure ORACLE_HOME
• Create INST_TOP
• Configure APPL_TOP
• Start Apps Processes.

15. When we run adcfgclone.pl which script it will call?
It will call adclone.pl which is located at $AD_TOP/bin .

16. What are the parameters are mandatory in RMAN DUPLICATE 11g?

• db_file_name_convert
• log_file_name_convert
• diagnostic_dest
• event='12345 trace name context forever, level 33'

17. Does clone preserve the patch history?
Yes, Rapid clone preserves the patch history in following locations:
RDBMS ORACLE_HOME: preserves the OUI oraInventory.
10.1.3 (IAS ORACLE_HOME): preserves the OUI oraInventory
10.1.2 ORACLE_HOME: preserves the patch level and Oracle inventory
APPL_TOP and Database: preserves the patch level and history tables.