Dia 18 de outubro de 2009 mudou o horario de verão e dia 21 de fevereiro de 2010 irá mudar novamente.
Com isso há uma troca de timezone de -03:00 para -02:00 e vice versa.
O Enterprise Manager Web se perde após esta troca, pois há configurações que indicão qual o timezone ele está trabalhando e tudo se altera e nada mais bate corretamente.
Pode ser visto desta forma:
[oracle@vmrstoever01 ~]$ date "+%z"
-0200
[oracle@vmrstoever01 ~]$ cat /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/config/emd.properties | grep TZ
agentTZRegion=Etc/GMT+3
Esta já é uma forma de identificarmos o problema.
Outra é tentar iniciar o EM e ficar esperando e esperando para aparecer no final failed.
[oracle@vmrstoever01 ~]$ emctl start dbconsole
TZ set to Brazil/East
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
vmrstoever01:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/log
[oracle@vmrstoever01 ~]$ emctl start agent
TZ set to Brazil/East
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting agent ................................. failed.
O que podemos fazer para resolver isso?
Recriar os arquivos do EM é uma opção porem há outra opção mais simples
Editar o arquivo /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/config/emd.properties
e ir na linha agentTZRegion e trocar para Etc/GMT+2 ficará assim:
#agentTZRegion=Etc/GMT+3
agentTZRegion=Etc/GMT+2
Agora forcar o TZ da maquina para o mesmo TimeZone
[oracle@vmrstoever01 ~]$ export TZ=Etc/GMT+2
E em seguida resetar o TZ do agent efetuando os seguintes processos
[oracle@vmrstoever01 ~]$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Updating /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/config/emd.properties...
Time zone set to Etc/GMT+2.
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('vmrstoever01:3938','Etc/GMT+2')
-- or --
connect to the database served by this DBConsole as user 'sys', and execute:
SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn('vmrstoever01:3938','Etc/GMT+2')
Aqui eu escolhi a segunda opção e efetuei os seguintes comandos
[oracle@vmrstoever01 ~]$ sqlplus
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 23 11:29:58 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - Production
SQL> alter session set current_schema = SYSMAN;
Session altered.
SQL> exec mgmt_target.set_agent_tzrgn('vmrstoever01:3938','Etc/GMT+2')
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
Agora pode ser conferido o Agent se está ok.
[oracle@vmrstoever01 ~]$ emctl start agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting agent ..... started.
E em seguida pode ser iniciado o dbconsole e neste ponto pode ser notado que o EM inicia muito mais rapidamente:
[oracle@vmrstoever01 ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
vmrstoever01:1158/em/console/aboutApplication
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01
Agent binaries : /oraprd01/app/oracle/product/10.2.0
Agent Process ID : 8381
Parent Process ID : 8378
Agent URL : vmrstoever01:3938/emd/main
Started at : 2009-12-23 11:34:53
Started by user : oracle
Last Reload : 2009-12-23 11:34:53
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 12
Size of XML files pending upload(MB) : 0.05
Available disk space on upload filesystem : 23.61%
Agent is already started. Will restart the agent
Stopping agent ... stopped.
Starting Oracle Enterprise Manager 10g Database Control ................. started.
------------------------------------------------------------------
Logs are generated in directory /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/log
Desta forma pode ser verificado que os XML files pending upload foram efetuados com sucesso:
[oracle@vmrstoever01 ~]$ emctl status agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01
Agent binaries : /oraprd01/app/oracle/product/10.2.0
Agent Process ID : 10115
Parent Process ID : 8898
Agent URL : vmrstoever01:3938/emd/main
Started at : 2009-12-23 11:37:18
Started by user : oracle
Last Reload : 2009-12-23 11:37:18
Last successful upload : 2009-12-23 13:19:28
Total Megabytes of XML files uploaded so far : 2.23
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 23.47%
---------------------------------------------------------------
Agent is Running and Ready
Referencias:
www.rnp.br/cais/alertas/2009/cais-alr-20091015.html
metalink.oracle.com
