Monthly Archives: December 2011

ORA-01882: timezone region not found error in Oracle Enterprise Manager 11g Grid Control

ORA-01882: timezone region not found is displayed when accessing “Response and Load” Graph for Weblogic Server Targets.
I get the this when I try to access Oracle WebLogic Server from Oracle Enterprise Manager 11g Grid Control and then try to
access ADMINSERVER graphs.

The …/Middleware/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc file show the error as

java.sql.SQLDataException: ORA-01882: timezone region not found
ORA-06512: at “SYSMAN.MGMT_GLOBAL”, line 8

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:79)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)

fter looking on the internet and Oracle metalink I could not find a satisfactory answer. I searched for
ORA-01882 and ORA-01882: timezone region not found. But this error code ORA-01882 looks like can appear in other
Oracle products too.

The metalink id 1148503.1 does exactly the same issue. But for me the solution did not work.

My OS time zone shows like this:


cat /etc/sysconfig/clock
ZONE="Etc/GMT"
UTC=true
ARC=false

And Oracle also understand this time zone as shown below:

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Dec 7 17:07:16 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT CAST(FROM_TZ(CAST('12-JUL-2010 08:00:00' as TIMESTAMP), 'GMT') AT TIME ZONE 'Etc/GMT' AS DATE) from dual;

CAST(FROM
---------
12-JUL-10

SQL>

Resolution:

To solve the issue add “-Duser.timezone=Etc/GMT” (without the quotes) in JAVA_PROPERTIES of your file
…/Middleware/gc_inst/user_projects/domains/GCDomain/bin/setDomainEnv.sh

Then do:


cd OMS_HOME/bin
emctl stop oms
emctl start oms

Then try. It should now work.

Oracle Enterprise Manager 11g Segment Advisor consumes significant CPU time

Oracle Enterprise Manager 11g is no doubt a very useful tool for database administrators.  Whoever has used it can testify that it makes life so easier.  For example the Oracle Enterprise Manager 11g Segment Advisor can give very useful information at the click of buttons. Getting these information through command line will need significant effort as well as knowledge.

But we must also be aware that it can also have significantly detrimental effect on your production database if you do not control usage.

If you maintain a database in a corporate environment it may be sometime necessary  to give access to your Oracle Enterprise Manager 11g to management stuff who may not be too tech savvy or at least with Oracle technologies. What they may be looking for is just to monitor activities or trends. But if they start running different advisors then it may impact a production database.

Today I was running Segment Advisor for just two tablespaces. One of them was 125G and another 32G. While running the segment advisor from one Oracle Enterprise Manager session I monitored the impact of this activity from another session through the database instance performance tab.

The impact looks significant to me. Note that this database is a non production database and was quite (meaning no serous activity happening at the time of running).

This is how looks in Top Activity screen
OEM11g Top Activity Screen

 

Continue reading



Loading