Enterprise Manager TimeZone Hatası

Enterprise Manager TimeZone Hatası

Oracle Enterprise manager konsolu başlatırken aşağıdaki gibi bir hata alırsanız ne yapabiliriz beraber bakalım.

Platform:
Win 2012 Server
Oracle 11.2.0.4

Önce oracle sid set edelim ve Enterprise manager consolu start edelim..

C:\Windows\system32>set ORACLE_SID=EPM
 
C:\Windows\system32>emctl start dbconsole;
https://SVTEST:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...
The OracleDBConsoleEPM service is starting...............
The OracleDBConsoleEPM service could not be started.
A service specific error occurred: 2.

Enterprise manager consolun durumunu kontrol edelim.

C:\Windows\system32>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://SVTEST:1158/em/console/aboutApplication
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory D:\oracle\product\11.2.0\dbhome_1/SVTEST_EPM/sysman/log

Mesajda belirtilen dizine gidip log file’ı kontrol edelim, aşağıdaki gibi timezone hatası varsa timezone değerini enterprise config dosyasından yeniden set edeceğiz.

Dosyamız;
D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM\sysman\log\emdb.nohub

----- Mon Sep 14 15:29:31 2015::heap size used is 384M -----
----- Mon Sep 14 15:29:31 2015::perm size used is 400M -----
----- Mon Sep 14 15:29:31 2015::joptions used are -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -----
----- Mon Sep 14 15:29:31 2015::Console Launched with PID 3604 at time Mon Sep 14 15:29:31 2015 -----
 
D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM\sysman\emd >
D:\oracle\product\11.2.0\dbhome_1\jdk/bin/java -server 
-Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=D:\oracle\product\11.2.0\dbhome_1 
-Doracle.home=D:\oracle\product\11.2.0\dbhome_1/oc4j -Doracle.oc4j.localhome=D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM/sysman 
-DEMSTATE=D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient 
-Doracle.security.jazn.config=D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBConsole_SVTEST_EPM/config/jazn.xml 
-Djava.security.policy=D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBConsole_SVTEST_EPM/config/java2.policy 
-Djavax.net.ssl.KeyStore=D:\oracle\product\11.2.0\dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/home/config/jazn.security.props 
-DEMDROOT=D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM -Dsysman.md5password=true -Drepapi.oracle.home=D:\oracle\product\11.2.0\dbhome_1 
-Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=D:\oracle\product\11.2.0\dbhome_1/jlib/emocmclnt.ks 
-Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/home/oc4j.jar 
-config D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBConsole_SVTEST_EPM/config/server.xml
----- Mon Sep 14 15:29:32 2015::tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset 180(min)
-----
----- Mon Sep 14 15:29:32 2015::trying again after waiting for 1 sec to account for daylight transition
-----
----- Mon Sep 14 15:29:32 2015::tzOffset for America/Caracas is -270(min), but agent is runnning with tzOffset 180(min)
-----
----- Mon Sep 14 15:29:32 2015::Mismatch detected between timezone in env (America/Caracas) and in D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM
/sysman/config/emd.properties (America/Caracas). Forcing value to latter.. -----
----- Mon Sep 14 15:29:32 2015::The agentTZRegion value in D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM/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_nameZ> , <new_tz_rgn> ) to get the value propagated to repository -----
15/09/14 07:59:33 Error starting ORMI server SVTEST port 5,520: Address already in use: JVM_Bind
15/09/14 07:59:33 Shutting down OC4J...
----- Mon Sep 14 15:31:01 2015::omsRecvDir is set? = 1 -----
----- Mon Sep 14 15:31:01 2015::osname is MSWin32 -----
'isainfo' is not recognized as an internal or external command,
operable program or batch file.
----- Mon Sep 14 15:31:01 2015::heap size used is 384M -----
----- Mon Sep 14 15:31:01 2015::perm size used is 400M -----
----- Mon Sep 14 15:31:01 2015::joptions used are -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -----
----- Mon Sep 14 15:31:01 2015::Console Launched with PID 3424 at time Mon Sep 14 15:31:01 2015 -----

Oracle home altında %DB_HOME%\hostname_SID\Sysman\Config\emd.properties
dosyasını açıyoruz.(D:\oracle\product\11.2.0\dbhome_1\SVTEST_EPM\sysman\config\emd.properties)

agentTZRegion değerine databaseden aşağıdaki sorgu sonucu dönen değeri set edip kaydedip çıkıyoruz..

SQL>select timezone_region FROM mgmt_targets WHERE 
target_type = 'oracle_emd' AND target_name like '%SVTEST%';
 
TIMEZONE_REGION
-------------------
+03:00

emd.properties dosyasında agentTZRegion değerini +03:00 set edip kaydedip çıkıyoruz.
(normalde GMT+2 yiz +1 de yaz saati uygulamasından)

agentTZRegion=+03:00

Şimdi Enterprise manager konsolunu tekrar başlatalım..

C:\Windows\system32>set ORACLE_SID=EPM
C:\Windows\system32>net start OracleDBConsoleEPM
The OracleDBConsoleEPM service is starting..................
The OracleDBConsoleEPM service was started successfully.

Ve konsolumuz açıldı..

Eğer yinede hata devam ediyorsa repository drop create etmeniz daha sağlıklı olacaktır..

drop etmek;

emca -deconfig dbcontrol db -repos drop

yeniden create etmek;

emca -config dbcontrol db -repos create

Tagged: , , , , , , ,

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir