Solved

oracle enterprise manager is not working

Posted on 2012-03-31
15
1,152 Views
Last Modified: 2012-05-03
oracle enterprise manager is not working and when i execute the

emctl start dbconsole i got the below error, please note that am using oracle database 10.2.0.4    64 Bit and windows server 2008 64 bit

C:\Users\AdminDB>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
https://TNXOMSDBTST:1185/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleWF
BCDBTS3 service is starting.....................................................
................................................................................
......................................................................
The OracleDBConsoleWFBCDBTS3 service could not be started.

A service specific error occurred: 1.

More help is available by typing NET HELPMSG 3547.
0
Comment
Question by:deniro1974
  • 7
  • 4
  • 2
  • +1
15 Comments
 
LVL 12

Assisted Solution

by:praveencpk
praveencpk earned 167 total points
ID: 37792863
The Enterprise Database Control 10.2.0.4 or 10.2.0.5 requires the patch from 31 Dec 2010 onward, If you have an oracle support account check this doc for more info MOS Doc 1217493.1

Also sometime there will be port problem check the below doc for more info.

http://docs.oracle.com/cd/B15874_03/install.1012/install/ts.htm
0
 

Author Comment

by:deniro1974
ID: 37794704
it was working before on the same server , but i had an issue so i needed to delete the old database and create new database and now the EM is not working
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 167 total points
ID: 37795740
>>i needed to delete the old database

Did you create a dbConsole repository in the new database?

emca -repos create
emca -config dbcontrol db
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Assisted Solution

by:Faher
Faher earned 166 total points
ID: 37800398
First check is dbcontrol is installed or not by calculating sysman user schemsa objects
select count(*) from dba_objects where owner='SYSMAN';
object must be more that 1500.

If objects are exists but dbcontorl is still not running then recreate dbcontrol

emca --deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
0
 

Author Comment

by:deniro1974
ID: 37822909
dear Faher,

i tried
emca --deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

still the services not work please advise.

best regards
0
 
LVL 1

Expert Comment

by:Faher
ID: 37823022
Did drop command ran succssefully ? can you please tell me sysman has how many objects

select count(*) from dba_objects where owner='SYSMAN';
0
 

Author Comment

by:deniro1974
ID: 37827084
yes at that time it was dropped successfully and the count was 0
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37828269
To recap:  You have recreated the repository in the new database and it didn't show any errors when creating it.

You have recreated it and still cannot start it?

If so: drop and recreate it one more time.  This time after you create it, attach the log generated to this quesiton.
0
 

Author Comment

by:deniro1974
ID: 37831173
dear slightwv

please find the attached logs from the emca for drop , creating and the activities log

Best regards
emca-2012-04-09-10-55-18-AM.log
emca-repos-create-2012-04-09-10-.log
emca-repos-drop-2012-04-09-10-51.log
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 37831834
In the log file at the end of the file it states that error starting database control.

you need to apply the interim patch it i think, please see the below docs

https://blogs.oracle.com/db/entry/enterprise_manager_database_control_configuration_-_recovering_from_errors_due_to_ca_expiry_on_oracl

http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle_Enterprise_Manager/OEM_22.shtml

Also if you have a Oracle support check this notes

Note: 1222603.1 Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on Oracle Database 10.2.0.4 or 10.2.0.5

Note: 1217493.1 ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37832318
I've also seen referneces to the not mentioned above.  Try the patch.

While we wait for feedback on the patch:  Is the log you posted the same as: D:\ORA_HOME\cfgtoollogs\emca\WFBCDBTS3\emca_2012-04-09_10-55-18-AM.log

If not, can you post that log as well?
0
 

Author Comment

by:deniro1974
ID: 37836146
yes its the same
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37837351
>>yes its the same

Thanks for the feedback.  Guess you are left with the patch.
0
 

Accepted Solution

by:
deniro1974 earned 0 total points
ID: 37907225
thanks for all you, but nothing worked with me the only solution was is delete this database and create new one after getting backup and everything sure this solution will not be good to use on production environment but thanks god its only a test environment.

Best regards
0
 

Author Closing Comment

by:deniro1974
ID: 37923312
this is the only thing worked with me
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
case statement in where clause 5 48
Oracle and DateTime math 6 37
Bash Script to Analyze Oracle Schemas 11 104
Oracle SQL Select unique values from two columns 4 53
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question