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.
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
Glad it helped.
Thanks for the comment.
You just saved my life man !
Thx so much
Great. Good to know. thank you for taking the time to comment.
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
Thanks , worked excellent in my lab. Step 1 fixed me up. cheers
This solved the problem but the backup jobs were lost when it was recreated.
very helpful trick, i m searching this for a long time……thx again…….
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
No. This fix is only related oracle. It is only a coincidence that the messages are similar.
is it safe to run this commands in the production server
>emca -deconfig dbcontrol db
>emca -config dbcontrol db
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.
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.
Excelente post.
Saludos
Thanks, this really save days.