JamesMcN
asked on
Oracle 10g OEM DBConsole service won't start on Windows XP Home Edition OS
Hello there,
I'm a competent Oracle developer with something like 5 years experience of developing on both the Oracle database server and in Oracle Forms. I've recently decided to educate myself on the DBA side of things, and have installed the Oracle 10g database server on my laptop. I am running the Windows XP (Home Edition) OS and this has been upgraded to Microsoft's Service Pack 2.
With hindsight being the wonderful thing that it is, after reading some of the articles and solutions presented on this website, I made the mistake of leaving my laptop connected to the internet whilst I installed the Oracle software. The database software was installed on my localhost machine, and this appears to have been correctly picked up by the actual database software installation, judging by the contents of the TNSnames.ora and listener.ora files. However, I don't seem to have been so lucky with the installation of OEM.
Immdediately after I'd installed the database, the OEM DBconsole service started correctly, and I was able to access the Enterprise Manager tool at the http://localhost:5501/em URL. Unfortunately, after experimentally shutting down the DBconsole process, I was unable to restart it. When I ran the "emctl start" command from the DOS prompt, I received the following error message:
EM Configuration issue. C:\oracle\product\10.1.0\D
Regarding the directory string shown, on my system $ORACLE_HOME = " C:\oracle\product\10.1.0\D
After reading one of the solutions to a similar problem on this forum, I disabled my internet connection and ran the "emca - r" command from the DOS prompt. This produced the following results:
--------------------------
RESULTS RETURNED BY THE emca - r COMMAND
--------------------------
C:\Documents and Settings\James>emca -r
STARTED EMCA at Mon May 09 06:38:43 BST 2005
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: MainDB
Service name: MainDB
Email address for notification:
Email gateway for notification:
Password for dbsnmp:
Password for sysman:
Password for sys: :
--------------------------
You have specified the following settings
Database ORACLE_HOME ................ C:\oracle\product\10.1.0\D
Enterprise Manager ORACLE_HOME ................ C:\oracle\product\10.1.0\D
Database host name ................ localhost
Listener port number ................ 1521
Database SID ................ MainDB
Service name ................ MainDB
Email address for notification ...............
Email gateway for notification ...............
--------------------------
Do you wish to continue? [yes/no]: yes
DBConsole is already configured for the database MainDB
Would you like to re-configure DBConsole for the specified database? [yes/no]: yes
Make sure that DBConsole has been shutdown
When you are ready to continue, press <Enter>
09-May-2005 06:41:26 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:29 oracle.sysman.emcp.EMConfi
INFO: Stopping the DBConsole ...
09-May-2005 06:41:31 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:31 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: targets.xml file is updated successfully
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: emoms.properties file is updated successfully
09-May-2005 06:41:40 oracle.sysman.emcp.EMConfi
INFO: Starting the DBConsole ...
09-May-2005 06:46:41 oracle.sysman.emcp.EMConfi
SEVERE: Error starting DBConsole. DBConsole could not be started successfully
Could not complete the configuration. Refer to the log file for details
--------------------------
END OF emca - r RESULTS
--------------------------
After noting the 'SEVERE' Error described above (and wondering which log file it was referring to?), I then attempted to start the DBconsole process from the DOS prompt again. Unlike the first time I did this, I actually got some results different to the original configuration error message described at the beginning of this question. The new results are shown below:
--------------------------
RESULTS OF emctl start dbconsole WHEN EXECUTED AT THE DOS PROMPT
--------------------------
C:\Documents and Settings\James>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://localhost:5501/em/console/aboutApplication
Agent Version : 10.1.0.2.0
OMS Version : 10.1.0.2.0
Protocol Version : 10.1.0.2.0
Agent Home : C:\oracle\product\10.1.0\D
Agent binaries : C:\oracle\product\10.1.0\D
Agent Process ID : 3580
Agent Process ID : 3580
Agent URL : http://localhost:1830/emd/main
Started at : 2005-05-08 16:45:26
Started by user : SYSTEM
Last Reload : 2005-05-09 06:27:07
Last successful upload : 2005-05-09 06:46:47
Total Megabytes of XML files uploaded so far : 1.70
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 48.55%
Agent is already started. Will restart the agent
This will stop the Oracle Enterprise Manager 10g Database Control process. Continue [y/n] :y
The OracleDBConsoleMainDB service is not started.
More help is available by typing NET HELPMSG 3521.
C:\Documents and Settings\James>NET HELPMSG 3521
The *** service is not started.
--------------------------
END OF emctl start dbconsole RESULTS
--------------------------
It's looking like something is still wrong, but I don't know what. Please can anyone on this forum shed any light?
I'm a competent Oracle developer with something like 5 years experience of developing on both the Oracle database server and in Oracle Forms. I've recently decided to educate myself on the DBA side of things, and have installed the Oracle 10g database server on my laptop. I am running the Windows XP (Home Edition) OS and this has been upgraded to Microsoft's Service Pack 2.
With hindsight being the wonderful thing that it is, after reading some of the articles and solutions presented on this website, I made the mistake of leaving my laptop connected to the internet whilst I installed the Oracle software. The database software was installed on my localhost machine, and this appears to have been correctly picked up by the actual database software installation, judging by the contents of the TNSnames.ora and listener.ora files. However, I don't seem to have been so lucky with the installation of OEM.
Immdediately after I'd installed the database, the OEM DBconsole service started correctly, and I was able to access the Enterprise Manager tool at the http://localhost:5501/em URL. Unfortunately, after experimentally shutting down the DBconsole process, I was unable to restart it. When I ran the "emctl start" command from the DOS prompt, I received the following error message:
EM Configuration issue. C:\oracle\product\10.1.0\D
Regarding the directory string shown, on my system $ORACLE_HOME = " C:\oracle\product\10.1.0\D
After reading one of the solutions to a similar problem on this forum, I disabled my internet connection and ran the "emca - r" command from the DOS prompt. This produced the following results:
--------------------------
RESULTS RETURNED BY THE emca - r COMMAND
--------------------------
C:\Documents and Settings\James>emca -r
STARTED EMCA at Mon May 09 06:38:43 BST 2005
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: MainDB
Service name: MainDB
Email address for notification:
Email gateway for notification:
Password for dbsnmp:
Password for sysman:
Password for sys: :
--------------------------
You have specified the following settings
Database ORACLE_HOME ................ C:\oracle\product\10.1.0\D
Enterprise Manager ORACLE_HOME ................ C:\oracle\product\10.1.0\D
Database host name ................ localhost
Listener port number ................ 1521
Database SID ................ MainDB
Service name ................ MainDB
Email address for notification ...............
Email gateway for notification ...............
--------------------------
Do you wish to continue? [yes/no]: yes
DBConsole is already configured for the database MainDB
Would you like to re-configure DBConsole for the specified database? [yes/no]: yes
Make sure that DBConsole has been shutdown
When you are ready to continue, press <Enter>
09-May-2005 06:41:26 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:29 oracle.sysman.emcp.EMConfi
INFO: Stopping the DBConsole ...
09-May-2005 06:41:31 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:31 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: targets.xml file is updated successfully
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: Updating file C:\oracle\product\10.1.0\D
09-May-2005 06:41:33 oracle.sysman.emcp.EMConfi
INFO: emoms.properties file is updated successfully
09-May-2005 06:41:40 oracle.sysman.emcp.EMConfi
INFO: Starting the DBConsole ...
09-May-2005 06:46:41 oracle.sysman.emcp.EMConfi
SEVERE: Error starting DBConsole. DBConsole could not be started successfully
Could not complete the configuration. Refer to the log file for details
--------------------------
END OF emca - r RESULTS
--------------------------
After noting the 'SEVERE' Error described above (and wondering which log file it was referring to?), I then attempted to start the DBconsole process from the DOS prompt again. Unlike the first time I did this, I actually got some results different to the original configuration error message described at the beginning of this question. The new results are shown below:
--------------------------
RESULTS OF emctl start dbconsole WHEN EXECUTED AT THE DOS PROMPT
--------------------------
C:\Documents and Settings\James>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://localhost:5501/em/console/aboutApplication
Agent Version : 10.1.0.2.0
OMS Version : 10.1.0.2.0
Protocol Version : 10.1.0.2.0
Agent Home : C:\oracle\product\10.1.0\D
Agent binaries : C:\oracle\product\10.1.0\D
Agent Process ID : 3580
Agent Process ID : 3580
Agent URL : http://localhost:1830/emd/main
Started at : 2005-05-08 16:45:26
Started by user : SYSTEM
Last Reload : 2005-05-09 06:27:07
Last successful upload : 2005-05-09 06:46:47
Total Megabytes of XML files uploaded so far : 1.70
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 48.55%
Agent is already started. Will restart the agent
This will stop the Oracle Enterprise Manager 10g Database Control process. Continue [y/n] :y
The OracleDBConsoleMainDB service is not started.
More help is available by typing NET HELPMSG 3521.
C:\Documents and Settings\James>NET HELPMSG 3521
The *** service is not started.
--------------------------
END OF emctl start dbconsole RESULTS
--------------------------
It's looking like something is still wrong, but I don't know what. Please can anyone on this forum shed any light?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The reason for this situation is that you have changed the IP or computer name in the domain after installing Oracle.
The Agent stores (encrypted) some details about your TCP/IP identification and after you change it for security reaso it won't start.
Oracle doesn't give us workaround for this. The reason is to stop hackers that will try to install 'zombie' Agent on the server
and will gain control over the Oracle instance.
The workaround is not pleasant. Make an Export (full or only of non-system schemas).
Choose your final IP (Oracle servers can not use DHCP method).
Using DBCA drop the existing DB.
Create a new one again with DBCA.
Import the schemas or the DB.
The Agent stores (encrypted) some details about your TCP/IP identification and after you change it for security reaso it won't start.
Oracle doesn't give us workaround for this. The reason is to stop hackers that will try to install 'zombie' Agent on the server
and will gain control over the Oracle instance.
The workaround is not pleasant. Make an Export (full or only of non-system schemas).
Choose your final IP (Oracle servers can not use DHCP method).
Using DBCA drop the existing DB.
Create a new one again with DBCA.
Import the schemas or the DB.
You can always specify the pfile when you start up your Oracle database.
sqlplus /nolog
connect / as sysdba
startup pfile=/full/path/to/your/i