Solved

Error code 2 starting OracleDbConsole service

Posted on 2014-09-02
4
6,444 Views
Last Modified: 2014-09-06
I have oracle 11g running on windows server 2008, I am able to connect to the db with SQL Developer and from the command prompt sqlplus. All the other services are running except for OracleDbConsoleorcl. I have tried to start the service from both from the command line and from the manage computer guy. Below is the error I get. I have also tried changing who starts the service from system to administrator but that did not work.


Windows could not start OracleDbConsoleorcl on
Local Computer. If this is a non-Microsoft service,
contact the service vendor, and refer the service
specific error code 2

I have tried editing the hosts file and adding the FQDN and the ip address as well as the localhost and loop back ip address. I have also tried copying the folders in the following two directories.

OC4J_DBConsole_localhost_orcl
OC4J_DBConsole_HOSTNAME_orcl

We are an educational institution and the administration cannot or will not pay for oracle support, so I am paying for this out of my pocket. The professor that took care of oracle before me retired and I missed a staff meeting where I was elected to maintain the server. We have several adjuncts that use it through out the semester. It was running and configured correctly in May but we have had several power outages during the summer. Any help will be greatly appreciated. I can send log files tomorrow during the day.
0
Comment
Question by:Charles Gabor
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40300063
There are versions of Oracle that are free:  Oracle Express Edition as long as you can meet the system and size requirements.

Also, Oracle is very good about working with Educational institutions.  I would reach out to them about your situation and they might work with you to put some $$$ back in your pocket!

That said, this seems to be due to a network change on the system.

Do you need dbConsole?  I rarely ever use it but I'm an old command line guy.

The following thread seems to talk about how to work with the network change on the server:
https://community.oracle.com/thread/311223?tstart=0
0
 

Author Comment

by:Charles Gabor
ID: 40300989
We are using Oracle 11g free from Oracle, I will try to see if I can get some technical support at a discount rate that the administration will pay for. In the mean time I have attached the emoms.log file. It looks like it might be a password expire problem. I am very new to dbs so I need the console. I can connect using sqlplus but really do not know the commands very well. For me taking care of the db is a collateral job not one I am getting paid for. I tried all the methods in the article you referenced nothing worked.

I guess my question is how do I change a password in sqlplus and what account am I changing the password for?
emoms.log
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40301030
Connect through sqlplus and issue:
select username, account_status, expiry_date from dba_users;

Going from memory I believe you are looking at the SYSMAN user.

If SYSMAN has Expired, you should probably change the profile to not have service accounts automatically expire.  The online docs talk about user profiles and how to set them up.


You can change the sysman password but it looks like it is a pain to do because OEM stores it inside the config files.

Unless you have a lot of historical data in the repository that you need to reference, I would probably just drop and recreate dbConsole.

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

Author Closing Comment

by:Charles Gabor
ID: 40307774
This worked great, thank you very much for your help. I am slowly learning how to manage oracle but it is a painful process. Thank you again.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
selective queries 7 27
PL/SQL Display based on value 4 26
Oracle SQL - Query help 7 54
How to Gracefuly recover in Racle stored procedure 1 29
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

776 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