Como configurar Database Console para Oracle RAC

Nunca esta demás, saber como recrear el Oracle Database Console para Oracle RAC y la verdad que fue bastante fácil. Mediante los siguientes comandos es posible volver a crear el repositorio satisfactoriamente.

Dentro de los parámetros que solicita el dialogo, es necesario entregar los siguientes valores:

Listener port number: 1521
Cluster name: vmgrac01-hs_cluster
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:

Como encuentro el nombre del cluster?

Bueno, debes ir al directorio $CRS_HOME/bin y ejecutar el siguiente comando:

./cemutlo -n ---> vmgrac01-hs_cluster

Una vez, obtenido el nombre del Cluster, ya podemos continuar con la configuración del Oracle Database Console...

Para recrear entonces el repositorio ejecutar el siguiente comando con el usuario Oracle:


[oracle@vmgrac01-hst]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Aug 3, 2010 1:10:53 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database unique name: 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
Cluster name: vmgrac01-hs_cluster
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/oracle/product/10.2.0/db_1 ]: /u01/app/crs
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1

Database instance hostname ................ vmgrac01-hst.andoria.cl
Listener port number ................ 1521
Cluster name ................ vmgrac01-hs_cluster
Database unique name ................ ORCL
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/crs
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 3, 2010 1:14:50 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2010-08-03_01-10-53-PM.log.
Aug 3, 2010 1:16:48 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Aug 3, 2010 1:17:04 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 3, 2010 1:20:07 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 3, 2010 1:20:47 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_vmgrac01-hst_ORCL11 to remote nodes ...
Aug 3, 2010 1:20:47 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_vmgrac02-hst_ORCL12 to remote nodes ...
Aug 3, 2010 1:21:01 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/10.2.0/db_1/vmgrac01-hst_ORCL11 to remote nodes ...
Aug 3, 2010 1:21:15 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/10.2.0/db_1/vmgrac02-hst_ORCL12 to remote nodes ...
Aug 3, 2010 1:21:16 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 3, 2010 1:27:15 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 3, 2010 1:28:00 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 3, 2010 1:28:00 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://vmgrac01-hst.andoria.cl:1158/em <<<<<<<<<<<
Aug 3, 2010 1:28:01 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

ORCL11 vmgrac01-hst vmgrac01-hst.andoria.cl
ORCL12 vmgrac02-hst vmgrac01-hst.andoria.cl


Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 3, 2010 1:28:01 PM

Nota: Es importante elegir cual nodo será configurado con Oracle Database Console, ya que se puede ingresar solo al nodo definido para esto. En este caso lo configure en el vmgrac01-hst.andoria.cl.


Y Listo!!!!
Viva LINUX!!!!

Saludos.
Alberto Silva Gallardo