{"id":130,"date":"2010-02-23T16:46:02","date_gmt":"2010-02-23T20:46:02","guid":{"rendered":"http:\/\/dbtricks.com\/?p=130"},"modified":"2010-02-23T16:48:25","modified_gmt":"2010-02-23T20:48:25","slug":"a-service-specific-error-occurred-2-when-trying-to-start-dbconsole","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=130","title":{"rendered":"“A service specific error occurred: 2” when trying to start dbconsole"},"content":{"rendered":"

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..).\u00a0 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.
\n
\nusually, to solve you should restart the dbconsole by opening the command prompt and typing emctl stop dbconsole<\/strong>. However, you may find that the service is no longer running. Trying to start the dbconsole by typing emctl start dbconsole<\/strong> in the command prompt will result in the following message:
\n
\nThe OracleDBConsole[ServiceName] service could not be started.<\/strong><\/p>\n

A service specific error occurred: 2.<\/strong><\/p>\n

More help is available by typing NET HELPMSG 3547.<\/strong><\/p>\n

as expected, typing NET HELPMSG will not provide usefull information.
\n
\nTo solve this:<\/p>\n

1) Delete and recreate the Enterprise Manager agent.<\/p>\n

In the command prompt type> emca -deconfig dbcontrol db<\/strong><\/p>\n

even if this fails, type> emca -config dbcontrol db<\/strong><\/p>\n

You will be asked to provide the database SID, the listener port, password for SYS, DBSNMP and SYSMAN accounts, and some optional settings.<\/p>\n

This process will run for several minutes.<\/p>\n

2) <\/strong>restart the dbconsole <\/strong><\/p>\n

> emctl stop dbconsole<\/strong><\/p>\n

> emctl start dbconsole<\/strong><\/p>\n

\nThis should solve the issue, however, if you are still unable to log in or you get the following error:<\/p>\n

ORA-28001: the password has expired (DBD ERROR: OCISessionBegin), make sure that the SYSMAN account is unlocked<\/strong><\/p>\n

SQL> conn \/ as sysdba
\nConnected.
\nSQL> alter user sysman identified by [new password]<\/strong>
\n2\u00a0 \/<\/p>\n

User altered.
\nSQL> alter user sysman account unlock;<\/strong><\/p>\n

User altered.
\nSQL> exit<\/p>\n

> emctl stop dbconsole<\/strong><\/p>\n

> emctl start dbconsole<\/strong>
\n<\/p>\n

if you still have problems logging in to database control, refer to the following post<\/p>\n

What to do when Enterprise Manager is not able to connect to the database instance.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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..).\u00a0 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[107,18],"class_list":["post-130","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-oracle-enterprise-manager"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=130"}],"version-history":[{"count":4,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":134,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/130\/revisions\/134"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}