Oracle Enterprise Manager

[Pazinato 0]

Prezados,...

 

Venho me deparando com alguns problemas na minha Instalação do OEM. Como sabem, quando se cria uma instancia de banco de dados utilizando o DBCA, o Enterparise Manager é será instalado por padrão e administrará localmente essa instancia. No meu caso, no servidor eu criei uma única instância e ao fim do processo o EM estava disponível e funcionando a contento.

 

Tempos depois, tivemos um problema de falta de espaço nesse servidor (que por sinal não estava sendo monitorado) que provocou a queda do DB. Uma vez solucionado e colocado o banco no ar, o EM parou de funcionar e até o momento não quer mais funcionar. Então pergunto a quem possa me ajudar....

 

1- Como faço para descobrir qual o problema? Conhecem alguma documentação? Já tem mais de um mes e a documentação disponível na Web ainda é inscipiente.

 

2- Partindo do pressuposto que não seja possível diagnosticar a causa (e consequentemente sua solução), pretendo desistalar e reinstalar somente o OEM. Alguém já teve essa experiência? Pode compartilhar? Somente para constar, sobre a instalação encontrei documentação abundante. Ainda não testei pois quero primeiro desistalar.

 

Toda ajuda será bem vinda. http://forum.imasters.com.br/public/style_emoticons/default/joia.gif

 

Agradeço antecipadamente.

[alphamek 2]

Pazinato,

 

Vamos lá, quando teve a queda do banco de dados, os serviços do agente do OEM iniciaram?

 

Está em qual plataforma?

 

Qual a versão do seu OEM?

 

Chegou a analisar os logs do OEM para saber a causa?

 

Abraços, :blink:

[Pazinato 0]

Pazinato,

 

Vamos lá, quando teve a queda do banco de dados, os serviços do agente do OEM iniciaram?

 

Está em qual plataforma?

 

Qual a versão do seu OEM?

 

Chegou a analisar os logs do OEM para saber a causa?

 

Abraços, :blink:

 

 

Obrigado por responder, Rodrigo...

 

Ok, então vamos por partes, às respostas:

1- Assim que o banco reiniciou, o OEM não retornou mais. Entretanto, somente percebi isso dias depois, pois havia lentidão nas respostas às consultas. Então, verifiquei que processos estavam consumindo os recursos e isso foi detectado. O OEM ficava num processo continuo de tentativa de se estabelecer.

2- A plataforma é Linux 5.1 (x86-84)

2- A versão do OEM que acompanha o Oracle 11g (11.1.0.6).

3- Quanto aos log, existem varios logs e outros arquivos dos quais eu anexei parte do seu conteúdo por serem repetitivas, mas se for necessário anexo os arquivos.

 

Durante a tentativa de resolver, descobri que um dos arquivos, o oc4j_connectors.xml, estava vazio (0 bytes). Como eu tenho um outro servidor com a mesma versão do Oracle porém em Windows 2003 Server, copiei o arquivo para ver o que acontecia. Desta vez, pelo menos o OEM iniciou, mas não permite o acesso através do browser, reclamando que a chave não é reconhecida. Então fiz o seguinte: Parei o OEM, editei cada um dos arquivos que trazem informações deste aplicativo em funcionamento (correpondem a arqs de log), dando um bom espaço entre a última parada e o novo iniciar/parar, simplesmente para ver o que rola. Olhando agora os arquivos nos quais existem algum tipo de resposta, vou listar para voce a parte de antes de ter o problema e esta última tentativa. Temos o seguinte:

 

1- EMCTL.LOG

Antes:

31100 :: Mon Apr 14 16:24:01 2008::AgentStatus.pm:Processing status agent

31100 :: Mon Apr 14 16:24:02 2008::AgentStatus.pm:emdctl status returned 3

32655 :: Mon Apr 14 16:41:19 2008::AgentStatus.pm:Processing status agent

32655 :: Mon Apr 14 16:41:20 2008::AgentStatus.pm:emdctl status returned 3

 

Agora:

1773 :: Fri Jun 20 15:48:59 2008::AgentStatus.pm:Processing status agent

1773 :: Fri Jun 20 15:49:00 2008::AgentStatus.pm:emdctl status returned 3

4720 :: Fri Jun 20 16:06:18 2008::AgentStatus.pm:Processing status agent

4720 :: Fri Jun 20 16:06:18 2008::AgentStatus.pm:emdctl status returned 3

 

 

2- EMAGENT.LOG

Antes:

2008-04-14 16:16:26 Thread-2925346160 Starting Agent 10.2.0.3.0 from /u01/app/oracle/product/11.1.0/db_1 (00701)

2008-04-14 16:16:26 Thread-2925346160 [Database Instance] InstanceProperty (DBVersion) is marked OPTIONAL but is being used (00506)

2008-04-14 16:16:26 Thread-2925346160 [Cluster Database] InstanceProperty (DBVersion) is marked OPTIONAL but is being used (00506)

2008-04-14 16:16:26 Thread-2925346160 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)

2008-04-14 16:16:29 Thread-2925346160 EMAgent started successfully (00702)

2008-04-16 17:58:09 Thread-1080039744 <HTTP Listener> Agent Signaled to EXIT by emctl (00800)

2008-04-16 17:58:10 Thread-2925346160 EMAgent normal shutdown (00703)

 

Agora:

2008-06-20 15:41:24 Thread-2868942656 Starting Agent 10.2.0.3.0 from /u01/app/oracle/product/11.1.0/db_1 (00701)

2008-06-20 15:41:24 Thread-2868942656 [Database Instance] InstanceProperty (DBVersion) is marked OPTIONAL but is being used (00506)

2008-06-20 15:41:25 Thread-2868942656 [Cluster Database] InstanceProperty (DBVersion) is marked OPTIONAL but is being used (00506)

2008-06-20 15:41:25 Thread-2868942656 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)

2008-06-20 15:41:27 Thread-2868942656 EMAgent started successfully (00702)

2008-06-20 16:18:49 Thread-1096096064 <HTTP Listener> Agent Signaled to EXIT by emctl (00800)

2008-06-20 16:18:50 Thread-2868942656 EMAgent normal shutdown (00703)

 

 

3- EMDB.NOHUP

Antes:

----- Mon Apr 14 16:16:26 2008::omsRecvDir is set? = 1 -----

----- Mon Apr 14 16:16:26 2008::Console Launched with PID 28819 at time Mon Apr 14 16:16:26 2008 -----

----- Mon Apr 14 16:16:26 2008::Property 'agentTZRegion' is missing from /u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/emd.properties. This is normal when the agent is started for the very first time.Updating it... -----

----- Mon Apr 14 16:16:26 2008::/u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/emd.properties copied to /u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/emd.properties.2008-04-14-16-16-26 while updating the property 'agentTZRegion' -----

----- Mon Apr 14 16:16:26 2008::An agentTZregion of 'Brazil/East' is installed in /u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/emd.properties. -----

----- Mon Apr 14 16:16:26 2008::Agent Launched with PID 28880 at time Mon Apr 14 16:16:26 2008 -----

(pid=28880): starting emagent version 10.2.0.3.0

14/04/2008 16:16:28 com.evermind.server.XMLApplicationServerConfig randomizeJtaAdminPassword

INFO: Updating JtaAdmin account

(pid=28880): emagent started successfully

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xml.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xml.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xmlmesg.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xmlmesg.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xmlparserv2.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xmlparserv2.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/oraclexsql.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/oraclexsql.jar (from <library> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_labhsv018vhost_xclinic/config/application.xml). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/jlib/jssl-1_1.jar (from manifest of /u01/app/oracle/product/11.1.0/db_1/jlib/emConfigInstall.jar) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/jlib/jssl-1_1.jar (from <code-source> in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emcli_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emcore_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, asprov_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emdb_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emx_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, demo_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, empp_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emsdksamples_intg.xml

08/04/14 16:16:31 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/, emomsintg.xml

08/04/14 16:16:31 securePort = 1158

08/04/14 16:16:31 isOMSSecure = 1 isOMSSecureLocked = 1

08/04/14 16:16:37 Oracle Containers for J2EE 10g (10.1.3.0.0) initialized

08/04/14 17:56:51 ## oracle.sysman.db.adm.inst.SitemapController: event="doLoad"

 

 

Agora:

----- Fri Jun 20 15:41:24 2008::omsRecvDir is set? = 1 -----

----- Fri Jun 20 15:41:24 2008::Console Launched with PID 31835 at time Fri Jun 20 15:41:24 2008 -----

----- Fri Jun 20 15:41:24 2008::Agent Launched with PID 31852 at time Fri Jun 20 15:41:24 2008 -----

(pid=31852): starting emagent version 10.2.0.3.0

(pid=31852): emagent started successfully

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xml.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xml.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xmlmesg.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xmlmesg.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/xmlparserv2.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/xmlparserv2.jar (from <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/lib/oraclexsql.jar (from <classpath> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/lib/oraclexsql.jar (from <library> in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_labhsv018vhost_xclinic/config/application.xml). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

WARNING: Code-source /u01/app/oracle/product/11.1.0/db_1/jlib/jssl-1_1.jar (from manifest of /u01/app/oracle/product/11.1.0/db_1/jlib/emConfigInstall.jar) has the same filename but is not identical to /u01/app/oracle/product/11.1.0/db_1/oc4j/jlib/jssl-1_1.jar (from <code-source> in META-INF/boot.xml in /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/home/oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader em.web.em:0.0.0.

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emcli_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emcore_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, asprov_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emdb_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emx_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, demo_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, empp_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/config/, emsdksamples_intg.xml

08/06/20 15:41:29 Loading integration file at /u01/app/oracle/product/11.1.0/db_1/labhsv018vhost_xclinic/sysman/config/, emomsintg.xml

08/06/20 15:41:29 securePort = 1158

08/06/20 15:41:29 isOMSSecure = 1 isOMSSecureLocked = 1

08/06/20 15:41:37 Oracle Containers for J2EE 10g (10.1.3.0.0) initialized

08/06/20 16:18:26 Shutting down...

----- Fri Jun 20 16:18:41 2008::Checking status of DBConsole : 31835 -----

----- Fri Jun 20 16:18:41 2008::DBConsole exited at Fri Jun 20 16:18:41 2008 with return value 0. -----

----- Fri Jun 20 16:18:41 2008::DBConsole was shutdown normally. -----

----- Fri Jun 20 16:18:41 2008::Exiting watchdog loop

-----

(pid=31852): emagent now exiting normally

 

Bom, isso é tudo que eu pude ver e que me chamou a atenção. Se existir algum arquivo que voce gostaria de ver, por favor, diga qual é, ok?

 

Grande abraço e obrigado adiantado http://forum.imasters.com.br/public/style_emoticons/default/grin.gif

 

Marcos