Top-Rated Free Essay

Oracle Apps DBA ADADMIN Paper

Satisfactory Essays
ADADMIN

At the time of execution adadmin prompts you to verify and enter several information pertaining to your applications installation like APPL_TOP location ,ORACLE_HOME.adadmin log file name,batch size etc.
Adadmin can also be run in a non interactive mode. This is accomplished by creating a defaults file.The defaults file must be place at the location $APPL_TOP/admin/[sid]/
You can create the defaults file with the following syntax
$adadmin defaultsfile=$APPL_TOP/admin/[sid]/samtask.txt
Next time you can run adadmin for the same task by specifying the interactive=no option. adadmin defaultsfile=APPL_TOP/admin/vis/samtask.txt logfile=adadmin_091306.log workers=9 interactive=no If your previous session of adadmin had encountered with problems adadmin prompts you to either continue with your old session or start with a fresh session as show below
Your previous AD Administration session did not run to completion.
Do you wish to continue with your previous AD Administration session [Yes] ?
The main menu of adadmin presents you with the following six choices
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
First two options are related to maintaining applications file system the second twop options relate to database activities ,the fifth option here is used to put the system in maintenance mode and bring it back from maintenance mode.
Under the Generate Applications Files Menu you can perform the following tasks
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
Under the Maintain Applications Files menu you can perform the following tasks
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
Under the Compile/Reload Applications Database Entities menu you can perform the following tasks
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
Under the Maintain Applications Database Entities menu you can perform the following tasks
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. Maintain Multiple Reporting Currencies schema
6. Return to Main Menu
Under the Change Maintenance Mode you can do the following
Change Maintenance Mode
————————-————————-
Maintenance Mode is currently: [Disabled].
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
If you notice the message this menu selection also shows the maintenance status (disabled in our case) of the system.
You can also forcefully exit adadmin at any point of time by typing ‘abort‘,This will however result in a unclean exit of adadmin and the next time when you run adadmin you will be prompted with the option to start fresh or continue with the previous session as described earlier

You May Also Find These Documents Helpful

  • Better Essays

    Notes on Oracle Dba

    • 72273 Words
    • 290 Pages

    OOracle® Database 2 Day DBA 10g Release 2 (10.2) B14196-03 April 2012 Oracle Database 2 Day DBA, 10g Release 2 (10.2) B14196-03 Copyright © 2004, 2012, Oracle and/or its affiliates. All rights reserved. Primary Author: Colin McGregor Contributing Author: Sushil Kumar, Antonio Romero, David Austin, Steve Fogel, Lance Ashdown, and Douglas Williams Contributor: Michele Cyran, Daniela Hansell, Vasudha Krishnaswamy, Peter Laquerre, Venkat Maddali, Mughees Minhas, JP Polk, Mark Townsend, and Wanli…

    • 72273 Words
    • 290 Pages
    Better Essays
  • Good Essays

    PRIYANK KHAMAR Oracle DBA

    • 1987 Words
    • 7 Pages

    IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 11g/10g/9i/8ion Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform. Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i,9i to 10g and 10g to 11g applied oracle patches. Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS…

    • 1987 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Questions for Oracle Database Administrator. As of now it contains 120 Questions. These questions are common for both Senior Oracle DBA or Junior DBA. I have divided the questions into 3 categories Technical Interview Questions, Unix Related questions asked to an Oracle Database Administrator (DBA) and Backup and Recovery Interview Questions commonly asked in Oracle DBA interview 1. What is an Oracle Instance? 2. What information is stored in Control File? 3. When you start an Oracle DB which file…

    • 1429 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    After watching the video, please answer the following questions: 1. List the business processes displayed in the video. A business process is a collection of related, structured activities or tasks that produce a specific service or product for a particular customer(s). In FedEx case, the business process is the packages sorting in order to ship them to customers in many destinations inside and outside the U.S. As displayed in the video, first, a FedEx agent picks up a package and scans it, entering…

    • 1448 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Oracle EBS

    • 2271 Words
    • 43 Pages

    Oracle E-Business Suite APPS, SYSADMIN, and oracle Securing Generic Privileged Accounts May 15, 2014 Mike Miller Stephen Kost Chief Security Officer Chief Technology Officer Integrigy Corporation Integrigy Corporation Phil Reimann Director of Business Development Integrigy Corporation Agenda Best Practices Overview 1 2 EBS Privileged Accounts 3 Q&A 4 Logging Auditing & Monitoring 5 About Integrigy ERP Applications Databases Oracle…

    • 2271 Words
    • 43 Pages
    Powerful Essays
  • Satisfactory Essays

    oracle

    • 3885 Words
    • 16 Pages

    ORACLE 10g ASM May 17th, 2006 Inderpal S. Johal Principal Consultant Agenda What is ASM Benefits of ASM ASM Architecture ASM Components DB Instance parameters to support ASM ASM Instance Monitoring using EM ASM Views Migrating from File system to ASM Miscellaneous Tips Q&A Data Softech Inc. Oracle 10g ASM 2 What is ASM ASM stands for Automatic Storage Management It is Oracle Cluster File System and Volume Manager Designed for Oracle Database Related Files Provide…

    • 3885 Words
    • 16 Pages
    Satisfactory Essays
  • Good Essays

    Oracle

    • 5656 Words
    • 23 Pages

    Oracle - Oracle- Database Management System Data management is an extraordinarily old craft. Aristotle 's scheme of interlocking classifications of knowledge in his work Physica is a data-management effort. In the early 1800s the Jacquard loom used holes punched in paper cards to represent instructions for controlling the action of a loom. These cards became the basis for Herman Hollerith’s card-sorting device, used for the 1890 U.S. census http://80-gme.grolier.com.ezproxy.apollolibrary.com. Many…

    • 5656 Words
    • 23 Pages
    Good Essays
  • Good Essays

    Oracle

    • 503 Words
    • 3 Pages

    1. What assumptions underlie Oracle’s recognition of revenue for license fee. Are these assumptions reasonable given the firm’s business and operating policies? Oracle recognized its license fee either upon shipment of the product or at the time such agreements are effective. In most instance is this the date of the agreement. The assumptions underlying this method is that if the customer is creditworthy and the terms of the agreement are such that the amounts are due within one year and are non-refundable…

    • 503 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Oracle

    • 32236 Words
    • 129 Pages

    Introduction to Oracle9i: SQL Instructor Guide • Volume 1 40049GC11 Production 1.1 October 2001 D33993 Authors Copyright © Oracle Corporation, 2000, 2001. All rights reserved. Nancy Greenberg Priya Nathan This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation…

    • 32236 Words
    • 129 Pages
    Powerful Essays
  • Powerful Essays

    Dba Check List

    • 2848 Words
    • 12 Pages

    DBA Check List Oracle DBA Checklist Version 1.4 Generic Revised: 23-Aug-2000 Authors: Thomas B. Cox, with Christine Choi Purpose: This document gives details for performing daily, weekly, and monthly checks of the status of one or more Oracle databases. All SQL and PL/SQL code for the listed checks can be found in the appendix. The latest version of this paper should always be available on the primary author 's home page, . Change Notes: 1.1: Typo in 'existext.sql…

    • 2848 Words
    • 12 Pages
    Powerful Essays