DB - Oracle reconfig database control

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>cd C:\app\Administrator\product\11.1.0\d
b_1

C:\app\Administrator\product\11.1.0\db_1>cd bin

C:\app\Administrator\product\11.1.0\db_1\BIN>emca
C:\app\Administrator\product\11.1.0\db_1\bin\emca.bat [operation] [mode] [dbType
] [flags] [parameters]

-h | --h | -help | --help: prints this help message
-version: prints the version

-config dbcontrol db [-repos (create | recreate)] [-cluster] [-silent] [-backup]
[parameters]: configure Database Control for a database
-config centralAgent (db | asm) [-cluster] [-silent] [parameters]: configure cen
tral agent management
-config all db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [para
meters]: configure both Database Control and central agent management

-deconfig dbcontrol db [-repos drop] [-cluster] [-silent] [parameters]: de-confi
gure Database Control
-deconfig centralAgent (db | asm) [-cluster] [ -silent] [parameters]: de-configu
re central agent management
-deconfig all db [-repos drop] [-cluster] [-silent] [parameters]: de-configure b
oth Database Control and central agent management

-addInst (db | asm) [-silent] [parameters]: configure EM for a new RAC instance
-deleteInst (db | asm) [-silent] [parameters]: de-configure EM for a specified R
AC instance

-reconfig ports [-cluster] [parameters]: explicitly reassign Database Control po
rts
-reconfig dbcontrol -cluster [-silent] [parameters]: reconfigures RAC Database C
ontrol deployment

-displayConfig dbcontrol -cluster [-silent] [parameters]: displays information a
bout the RAC Database Control configuration

-migrate -from dbcontrol -to centralAgent [-repos drop] [-cluster] [-silent] [p
arameters]: migrates EM configuration from Database Control to central agent

-upgrade (db | asm | db_asm) [-cluster] [-silent] [parameters]: upgrades an earl
ier version of the EM configuration to the current version

-restore (db | asm | db_asm) [-cluster] [-silent] [parameters]: restores the cur
rent version of the EM configuration to an earlier version

Parameters and Options:
[parameters]: [ -respFile fileName ] [ -paramName paramValue ]*
db: perform configuration operation for a database (including databases that use
ASM)
asm: perform configuration operation for an ASM-only instance
db_asm: perform upgrade/restore operation for a database and an ASM instance
-repos create: create a new Database Control repository
-repos drop: drop the current Database Control repository
-repos recreate: drop the current Database Control repository and recreate a new
one
-cluster: perform configuration operation for a RAC database
-silent: perform configuration operation without prompting for parameters
-backup: configure automatic backup for a database

Parameters for single instance databases
ORACLE_HOSTNAME: Local hostname
SID: Database SID
PORT: Listener port number
ORACLE_HOME: Database ORACLE_HOME
HOST_USER: Host username for automatic backup
HOST_USER_PWD: Host user password for automatic backup
BACKUP_SCHEDULE: Automatic backup schedule (HH:MM)
EMAIL_ADDRESS: Email address for notifications
MAIL_SERVER_NAME: Outgoing Mail (SMTP) server for notifications
ASM_OH: ASM ORACLE_HOME
ASM_SID: ASM SID
ASM_PORT: ASM port
ASM_USER_ROLE: ASM user role
ASM_USER_NAME: ASM username
ASM_USER_PWD: ASM user password
SRC_OH: ORACLE_HOME for the database to be upgraded
DBSNMP_PWD: Password for DBSNMP user
SYSMAN_PWD: Password for SYSMAN user
SYS_PWD: Password for SYS user
DBCONTROL_HTTP_PORT: Database Control HTTP port
AGENT_PORT: EM agent port
RMI_PORT: RMI port for Database Control
JMS_PORT: JMS port for Database Control
EM_SWLIB_STAGE_LOC: Software library location
PORTS_FILE: Path to a static file specifying the ports to use (Default v
alue : ${ORACLE_HOME}/install/staticports.ini).

Additional Parameters for cluster databases
CLUSTER_NAME: Cluster name
DB_UNIQUE_NAME: Database unique name
SERVICE_NAME: Service name
EM_NODE: Database Control node name
EM_SID_LIST: Agent SID list [comma separated]

C:\app\Administrator\product\11.1.0\db_1\BIN>emca -config dbcontrol db

STARTED EMCA at Mar 27, 2009 4:21:55 PM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: 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
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ C:\app\Administrator\product\11.1.0\db_1

Local hostname ................ cdcjp70
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Mar 27, 2009 4:23:28 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\Administrator\cfgtoollogs\emca\or
cl\emca_2009_03_27_16_21_55.log.
Mar 27, 2009 4:23:35 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 27, 2009 4:23:43 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos
itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 27, 2009 4:24:52 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Mar 27, 2009 4:24:55 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Cannot start Database Control. The following ports are already in use: [
Database Control HTTP port:1158 RMI port for Database Control:5520].
Refer to the log file at C:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_03
_27_16_21_55.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Administra
tor\cfgtoollogs\emca\orcl\emca_2009_03_27_16_21_55.log for more details.

C:\app\Administrator\product\11.1.0\db_1\BIN>