Where to find EMCA log files

Where to find the logs:

EMCA 10.1

In 10.1 the emca log files are located in the $ORACLE_HOME/cfgtoollogs directory and are in the format they are in is emca.log.X.

EMCA creates the log file if it does not exist (usually the first time it is launched) and then it appends to this each time it runs.

EMCA 10.2

In 10.2 the emca log files are located in the $ORACLE_HOME/cfgtoollogs/emca directory. The filename is in the format emca_timestamp.log where timestamp is in the format: YYYY-MM-DD_HH12-MI-AMP/PM.log.

A new file is created each time emca is run. Then for each database, a sub-directory is creatd under $ORACLE_HOME/cfgtoollogs/emca in the format: $ORACLE_HOME/cfgtoollogs/emca/$ORACLE_SID.

RAC:

If the database is a RAC database, for some specific operations like add and remove of an instance a new subdirectory is created for each instance under the $ORACLE_HOME/cfgtoollogs/emca/db_unique_name directory.

emca creates the log files only on the node of the cluster from where emca is running from

For example, for a RAC database with two instances there will be emca log files in the following locations:

1. $ORACLE_HOME/cfgtoologs/emca
2. $ORACLE_HOME/cfgtoollogs/emca/prod
3. $ORACLE_HOME/cfgtoollogs/emca/prod/prod1 (SID of the first RAC instance on the database prod)
4. $ORACLE_HOME/cfgtoollogs/emca/prod/prod2 (SID of the second RAC instance on the database prod)

EMCA 11.1

In 11.1 the emca log files are located in the $ORACLE_BASE/cfgtoollogs/emca directory. The filename is the format emca_timestamp.log where timestamp is in the format: YYYY-MM-DD_HH12-MI-AMP/PM.log. An example of a filename is: emca_2009-04-17_10-45-10-AM.log. A new fiile is created each time emca is executed. Then for each database a sub-directory is created under $ORACLE_BASE/cfgtoollogs/emca – $ORACLE_HOME/cfgtoollogs/emca/db_unique_name.

How to get additional data into the emca.log?

1. Backup the file emcalog.properties in $ORACLE_HOME/sysman/config
2. Edit the file emcalog.properties to change the value of the parameter shown below:

oracle.sysman.emcp.level = CONFIG to oracle.sysman.emcp.level = FINER

RAC Databases on Clustered Nodes (valid for emca 10.1, 10.2 and 11.1)

---

Possibly related posts: (automatically generated)

• How to Recreate the Database Control Repository