Categories
Blog

How to recreate database dbconsole

Steps to recreate database dbconsole
1) emca -deconfig dbcontrol db -repos drop
2) Normally you would run emca -reconfig all db -repos recreate but we want to specify a listener home

$ emca -config dbcontrol db -repos recreate -cluster -LISTENER_OH /opt/app/oracle/product/10.2/asm_1
STARTED EMCA at 13-Nov-2009 11:18:11
 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: shello1
 Listener port number: 1521
 Cluster name: crs
 Password for SYS user: warrier
 Password for DBSNMP user: warlord
 Password for SYSMAN user: warlord
 Email address for notifications (optional):
 Outgoing Mail (SMTP) server for notifications (optional):
 ASM ORACLE_HOME [ /opt/app/oracle/product/10.2/db_1 ]: /opt/app/oracle/product/10.2/asm_1
 ASM port [ 1521 ]:
 ASM user role [ SYSDBA ]:
 ASM username [ SYS ]:
 ASM user password: warlord
 -----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /opt/app/oracle/product/10.2/db_1
Database instance hostname ................ shelled.net
 Listener port number ................ 1521
 Cluster name ................ crs
 Database unique name ................ shello1
 Email address for notifications ...............
 Outgoing Mail (SMTP) server for notifications ...............
 ASM ORACLE_HOME ................ /opt/app/oracle/product/10.2/asm_1
 ASM port ................ 1521
 ASM user role ................ SYSDBA
 ASM username ................ SYS
-----------------------------------------------------------------
 Do you wish to continue? [yes(Y)/no(N)]: Y

This will recreate the dbconsole.