Thursday, 14 April 2016

autoconfig interview questions in oracle apps

1.What is autoconfig?
Autoconfig is a configuration tool that simplifies & Standadize configuration management tasks on oracle application environment.
*) adautocfg.sh internally call two scripts (adconfig.sh & adconfig.pl) ($AD_TOP/bin)

2. What are the parameter autoconfig will ask for?
Context file name and apps password

3. What is context file?
Context file is a central repository, which stores all application configuration information. The name is like _ .xml

4. How you will find autoconfig is enabled/not for u r applications?
a) Open any env / configuration files, the first few lines will tell u that these files are maintained by autoconfig.
b) If contextname.xml file is there in APPL_TOP/admin

5. How autoconfig will create env and configuration files?
Autoconfig will go to each and every top template directory take the templates from there and fill the values from xml file and create the required files.

6. In how many phases autoconfig will run?
*) NSTE8 - Instantiates AutoConfig template files to the AutoConfig configuration files specified in the relevant template driver files.
*) INSTE8_SETUP - Executes setup scripts that carry out activities not involving connection to the database.
*) INSTE8_PROFILE - Executes setup scripts that update profile options.
*) INSTE8_APPLY - Executes setup scripts that carry out activities involving updates to the database.

7. What is the location of adconfig log file?
$APPL_TOP/admin/log/

8. Is it possible to restore a autoconfig run?
Partially. Adconfig will create a restore script at $APPL_TOP/admin//out/. This restore.sh will copy the backed up files before autoconfig run to its original locations. But the profile values updated in the database can’t be restored back.

9. How to run autoconfig in test mode?
adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test
mode and create the difference file which tells us what is going to change, when u actually run autoconfig.

10. How to find autoconfig is enabled or not for database?
If we have appsutil directory under RDBMS_ORACLE_HOME.

No comments:

Post a Comment