So we need to find why the agent is not running. Checked agabend.log which shows:

The
agentTZRegion value in
/oracle/product/11.2.0/*************_*******/sysman/config/emd.properties
is not in agreement with what agent thinks it should be.Please verify
your environment to make sure that TZ setting has not changed since the
last start of the agent.If you modified the timezone setting in the
environment, please stop the agent and exectute 'emctl resetTZ agent'
and also execute the script
mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>) to
get the value propagated to repository.

Found MOS document "Dbconsole 11.2 Does Not Start Logs Shows Timezone Mismatch (Doc ID 1329914.1)".Oracle instant client was installed on the same Oracle RDBMS Home, removed just that using OUI and now dbconsole is working fine.
If you have similar situation and had created new Database using DBCA. You might have seen below warning message by dbca.

6 comments:

Thank you for your website. I've been struggling with this problem for over a month, including opening an SR with Oracle. Oracle never brought up this bug. You are doing a great service to the Oracle DBA community.

Click to edit this message... Edit Click to report abuse... Click to reply to this thread ReplyAOA/Hello,

Dear All,

First of all thanks to all of those people who posted solutions in different forums on this issue as this helped me to solve this problem. One more thing, always read documentation and always check log files for error reports as Oracle is not too much interactive.

The Problem " Error Starting Database Control Please execute the following command(s) " faced at the end of installation of Oracle 10g / 11g is caused due to Time Zone Values in different files, tables and services of Oracle. Interestingly, these values do not change automatically with the change in OS time zone and you have to do it manually.

You also have to set some environment variables manually like ORACLE_UNQNAME, ORACLE_SID, ORACLE_HOSTNAME etc.

You also have to set machine name and IP in the hosts file if required so that EM finds the localhost.

127.0.0.1 localhost127.0.0.1 computer name / hostname

PRAISE ORACLE FOR THIS

Following is the Solution which worked well for me.

Step 1: Go to dbhome > hostname_SID > Sysman > Config > open emd.properties in notepad and set the value agentTZRegion=+05:00 to the value of your timezone and click save. You can also do it using export and time zone reset commands.

Step 2: ALTER DATABASE SET TIME_ZONE='+05:00'; according to your time zone. You can check DB TIME Zone using " select dbtimezone from dual ; ".

Step 3: In step 2 if you get the error "ORA-30079: cannot alter database timezone when database has TIMESTAMP WITHLOCAL TIME ZONE columns" then please FOLLOW following steps

SQL> select count (*) from dba_tab_columns2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ;

COUNT(*)1

In this case there is only one table. The owner and name can be determined by:

SQL> select owner, table_name from dba_tab_columns2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE';

This oe.orders is just a table in the example schema of OE so this colums can be dropped. So please dont install sample schemas if you dont need them.

SQL> alter table OE.ORDERS drop column ORDER_DATE ;

Table altered.

Now the Time Zone can be altered using above command.

Step 4: Also check the value of " SELECT SESSIONTIMEZONE FROM DUAL; " and if the value differs from os time zone, db time zone , emd.properties / agent time zone then also set it according to your timezone but I believe it always gives the OS time zone.

Step 5: Stop and Restart all Services and check that Oracle DBConsole service is running or not and if not running then start from command prompt " emctl start dbconsole" .

NOW THE ENTERPRISE MANAGER WILL WORK WELL BY THE GRACE OF ALMIGHTY ALLAH.

Thank you so much bro.... may ALLAH give HIS grace so that u can achieve the ended limits of whatever u want, and will b able to give us solutions of related problems.... Thanks again....Tauseef Ahmed g tusi great o..... :)