1 Definition
Oracle10G EM adopts the web method and is divided into two products: database control and grid control. This section describes how to create a single data dbcontrol. To install Grid control, download a separate CD.
When using DBCA to create a database, you can choose whether to enable dbcontrol. To enable dbcontrol, you need to create a sysman schema in the database to save some data of EM, this is the repository of EM ).
You can use the command line tool emca to create, modify, recreate, or delete dbcontrol configurations.
2. Syntax of Common commands
Emca-repos create creates an EM Database
Emca-repos recreate re-creates an EM Database
Emca-repos drop delete an EM Database
Emca-config dbcontrol db configure Database Control of the Database
Emca-deconfig dbcontrol db deletes the Database Control Configuration of a Database
Emca-reconfig ports reconfigure db control and agent ports
Emctl start console to start the EM console service. You need to set the ORACLE_SID environment variable before use.
Emctl stop console to stop the EM console service. You need to set the ORACLE_SID environment variable before use.
Note: You can check the $ ORACLE_HOME/install/portlist. ini file to find the port currently in use by dbcontrol. The default port is dbcontrol http port 1158 and agent port 3938. To reconfigure the port, run the following command:
Emca-reconfig ports-dbcontrol_http_port 1159(This command experiment failed. After running, it was still 1158. The reason is not found .)
Emca-reconfig ports-agent_port 3939
3. Experiment
3.1 error reported before dbconsole is configured
[Oracle @ cent4 ~] $ Emctl start dbconsole
TZ set to PRC
Enter the name of the Configuration file./u01/app/oracle/product/10.2.1/db_1/Solaris/j2ee/OC4J_DBConsole_cent4.oracle.com_ltest not found.
3.2 configure dbconsole
[Oracle @ cent4 j2ee] $ emca-config dbcontrol db
EMCA started at 9:13:27
EM Configuration Assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Enter the following information:
Database SID: ltest
Listener port: 1521
SYS user password:
DBSNMP user password:
Password of the SYSMAN User:
Password of the SYSMAN User: email address of the notification (optional ):
Notification sending (SMTP) server (optional ):
-----------------------------------------------------------------
The following settings have been specified:
Database ORACLE_HOME ....../u01/app/oracle/product/10.2.1/db_1
Database Host Name...
Listener port number ...... 1521
Database SID ......
Email Address of the notification ...............
Notification sending (SMTP) server ...............
-----------------------------------------------------------------
Continue? [Yes (Y)/no (N)]: YES
2011-11-10 9:15:59 oracle. sysman. emcp. EMConfig perform
Information: this operation is logged to/u01/app/oracle/product/10.2.1/db_1/export toollogs/emca/ltest/emca_2011-11-10_09-13-27-Morning. log.
2011-11-10 9:16:12 oracle. sysman. emcp. util. DBControlUtil startOMS
Information: Starting Database Control (this operation may take some time )...
2011-11-10 9:17:52 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration
Information: The Database Control has been started successfully.
2011-11-10 9:17:52 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration
Information: >>>>>>>>>> Database Control URL for http://cent4.oracle.com: 1158/em <
The Enterprise Manager configuration has been completed successfully.
EMCA ended at 9:17:52
[Oracle @ cent4 j2ee] $ ls
Deploy_db.ini home isqlplus oc4j_applications OC4J_DBConsole OC4J_DBConsole_cent4.oracle.com_ltest