Reports a summary of the timing for jobs run by parallel workers. Web-Based Utilities Oracle Applications Manager OAM provides a Web-based interface where system administrators can monitor system status, administer services, examine system configuration, manage Oracle Workflow, view applied patches, and measure system usage. It provides a concise overview of the state of your Oracle E-Business Suite system, and serves as a gateway to utilities for tasks such as managing system configuration, reviewing patch history, determining which patches will bring your system up to date, registering additional products and languages, and other maintenance activities. The Web-based maintenance utilities are listed in the following table. You can search the database to create reports in several formats.

Author:Voodoom Aramuro
Language:English (Spanish)
Published (Last):24 January 2005
PDF File Size:16.98 Mb
ePub File Size:19.11 Mb
Price:Free* [*Free Regsitration Required]

We run maintenance tasks from the command line using AD Administration. Once we start this utility, it presents the tasks in menu form, grouped generally by type of activity you will perform.

For example, the tasks associated with compiling and reloading Applications database entities are grouped on the same menu. We can use AD Administration to complete some runtime tasks during or after an installation or upgrade, or any time thereafter. On a broad level the tasks performed by adadmin can be categorized into database activities and Applications file system management tasks. Similar to AutoInstall and AutoPatch, adadmin can run parallel workers for most database tasks and some file system tasks.

Preliminary Tasks before running Adadmin: 1. Logging in as applmgr. Shutting down concurrent managers when relinking certain files or performing certain database tasks. Ensuring sufficient temporary disk space. Running Adadmin: AD Administration asks you some initial questions. It asks for the name of the log file. By default this is adadmin. It asks if we want to receive an email message if adadmin encounters a failure.

Some SQL scripts perform row set processing. Adadmin asks us to set the number of rows these scripts process. It asks us the type of files we currently have. It asks us to confirm the database and database home directory. It then determines the username for your Application Object Library user. Adadmin determines other installation information. Generate Applications Files menu 2. Maintain Applications Files menu 3. Maintain Applications Database Entities menu 5.

Change Maintenance Mode 6. Exit AD Administration The first two options are related to maintaining applications file system and the second two options related to the database activities, the fifth option here is used to put the system in maintenance mode and bring it back from maintenance mode.

Generate Applications Files: If system users are having difficulty accessing messages, forms, or reports, you may be able to resolve the issue by generating the associated files. Or, when you apply a patch that adds or changes product functionality, you may want to generate the associated files after you apply the patch, instead of running the generate driver during the patching downtime. The generate files tasks may be performed on any server, as required.


Getting Started

Enter your AD Administration log file name or press [Return] to accept the default file name shown in brackets. Filename [adadmin. Do you wish to activate this feature [No]? The Applications System name must be unique across all Oracle Applications Systems at your site, must be from 1 to 30 characters long, may only contain alphanumeric and underscore characters, and must start with a letter.


Oracle Apps DBA Reference

This task compiles objects owned and referenced by the APPS schema only. When you type Yes at this prompt, Invoker Rights processing runs only on packages that have changed since Invoker Rights processing was last run. Using this option after you modify flexfields for the first time improves performance at runtime. If the DUAL table does not exist, or if it does not contain exactly one row, Oracle Applications products that access this table will fail. Compile menu it compile all the menus in the database. Please refer below article to get information about it Maintain Applications Files Relink Applications programs Relinks Oracle Applications executable programs with the Oracle server libraries so that they function with the Oracle database.


AD Utilities(adadmin, adrelink , adident, ADMRGPCH)

Running the environment file. Shutting down the concurrent managers when relinking certain files or performing certain database tasks. Ensuring Sufficient temporary disk space. This name can be Changed when starting up AD Administration. We generally perform this task only when instructed to do so in a readme file of a patch.

Related Articles