What happened and how do I fix it?
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0 Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved. http://123.45.678.90:1234/em/console/AboutApplication Agent Version : 10.1.0.5.1 OMS Version : 10.1.0.5.0 Protocol Version : 10.1.0.2.0 Agent Home : D:\oracle\product\10.2.0\db_1\123.45.678.90_blahblah Agent binaries : D:\oracle\product\10.2.0\db_1 Agent Process ID : 2904 Agent Process ID : 2904 Agent URL : http://123.45.678.90:1234/em/console/emd/main Started at : 2011-09-27 08:49:49 Started by user : SYSTEM Last Reload : 2011-09-27 08:49:49 Last successful upload : (none) Last attempted upload : (none) Total Megabytes of XML files uploaded so far : 0.00 Number of XML files pending upload : 932 Size of XML files pending upload(MB) : 5.17 Available disk space on upload filesystem : 34.62% Agent is already started. Will restart the agent System error 1060 has occurred. The specified service does not exist as an installed service.
Not sure if this helps - but one thing I have noticed is v$process increases rapidly from the time I started to now. When I first started, select count(*) from v$process* was 60; and now it's over 252. This is a test environment; it shouldn't have so much thing going on. And it continues to go up in count ...happens for example when the EM repository is corrupt, and the database is flooded with connections with SYSMAN user
apex_disco wrote:Configuring Database Control with EMCA
The process count seems stable if I start all the services except DBCONSOLE. So, that sorts of confirm DBCONSOLE service is corrupt. Question is how do I fix it? I have tried DBCA and Configure Database Options but get message "No configuration is made, the database will not be updated. Click on OK button to return back to the wizard."
Is there a need to reinstall just the DBCONSOLE? If so, how do I do it?