AutoConfig@R12Apps

AutoConfig is a tool that supports automated configuration of an Oracle E-Business Suite Release 12 instance. All the information required for configuring an Applications instance is collected into two local repositories, called the Applications context file and the database context file.

When AutoConfig runs on the application tier, it uses information from the Applications context file to generate all configuration files and update database profiles. When AutoConfig runs on the database tier, it uses information from the database context file to generate all configuration files used on the database tier.

AutoConfig provides several major benefits, including:

• Configuration Support: AutoConfig configures the APPL_TOP, the ORACLE_HOMEs, and the supporting technology stack.
• Configuration Management: AutoConfig centralizes the configuration and re-configuration of an Applications instance.
• Configuration Delivery and Patching: The uptake of new technology is simplified, as new configurations and configuration changes can be provided in the form of a patch.

Run AutoConfig on the Database Tier:
1.Log-in to the Oracle User
2.Source the Environment file
3.Run the autoconfig script.
sh <RDBMS_ORACLE_HOME>/appsutil/scripts/
<CONTEXT_NAME>/adautocfg.sh

Run AutoConfig on the Application Tier:

1.Log-in to the Apps User
2.Source the Environment file
3.Run the autoconfig script.

Run AutoConfig on all application tier nodes and execute the following command to run AutoConfig.

sh <INST_TOP>/admin/scripts/adautocfg.sh

How to Enable Maintance Mode In R12 APPS? 

During a patch application the recommended option is to Enable Maintenance node.When adsetmmd.sql runs, it sets the Profile Option ‘Applications Maintenance Mode’ (APPS_MAINTENANCE_MODE) to ‘MAINT’ to Enable ‘Maintenance Mode’ and to ‘NORMAL’ to Disable it.When you Enable or Disable ‘Maintenance Mode’, adadmin will execute the script.

sqlplus -S  apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

sqlplus -S  apps/*****
@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

Determining if Maintenance Mode is Running:

A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this Profile Option as follows:

sqlplus apps/apps
SQL>select fnd_profile.value('APPS_MAINTENANCE_MODE')
from dual;

If the query returns ‘MAINT’, then Maintenance Mode has been Enabled and the Users will not be able to Login. If the query returns ‘NORMAL’ then Maintenance Mode has been De-Activated and the Users will be able to use the application.

How can you licence a product after installation ?

You can use ad utility adlicmgr to licence product in Oracle Apps.
 

What is adsplice utility ?
adsplice in oracle apps is utility to add a new product.

How you put Applications 11i in Maintenance mode ?
[applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env
[applmgr@srvr33 appltop]$ adadmin

 AD Administration Main Menu  --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration

Enter your choice [6] : 5

Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Enabled].


Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu

Here  internally call bellow Script
@$AD_TOP/patch/115/sql/adsetmmd.sql 

You can also put your application in maintencemode from backend :
Enable Maintenance mode :

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual; –> to check

Disable Maintenance mode :

SQL> @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE
SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual; –> to check

ADCTRL Options



[applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env
[applmgr@srvr33 appltop]$ adctrl

                AD Controller Menu
     ---------------------------------------------------

     1.    Show worker status

     2.    Tell worker to restart a failed job

     3.    Tell worker to quit

     4.    Tell manager that a worker failed its job

     5.    Tell manager that a worker acknowledges quit

     6.    Restart a worker on the current machine

     7.    Exit

ADADMIN Options


[applmgr@srvr33 appltop]$ . APPSdb4_srvr33.env
[applmgr@srvr33 appltop]$ adadmin

 AD Administration Main Menu  --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration

Enter your choice [6] : 1

         Generate Applications Files
   ----------------------------------------

   1.    Generate message files

   2.    Generate form files

   3.    Generate report files

   4.    Generate graphics files

   5.    Generate product JAR files

   6.    Return to Main Menu

Enter your choice [6] : 2

         Maintain Applications Files
   ----------------------------------------

   1.    Relink Applications programs

   2.    Create Applications environment file

   3.    Copy files to destinations

   4.    Convert character set

   5.    Maintain snapshot information

   6.    Check for missing files

   7.    Return to Main Menu

Enter your choice [6] : 3

        Compile/Reload Applications Database Entities
   ---------------------------------------------------

   1.    Compile APPS schema

   2.    Compile menu information

   3.    Compile flexfields

   4.    Reload JAR files to database

   5.    Return to Main Menu

Enter your choice [6] : 4

         Maintain Applications Database Entities
   ---------------------------------------------------

   1.    Validate APPS schema

   2.    Re-create grants and synonyms for APPS schema

   3.    Maintain multi-lingual tables

   4.    Check DUAL table

   5.    Convert to Multiple Reporting Currencies

   6.    Convert to Multi-Org

   7.    Return to Main Menu

Enter your choice [6] : 5

             Change Maintenance Mode
   ----------------------------------------

Maintenance Mode is currently: [Enabled].


Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system.  See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.


Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu