Monday, June 21, 2010

How to Install and Deinstall DBconsole

Step-By-Step - DBconsole RAC Uninstall

WARNING: The uninstall process will Quiesce the database. Do not run on a live system
1. Ensure you have the following information before continuing.
  • Database unique name
  • Listener port number
  • Password for SYS user
  • Password for SYSMAN user
2. Log onto any node in the cluster.
3. Set-up your environment
  • . oraenv
  • ORACLE_SID = [SID] ? enter sid
4. Deconfigure dbconsole and drop the repository
  • emca -deconfig dbcontrol db -repos drop -cluster


Step-By-Step - DBConsole RAC Install

1. Ensure you have the following information before continuing.
  • The Database unique name
  • The Listener port number
  • The Cluster name
  • The Password for SYS user
  • The Password for DBSNMP user
  • The Password for SYSMAN user
  • The Email address for notifications (optional)
  • The Outgoing Mail (SMTP) server for notifications (optional)
  • The ASM ORACLE_HOME e.g. /u01/app/asm/product/10.2.0
  • The ASM port e.g. 1521
  • The ASM user role e.g. SYSDBA
  • The ASM username e.g. SYS
  • The ASM user password
2. Log onto any node in the cluster.
3. Set-up your environment
  • . oraenv
  • ORACLE_SID = [SID] ? enter sid
4. Install database control
  • emca -config dbcontrol db -repos create -cluster
5. Multiple dbconsole inside a RAC environment
Redirects the agents monitoring the database instances in NODE_list so that they upload their data to the console running on nodename. Also, agents monitoring database instances on nodename will also upload their data to the local console. Note that if you do not enter the command options -EM_NODE or -EM_NODE_LIST at the command line, you are prompted for them.

-EM_NODE defaults to the local node if not specified when prompted. -EM_NODE_LIST defaults to all database instances if not specified.

You can use this command to start the console on more than one node. For example, on an 8-node cluster with nodes node1, node2, node3, node4, node5, node6, node7, and node8, you can run the following commands in succession:
  • emca -reconfig dbcontrol –cluster –EM_NODE node1 -EM_NODE_LIST node2,node3,node4
  • emca -reconfig dbcontrol –cluster –EM_NODE node5 -EM_NODE_LIST node6,node7,node8
In this scenario, two Database Control consoles start: one on node1 and the other on node5. You can manage and monitor all targets in the cluster from either of these two consoles.

Step-By-Step - DBconsole Non-RAC Uninstall

WARNING: The uninstall process will Quiesce the database. Do not run on a live system
1. Ensure you have the following mandatory information before starting.
  • The Database SID
  • The Listener port number
  • The Password for SYS user
  • The Password for SYSMAN user
2. Log onto the host.
3. Set-up your environment.
  • . oraenv
  • ORACLE_SID = [SID] ? enter sid
3. Uninstall dbconsole
  • cd $ORACLE_HOME/bin
  • ./emca -deconfig dbcontrol db -repos drop

Step-By-Step - DBconsole Non-RAC Install

1. Ensure you have the following mandatory information before starting.
  • The Database SID
  • The Listener port number
  • The Password for SYS user
  • The Password for DBSNMP user
  • The Password for SYSMAN user
  • The ASM ORACLE_HOME. e.g. /u01/app/asm/product/10.2.0
  • The ASM SID
  • The ASM Listener port. e.g. 1521
  • The ASM user role. e.g. SYSDBA
  • The ASM SYS username
  • The ASM SYS user password
2. Log onto the host.
3. Set-up your environment.
  • . oraenv
  • ORACLE_SID = [SID] ? enter sid
4. Install dbconsole
  • cd $ORACLE_HOME/bin
  • ./emca -config dbcontrol db -repos create

Step-By-Step - Reconfigure Port Number

1. To reconfigure the HTTP port number run the following command.
  • For a RAC environment…

    • emca -reconfig ports -cluster -DBCONTROL_HTTP_PORT 8888
  • For a Non-RAC environment…

    • emca -reconfig ports -DBCONTROL_HTTP_PORT 8888

Display the current cluster configuration

1. This command prompts for the database unique name for the cluster database.
It prints the current configuration to the screen, indicating the nodes that have consoles running on them and the consoles where each agent is uploading.



  • emca -displayConfig dbcontrol –cluster








  • Useful Information