Skip Headers
Oracle® Fusion Applications Patching Guide
11g Release 6 (11.1.6)

Part Number E16602-16
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

9 Performing System Maintenance Tasks

This chapter describes the process of running Oracle Fusion Applications utilities to perform routine system maintenance tasks.

This chapter contains the following topics:

9.1 Introduction to AD Administration

AD Administration is a standalone utility that performs administration maintenance tasks for the products in your Oracle Fusion Applications Oracle home and your Applications Core Oracle home. The general purpose of the maintenance tasks is to keep your Oracle Fusion Applications files and database objects up-to-date. Some maintenance tasks should be performed systemwide on a regular basis, while others are required infrequently.

Run AD Administration by using the command-line utility, adadmin. This utility has a wrapper script that sets the environment and calls the utility. For UNIX, the wrapper is and for Windows it is adadmin.cmd. This brings you to the AD Administration main menu, where you select from a list of submenus that contain these task groups:

After the utility starts, it requires that you enter system information by responding to a series of prompts.

9.1.1 AD Administration Main Menu

The AD Administration main menu is the gateway to submenus, where you select the individual maintenance tasks. For example, selecting Maintain Snapshot Information takes you to the Maintain Snapshot Information submenu, where you can run tasks related to snapshots of the application-related files of a given Oracle home.

Figure 9-1 AD Administration Main Menu

AD Administration Main Menu

To select a submenu, enter the number of the submenu at the prompt.

9.1.2 Valid Command-Line Arguments

You may want to add arguments to the adadmin command to customize its operations. For example, you can add defaultsfile=defaultsfile_location to indicate that you want to create a defaults file for use in running maintenance tasks noninteractively, without the need to respond to prompts. For more information, see Section 9.4, "Running Maintenance Tasks Noninteractively".

9.1.3 Prompts and Password Security

When you run AD Administration, it prompts for information about your system. Prompts typically include a description of the information needed, and usually, a default answer is enclosed in brackets. Enter a response to the prompt, or press Enter to accept the default. AD Administration prompts include:

  • Confirmation of your Oracle home location

  • Log file name

  • Batch size

  • Confirmation of the correct database

Some submenu options may trigger additional system prompts associated with that task.

For increased security, the adadmin command does not prompt for passwords, nor does the program store passwords in clear text or obfuscated format in the restart or defaults file. Instead, it uses the Credential Store Framework (CSF) to store and retrieve passwords from the CSF wallet. For more information, see Section 2.4, "Oracle Fusion Applications Patching and the Security Model".

9.1.4 Starting AD Administration

Follow these steps to start the AD Administration utility:

  1. From any directory, start AD Administration with this command, adding any arguments that apply to this session:

    (UNIX) FA_ORACLE_HOME/lcm/ad/bin/ [argument]
    (Windows) FA_ORACLE_HOME\lcm\ad\bin\adadmin.cmd [argument]

    AD Administration starts and displays the first prompt.

  2. Respond to each prompt by either entering a value or pressing Enter to accept the default value. When you have responded to all of the prompts, the AD Administration main menu appears.

  3. Select a menu or submenu option by entering its number in the brackets at the bottom of the screen.

  4. From the next menu, select any task by entering its number.

  5. You can exit AD Administration from any submenu screen by entering the option number for Exit AD Administration.

9.2 Maintaining Snapshot Information

A snapshot represents each unique combination of Oracle home, product, and version at any given point of time. It includes information on each file maintained by Oracle Fusion Applications AutoPatch (AutoPatch) and a summary of database patches that have been applied to that Oracle home. The information maintained for each file includes the subdirectory where it is located, the name of the file and its version, and the file metadata. The files tracked in the snapshot are those files located in the following product family subdirectories: components, db, and patch. Because snapshots track only files for which there can be different versions as shipped by Oracle, they do not track C executable files or log files.

Each time you run Oracle Fusion Applications Patch Manager (Patch Manager) or AutoPatch, the snapshot is updated to include any new file copied to the Oracle home. When you apply a patch, Patch Manager performs version-checking against the file to determine which files must be replaced.

The snapshot can be either a current view or a named view.

Current View Snapshot

A current view snapshot is a copy of the current file system of the Oracle home. Patch Manager creates the current view. The current view is then updated every time a patch is applied and every time the Update Current View Snapshot process runs to maintain a consistent view. Patch Manager uses the current view snapshot to determine if all prerequisite patches have been applied to the Oracle home.

For more information, see Section, "Update Current View Snapshot".

Named View Snapshot

A named view snapshot is a copy of the current view snapshot that you create at a particular time and it is never updated. You can compare one or more named view snapshots to the current view snapshot or refer to previous states of your Oracle home, as needed. Complete file, file version information, and patch history is stored in a named view snapshot.

Properly maintained snapshots allow you to:

Snapshot Tables

Snapshot information is stored in several tables. They contain details such as:

Table 9-1 describes the tables related to snapshots.

Table 9-1 Snapshot Tables

Table Name Description


Records one entry for each snapshot.


Records all patches ever applied at the moment of snapshot creation for a specific snapshot.


Records all files associated with a particular snapshot.


Records all files associated with every snapshot in the system. Contains one entry for each file, regardless of how many snapshots and snapshot versions exist. This table may contain files that are no longer in the system to save files for past snapshots.


Records all versions for each file that are present in any snapshot.


Records all patches that have been applied to the Oracle home.

9.2.1 Maintain Snapshot Information Menu

You can select a task from the Maintain Snapshot Information submenu. Select the last option in the list to return to the AD Administration main menu.

Figure 9-2 Maintain Snapshot Information Menu

Maintain Snapshot Information Menu List Snapshots

This action queries the database and lists all snapshots. It displays the name, type, and comments for each snapshot stored in the AD_SNAPSHOTS table. Update Current View Snapshot

If your current view snapshot is not up-to-date, you can update it. An example of when you may need to run this task is when a snapshot may not have been updated as the result of an interruption during a patching session. All of the other snapshot maintenance tasks are based on the results of this task. You can choose to scan the entire Oracle Fusion Applications Oracle home for all installed product families to determine which component directories should be examined or you can choose a specific product family. For each of those components, it scans these product family subdirectories: components, db, and patch. It then updates the database as follows:

  • Inserts and updates the current view snapshot whenever the Update Current View Snapshot runs.

  • Modifies the file and file version information for the current view snapshot.

  • Sets the RAN_SNAPSHOT_FLAG column in the AD_SNAPSHOTS table to Y to indicate that the Update Current View Snapshot ran.

Figure 9-3 Maintain Current View Snapshot

Maintain Current View Snapshot menu Create a Named View Snapshot

This action lists the current view snapshot and prompts you to provide a name. It then performs the following actions:

  • Creates the named view snapshot.

  • Creates a file information list for this snapshot by copying from the current view snapshot.

  • Copies the bug fix list from the current view snapshot. Export a Snapshot to a File

This action lists the snapshots available for export. Then it copies the snapshot file details and snapshot bug fix information to an output file that you specify at the prompt. Import a Snapshot from a File

This action prompts you for the full path and name of the file you want to import. It then updates the snapshot tables with the imported snapshot details. Delete a Named View Snapshot

This action lists the snapshots available for deletion. For the snapshot you select, it deletes the file details and snapshot bug fix entries from the snapshot tables.

9.3 Maintaining Applications Database Entities

Database entities are objects or data related to Oracle Fusion Applications. During standard system use, some database entities may become invalid, for example, through user error or after you apply a large patch. Oracle recommends that you verify the integrity of database entities as a regular maintenance procedure, or whenever the activity of your system indicates that database entities may need revalidation.

AD Administration contains several tasks designed to manage database entities. You access them from the Maintain Applications Database Entities submenu. Some tasks in this menu report on issues, or potential issues, and others actually resolve the issues.

Figure 9-4 Maintain Applications Database Entities

Maintain Applications Database Entities

9.3.1 Compiling Invalid Objects

As you apply patches and make manual changes to the database, the number of invalid objects can increase. This process compiles invalid database objects in all schemas in the database. As soon as the compile process is complete, AD Administration generates an HTML report that contains information about any objects that remain invalid.

9.3.2 Running the Health Check

The health check process is a centralized set of validity checks that you can perform to ensure that the database is compatible with Oracle Fusion Applications. It validates the schemas and the database objects they contain to verify that they are valid.

The checks performed are as follows:

  • Confirms the presence and validity of ADM_DDL in the FUSION_RUNTIME schema

  • Identifies grants given to Oracle Fusion Applications and grants given by way of roles. Ensures that no grant is given with the admin option set to Yes. This task grants privileges to roles used by the FUSION_RUNTIME schema.

  • Performs various checks on Oracle Fusion Application such as ensuring that synonyms point to valid, existing tables.

  • Verifies that privileges are given to roles used by the FUSION_RUNTIME schema.

  • Generates a list of invalid objects, compiles the invalid objects, and issues a report that includes the commands to recompile the objects that remain invalid.

The health check process produces a report with its findings, named ad_health_check_report.html. It also creates two scripts that contain a set of corrective actions that you can take to fix the issues found by the analysis. The scripts may contain steps for you to follow to resolve an issue and they may also contain SQL actions that are executed when you run the script. The HTML file and both scripts are located in the FA_ORACLE_HOME /admin/SID/log directory.

The following scripts are created:

  • ad_health_fix_sys.sql: Run this script as sysdba.

  • ad_health_fix_fus.sql: Run this script as fusion.

9.3.3 Recreating Grants and Synonyms

This task grants privileges to roles used by the FUSION_RUNTIME schema.

9.3.4 Maintaining Multi-lingual Tables

The standard Oracle Fusion Applications Multilingual Support (MLS) table architecture requires that the multilingual tables (those ending with _TL) be fully populated for all active languages. For each row in the base table, there must be a corresponding row in the MLS table for each active language. The Maintain Multilingual Tables utility standardizes and centralizes the synchronization logic for all tables in Oracle Fusion Applications. It relies on the Application/XDF dictionary data to know which tables to synchronize and inserts records only when they are missing for a given language. When you install a language, this task automatically runs. You can also run it from the AD Administration menu when you have reason to believe that the data in the _TL table is not synchronized. For more information, see "Maintaining Oracle Fusion Applications Languages" in the Oracle Fusion Applications Upgrade Guide.

9.4 Running Maintenance Tasks Noninteractively

The previous sections have so far described how to run AD Administration interactively - you start the adadmin utility and respond to system prompts, select a submenu from the main menu, and then select the task you want to run from that submenu. You can also run AD Administration noninteractively by specifying a defaults file that contains the information necessary to run one of the maintenance tasks. The first time you create the defaults file, you run the adadmin command interactively, and then you can reuse the defaults file for the task that you performed.

This section describes the steps necessary to create a defaults file and save it for when you want to run one of the AD Administration tasks without user intervention. You may want to use the noninteractive functionality for long-running tasks, such as compiling the schema.

9.4.1 Creating a Defaults File

To create a defaults file, you add the option defaultsfile=defaults file location to your adadmin command. The following example syntax shows how to create a defaults file for compiling the schemas:

(UNIX) FA_ORACLE_HOME/lcm/ad/bin/ defaultsfile=FA_ORACLE_HOME/admin/$TWO_TASK/default_compile.txt

(Windows) FA_ORACLE_HOME\lcm\ad\bin\adadmin.cmd defaultsfile=FA_ORACLE_HOME\admin\%LOCAL%\default_compile.txt

The next time you want to perform this same task noninteractively, call the adadmin command in noninteractive mode and specify the defaults file. Then run the adadmin command interactively to record the history of the session in the specified defaults file.

The following example specifies the defaults file:

(UNIX) FA_ORACLE_HOME/lcm/ad/bin/ defaultsfile=FA_ORACLE_HOME/admin/$TWO_TASK/default_compile.txt interactive=no

(Windows) FA_ORACLE_HOME\lcm\ad\bin\adadmin.cmd defaultsfile=FA_ORACLE_HOME\admin\%LOCAL%\default_compile.txt interactive=no

When you use the defaults file in noninteractive mode, your adadmin session reads the contents of the defaults file to respond to the prompts.

9.4.2 Selecting a Menu Option Noninteractively

You can select a specific AD Administration menu option by specifying the menu name when you call the adadmin command. This functionality allows you to perform specific tasks somewhat noninteractively without using a defaults file. You must respond to the initial adadmin prompts. The following example shows how to run adadmin to compile the schemas:

(UNIX) FA_ORACLE_HOME/lcm/ad/bin/ menu_option=CMP_INVALID

(Windows) FA_ORACLE_HOME\lcm\ad\bin\adadmin.cmd menu_option=CMP_INVALID

If you select a menu option that contains additional prompts, such as List Snapshots, then you must respond to those prompts interactively. Table 9-2 provides a list of menu names that you can specify with menu_option when running the adadmin command.

Table 9-2 AD Administration Menu Options

Menu Name Description


Lists snapshots


Updates the current view snapshot


Updates the current view snapshot for a product


Creates a named view snapshot


Exports a snapshot to a file


Imports a snapshot from a file


Deletes a named view snapshot


Compiles schemas


Performs the health check analysis


Re-creates grants and synonyms for the FUSION_RUNTIME schema


Maintains multi-lingual tables

9.4.3 Selecting a Menu Option While Using a Defaults File

You can combine the functionality provided by adding menu_option to the adadmin command along with specifying a defaults file. This allows you to bypass responding to prompts interactively. However, if you add the menu_option selection to the adadmin command while referencing an existing defaults file, your session executes only that menu choice from the defaults file. For example, if your defaults file was created to compile schemas and update the current view snapshot, the following command would update only the current view snapshot:

(UNIX) FA_ORACLE_HOME/lcm/ad/bin/ menu_option=update_current_view defaultsfile=FA_ORACLE_HOME/admin/$TWO_TASK/mydefaults.txt

(Windows) FA_ORACLE_HOME\lcm\ad\bin\adadmin.cmd menu_option=update_current_view defaultsfile=FA_ORACLE_HOME\admin\%LOCAL%\mydefaults.txt

9.5 Running the HomeChecker Utility

The HomeChecker utility verifies the correctness of any Oracle Fusion Applications Oracle home directory. It verifies that the duplicated Oracle Applications Development Framework (Oracle ADF) libraries within Oracle Fusion Applications are synchronized with each other. While separate copies of the libraries are maintained, they are treated logically as a unit and this utility verifies that the libraries are still consistent with each other. HomeChecker also ensures that the artifacts within the Oracle home match the central Oracle Inventory, to confirm that the artifacts were laid down either as part of the initial installation or by a subsequent patch. For more information, see Section 2.1.5, "Oracle Universal Installer (OUI) Inventory".

The HomeChecker output displays the following information:

You would most likely run the HomeChecker utility when you are working with Oracle Support Services to diagnose issues with your environment.

To run the HomeChecker utility

Run the following command:

(UNIX) FA_ORACLE_HOME/lcm/ad/bin/ -validate FA_ORACLE_HOME path [-logfile log file name] [-prodfamily comma-separated list of product families] [-reportfile 
report file path] [-loglevel log level]

(Windows) FA_ORACLE_HOME\lcm\ad\bin\homechecker.cmd -validate FA_ORACLE_HOME path [-logfile log file name] [-prodfamily comma-separated list of product families] [-reportfile
report file path] [-loglevel log level]

Table 9-3 HomeChecker utility parameters

Parameter Description Mandatory


Specify the path to FA_ORACLE_HOME



Overrides the default log file name and sends the processing information to the file you specify, under the FA_ORACLE_HOME/admin/FUSION/log directory



Supply a comma-separated list of product families you want to see on the report



Supply the directory path and file name for report output

No, the default is the current directory


Records messages in the log file at the level you specify. Enter a value to override the default log level of INFO. See Section 10.1, "Oracle Fusion Applications Patch Manager Logging".