The reason of ORACLEDBCONSOLEORCL service not starting and the solution idea

By this Oracledbconsole service can not start the problem of torture for two weeks, today is very fortunate, on the internet inadvertently saw a warrior's ideas, although the wrong situation is not exactly the same, but his ideas can be moved over.
Environment: Windows XP, install Oracle 11g, complete database software, create a new database (the SID of the database is orcl20120825), but unable to access the Web version of Enterprise Manager (EM), the hint is "403, the server denied your access request." Because the ID of the database is orcl20120825, so the corresponding Windows service name is OracleDbConsoleorcl20120825, the reason is not much to say, presumably encountered this problem of friends know that this service does not start, so can not enter the Enterprise Manager. Try to start this service and prompt "Windows cannot start ORACLEDBCONSOLEORCL on the local computer. For more information, consult the system event log. If this is a non-Microsoft service, contact your service vendor and refer to the specific service error code 2。 ”
As for the specific reasons, there are many people on the internet to discuss, such as computer name changes, IP address changes, etc., are not discussed separately. The specific cause of the error, only the computer can answer, so, or first ask CMD it ~
Then start the Enterprise Manager in CMD and try it:
1.c:\documents and Settings\administrator>emctl start Dbconsole
This is the command to start the console, which of course is an error:
environment variable oracle_unqname not defined. Please set Oracle_unqname to database unique name.
Although not very clear, but it is certain that the reason can not be started with the ID, SID and other variables related, perhaps the name of the database, perhaps the name of the computer, perhaps the name of a file. Continue ~
2. Since CMD said to set a oracle_unqname for the database, and then searched the Internet, presumably this command:
C:\Documents and Settings\administrator>set oracle_unqname=orcl20120825
Hit the carriage return did not respond, the amount,,, so then knock a semicolon,,,
C:\Documents and settings\administrator>;
Still no response,,, forget, it is already set up, then try to start the Enterprise Manager:
C:\Documents and Settings\administrator>emctl start Dbconsole
Continue to error, but this time the content of a specific:
Oc4j Configuration issue. e:\app\administrator\product\11.2.0\dbhome_1/oc4j/j2ee/oc4j_dbconsole_180.111.140.106_orcl20120825 not found.
It is clear that Oracle is unable to find the prompt for this file or folder and error. So take it for granted that you can go to the directory given in the hints to look at, such as:



Sure enough, there is no oc4j_dbconsole_180.111.140.106_orcl20120825 this folder or file in this directory. However, notice that there is a folder in the directory that is very similar to the file name in the prompt
oc4j_dbconsole_localhost_orcl20120825, only the middle part is different. At this stage, the situation is beginning to clear.
Obviously, 180.111.140.106 appears to be an extranet address, which appears to be in the case of dynamic allocation of IP, can be verified, re-open a cmd,>ipconfig, such as:



Sure enough, this is a dynamically assigned native IP address. And the above directory in the oc4j_dbconsole_localhost_orcl20120825 folder, the middle of the localhost also represents the machine, to this step, basically can get EM can not start the reason, Probably because Oracle uses localhost to identify some variables or files by default, but in a later operation, because the computer is already in the state of the Sisu network, and therefore has a dynamic IP, Oracle use this dynamic IP to identify some variables or files, As a result, some associated files or system settings appear inconsistent with the file name.
The cause of the failure was found, and then the solution begins. Here is to borrow the idea of the warrior:
1. Based on previous experience in Windows toss, you can guess oc4j_dbconsole_localhost_orcl20120825 folder and oc4j_dbconsole_180.111.140.106_ The content in the orcl20120825 folder is the same, except that the folder name is different. Since the prompt said to find the folder of the name, it is not possible to rename the oc4j_dbconsole_localhost_orcl20120825 folder directly, the file name of the localhost changed to 180.111.140.106? Maybe, but to be on the safe side, copy one and rename it. Such as:



As a result, a folder named oc4j_dbconsole_180.111.140.106_orcl20120825 is in the directory. Next, continue executing the last command in CMD and try to start the EM
：
C:\Documents and Settings\administrator>emctl start Dbconsole
Although it is still an error, and the previous error message is very similar:
EM Configuration issue. e:\app\administrator\product\11.2.0\dbhome_1/180.111.140.106_orcl20120825 not found.
It is also a hint that you cannot find a file under a path, so repeat the previous step, and look in the directory for this prompt, such as:



Similarly, in this directory there is no hint in the 180.111.140.106_orcl20120825 folder, but there is a very similar file name folder: localhost_orcl20120825, It is also obvious that the IP address changes caused by the previous article is not consistent with the file naming. Copy the idea of the previous step, guess the content in the 180.111.140.106_orcl20120825 folder is the same as the content in the localhost_orcl20120825, and then copy a localhost_ orcl20120825 folder and rename it to 180.111.140.106_orcl20120825, such as:



As a result, a folder named 180.111.140.106_orcl20120825 is in the directory. Next, continue executing the last command in CMD and try to start em:
C:\Documents and Settings\administrator>emctl start Dbconsole
Although it is still an error, and the previous error message is very similar:
Unable to determine local host vide E:\app\administrator\product\11.2.0\dbhome_1/180.111.140.106_orcl20120825/sysman /config/emd.properties:no such file or directory
This time the hint is more specific, the specified directory is not found in the specified file. Then, repeat the previous step, go to the directory given in the hint and look at it, such as:



This time the situation is a little bit complicated, there is only one OPMN folder in the 180.111.140.106_orcl20120825/sysman/directory, and there is no config folder in the prompt, and there is no folder similar to the "config" name.
Extrapolate Now that you've guessed that the contents of the 180.111.140.106_orcl20120825 folder and the localhost_orcl20120825 folder are consistent, it's natural to think back to the previous step Localhost_ orcl20120825 folder to take a look: such as:



In the localhost_orcl20120825 in the Sysman directory, you can see in fact the content and 180.111.140.106_orcl20120825 under the Sysman directory content is not the same, but both have a OPMN folder, And there are four more folders in the Localhost_orcl20120825\sysman directory, and one of them is named Config, and the path to the error hint in the previous step is the Config directory. And in this config folder there is a file with the same name as the emd.properties in the previous step, so similar to repeat the previous idea, the Localhost_orcl20120825\sysman directory of config, EMD, log, The recv is copied to the 180.111.140.106_orcl20120825\sysman directory (because the OPMN folder is not yet known for its usefulness, so do not move it first). In this way, the directory structure under 180.111.140.106_orcl20120825\sysman is the same as the directory structure under Localhost_orcl20120825\sysman, such as:



Next, continue executing the last command in CMD and try to start em:
C:\Documents and Settings\administrator>emctl start Dbconsole
Amount,,, seemingly no error:
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, Oracle Corporation. All rights reserved.
Https://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ... OracleDBConsoleorcl20
120825 service is starting up ..... ..... ..... ..... ..... ...................
The OracleDBConsoleorcl20120825 service has started successfully.
It's started!
Look at the Windows service again:



This service is starting up!
Don't worry, then use the browser into EM try:



So far, solved a long-standing heart disease!

The reason of ORACLEDBCONSOLEORCL service not starting and the solution idea