DBConsole problem after summer time

[ecalvetti]

Environment information:
* Oracle version: Oracle Database 10G Enterprise Edition Release 10.2.0.4.0 - 64bits.
* Operating system: Windows Server 2008 Enterprise.


Hello!

Since when changed summer time I can no longer climb the dbconsole service from any instance of the server.

Timezone Server: -03: 00 (Brasília)

I have already had this problem previously and decided to remove the repository and re-creating. But now it's not the solution I got.

Procedures already performed without success:

Procedure 1:
(a) Removing the repository:
Ezca -Deconfig DBControl DB -Repos DROP
Result: Removed successfully!

b) Creating a new repository:
Ecca -Config DBControl DB -Repos Create
Result: Created successfully! But the DBConsole service did not go up.

Procedure 2:

a) Manually removes the repository, excluding objects and Sysman user, among other items ...

b) Creating a new repository:
Ecca -Config DBControl DB -Repos Create
Result: Created successfully! But the DBConsole service did not go up.


Procedure 3:
(a) I performed the command to reset the timezone:
EMCTL RESETTZ Agent
Result: failed to reset the timezone claiming that the TZ of the file "emd.properties" (America / são_paulo) is different from the list of oracle timezones, file "supportedtzs.lst". Note to this file, I observed that America / são_Paulo is related to -02: 00.

The curious is that at the test base, I did the whole procedure "1" and worked. And curiously, the files "emd.properties" and "supportedtzs.lst", have the same information as the server that presents problem (America / são_Paulo related to -02: 00, but server like -03: 00, Brasília).

Procedure 4:
(a) I changed the contents of the file "emd.properties" from: agenttzregion = america / são_paulo, to : agenttzregion = etc / gmt + 3, which corresponds to -03: 00.
Result: The DBConsole service did not rise.


Another observed fact is that in some of the instances with a problem in dbconsole, I do not have the target "Oracle_emp", which would be the Oracle agent. When recreating the repository, it disappears, even not appearing in the "targets.xml" file.


Procedure 5:

a) I uninstalled Enterprise Manager via Oracle Gui.

b) I installed Enterprise Manager via Oracle GUI.

Result: The DBConsole service did not rise.


Does anyone else have another alternative to resurrect dbconsole? I am unable to manage the environments through OEM.

Thanks!

[elidias7]

Oops!

But what error he presents when he starts, sends the excerpt to us!

Hugs,

[ecalvetti]

Hello Eli, follows the error:

Select all

C:\>emctl start dbconsole 
 
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved. 
https://SCFNS4SRV01.intranet:5504/em/console/aboutApplication 
 
Starting Oracle Enterprise Manager 10g Database Control ...O serviço de OracleDB 
ConsoleDNITPRO está sendo iniciado.............................................. 
................................................................................ 
.............................................................................. 
 
O serviço de OracleDBConsoleDNITPRO não pôde ser iniciado. 
 
Erro específico do serviço: 1. 
 
Para obter mais ajuda, digite NET HELPMSG 3547. 
 
 
 
C:\>NET HELPMSG 3547 
 
Erro específico do serviço: ***.

By displayed Windows events, I was able to get the following message:

Select all

Nome do Log:   System 
Fonte:         Service Control Manager 
Data:          01/03/2011 11:56:21 
Identificação do Evento:7024 
Categoria da Tarefa:Nenhum 
Nível:         Erro 
Palavras-chave:Clássico 
Usuário:       N/D 
Computador:    SCFNS4SRV01.intranet 
Descrição: 
O serviço OracleDBConsoleDNITPRO terminou com o erro específico de serviço 1 (0x1). 
XML de Evento: 
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> 
  <System> 
    <Provider Name="Service Control Manager" Guid="{555908D1-A6D7-4695-8E1E-26931D2012F4}" EventSourceName="Service Control Manager" /> 
    <EventID Qualifiers="49152">7024</EventID> 
    <Version>0</Version> 
    <Level>2</Level> 
    <Task>0</Task> 
    <Opcode>0</Opcode> 
    <Keywords>0x80000000000000</Keywords> 
    <TimeCreated SystemTime="2011-03-01T14:56:21.000Z" /> 
    <EventRecordID>42659</EventRecordID> 
    <Correlation /> 
    <Execution ProcessID="0" ThreadID="0" /> 
    <Channel>System</Channel> 
    <Computer>SCFNS4SRV01.intranet</Computer> 
    <Security /> 
  </System> 
  <EventData> 
    <Data Name="param1">OracleDBConsoleDNITPRO</Data> 
    <Data Name="param2">1 (0x1)</Data> 
  </EventData> 
</Event>

Hugs,

Ewerton Calvetti
hollow - Oracle Certified Associates
ITIL Foundation

[elidias7]

Ewerton.

Delete the repository and the in and delete the Windows service as well. This is done re-creating it by DBCA. See if it works ...................

Hugs,

[Doug]

Edit the file

Select all

/oraprd01/app/oracle/product/10.2.0/vmrstoever01_tkrs01/sysman/config/emd.properties

and go on the AgentTzRegion line and swap for etc / gmt + 2 will look like this:

Select all

#agentTZRegion=Etc/GMT+3 
agentTZRegion=Etc/GMT+2

now forcar the tz of the machine For the same timezone

Select all

[oracle@vmrstoever01 ~]$ export TZ=Etc/GMT+2E

then reset the Agent TZ performing the following processes

Select all

[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.
Now can be checked by Agent if it is OK.

Select all

[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.

and then dbconsole can be started and at this point can be noted that the in starts much faster:

Select all

[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. 
 
https://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         : https://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         : https://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

References: http://www.rstoever.com/

[Lorival]

Dear,

This is a bug that has now started in 2011, exetty in version 10.2.0.4.

In Oracle's metalink I found a correction to be applied ...

- The patch is 8350262



Apply said patch and keep us informed about the results.


Sincerely.

Lorival Resende
DBA - Uberlandia (MG)

[Lorival]

only exclaring ... on the Oracle website, this is not considered a bug ..

According to them, it is the digital security certificate ( https) that expired on 31-12-2010.


Hugs.


Lorival Abadio Resende

[ecalvetti]

Personnel,

Thanks for the messages ... I was out for a good time, without access to the database environment. I will return to the company on 2nd, where I will be able to evaluate each of the comments .. I will post the result in the forum for sure!

Thanks for all the support to date.

_________________
[] s.
Calvetti
OCA - Oracle Certified Associates
ITIL Foundation

[ecalvetti]

Personal, I managed (MOS) to work the DBConsole in production, with some caveats, thanks to the comments of colleagues.

The reservations, or would say, the claims, are:

- I can access the dbconsole of the production environment and monitor the database. So far easy!
- The Windows service does not indicate that it is started.
- When you try to start service in Windows, it gives error and does not start. Detail: The DBConsole page comes out of the air while I try to start the service, but it turns off soon after the error in the service.

The expectation is when restarting the server .. if it will continue to work !!!

I was able to access dbconsole after performing all procedures indicated by Doug. I had already made these steps before, with a single difference: I was putting on the Váriavel "Agenttzregion" the value "America / são Paulo" rather than "etc / gmt + 2".

As for the lourival, I very wanted to apply the patch, but the customer does not have oracle support. I believe that this patch I only get through the CSI ( Customer Support Identifier ) of Oracle, correct?
ABS.,

Calvetti
OCA - Oracle Certified Associates
ITIL Foundation

[Wilson]

Buddy, help me in a thing, please. You mentions in your post that uninstalled and then reinstalled O Via Gui do Oracle. Current: How did you get, how did you reinstall? I uninstalled but I can not reinstall the same. Could you tell me for favopr as you did?

Thanks.

[leandro_lana]

Good morning ... I did not li td that they posted here. But as I have a legal knowledge about this problem I will pass two links and think they will help a lot.

This talks about the problem of not raising the in after the change of time http://www.oraclehome.com.br/2011/09/07 ... -de-verao/
and this speaks about the application of a path to If you are in safe mode (https) http://www.oraclehome.com.br/2011/09/23 ... e-manager/
CYA

[ruibarros]

Ecalvetti,
as our Lorival colleague quoted ... this is a bug and is only corrected with patch application! If you can get this patch, below the instructions to correct the problem:

Select all

 
1) Deletar o serviço windows: sc delete nome_do_serviço 
 
2) Deletar essas pastas 
$ORACLE_HOME/<hostname> 
$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid> 
 
3)Dropar objetos logado como system: 
 
DROP USER sysman CASCADE; 
DROP PUBLIC SYNONYM setemviewusercontext; 
DROP ROLE mgmt_user; 
DROP PUBLIC SYNONYM mgmt_target_blackouts; 
DROP USER mgmt_view; 
 
4) Aplicar o patch de correção do oem segundo nota do metalink : 1222603.1 
Patch 8350262 
 
5) Instalar o Dbconsole: 
emca -config dbcontrol db -repos create 

Embrace!