Oracle EM (Enterprise Manager) Collection stickers

Source: Internet
Author: User
Em configuration command ==============================

Create an EM Database
Emca-repos create
Rebuilding an EM Database
Emca-repos recreate
Delete An EM Database
Emca-repos drop
Configure Database Control for the database
Emca-config dbcontrol DB
Delete Database Control Configuration of a Database
Emca-deconfig dbcontrol DB
Reconfigure the Database Control port. The default port is 1158.
Emca-reconfig ports
Emca-reconfig ports-dbcontrol_http_port 1160
Emca-reconfig ports-agent_port 3940
Set the oracle_sid environment variable and start the EM console service.
Emctl start dbconsole
Set the oracle_sid environment variable and stop the EM console service.
Emctl stop dbconsole
Set the oracle_sid environment variable to view the EM console service status.
Emctl status dbconsole

Steps for configuring dbconsole
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole
To reconfigure dbconsole
Emca-repos drop
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole

Failed to log on to Oracle after network disconnection
Em ====================================

The network is disconnected and the dbconsole service cannot be started to solve this problem. Many Oracle 10 Gb xdjm users have encountered this problem. I have also encountered this problem in my notebook. dbconsole is usable, however, if a laptop uses a wireless network card to connect to the Internet, the same situation may occur when the laptop is not connected to wifi.

Error status:
Window Platform
Previously, dbconsole can be started, but the oracledbconsolexxx service cannot be started after the network is unplugged.

Troubleshooting:
First, set the Window environment variable oracle_sid = database Sid.
Open cmd
Enter emctl start dbconsole
An error message is displayed. If oracle_sid is not set, the message is displayed.
Environment Variable oracle_sid not defined. Please define it.

If oracle_sid has been set, the error prompt is
.
D: \ oracle \ product \ 10.1.0 \ db_1 is the home directory of Oracle10g on your machine.

This information is very important and is also the root cause of service failures.
Dbconsole is a Java Web application. When creating dbconsole, we will create a repos Based on the machine and Oracle information. This repos is the repository that stores the configuration information of dbconsole. Due to network disconnection, the machine name will be mapped to localhost, and the machine name is used by default when the database is created. Therefore, if the two directories do not match, the dbconsole fails to find the directory for configuring the repository.

Solution,
There are two solutions: one is more formal
Re-establish repos through emca
The command is as follows:
Emca-config dbcontrol DB-repos recreate

Method 2 is self-tested. It is not a formal method, but easier to operate than the previous method.
A Directory D: \ oracle \ product \ 10.1.0 \ db_1 \ Solaris \ J2EE \ oc4j_dbconsole_localhost_java cannot be found in the information prompt. Go to the directory at the top of the message prompt and check it, we can see a directory similar to oc4j_dbconsole_janes_java. Here, Janes is my machine name. Copy this directory to the current directory and change it to the directory name not found in the Information prompt, for example, change to D: \ oracle \ product \ 10.1.0 \ db_1 \ Solaris \ J2EE \ oc4j_dbconsole_localhost_java.

In the Directory D: \ oracle \ product \ 10.1.0 \ db_1, you can find a directory named like janes_orcl,
Note: janes_orcl the Janes here is my machine name and orcl is my Oracle SID. You can find a similar directory based on your situation, copy the file to the current directory and change it to localhost_orcl.

There is a third method, but I have not tried it.
If this problem occurs, try set oracle_hostname = localhost.

Related Article

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.