Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
Oracle EM agent and new TZ rules

Oracle EM agent and new TZ rules

2007-03-12       - By Alexei_Roudnev

 Back
Reply:     1     2     3     4     5  

Does anyone had such problem?
Agents stop working (strange, but not on all servers, on a few only). When
starting manually, we seeL



-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --

oracle@(protected):~> date
Mon Mar 12 12:13:03 PDT 2007
oracle@(protected):~>
oracle@(protected):~> product/agent10g/bin/emctl start agent
Oracle Enterprise Manager 10g Release 10.2.0.2.0.
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
Starting agent ..... failed.
The agentTZRegion value in /opt/oracle/product/agent10g/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.
Consult the log files in: /opt/oracle/product/agent10g/sysman/log
oracle@(protected):~> product/agent10g/bin/emctl resetTZ agent
Oracle Enterprise Manager 10g Release 10.2.0.2.0.
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
Updating /opt/oracle/product/agent10g/sysman/config/emd.properties...
-- -- Mon Mar 12 12:15:51 2007::tzOffset for US/Pacific is -480(min), but agent
is runnning with tzOffset -420(min)
-- --
-- -- Mon Mar 12 12:15:51 2007::trying again after waiting for 1 sec to account
for daylight transition
-- --
-- -- Mon Mar 12 12:15:51 2007::tzOffset for US/Pacific is -480(min), but agent
is runnning with tzOffset -420(min)
-- --
resetTZ failed.
The agentTZRegion in:
/opt/oracle/product/agent10g/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:
/opt/oracle/product/agent10g/sysman/admin/supportedtzs.lst
oracle@(protected):~>

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --


Correct value is -420, not 480.

I made 100% sure that all jre in oracle have correct lib/zi timezone library,
but it did not helped.