Oracle 10g

Configure Database Control - Metalink Note:272186.1.

When you start up the enterprise manager dbconsole with emctl start dbconsole, it fails with the following error

OC4J Configuration Issue: $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_host_sid not found

The directories $ORACLE_HOME/host_sid and $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_host_sid don’t exist, meaning that the database control console had not been configured for the database.

To remedy this, first make sure the TZ environment variable is set in the file /etc/sysconfig/clock stores a parameter ZONE which must be in the following both files:

$ORACLE_HOME/sysman/admin/nsupportedtzs.lst and
$ORACLE_HOME/sysman/admin/supportedtzs.lst

This will typically be Europe/London
Set the TZ variable to this value, e.g. export TZ=”Europe/London” and run the command emca -r to create all the console configuration information for the database. You will prompted for the following information:

• Listener Port
• Database Name
• SYS password
• SYSTEM password
• SYSMAN password
• DBSNMP password
• Email address for notifications

You should now be able to start the database control with emctl start dbconsole.

 

---