Follow Us on Twitter

How to Reinstalll DBconsole

by Jos van den Oord on August 13, 2010 · 3 comments

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

    Ratings:
    VN:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)

    { 3 comments… read them below or add one }

    Petur Gretarsson March 2, 2011 at 6:54 pm

    Hi,

    Thanks for sharing. Have you changed the listener port number and then needed to reconfigure dbcontrol using emca -config dbcontrol db -cluster ?
    That is not working for me unfortunately.

    Best regards,
    Pétur

    Reply

    Carolin Chatham December 30, 2011 at 7:29 pm

    I am trying to install dbconsole on a oracle 11g solaris system. When I type:
    emca -deconfig dbcontrol db -repos drop
    I get the following error: Error occured during initialization of VM java.lang.NoSuchMethodError: java.lang.System.nanoTime()j

    Any idea?
    Carolin

    Reply

    mamun April 30, 2015 at 7:07 am

    it worked for me. Thanks.

    Reply

    Leave a Comment

     

    Previous post:

    Next post:

    About Whitehorses
    Company profile
    Services
    Technology

    Whitehorses website

    Home page
    Whitebooks
    Jobs

    Follow us
    Blog post RSS
    Comment RSS
    Twitter