Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

EM directory structure


When talking about the Enterprise Manager directory related structure, there are basically four relevant sections in the Oracle Home, the first one has to do with EMCA, the EMCA directory is where Oracle stores the log files related to EMCA executions, there you will find a directory where generic EMCA output is stored, meanwhile under this directory you will find directories named the same as each Oracle Instance that has been configured by EMCA.

The second section is related to the specific EM console; here there are two main directories, one stores the console configuration, most of these configuration files are not supposed to be manipulated by the DBA unless explicitly directed by Oracle support. There are configuration files that are modified by EMCA.

There is a fourth section located under the Oracle Home named sysman. When a new console is created EMCA reads template configuration files from here and executes the scripts to create or recreate the EM repository...