Oracle Enterprise Manager

Me he preguntado como reconstruir el Database Control. La verdad que no funciona para nada mi dbconsole asi que...lo reconstrui....

Aquí van los comandos (No te olvides de configurar el ORACLE_SID)

Si existe en esquema SYSMAN es necesario eliminar el repositorio con el siguiente comando.

oracle@heretic:/u01/oracle/10g/network/admin$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Mar 24, 2009 3:08:31 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: ORADALI
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 24, 2009 3:08:43 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/10g/cfgtoollogs/emca/HA_PROD/emca_2009-03-24_03-08-31-PM.log.
Mar 24, 2009 3:08:43 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Mar 24, 2009 3:08:43 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Mar 24, 2009 3:09:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 24, 2009 3:09:09 PM

Para configurar nuevamente el Database Control, se debe ejecutar lo siguiente:

oracle@heretic:/u01/oracle/10g/network/admin$ emca -config dbcontrol db -repos create

STARTED EMCA at Mar 24, 2009 3:10:42 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: ORADALI
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/oracle/10g

Database hostname ................ heretic
Listener port number ................ 1521
Database SID ................ ORADALI
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 24, 2009 3:10:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/10g/cfgtoollogs/emca/HA_PROD/emca_2009-03-24_03-10-42-PM.log.
Mar 24, 2009 3:10:59 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 24, 2009 3:11:52 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Mar 24, 2009 3:11:55 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Mar 24, 2009 3:15:43 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Mar 24, 2009 3:15:43 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 24, 2009 3:17:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Mar 24, 2009 3:17:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://heretic:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 24, 2009 3:17:17 PM

Y Listo!!!!!

Saludos.
Alberto Silva Gallardo.