O objetivo desta é explicar a aplicação do Patch 8350262 para corrigir um problema no Enterprise Manager.
Motivo do Erro:
No Enterprise Manager Database Control com Banco de Dados Oracle 10.2.0.4 e 10.2.0.5, o certificado raiz usado para manter segura as comunicações via protocolo Secure Socket Layer (SSL), expirará em 31/12/2010 00:00:00. A expiração do certificado causa erros se tentares configurar o Database Control depois de 31/12/2010 00:00:00. Database Control já configurados antes dessa data não são afetados pelo problema.
Portanto o objetivo desse é corrigir este problema aplicando o Patch 8350262.
O banco de dados Oracle que estou utilizando para a aplicação deste Patch é o 10.2.0.4.0.
Durante o processo de instalação, ao iniciar o Enterprise Manager, o mesmo ocorreu com erros conforme abaixo:
Starting Oracle Enterprise Manager 10g Database Control ......................................................................
....................... failed.
------------------------------------------------------------------
Logs are generated in directory /opt/app/oracle/product/10.2.0/server_xxxx/sysman/log
Aug 8, 2011 6:51:17 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /opt/app/oracle/product/10.2.0/bin/emctl start dbconsole
Aug 8, 2011 6:51:17 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /opt/app/oracle/product/10.2.0/cfgtoollogs/emca/XX/emca_2011-08-08_06-44-52-PM.log for more details.
Aug 8, 2011 6:51:17 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:646)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:224)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:193)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
Por conseqüência do erro durante a instalação, foi parado o EM e depois inicializado novamente conforme abaixo:
oracle@server oracle]$ emctl stop 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. https://server.meuserver.net:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control ... ... Stopped. [oracle@server oracle]$ 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. https://server.meuserver.net:1158/em/console/aboutApplication Starting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed. ------------------------------------------------------------------ Logs are generated in directory /opt/app/oracle/product/10.2.0/server.meuserver.net_XX/sysman/log
O erro de falha continuou a ocorrer, sendo assim, pesquisando foi identificado que para corrigir o problema devemos aplicar o Patch para o EM.
Vamos remover o EM instalado que está ocorrendo falha.
OBS: Para recriação do Enterprise Manager veja o POST do Anderson Graf https://oraclehome.com.br/2011/09/06/recriando-repositorio-do-oracle-enterprise-manager/
[oracle@server oracle]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Aug 8, 2011 6:42:48 PM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: XX Listener port number: 1521 Password for SYS user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: Y Aug 8, 2011 6:43:26 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /opt/app/oracle/product/10.2.0/cfgtoollogs/emca/XX/emca_2011-08-08_06-42-48-PM.log. Aug 8, 2011 6:43:27 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Aug 8, 2011 6:43:29 PM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... Aug 8, 2011 6:44:25 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Aug 8, 2011 6:44:25 PM [oracle@server oracle]$
OBS: Para aplicação deste, não há necessidade de baixar o banco de dados. Devemos apenas verificar se o JAVA do EM está em execução, pois este não deve estar em execução durante a aplicação do Patch. Baixar também todos os EM e os seus respectivos agentes antes de aplicar o Patch.
Devemos copiar o arquivo baixado do Metalink e descompactar o mesmo em qualquer diretório. Este procedimento já realizei.
Vamos aplicar o Patch 8350262. Este procedimento foi executado em um Linux Red Hat 64 Bits.
[oracle@server oracle]$ cd /home/oracle/ [oracle@server ~]$ cd 8350262/ [oracle@server 8350262]$ ls -l total 24 drwxr-xr-x 4 oracle dba 4096 Sep 14 2010 etc drwxr-xr-x 3 oracle dba 4096 Sep 14 2010 files -rwxrwxr-x 1 oracle dba 1069 Oct 7 2010 killDBConsole -rwxrwxr-x 1 oracle dba 4640 Oct 7 2010 killDBConsole.pl -rw-rw-r-- 1 oracle dba 3278 Oct 5 2010 README.txt
Para aplicar o Patch, devemos estar dentro do diretório contendo os arquivos do Patch conforme abaixo. Já que estamos dentro do diretório contendo o Patch, vamos aplicar o Patch envolvendo o OPatch.
[oracle@server 8350262]$ /opt/app/oracle/product/10.2.0/OPatch/opatch apply Invoking OPatch 10.2.0.4.2 Oracle Interim Patch Installer version 10.2.0.4.2 Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /opt/app/oracle/product/10.2.0 Central Inventory : /opt/app/oracle/oraInventory from : /etc/oraInst.loc OPatch version : 10.2.0.4.2 OUI version : 10.2.0.4.0 OUI location : /opt/app/oracle/product/10.2.0/oui Log file location : /opt/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2011-09-14_14-18-38PM.log ApplySession applying interim patch '8350262' to OH '/opt/app/oracle/product/10.2.0' Running prerequisite checks... OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Backing up files and inventory (not for auto-rollback) for the Oracle Home Backing up files affected by the patch '8350262' for restore. This might take a while... Backing up files affected by the patch '8350262' for rollback. This might take a while... Patching component oracle.sysman.agent.core, 10.2.0.4.0a... Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class" Updating jar file "/opt/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/SecConstants.class" ApplySession adding interim patch '8350262' to inventory Verifying the update... Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8350262 are present in Oracle Home. OPatch succeeded. [oracle@server 8350262]$
Após a aplicação do Patch ocorrer com Sucesso, vamos criar novamente o Enterprise Manager (EM) conforme abaixo:
[oracle@server oracle]$ emca -config dbcontrol db -repos create STARTED EMCA at Sep 14, 2011 3:13:11 PM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: XX Listener port number: 1521 Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /opt/app/oracle/product/10.2.0 Database hostname ................ server.meuserver.net Listener port number ................ 1521 Database SID ................ XX Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Sep 14, 2011 3:13:30 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /opt/app/oracle/product/10.2.0/cfgtoollogs/emca/XX/emca_2011-09-14_03-13-11-PM.log. Sep 14, 2011 3:13:31 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Sep 14, 2011 3:14:40 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Sep 14, 2011 3:14:43 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Sep 14, 2011 3:14:59 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Sep 14, 2011 3:14:59 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Sep 14, 2011 3:16:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Sep 14, 2011 3:16:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://server.meuserver.net:1158/em <<<<<<<<<<< Enterprise Manager configuration completed successfully FINISHED EMCA at Sep 14, 2011 3:16:35 PM
Vamos verificar o status após aplicação do Patch e da Criação do EM.
[oracle@server oracle]$ emctl status 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. https://server.meuserver.net:1158/em/console/aboutApplication Oracle Enterprise Manager 10g is running. ------------------------------------------------------------------ Logs are generated in directory /opt/app/oracle/product/10.2.0/server.meuserver.net_XX/sysman/log
Vamos verificar o status do Agent do Enterprise Manager após aplicação do Patch e da Criação do EM.
[oracle@server oracle]$ emctl status 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. --------------------------------------------------------------- Agent Version : 10.1.0.6.0 OMS Version : 10.1.0.6.0 Protocol Version : 10.1.0.2.0 Agent Home : /opt/app/oracle/product/10.2.0/server.meuserver.net_XX Agent binaries : /opt/app/oracle/product/10.2.0 Agent Process ID : 23029 Parent Process ID : 20310 Agent URL : https://server.meuserver.net:1832/emd/main Started at : 2011-09-14 15:16:32 Started by user : oracle Last Reload : 2011-09-14 15:16:32 Last successful upload : 2011-09-14 15:24:59 Total Megabytes of XML files uploaded so far : 4.33 Number of XML files pending upload : 0 Size of XML files pending upload(MB) : 0.00 Available disk space on upload filesystem : 25.35% --------------------------------------------------------------- Agent is Running and Ready [oracle@server oracle]$
Pronto resolvemos o problema da falha ao iniciar o Enterprise Manager.
Para mais informações sobre o assunto, veja no Metalink os IDs [ID 1217493.1],[ID 1222603.1].
Autor: Maycon Tomiasi
Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.
One thought on “Aplicação do Patch 8350262 para Correção do Enterprise Manager.”