Aplicar Patch Oracle Enterprise Manager (8350262)

Aplicar Patch Oracle Enterprise Manager.

Na ferramenta Oracle Enterprise Manager Database Control com Banco de Dados 10g, o certificado raiz usado para manter segura as comunicações, o certificado que garante essa comunicação foi expirado em 31/12/2010 00:00:00. Por este motivo, ocorre erros durante a incialização da ferramenta Oracle Enterprise Manager ( OEM ).
Para corrigir este problema, vamos aplicar o Patch 8350262.

Lembrando que este tipo de problema é identificado no Banco de dados Oracle 10g, apenas para esta versão.



Aplicar Patch Oracle Enterprise Manager.

Durante a inicialização da ferramenta, ocorre falha, conforme mensagem abaixo:

[oracle@oraserver]$ 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.oraserver.net:5500/em/console/aboutApplication

Starting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/server.oraserver.net_XX/sysman/log



[oracle@oraserver ]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Jul 5, 2011 6:42:48 PM
EM Configuration Assistant, Version 10.2.0.4.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: DBNAME
Listener port number: 1521
Password for SYS user:****
Password for SYSMAN user:****

Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 5, 2011 7:45:26 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/cfgtoollogs/emca/XX/emca_2011-07-05_07-45-48-PM.log.
Jul 5, 2011 7:45:27 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jul 5, 2011 7:45:29 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Jul 5, 2011 7:44:25 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at  Jul 5, 2011 7:44:25 PM
[oracle@oraserver]$

Para aplicar o patch, será necessário fazer o download do mesmo no site da Oracle.

[oracle@oraserver]$ cd /home/oracle/
[oracle@oraserver]$ cd 8350262/
[oracle@oraserver]$ ls -l
total 24
drwxr-xr-x 4 oracle oinstall 4096 Sep 14  2010 etc
drwxr-xr-x 3 oracle  oinstall  4096 Sep 14  2010 files
-rwxrwxr-x 1 oracle oinstall  1069 Oct  7  2010 killDBConsole
-rwxrwxr-x 1 oracle oinstall  4640 Oct  7  2010 killDBConsole.pl
-rw-rw-r-- 1 oracle oinstall  3278 Oct  5  2010 README.txt

Para aplicar o patch, conecte no diretório onde o mesmo foi descompactado. Segue exemplo abaixo.

[oracle@oraserver]$ cd /home/oracle/8350262/
[oracle@oraserver]$ opatch apply

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /u01/app/oracle/product/10.2.0/oui

ApplySession applying interim patch '8350262' to OH '/u01/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 "/u01/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 "/u01/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 "/u01/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 "/u01/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 "/u01/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 "/u01/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 "/u01/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 "/u01/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@oraserver]$

Maravilha, após concluir com sucesso a aplicação do patch, estart a criação da ferramenta Oracle Enterprise Manager.

[oracle@oraserver]$ emca -config dbcontrol db -repos create

STARTED EMCA at Jul 6, 2011 4:13:11 PM
EM Configuration Assistant, Version 10.2.0.4.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: DBNAME
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 ................ /u01/app/oracle/product/10.2.0

Database hostname ................ server.oraserver.net
Listener port number ................ 1521
Database SID ................ DBNAME
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 6, 2011 4:13:30 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/cfgtoollogs/emca/XX/emca_2011-07-06_04-13-11-PM.log.
Jul 6, 2011 4:13:31 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 6, 2011 4:14:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 6, 2011 4:14:43 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 6, 2011 4:14:59 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 6, 2011 4:14:59 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 6, 2011 4:16:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 6, 2011 4:16:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://server.oraserver.net:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 6, 2011 4:16:35 PM

Para verificar o status da ferramenta Oracle Enterprise Manager, digite o comando abaixo:

[oracle@oraserver]$ 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.oraserver.net:5500/em/console/aboutApplication

Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /opt/app/oracle/product/10.2.0/server.oraserver.net_XX/sysman/log

Pronto, feito isso o problema será solucionado, e a ferramenta Oracle Enterprise Manager será valida para os próximos 10 anos. As informações sobre este assunto, podem ser encontradas no metaink [ID 1222603.1].


Abraço a todos.

Qualquer dúvida, deixe seu comentário.