Reinstall the Oracle on the notebook, after the installation is complete, you can use the OEM console normally, but log back on after logging in or reboot the system after logging in, or the notebook using the network environment has changed, you may encounter problems. These problems encountered the solution used, but for a long time did not toss forget, today put these problems and solutions recorded here.
1, the network environment changes cause unable to start
The phenomenon of this problem is that OEMs cannot be started. Use the command line as follows:
Copy Code code as follows:
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, Oracle Corporation. All rights reserved.
Http://IP:1158/em/console/aboutApplication
.....
This phenomenon has been encountered many times, often after the network environment of your computer (IP address) has changed, resulting in the launch of Oracle will be based on your current IP address to construct the OEM address, rather than the IP you originally installed. Pay attention to this place above, http://IP:1158/em.
In response to this problem, I also based on Google search to rebuild the OEM, but this method is still relatively cumbersome and long, and often encounter inexplicable errors.
The easiest solution I can use is to modify the $oracle_home/bin/emctl.bat file, open the file, and add the following 2 lines of code at the beginning of the file or in the right place (like my setlocal after 42 lines):
Copy Code code as follows:
Set Oracle_sid=test
Set Oracle_hostname=laidye
Note that oracle_hostname to be set to your initial installation when ORACLE read and set the name, in the absence of a network environment to install OEM is often your computer name, you can view the $oracle_home/hostname_sid folder. In this way, no matter how the network environment you use changes, you can start the OEM normally.
2, after landing page display error
2.1. Error java.lang.Exception:Exception in sending Request:: null
The root cause of this problem is the time zone setup problem, and the workaround is to modify the time zone of the configuration file.
Stop the OEM, and then open $oracle_home/hostname_sid/sysman/config/emd.properties, and the last line
Agenttzregion=gmt
Change into
Agenttzregion=asia/shanghai
The specific time zone name can be viewed $oracle_home/sysman/admin/supportedtzs.lst or through the data query select Tzname from V$timezone_names;
Typically, this setting is complete and then restarted. You may also experience this error: Database error Io exception: Unknown host specified
2.2. Database error Io exception: Unknown host specified
If you are experiencing this problem, manually register the new configured time zone parameters under the configuration, using the following command:
Copy Code code as follows:
Set Oracle_sid=youdbsid
Emctl Stop Dbconsole
Emctl Config Agent Gettz
Emctl Start Dbconsol
-the end-
