Symptoms
emctl start dbconsole
fails and emdctl.trc has the following
Thread-4135626432 WARN http: snmehl_connect: connect failed to
(hostname:3938): Connection refused (error = 111)
caused by agentTZRegion pointing to wrong timezone in emd.properties file (more on metalink note
751634.1)
find a supporting timezone from $ORACLE_HOME/sysman/admin/supportedtzs.lst file
and set the TZ value with
export TZ=time_zone
ORACLE_HOME/bin/emctl resetTZ agent
emctl start dbconsole
If emctl has never started, when trying to reset the TZ (more on metalink note
388280.1)
ERROR at line 1:
ORA-20233: Invalid agent name hostname:3938
ORA-06512: at "SYSMAN.MGMT_TARGET", line 3737
ORA-06512: at line 1
will occur. This could be confirmed with
select target_name, target_type from mgmt_targets;
To execute mgmt_target.set_agent_tzrgn procedure, there should be a target call 'oracle_emd' in table.
To fix this
$ export EMDROOT=$ORACLE_HOME
$ export EMSTATE=$ORACLE_HOME
and comment the agentTZRegion parameter in the AGENT_HOME/sysman/config/emd.properties file. Then reset the agent timezone and start again
emctl resetTZ agent
emdctl validateTZ agent
emctl start dbconsole
Even all of the above it may still not work and following described on the metalink note
821137.1 finally did the trick.
1.
grant execute on utl_smtp to public;
grant execute on utl_tcp to public;
grant execute on utl_file to public;
grant execute on dbms_sql to public;
grant execute on DBMS_OBFUSCATION_TOOLKIT to public;
2. Delete the files manually
$ORACLE_HOME/hostname_sid
$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_sid
3. create the dbcontrol again
emca -config dbcontrol db -repos create
More infor is available on following metalink notes
Note
278100.1 - How to Drop, Create and Recreate DBconsole in Database R2.
Note
750768.1 - Quick Guide to Avoid Issues in Creating DB Control Using EMCA.