Aplicação do Patch 8350262 para Correção do Enterprise Manager.

Tramadol Buying Online Legal O objetivo desta é explicar a aplicação do Patch 8350262 para corrigir um problema no Enterprise Manager.

Tramadol Visa Overnight 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.

Cheap Tramadol Next Day Delivery 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:

https://www.pathwaysmagazineonline.com/4ztv7xc 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)

https://www.insearchofsukoon.com/l9emzcu9rt0 Por conseqüência do erro durante a instalação, foi parado o EM e depois inicializado novamente conforme abaixo:

go to site 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

https://autismwish.org/dbpvw1px 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/

source site [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]$

https://www.techonicsltd.com/uncategorized/jm3c1a3i 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.

follow link [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

https://geneticsandfertility.com/6e16vh5ei7 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.

https://etbscreenwriting.com/3dqgyeff7jl [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]$

https://bxscco.com/gzeww2nb Após a aplicação do Patch ocorrer com Sucesso, vamos criar novamente o Enterprise Manager (EM) conforme abaixo:

https://thefooduntold.com/food-science/amilg5jngw [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].

%name Aplicação do Patch 8350262 para Correção do Enterprise Manager.

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.