2012-10-27 - 2012-10-28 11gR2 "ADMINISTRATOR'S GUIDE" page 305 - 352

 

接下去的这一章讲了很多的如何向Oracle Support提供incident package的方法。
可以细看 page 308 - 325

 

这一章节基本都是讲EM的操作，其实我们更多时候最好是不用EM，但是我一直十分喜欢用EM进行数据库的性能监控。

 

Directory Structure in the Management Service Home for Release 11g or Later

 

Directory Structure in the Management Home for Release 10g -- 10g的目录结构

 

Using EMCA With Oracle RAC -- RAC中使用EMCA
When you use EMCA to configure Database Control for Oracle RAC, you configure
the Database Control for each instance in the cluster. However, by default the Database
Control Console will only start on the local node. On every other node of the cluster,
only the Enterprise Manager agent will start. This is because the Database Control
Console opens several connections to the database. If an instance of the console is
running on every host in the cluster, then you may easily exceed the maximum
number of permitted open connections on a 32-node or 64-node environment.
默认情况下，EM只会在RAC的一个节点中启动，这里也做了解释。

Backing Up the emkey.ora File -- 备份emkey.ora文件
During the installation, the Database Control management repository is placed in
secure mode. All Enterprise Manager data is encrypted using the encryption key
stored in the file emkey.ora. If this file is damaged or lost, and cannot be restored
from a backup, you will no longer be able to use the existing Enterprise Manager
repository.
The emkey.ora file is located in the $ORACLE_HOME/node_name_Database_
name/sysman/config directory. For example, on the racnode2 server, the
encryption key file for the orcl.example.com database is located at
/u01/app/oracle/product/11.2.0/dbhome_1/racnode2_
orcl/sysman/config/emkey.ora.
这个文件平时都没怎么注意，看来还是有一定重要性的，存放了em的repository。