Oracle EM Manual Configuration

Source: Internet
Author: User

Reprinted from: http://www.cnblogs.com/sopost/archive/2010/08/14/2190098.html

Configuring EM with EMCA

EMCA is a command prompt that uses formats and methods to enter EMCA at a command prompt, EMCA use help appears on the screen.

Command Help is as follows:
EMCA [Operation] [mode] [Database type] [tag] [parameter]

The following two commands are commonly used:
Emca-config Dbcontrol db-repos Create an EM repository and simultaneously formulate the database Control
Emca-deconfig dbcontrol db-repos Drop Delete the database control and delete the EM database at the same time

[Operation] corresponds to-config and-deconfig meaning is the compounding meaning. Note "-" must not be less
[mode] corresponds to Dbcontrol, which means the database Control
[Database type] corresponds to DB, which means the database, which performs configuration operations on the database (including databases using ASM)
[Mark] not here.
[parameter] corresponds to-repos Create and-repos drop, meaning creating an EM repository and deleting the current EM repository

If we haven't formulated the database control and we don't have an EM database, we'll enter the following command
Emca-config Dbcontrol Db-repos Create

Database SID:ORCL
Listener Port number: 1521
SYS User's password:
DBSNMP User's password:
Sysman User's password:
Sysman User's password: e-mail address of the notification (optional):
Outgoing (SMTP) server for notifications (optional):
Do you want to continue? [Yes (Y)/no (N)]: Y

If successful, and start Dbcontrol at the same time, the following startup information appears:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Http://IP:port/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ... Oracledbconsoleorcl
The service is starting ......... ........
The ORACLEDBCONSOLEORCL service has started successfully.

Hit the Web browser, enter http://IP:port/em/can see the boot information.

If the original EM database has been created, you can configure the database Control
Emca-config Dbcontrol DB

If you need to remove the database control configuration, but do not delete the EM repository
Emca-deconfig Dbcontrol DB

If you need to delete all, enter the following command: (Note!) DBCA is not deleting the EM database and canceling the database control configuration)
Emca-deconfig Dbcontrol Db-repos Drop

Delete an EM database, but if the database control is prepared, it is no longer available and requires the Dbconsole service to be stopped before it can be used.
Emca-repos Drop

Create an EM database, if the database control is prepared, but found that the EM repository does not exist, you can create it with the following command.
Emca-repos Create

Rebuilding an EM database
Emca-repos recreate

If we do not have any information in our database, we will use a single statement to prepare
Emca-config Dbcontrol Db-repos Create
Need to remove all em repositories with
Emca-deconfig Dbcontrol Db-repos Drop
But we can also make a step-by-step formulation, or in the EM problem, we need to use a separate command to deal with.

Command summary:
Emca-config Dbcontrol db-repos Create an EM database and prepare the database Control
Emca-deconfig dbcontrol db-repos Drop cancel the configuration of the database Control and delete the EM database
Emca-repos Create an EM repository
Emca-repos recreate rebuilding an EM database
Emca-repos drop Delete an em repository
Emca-config Dbcontrol DB Configuration Database Control
Emca-deconfig Dbcontrol db To delete database control configuration
Emctl start dbconsole after setting the ORACLE_SID environment variable, launch the EM console service
Emctl Stop dbconsole The EM console service after setting the ORACLE_SID environment variable first
Emctl status Dbconsole After setting the ORACLE_SID environment variable, view the state of the EM console service

Advantages: Can not complete the preparation of EM in DBCA, can also delete em.
Disadvantages: Complex, command parameters are not selected correctly, often error.
Because errors often occur under commands, errors are analyzed based on error prompts and logs to analyze the cause of the error, and then the method of resolving the error based on the cause of the error can be solved.

Note: If the login is garbled, the problem is that the DK/JRE character set is automatically selected at installation, there are many character sets in the $oralce_home/jdk/jre/lib directory,

Choose an appropriate character set to replace the default file

CP Font.properties.zh_CN. Redhat font.properties

After the replacement, you need to clean up the cache and restart EM. The cache path is typically located in

$ORACLE _home/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs Erase all GIFs.

Note: When manually configuring EM, be careful to check whether SYSMAN,DBSNMP users are available in the Dba_users

Otherwise enter EM, no login options and feature options

Oracle EM Manual Configuration

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.