Oracle Corp. and/or its affiliates.

Oracle Diagnostic Assistant Admin Main Menu - Documentation

main - Oracle Diagnostic Assistant Admin Main Menu 
         
  The Admin Main Menu enables you to perform limited admin functions.
    
  Select one of the following options:
    (1) Manage Properties
    (2) Data Collection History
    (3) Diagnostic Assistant Version 
  
    (H)elp   (E)xit

[+] Toggle Help

Showing Menu Help: 
  Oracle Diagnostic Assistant: Admin Main Menu.   
     
  The Admin Mainn Menu enables you to perform limited 
  admin functions.
    
  Explanation of available options:
    (1) Manage Properties
        This selection provides options for viewing and managing property values
        There are currently 2 property files used by the Diagnostic Assistant:
          o da.properties which defines common properties 
          o user.properties has limited functionality - it is 
            possible that this file is empty
			  
        Note: some properties are not defined until prompted for the first
              time within the tool (Ie. MOS Username, CSI) or explicitely 
              set using this menu
			  
        UNDER NO CIRCUMSTANCES MUST THE PROPERTY FILES BE MODIFIED manually. 
        Use this Manage Properties menu to perform the modifications allowed.
			   
        This menu also includes an option to restore all properties back to 
        their original default values.
			   
    (2) Data Collection History
        This option provides access to view summary and detailed information
        of data collections performed
		
        Currently, you can view the latest OCM collection's detail or 
        summary information.  Also, a list of a diagnostic collections 
        executed during the current session is available for viewing.
			   
    (3) Diagnostic Assistant Version
        This option displays the Diagnostic Assistant version number, 
        build number and build date.
		Also included are the versions of ADR, RDA ad OCM (if they exist)
		
        This information is helpful when logging a service request for
        the Diagnostic Assistant or in debugging issues with
        Development.
		
        Make sure you have the latest version of the tool, by
        comparing your version with latest version documented in 
        MOS knowledge article 201804.1.

Menu Option: 1  -  [+] Show Menu Details
Menu Option: 2  -  [+] Show Menu Details
Menu Option: 3  -  [+] Show Command Details
Top | Back

AdminProp - Manage Properties 
  
  The following options allow for viewing the properties    
  files and managing the stored properties.
      
  Select one of the following options:
    (1) View da.properties
    (2) View user.properties 
    (3) Change User Configuration values
    (4) Reset User Configuration values
    (5) Allow/Disallow saving passwords
    (6) Allow/Disallow browser viewer


    (M)ain    (B)ack    (H)elp   (E)xit

[+] Toggle Help

Showing Menu Help: 
  Admin Main Menu: Manage Properties Menu Help
    
  Explanation of available options:
	
    (1) View da.properties
        o displays da.properties file contents
        o results will display on the screen page by page
			   
    (2) View user.properties
        o displays user.properties file contents
        o results will display on the screen page by page
        
    (3) Change User Configuration values
        o Permits change of property values previously set, including
          passwords (if applicable)
        o Useful in case the values were incorrectly entered when 
          initially prompted or the value has changed for any reason

    (4) Reset User Configuration values
        o Permits reset to the original default value for property values 
          previously set, including passwords (if applicable)
        o Can choose to reset a single property value or ALL
        o Does not prompt for new values; it simply removes the existing value
          and sets it to the default value, if there is one
    
    (5) Allow/Disallow saving passwords
        o By selecting this option, the 'use_wallet' property can
          be changed to TRUE (which allows passwords to be saved in a 
          secure Oracle wallet) or FALSE (which does not allow
          passwords to be saved, and so the user is prompted each time).
        o This property is set to FALSE by default
              
    (6) Allow/Disallow browser viewer
        o By selecting this option, the 'browser_viewer_spawned' property can
          be changed to TRUE.
        o This property is set to FALSE by defalt
                       			  
    Note: Oracle wallet is used to secure passwords

Menu Option: 1  -  [+] Show Command Details
Menu Option: 2  -  [+] Show Command Details
Menu Option: 3  -  [+] Show Menu Details
Menu Option: 4  -  [+] Show Menu Details
Menu Option: 5  -  [+] Show Command Details
Menu Option: 6  -  [+] Show Command Details
Menu Option: M  -  [+] Show Menu Details
Menu Option: B  -  [+] Show Menu Details
Top | Back

ChangeProp - Change User Configuration Values 
  
  The following options allow for changing property values.
      
  Select one of the following options:
    (1) Change a specific property value
    (2) Change a saved password

    (M)ain    (B)ack    (H)elp   (E)xit

[+] Toggle Help

Showing Menu Help: 
  Admin Main Menu: Change Properties Menu Help
    
  Explanation of available options:
	
    (1) Change a specific property value
        o Select from the list of available properties dislayed
        o Permits reset of a single value stored in da.properties or
          user.properties
          
    (2) Change a saved password
        o Only applies if Allow saving passwords is TRUE
        o Select from the list of available passwords dislayed
        o Permits reset of a single password value

Menu Option: 1  -  [+] Show Command Details
Menu Option: 2  -  [+] Show Command Details
Menu Option: M  -  [+] Show Menu Details
Menu Option: B  -  [+] Show Menu Details
Top | Back

ResetProp - Reset User Configuration 
  
  The following options allow for changing property values.
      
  Select one of the following options:
    (1) Reset a specific property value
    (2) Reset a saved password
    (3) Reset ALL Stored Properties and Passwords

    (M)ain    (B)ack    (H)elp   (E)xit

[+] Toggle Help

Showing Menu Help: 
  Admin Main Menu: Reset Properties Menu Help
    
  Explanation of available options:
	
    (1) Reset a specific property value
        o Select from the list of available properties dislayed
        o Resets a single value stored in da.properties or
          user.properties to the default, or NO VALUE if there is not one
    (2) Reset a saved password
        o Select from the list of available passwords dislayed
        o Removes the value stored for the password chosen
    (3) Reset ALL Stored Properties and Passwords
        o Removes the values from all properties and passwords
        o Sets those that have a default to that value, or NO VALUE if there 
          is not one

Menu Option: 1  -  [+] Show Command Details
Menu Option: 2  -  [+] Show Command Details
Menu Option: 3  -  [+] Show Command Details
Menu Option: M  -  [+] Show Menu Details
Menu Option: B  -  [+] Show Menu Details
Top | Back

AdminFile - Data Collection History 
   
  Data Collection History allows the viewing of OCM summary 
  and detail information as well as other diagnostic files.
    
  Select one of the following options:
    (1) Latest OCM Collection Summary
    (2) Latest OCM Collection Detail
    (3) RDA Collections Summary
    (4) RDA Collections Detail
    (5) ADR Collections Summary
    (6) ADR Collections Detail
	  
    (M)ain    (B)ack    (H)elp   (E)xit

[+] Toggle Help

Showing Menu Help: 
   
  Admin Main Menu: Data Collection History Menu Help

  Explanation of available options:
	
    (1) Latest OCM Collections Summary
        o Retrieves the latest configuration summary data and provides
          immediate viewing of this data

    (2) Latest OCM Collections Detail
        o  Retrieves the latest configuration summary data and provides
           immediate viewing of this data
          
    (3) RDA Collections Summary
        o list of all RDA collections, including what and when
		   
    (4) RDA Collections Detail
        o list of all the files created for each collection listed 
          in the summary
        o output will be extensive, but a paging menu will be 
          available for scrolling
            
    (5) ADR Collections Summary
        o List of all ADR incidents
		   
    (6) ADR Collections Detail
        o Shows incident detail
        o Future: additional detail is planned

Menu Option: 1  -  [+] Show Command Details
Menu Option: 2  -  [+] Show Command Details
Menu Option: 3  -  [+] Show Command Details
Menu Option: 4  -  [+] Show Command Details
Menu Option: 5  -  [+] Show Command Details
Menu Option: 6  -  [+] Show Command Details
Menu Option: M  -  [+] Show Menu Details
Menu Option: B  -  [+] Show Menu Details
Top | Back

COMMAND: adr_173
COMMAND TYPE: Adr
COMMAND TITLE: Summary of Incidents
COMMAND DESCRIPTION: 
  Command Summary
    This command retrieves the latest configuration summary data and provides
    immediate viewing of this data.

  Input Requirements
    o None
    
  Ouput Details
    o Example: sample below has 0 incidents so is not truly reflective
      of a production environment
              
                           ADR Summary
          =================================================
          ORACLE_HOME:  /u01/app/oracle/product/11.2.0.1.0
             ADR Base:  /u01/app/oracle
             ADR Home:  diag/rdbms/v1121/V1121
          ORACLE_SID:  V1121
          =================================================
          =================================================
          Displaying the 5 Most recent ADR incidents
          =================================================
          Incident ID: 0
          Created: <NULL>
          Error: <NULL>-0
COMMAND ARGUMENT(S): 
summary
Top|Back

COMMAND: adr_174
COMMAND TYPE: Adr
COMMAND TITLE: Incidents Detail
COMMAND DESCRIPTION: 
  Command Summary
    This command retrieves the latest configuration summary detail and provides
    immediate viewing of this data.
    
    NOTE: Limited summry details are currently available
          More details will be added in coming releases    
      
  Input Requirements
    o None
    
  Ouput Details
    o Example:
                          Summary Detail
          =================================================
          ORACLE_HOME:  /u01/app/oracle/product/11.2.0.1.0
             ADR Base:  /u01/app/oracle
             ADR Home:  diag/rdbms/v1121/V1121
          ORACLE_SID:  V1121
          =================================================
          =================================================
          Displaying the 5 Most recent ADR incidents
          =================================================

                        Additional Details
          =================================================
          Displaying the last 500 lines of
          /u01/app/oracle/diag/rdbms/v1121/V1121/trace/V1121_ora_6782.trc
          -------------------------------------------------
          _bloom_predicate_enabled            = true
          _optimizer_enable_extended_stats    = true
          _is_lock_table_for_ddl_wait_lock    = 0
          _pivot_implementation_method        = choose
          optimizer_capture_sql_plan_baselines = false
          optimizer_use_sql_plan_baselines    = true
          _optimizer_star_trans_min_cost      = 0
          ...
COMMAND ARGUMENT(S): 
summary detail
Top|Back

COMMAND: ocm_201
COMMAND TYPE: Ocm
COMMAND TITLE: Tool Help
COMMAND DESCRIPTION: 
  Command Summary
    This command shows how to call the configuration collector and describes
    available actions and syntax
      
  Input Requirements
    o None
    
  Ouput Details
    o List of available options and corresponding actions and syntax
COMMAND ARGUMENT(S): 
help
Top|Back

COMMAND: ocm_202
COMMAND TYPE: Ocm
COMMAND TITLE: Latest Configuration Summary
COMMAND DESCRIPTION: 
  Command Summary   
    This command retrieves the latest configuration summary data and provides
    immediate viewing of this data  
      
  Input Requirements
    o None
    
  Ouput Details
    o Latest configuration summary level information is displayed
COMMAND ARGUMENT(S): 
summary
Top|Back

COMMAND: ocm_203
COMMAND TYPE: Ocm
COMMAND TITLE: Latest Configuration Detail
COMMAND DESCRIPTION: 
  Command Summary
    This command retrieves the latest configuration summary detailed data 
    and provides immediate viewing of this data. 
      
  Input Requirements
    o None
    
  Ouput Details
    o Latest configuration detail level information is displayed
COMMAND ARGUMENT(S): 
summary detail
Top|Back

COMMAND: rda_392
COMMAND TYPE: Rda
COMMAND TITLE: Collection Summary
COMMAND DESCRIPTION: 
  Command Summary
    This command shows the last collection details (what, where and when)
    followed by a collection summary of each modue and profile discovered. 
      
  Input Requirements
    o None
    
  Ouput Details
    o Results are:
            Last Collection(x) for: RDA
            Date: Tue Feb 28 07:19:06 EST 2012
            Output Directory: $ORACLE_HOME/rda/da/output/rda/DB11g/output
            COLLECTION SUMMARY:
              Overview
              Operating System Setup
              User Profile
              Performance
              ....
COMMAND ARGUMENT(S): 
summary
Top|Back

COMMAND: rda_393
COMMAND TYPE: Rda
COMMAND TITLE: Collection Detail
COMMAND DESCRIPTION: 
  Command Summary
    This command includes the  the summary details as well as a list of
    all the detailed files for that collection.
    This is repeated for each collection discovered.
      
    Input Requirements
      o None
    
    Ouput Details
      o Results are repeated for each collection found:
         Last Collection(x) for: RDA
         Date: Tue Feb 28 10:21:36 EST 2012
         Output Directory: $ORACLE_HOME/rda/da/output/rda/LOG/output
         COLLECTION SUMMARY:
           Overview
           RDBMS Log/Trace Files

         FILE LIST:
         DA_S919LOAD_A.fil
         DA_LOG_alert_log.htm
         DA_LOG_last_errors.htm
         DA_LOG_diag_problems.htm
         ....
COMMAND ARGUMENT(S): 
summary detail
Top|Back

COMMAND: sys_649
COMMAND TYPE: System
COMMAND TITLE: All Tool Versions
COMMAND DESCRIPTION: 
  Command Summary
    This command displays the version of the Diagnostic Assistant
    tool as well as versions of ADR, RDA and OCM.
      
  Input Requirements
    o None
    
  Ouput Details
    o Version of the Diagnostic Assistant tool currently running
    o Version of ADR, RDA and OCM installed
    o Example:
          DA Version:         1.2.0-b631 
          RDA Version:        4.26 
          OCM Version:        10.3.6.0.2 
          ADR Version:        11.2.0.1.0 
          Sqlplus Version:    11.2.0.1.0
COMMAND ARGUMENT(S): 
show_component_versions
Top|Back

COMMAND: sys_651
COMMAND TYPE: System
COMMAND TITLE: Stored Properties
COMMAND DESCRIPTION: 
  Command Summary
    This command displays Diagnostic Assistant tool level stored properties.
      
  Input Requirements
    o None
    
  Ouput Details
    o Contents of the da.properties file
COMMAND ARGUMENT(S): 
show_da_properties
Top|Back

COMMAND: sys_652
COMMAND TYPE: System
COMMAND TITLE: User Properties
COMMAND DESCRIPTION: 
  Command Summary
    This command displays Diagnostic Assistant user level stored properties.
      
  Input Requirements
    o None
    
  Ouput Details
    o Contents of the user.properties file
COMMAND ARGUMENT(S): 
show_user_properties
Top|Back

COMMAND: PREREQ_REQ_SETUP_PROP
COMMAND TYPE: OS
COMMAND TITLE: Valid values for required_setup_properties.ini
COMMAND DESCRIPTION: 
TODO
COMMAND ARGUMENT(S): 
      echo DA.mos_csi
      echo DA.mos_userid
      echo DA.host.DA_PROCWATCHER_DIR
      echo DA.host.DA_OSWBB_DIR
      echo DA.host.DA_OSWATCHER_DIR
      echo DA.host.DA_EXACHK_DIR
      echo DA.host.sqlt_dir
      echo DA.host.tom_home
      echo DA.host.hangfg_dir
      echo DA.host.stackx_loc
Top|Back

COMMAND: sys_663
COMMAND TYPE: System
COMMAND TITLE: Change User Configuration values
COMMAND DESCRIPTION: 
  Command Summary

    This command allows you to change the existing value for a
    setup property.
      
  Input Requirements
    o Selection of a property to change
    o The new value for the property
    
  Ouput Details
    o Confirmation that the value for the given property has been set to the
      new value
command_prompt1:
PREREQ_REQ_SETUP_PROP|Please choose a property to change |PREREQ_REQ_SETUP_PROP:all
COMMAND ARGUMENT(S): 
set_property %%PREREQ_REQ_SETUP_PROP%% show_before_set
Top|Back

COMMAND: PREREQ_PASSWORD_PROP
COMMAND TYPE: OS
COMMAND TITLE: Valid values for passwords in required_setup_properties.ini
COMMAND DESCRIPTION: 
TODO
COMMAND ARGUMENT(S): 
      echo DA.mos_password
      echo DA.host.celladmin_password
      echo DA.root_password
      echo DA.system.SQLPLUS_PASSWORD
      echo DA.scott.SQLPLUS_PASSWORD
Top|Back

COMMAND: sys_664
COMMAND TYPE: System
COMMAND TITLE: Change Saved Passwords
COMMAND DESCRIPTION: 
  Command Summary
    This command allows you to change the existing value for a stored
    password.
      
    Input Requirements
      o Selection of a password to change
      o The new value for the password
    
    Ouput Details
      o Confirmation that the value for the password has been changed
command_prompt1:
PREREQ_PASSWORD_PROP|Please choose which password to change |PREREQ_PASSWORD_PROP:all
COMMAND ARGUMENT(S): 
set_wallet_property %%PREREQ_PASSWORD_PROP%%
Top|Back

COMMAND: PREREQ_BOOLEAN
COMMAND TYPE: OS
COMMAND TITLE: Valid values for boolean questions
COMMAND DESCRIPTION: 
TODO
COMMAND ARGUMENT(S): 
      echo TRUE
      echo FALSE
Top|Back

COMMAND: PREREQ_YES_NO
COMMAND TYPE: OS
COMMAND TITLE: Valid values for YES/NO questions
COMMAND DESCRIPTION: 
TODO
COMMAND ARGUMENT(S): 
      echo YES
      echo NO
Top|Back

COMMAND: sys_665
COMMAND TYPE: System
COMMAND TITLE: Allow/Disallow Saving Passwords
COMMAND DESCRIPTION: 
  Command Summary
    This command can be used to allow or disallow passwords (credentials)
    entered	into Diagnostic Assistant to be saved. By default, this 
    functionality is disallowed (FALSE).
      
  Input Requirements
    o TRUE or FALSE
    
  Ouput Details
    o Confirmation that the value chosen was saved
command_prompt1:
PREREQ_BOOLEAN|Allow credentials to be saved|PREREQ_BOOLEAN:all
COMMAND ARGUMENT(S): 
set_da_property use_wallet %%PREREQ_BOOLEAN%%
Top|Back

COMMAND: sys_666
COMMAND TYPE: System
COMMAND TITLE: Configured Properties
COMMAND DESCRIPTION: 
  Command Summary
    This command can be used to allow or disallow use of a browser viewer.
    By default, this functionality is disallowed (FALSE).
      
  Input Requirements
    o TRUE or FALSE
    
  Ouput Details
    o Confirmation that the value chosen was saved
command_prompt1:
PREREQ_BOOLEAN|Allow browser viewer to be used|PREREQ_BOOLEAN:all
COMMAND ARGUMENT(S): 
set_da_property browser_viewer_spawned %%PREREQ_BOOLEAN%%
Top|Back

COMMAND: sys_667
COMMAND TYPE: System
COMMAND TITLE: Property Defaults
COMMAND DESCRIPTION: 
  Command Summary
    This command will remove all saved values and return system properties 
    to their default values, including turning off saved passwords and emptying
    the Oracle Wallet, if the YES parameter is passed. If NO is
    passed, it takes no action.
      
  Input Requirements
    o YES to reset and NO to exit without taking action
    
  Ouput Details
    o Confirmation that values have been removed and/or reset
command_prompt1:
PREREQ_YES_NO|Do you wish to reset all saved values to their defaults?|PREREQ_YES_NO:all
COMMAND ARGUMENT(S): 
reset_da_properties_to_defaults %%PREREQ_YES_NO%%
Top|Back

COMMAND: sys_668
COMMAND TYPE: System
COMMAND TITLE: Reset a specific property value
COMMAND DESCRIPTION: 
  Command Summary

    This command allows you to remove the existing value for a
    setup property. You will be prompted for a value again the next time 
    you run a command which requires the property.
      
  Input Requirements
    o Selection of a property to reset
    
  Ouput Details
    o Confirmation that the value for the given property has been removed
command_prompt1:
PREREQ_REQ_SETUP_PROP|Please choose a property to reset |PREREQ_REQ_SETUP_PROP:all
COMMAND ARGUMENT(S): 
reset_property %%PREREQ_REQ_SETUP_PROP%%
Top|Back

COMMAND: sys_669
COMMAND TYPE: System
COMMAND TITLE: Reset a saved password
COMMAND DESCRIPTION: 
  Command Summary

    This command allows you to remove the value for an existing saved
    password. You will be prompted for a value again the next time you run a 
    command which requires the property.
      
  Input Requirements
    o Selection of which password to reset
    
  Ouput Details
    o Confirmation that the password has been reset
command_prompt1:
PREREQ_PASSWORD_PROP|Please choose a property to reset |PREREQ_PASSWORD_PROP:all
COMMAND ARGUMENT(S): 
remove_wallet_property %%PREREQ_PASSWORD_PROP%%
Top|Back