Database Reference
In-Depth Information
Reconfiguring the Database Console
With the Oracle 11g Release 2 version of the Database Control, there have been occasions in which the control needs
to be rebuilt or reconfigured. Reconfiguring of the Database Control often corrects any issues that may have occurred
in the repository for the control. To reconfigure the Database Control, you need to invoke the Enterprise Manager
Configuration Assistant (
emca
) with the
recreate
option. The following
emca
command (see Listing 6-14) will
reconfigure the Database Control and re-create the repository for the database on the Oracle Database Appliance.
Listing 6-14.
recreate Command
$ cd $ORACLE_HOME/bin
$ ./emca -config dbcontrol db -repos recreate -cluster
When reconfiguring Database Control, the
emca
command will ask you for a few parameters. These parameters
can be passed on the command line or in a parameter file. These parameters can be found in Table
6-1
. The output
in Listing 6-15 is from reconfiguring Database Control for a cluster database on the Oracle Database Appliance. The
output has been shortened to highlight the areas that are of concern when reconfiguring Database Control.
Listing 6-15.
Output from emca Reconfigure of Database Control
STARTED EMCA at Oct 9, 2013 4:47:58 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name: dboda
Service name: dboda
Listener ORACLE_HOME [ /u01/app/11.2.0.3/grid ]:
Password for SYS user: come
Database Control is already configured for the database dboda
You have chosen to configure Database Control for managing the database dboda
This will remove the existing configuration and the default settings and perform a fresh
configuration
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: dboda_cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/11.2.0.3/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
Oct 9, 2013 4:48:41 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
