Oracle OCP 9i to 11g Diagnosability Enhancements

Card Set Information

Author:
Tralala
ID:
208258
Filename:
Oracle OCP 9i to 11g Diagnosability Enhancements
Updated:
2014-05-29 10:47:38
Tags:
Oracle OCP 9i 11g Diagnosability Enhancements
Folders:

Description:
Oracle OCP 9i to 11g Diagnosability Enhancements
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. What is ADR?
    • Automatic Diagnostic Repository
    • A directory structure for diagnostic files
    • Support multiple instances and multiple products
  2. Which parameter defines where the ADR resides
    DIAGNOSTIC_DEST
  3. Which init parameters have been depreciated with arrival of ADR?
    BACKGROUND|USER_DUMP_DEST
  4. Which view list alls the ADR locations for current Oracle instance?
    V$DIAG_INFO
  5. Which ADR location contains XML formatted logs?
    Diag Alert
  6. Which ADR location contains TXT formatted logs?
    Diag Trace
  7. Which view returns Active Problem Count and Active Incident Count?
    V$DIAG_INFO
  8. Which tool uploads diagnostic data to Oracle support?
    Support Workbench
  9. What requires configuration for Support Bench?
    Oracle Configuration Manager
  10. In support Workbench, what is a "Problem"?
    • A critical error
    • ORA-00600 ORA-07445 ORA-04031
  11. In support Workbench, what is a "Incident"?
    A single occurrence of a problem
  12. What happens when an incident is generated?
    • An entry is made in the alert log
    • Incident alert is sent to OEM
    • Diagnostic data is stored in dump files
  13. Where are incident dumps stored?
    In the ADR in subdirectory created for that incident
  14. What is flood control?
    A mechanism to prevent a single problem generating hundreds of incidents
  15. How are the thresholds for incident flood control adjusted?
    They can't be changed
  16. What happens if five incidents of the same problem key occur in one hour?
    Subsequent incidents are flood controlled
  17. What happens if 25 incidents of the same problem key occur in one day?
    Subsequent incidents are flood controlled
  18. What happens after 50 incidents/hr or 250 incidents/day f the same problem key occur?
    No further information is recorded. A message is written to the alertlog indictating this.
  19. By default, how long is ADR metadata retained?
    One year
  20. By default, how long are incident and dump files kept?
    One month
  21. What is an incident package?
    A collection of metadata stored in the ADR pointing to files relating to a given incident.
  22. By default, what incidents for A PROBLEM are added to an incident package?
    First and last three
  23. What is ADRCI
    • Automatic Diagnostic Repository Command Interpreter
    • A command-line utility
  24. What does ADRCI allow?
    • Viewing of diagnostic data in ADR
    • Viewing of Health Monitor reports
    • Packaging incident and problem information for Oracle Support.
  25. How is ADRCI secured?
    At OS Level
  26. What is the ADRCI homepath?
    The root directory of all diagnostic data for a particular instance of a given Oracle product or component.
  27. Which alert log does the ADRCI use?
    The XML version without tags
  28. How are scripts run in ADRCI?
    @scriptname - same as SQLPLUS
  29. Which ADRCI command lists all files in the trace directory?
    SHOW TRACEFILE
  30. Which ADRCI command displays information about open incidents
    SHOW INCIDENT
  31. What are the three steps in packaging an incident?
    • Create a logical incident package
    • Add diagnostic info to the incident package
    • Generate physical incident package
  32. Which tools are available to generate an incident package?
    • OEM
    • ADRCI
  33. Which ADRCI command creates a package incident?
    IPS CREATE PACKAGE INCIDENT incident_number
  34. Which ADRCI command creates a package problem?
    IPS CREATE PACKAGE PROBLEM problem_ID
  35. Which ADRCI command creates a package problemkey?
    IPS CREATE PACKAGE PROBLEMKEY problem_key
  36. What does IPS CREATE PACKAGE SECONDS do?
    Create a package including all diagnostics that have occurred from sec seconds until now
  37. what does IPS CREATE PACKAGE without additional information do?
    Creates and empty package
  38. How is an incident added to a package?
    IPS ADD INCIDENT incident_number PACKAGE package_number
  39. How is a file added to a package?
    • IPS ADD FILE filespec PACKAGE package_number
    • where filespec = path/filename
  40. What is the limitation on files added to a package?
    The file must come from within the ADR base directory hierarchy
  41. In what form are physical incident packages?
    ZIP
  42. What IPS command generates a physical incident package
    IPS GENERATE PACKAGE package_number
  43. What is an IPS incremental package?
    Only contains incidents for a package since the last package generation.
  44. What IPS command generates an incremental physical incident package
    IPS GENERATE PACKAGE package_number INCREMENTAL
  45. Of what Oracle feature is Heath Monitor a part of?
    DATABASE FAULT DIAGNOSABILITY INFRASTRUCTURE
  46. Where does Heath Monitor store its findings?
    AUTOMATIC DIAGNOSTIC REPOSITORY
  47. How are heath checks run manually?
    Using DBMS_HM or OEM
  48. What are the two modes for running heath checks?
    • DB-online
    • DB-offline
  49. In what state is the database when the DB-offline heath check is run?
    nomount
  50. What health checks can be run in DB-online mode?
    All
  51. What health checks can be run in DB-offline mode?
    • Redo Integrity Check
    • DB Structure Integrity Check
  52. What does DB Structure Integrity Check do?
    Integrity of database files inaccessible, corrupt or inconsistent
  53. What does DB Block Integrity Check do?
    Block corruption
  54. What does Redo Integrity Check do?
    Contents of redo logs and archived logs for accessibility and corruption
  55. What does Undo Segment Integrity Check do?
    Checks for undo corruption
  56. If corruption is found in Undo segment, what memory structures does Oracle use to recover the corrupted transaction?
    PMON and SMON
  57. What does Transaction Integrity Check do?
    Same as undo, but for a single transaction
  58. What does Dictionary Integrity Check do?
    Examines the integrity of core dictionary objects (ie tab$ and col$)
  59. How is DBMS_HM package used?
    DBMS_HM.RUN_CHECK('CHECKNAME1', 'CHECKNAME2')
  60. Which view contains a list of available health checks?
    V$HM_CHECK
  61. If a health check requires a parameter, in which view are those parameter names found?
    V$HM_CHECK_PARAM...NOT V$HM_CHECK, which only list the CHECK NAME
  62. What triggers a reactive health check?
    A critical error
  63. What types of health check are there?
    • Reactive
    • Manual
  64. What are the possible values for STATUS in an incident?
    • COLLECTING
    • READY
    • TRACKING

What would you like to do?

Home > Flashcards > Print Preview