Oracle 10g OEM regular error solving

Source: Internet
Author: User

After installing Oracle in the notebook, you can use the OEM console normally. However, after logging out, log on again or restart the system, or change the network environment of the notebook, problems may occur. The solutions to these problems have been used, but I have forgotten them for a long time. Today I have recorded these problems and solutions here.

0. Failed to start due to network environment changes

This problem occurs because the OEM cannot be started. Use the following command line:

C:/Users/Administrator> set ORACLE_SID = TEST

C:/Users/Administrator> emctl stop dbconsol

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // IP: 1158/em/console/aboutApplication
.....
This problem has been encountered many times. It is often because the network environment (IP address) of your computer changes, so that oracle will construct an OEM address based on your current IP Address at startup, instead of the IP address you installed. Note the above: http: // IP: 1158/em.

To solve this problem, I also rebuilt the OEM based on the methods found by google, but this method is still cumbersome and long, and often encounters inexplicable errors.

The simplest solution is to modify $ ORACLE_HOME/BIN/emctl. bat file, open this file, and add the following two lines of code at the beginning of the file or in a proper location (for example, after 42 rows of setlocal:

Set ORACLE_SID = TEST
Set ORACLE_HOSTNAME = Laidye

Note that ORACLE_HOSTNAME should be set to the name you read and set during the initial installation of oracle. It is often the name of your computer when installing oem in a network environment, for more information, see the $ ORACLE_HOME/HOSTNAME_SID folder. In this way, the OEM can be started normally no matter how the network environment you are using changes.

1. An error is displayed on the logon page.

1.1 error java. lang. Exception: Exception in sending Request: null

The root cause of this problem is the time zone setting problem. The solution is to modify the time zone of the configuration file.

Stop the OEM, open $ ORACLE_HOME/HOSTNAME_SID/sysman/config/emd. properties, and set the last line

AgentTZRegion = GMT

Change

AgentTZRegion = Asia/Shanghai

For specific time zone names, you can view $ ORACLE_HOME/sysman/admin/supportedtzs. lst or Select TZNAME From v $ timezone_names through data query;

In general, you can restart the instance after the configuration is complete. This error may also occur: Database Error Io exception: Unknown host specified

1.2 Database Error Io exception: Unknown host specified

If you encounter this problem, manually register the time zone parameter configured in the configuration, and use the following command:

Set ORACLE_SID = youdbsid

Emctl stop dbconsole
Emctl config agent getTZ
Emctl start dbconsol

-The End-

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.