Configurar Oracle Enterprise Manager

Instalando a ferramenta Oracle Enterprise Manager em banco de dados Oracle 10g e 11g.
Observação: Este procedimento é para ambiente single instance.

Verifique os usuários DBSNMP e SYSMAN, estes devem estar com as contas criadas no Banco de dados.

Segue abaixo o procedimento: Para criação!



Instalando a ferramenta Oracle Enterprise Manager em banco de dados Oracle 10g e 11g.
Observação: Este procedimento é para ambiente single instance.

Verifique os usuários DBSNMP e SYSMAN, estes devem estar com as contas criadas no Banco de dados.

Segue abaixo o procedimento: Para criação!


Comando: emca -config dbcontrol db -repos recreate

[oracle@oraprd ~]$ emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 6, 2011 2:21:55 PM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
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 ................ /oraprd01/app/oracle/product/11.1.0/db_1

Local hostname ................ oraprd
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 6, 2011 2:22:27 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oraprd01/app/oracle/cfgtoollogs/emca/orcl/emca_2011_07_06_14_21_55.log.
Jul 6, 2011 2:22:30 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jul 6, 2011 2:22:36 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 6, 2011 2:26:52 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 6, 2011 2:26:52 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 6, 2011 2:35:14 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 6, 2011 2:35:26 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 6, 2011 2:36:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 6, 2011 2:36:41 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for oraprd
Jul 6, 2011 2:36:52 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jul 6, 2011 2:36:52 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jul 6, 2011 2:37:09 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jul 6, 2011 2:37:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 6, 2011 2:37:30 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 6, 2011 2:37:30 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 6, 2011 2:38:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 6, 2011 2:38:58 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://oraprd:1158/em <<<<<<<<<<<
Jul 6, 2011 2:39:09 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file:

/oraprd01/app/oracle/product/11.1.0/db_1/oraprd_orcl/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 6, 2011 2:39:09 PM