Oracle – The agentTZRegion value error
The below error messages occurs when you go to manually start the grid agent on a server:
$ emctl start agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Starting agent ...... failed.
The agentTZRegion value in $ORACLE_HOME/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(, ) to get the value propagated to repository.
Consult the log files in: $ORACLE_HOME/sysman/log
When you query $TZ you get something like the following:
$ echo $TZ
Africa/Tunis
When you try to run emctl resetTZ agent you get the following message:
emctl resetTZ agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Updating $ORACLE_HOME/sysman/config/emd.properties...
----- Mon Jun 13 11:45:20 2011::tzOffset for Africa/Tunis is 120(min), but agent is runnning with tzOffset 60(min)
-----
----- Mon Jun 13 11:45:20 2011::trying again after waiting for 1 sec to account for daylight transition
-----
----- Mon Jun 13 11:45:20 2011::tzOffset for Africa/Tunis is 120(min), but agent is runnning with tzOffset 60(min)
-----
resetTZ failed.
The agentTZRegion in:
$ORACLE_HOME/sysman/config/emd.properties
is not in agreement with what the agent thinks it should be.
Fix your environment.
Pick a TZ value that corresponds to time zone settings listed in:
$ORACLE_HOME/sysman/admin/supportedtzs.lst
Emd.properties shows the agentTZRegion to be correct:
$ cat emd.properties
...
agentTZRegion=Africa/Tunis
Fix the error
As the resetTZ Agent was showing a time difference of 60 minutes, I set the TZ to the following:
export TZ=Etc/GMT+1
Then run the
$ emctl resetTZ agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Updating $ORACLE_HOME/sysman/config/emd.properties...
Successfully updated $ORACLE_HOME/sysman/config/emd.properties.
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn(':','Etc/GMT+1')
and commit the changes
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('':'','Etc/GMT+1')
SQL> commit
Log onto the Grid Agent database and run the sql script as above.
Now when you go to start grid agent it should start successfully:
$ emctl start agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Starting agent ........ started.
Its works for me!
how? its here…
[oracle@localhost ~]$ export TZ=Etc/GMT-5
[oracle@localhost ~]$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /u01/app/oracle/product/10.2.0/db_1/localhost_orcl/sysman/config/emd.properties…
Time zone set to Etc/GMT-5.
To complete this process, you must either:
connect to the database served by this DBConsole as user ‘sysman’, and execute:
SQL> exec mgmt_target.set_agent_tzrgn(‘localhost:3938′,’Etc/GMT-5’)
— or —
connect to the database served by this DBConsole as user ‘sys’, and execute:
[oracle@localhost ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ……………………. started.
certainly like your web-site however you have
to take a look at the spelling on quite a few of your posts.
Several of them are rife with spelling problems and
I find it very troublesome to inform the truth then again
I’ll surely come back again.
Ukrainian site EvroHouse
Справжня сфера, яка розвивається, а спільно з тим пропонує нові рішення в правила нові нормативи,
новоспечені методи, зараз в даний час спрощують життя будь-якого розвиток ремонтно-будівельних і монтажних свіжоспечених методів, дає
право полегшити і заощадити на будівельних матеріалах.
Із Видами будівництва і аналіз нових
будівельних матеріалів, ви зможете познайомитися EvroHouse.com.ua, надає щотижневу оновлювану повідомлення про останніх
створених передових будівельних
технологіях. Із нами будувати зробилося економно і з нами сбрежете готівкові кошти на
запланований ремонт, або на будівництві новітньої
дачі. Ми допоможемо вам як потрібно віддати перевагу матеріал для
різних справ.
Старі технологи нескладних споруд,
пішли в минуле, помилуйтеся, яким чином можна недорого спорудити будиночок з пінопласту.
Поява на ринку новейших монтажних будівельних матеріалів, наприклад
OSB плита, дозволило зводити будівлі оперативно і нових матеріалів, які колись широко співпадіння використовувалися, Покласти:
полістирол, додало потенційність зберігати
на оплаті рахунків, і зберігати
теплу атмосферу в будівлі.
А, обладнання, якому присвячений цілий розділ на порталі, збільшило темп
провидіння справ в рази. Відвідайте вищенаведеного сайт, і
ви вже співпадіння вийдете
від туди.
hi!,I like your writing very so much! percentage we keep up
a correspondence more approximately your article on AOL?
I require an expert on this space to resolve my problem. May be that’s you!
Having a look forward to peer you.
Thank you! That was superb 🙂
A guitar strings also come in different colors on top
of that. Choosing a right kind of bikini can be really daunting.
Not only will a tan make your skin tone look sexier, but it
can also make you thinner, enhancing just how you look in that teeny weeny bikini.
One of the best solutions for this is choosing a dark
bottom and then an attractive or printed color for the top.
But manage on previously than you go off to get
hold of a pair that in form you the best as a result of you earliest have to
have to master about about what in truth can help make swimwear alluring
and retains it from presently staying dull. You may be glad that Speedo
also offers sun protection.
A successful turn key cash system should have all
the details of the business mapped out for you and available
for you to view. When the website visitors
click on the ads or banner, you get paid as the owner of such website.
Why not create additional revenue streams so you won.
excellent post , i was surfing for many pages even the oracle documentation , and finally this post solved my problem
This is a JAVA issue.
And it is still not resolved today.
Get the same annoying error with EM 13c.
It is sufficient to change TZ to GMT, execute “emctl resetTZ agent”, then reset the TZ to your local value, and execute again “emctl resetTZ agent”, then the agent should start sucessfully. Java sucks!