Logo Background

Oracle Administration Using adadmin

  • By on November 19, 2008 | 14 Comments

    AD Admin

    Continuing our discussions on ad utilities today i will discuss about the most commonly used ad utility adadmin. Adadmin is a utility that performs a number of tasks required from maintain and administering an Oracle Applications instance.

    On a broad level the tasks performed by adadmin can be categorized into database activities and Applications file system management tasks.

    In addition to these, adadmin in 11.5.10 onwards you can use adadmin to put the system in Maintenance Mode also. Maintenance mode is special mode introduced to facilitate maintenance tasks like patch application.

    Before you run adadmin you must ensure the following.

    Set your applications environment
    Ensure that you have sufficient space in tmp disk.
    For certain adadmin task you may require to shutdown your concurrent managers

    You can run adadmin by typing adadmin at the command prompt after setting the environment.

    $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

    Previous
    Next
    » Oracle Application Security Hardening
14 Comments
  1. #1 anis
    May 29, 2009 12:32 am

    Which option should i chose to compile forms

    Post ReplyPost Reply
  1. #2 Jing Hong
    May 29, 2009 4:24 am

    Hi Anis,

    To compile Oracle Forms, please refer to http://www.allguru.net/consultant/oracle-apps-dba/compile-fmb-mmb-pll/

    Post ReplyPost Reply
  1. #3 Jing Hong
    May 29, 2009 4:27 am

    Or using adadmin, you can go to Generate Applications Files Menu – Generate form files to recompile your form.

    Post ReplyPost Reply
  1. #4 malli
    October 16, 2009 8:49 am

    you have to select generate applications files menu in that forms

    Post ReplyPost Reply
  1. #5 Amit
    March 2, 2010 10:59 am

    Hi,

    I need to re-compile all flexfields and forms in adadmin. Please suggest how can I do so.

    Thanks in advance,
    Amit

    Post ReplyPost Reply
  1. #6 Jing Hong
    March 3, 2010 12:30 am

    You can recompile the flexfield by choosing option (3) Compile/Reload Applications Database Entities menu and then option (5) Compile flexfields. For forms compilation choose (1) Generate Applications Files menu and (2) Generate form files.

    All this option will be available for you after launching adadmin console.

    Post ReplyPost Reply
  1. #7 Hussain
    May 11, 2010 12:15 am

    Hi Guru, There was some issue when we were saving data in flexfields, I tried re-compiling the flexfields in test instance and the issue got resolved. When can I run the re-compile flexfields option in Production instance? In all the adadmin documentation it is mentioned to only compile flexfields if it is mentioned in Patch readme. Please suggest.

    Thanks & Regards,
    Hussain

    Post ReplyPost Reply
  1. #8 Jing Hong
    May 11, 2010 12:33 am

    Hi Hussain, shutdown the application before running the flexfield compilation using adadmin in Production. Is a good practice as we don’t want user to access the flexfield during the compilation time which might cause error.

    Post ReplyPost Reply
  1. #9 Hussain
    May 11, 2010 8:05 am

    Thanks Guru for your quick and kind help.

    Post ReplyPost Reply
  1. #10 indu
    June 6, 2010 10:15 am

    hi guru,
    my application is in multi node environment. admin, concurrent, report servers are in node A. form and web servers are in node B. i am requested to run adadmin to generate forms, so where do i need to run adadmin whether it is in node A or node B? if so node A, why node A? if so node B, why node B?

    Post ReplyPost Reply
  1. #11 Jing Hong
    June 7, 2010 11:15 pm

    Hi Indu, you just need to run once if your multi node apps environment is running on shared APPL_TOP architecture where all the apps node refer to centralized source code such as forms and reports.

    Post ReplyPost Reply
  1. #12 shubhod salian
    July 22, 2010 1:05 am

    Hi Indu,

    You need to execute adadmin on node B , simply because your forms server resides on this node. This should work fine. Let me know the results.

    Regards
    Shubhod
    DBA Apps
    Tata Power
    Bangalore

    Post ReplyPost Reply
  1. #13 venky
    November 28, 2010 8:33 am

    Hi All,
    Can somebody help me with the below issue.

    I logged in to EBS. Chose MANUFACTURING OPERATIONS CENTER USER/in that. When i try to open any option it should open a JSP page. But i am getting page cannot be displayed. Donno why! I tried a lot.At last I got a doc in metalink which says please run flexfields.

    What i want to know is how come compiling flexfields related to this issue. If I run flexfields what happens actually. If don’t mind can somebody give reply asap.

    Post ReplyPost Reply
  1. #14 praveen kumar
    December 17, 2013 10:29 pm

    how to compile the jsps with adadmin?

    NOTE: I KNOW OTHER WAY TO COMPILE JSP IS
    perl ojspcompile.pl

    Post ReplyPost Reply
Leave a Comment