“A service specific error occurred: 2” when trying to start dbconsole

When logging in to database control after some time you may get a message that some accounts’ passwords need to be changed (sysman, system etc..).  A page will be displayed allowing you to change those password but if something (like timeout) happens during the page processing you will not be able to log in again to the database control and change the passwords.

usually, to solve you should restart the dbconsole by opening the command prompt and typing emctl stop dbconsole. However, you may find that the service is no longer running. Trying to start the dbconsole by typing emctl start dbconsole in the command prompt will result in the following message:

The OracleDBConsole[ServiceName] service could not be started.

A service specific error occurred: 2.

More help is available by typing NET HELPMSG 3547.

as expected, typing NET HELPMSG will not provide usefull information.

To solve this:

1) Delete and recreate the Enterprise Manager agent.

In the command prompt type> emca -deconfig dbcontrol db

even if this fails, type> emca -config dbcontrol db

You will be asked to provide the database SID, the listener port, password for SYS, DBSNMP and SYSMAN accounts, and some optional settings.

This process will run for several minutes.

2) restart the dbconsole

> emctl stop dbconsole

> emctl start dbconsole

This should solve the issue, however, if you are still unable to log in or you get the following error:

ORA-28001: the password has expired (DBD ERROR: OCISessionBegin), make sure that the SYSMAN account is unlocked

SQL> conn / as sysdba
Connected.
SQL> alter user sysman identified by [new password]
2  /

User altered.
SQL> alter user sysman account unlock;

User altered.
SQL> exit

> emctl stop dbconsole

> emctl start dbconsole

if you still have problems logging in to database control, refer to the following post

What to do when Enterprise Manager is not able to connect to the database instance.

Share on RedditEmail this to someoneShare on Google+Share on LinkedInShare on FacebookDigg thisTweet about this on Twitter

15 thoughts on ““A service specific error occurred: 2” when trying to start dbconsole

  1. Olivier BOCQUI

    Thank’s a lot for this explanations : it helped a lot !
    I followed the commands and steps you indicate, and now my problems are solved, and Database Control works well.

    I really appreciate ( sorry for my poor English )

    Olivier BOCQUI – Montmorency – France

  2. Todor

    Thanks for the great post!
    However in my case this did not solve the whole issue. I had to to the following actions:

    >emctl stop dbconsole
    >emca -repos drop
    >emca -deconfig dbcontrol db
    >emca -repos create
    >emca -config dbcontrol db
    >emctl stop dbconsole
    >emctl start dbconsole

    Regards,
    Todor

  3. Andy

    My search in Windows 7 stopped working. I am not a programmer or engineer. Found solution to repair the registry on Web. The next to last step is to run “net start wsearch” from cmd. get error msg “A service specific error occurred: 2147750271. More help is available by typing NET HELPMSG 3547.” That does not help. Will your fix work? How do I find database SID, the listener port, password for SYS, DBSNMP and SYSMAN accounts?
    Thanks in advance

  4. damian

    is it safe to run this commands in the production server
    >emca -deconfig dbcontrol db
    >emca -config dbcontrol db

  5. Asaf Tal Post author

    This should have effect on your console so if you have a client you can log in with it should not be a problem. Nonetheless, I would suggest testing everything you do on your production server in your
    test environment.

  6. damian

    we don’t have a test environment and that’s the reason i asked this. I hope there will not be any issues with the live Databases by doing this.

Leave a Reply

Your email address will not be published. Required fields are marked *