{"id":7012,"date":"2015-03-19T15:46:16","date_gmt":"2015-03-19T15:46:16","guid":{"rendered":"https:\/\/pitss.org\/us\/?p=7012"},"modified":"2018-05-23T19:14:25","modified_gmt":"2018-05-23T23:14:25","slug":"unable-to-start-oracle-enterprise-manager-11g-database-control-due-to-time-zone-change","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2015\/03\/19\/unable-to-start-oracle-enterprise-manager-11g-database-control-due-to-time-zone-change\/","title":{"rendered":"Unable to Start Oracle Enterprise Manager 11g Database Control Due to Time Zone Change"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;3.0.51&#8243; custom_padding=&#8221;0px||50px|&#8221;][et_pb_row custom_padding=&#8221;0px|||&#8221; admin_label=&#8221;Row&#8221; _builder_version=&#8221;3.0.51&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.106&#8243; custom_margin=&#8221;||30px|&#8221;]<\/p>\n<p>There is a known issue where the DB Admin Console is unable to start (either with the Windows Service in Windows or with emctl start dbconsole in other OS platforms) due to the following error:<\/p>\n<p>\u201cStarting Oracle Enterprise Manager 11g Database Control \u2026The OracleDBConsole&lt;SID&gt; service is starting\u2026\u2026\u2026.. The OracleDBConsole&lt;SID&gt; service could not be started.<\/p>\n<p>\u201cA service specific error occurred: 2.<\/p>\n<p>\u201cMore help is available by typing NET HELPMSG 3547.\u201d<\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#e2e2e2&#8243; divider_position=&#8221;center&#8221; disabled_on=&#8221;on|on|off&#8221; admin_label=&#8221;Divider&#8221; _builder_version=&#8221;3.2&#8243; custom_css_main_element=&#8221;margin-bottom:30px !important;&#8221;][\/et_pb_divider][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.51&#8243; custom_margin=&#8221;||30px|&#8221;]<\/p>\n<h3><strong>What you&#8217;ll learn in this article:<\/strong><\/h3>\n<p><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong>\u00a0Where to find these errors<br \/> <strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0<\/span><span style=\"font-size: 16px;\">Why these errors are appearing<br \/> <\/span><strong style=\"font-size: 16px; padding-right: 5px; background-color: #ffffff; color: #abd25e;\">\u2713<\/strong><span style=\"font-size: 16px; background-color: #ffffff;\">\u00a0<\/span><span style=\"font-size: 16px;\">Step-by-step tutorial to solve these errors in Windows and Unix<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8221;40px|40px|30px|40px&#8221; background_position_1=&#8221;top_left&#8221; background_repeat_1=&#8221;no-repeat&#8221; admin_label=&#8221;Row&#8221; _builder_version=&#8221;3.0.51&#8243; background_color=&#8221;#006bb3&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.0.47&#8243; parallax=&#8221;off&#8221; parallax_method=&#8221;on&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;no-repeat&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;3.0.106&#8243; background_color=&#8221;#006bb3&#8243; background_layout=&#8221;dark&#8221;]<\/p>\n<h2 style=\"font-size: 30px! important;\"><strong>Fill out the form below to access this blog post.<\/strong><\/h2>\n<p>[\/et_pb_text][et_pb_code admin_label=&#8221;Code&#8221; module_class=&#8221;white-text&#8221; _builder_version=&#8221;3.3.1&#8243;][ninja_form id=47][\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is a known issue where the DB Admin Console is unable to start (either with the Windows Service in Windows or with emctl start dbconsole in other OS platforms) due to the following error: \u201cStarting Oracle Enterprise Manager 11g Database Control \u2026The OracleDBConsole&lt;SID&gt; service is starting\u2026\u2026\u2026.. The OracleDBConsole&lt;SID&gt; service could not be started. \u201cA [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"There is a known issue where the DB Admin Console is unable to start (either with the Windows Service in Windows or with emctl start dbconsole in other OS platforms) due to the following error:\r\n\r\n\u201cStarting Oracle Enterprise Manager 11g Database Control \u2026The OracleDBConsole&lt;SID&gt; service is starting\u2026\u2026\u2026.. The OracleDBConsole&lt;SID&gt; service could not be started.\r\n\r\n\u201cA service specific error occurred: 2.\r\n\r\n\u201cMore help is available by typing NET HELPMSG 3547.\u201d\r\n\r\nThe first place to look for the errors above is the folder with the database log files located in %DB_ORACLE_HOME%\\&lt;Hostname&gt;_&lt;db_unique_name&gt;\\sysman\\log ($DB_ORACLE_HOME\/&lt;Hostname&gt;_&lt;db_unique_name&gt;\/sysman\/log in Unix). One log file to check is emdctl.trc. Check for errors such as: \u201cERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-###,and testTZoffset for &lt;Time_Zone&gt;:-### do not match\u201d\r\n\r\n<a class=\"thickbox\" href=\"https:\/\/pitss.org\/files\/2015\/03\/image2.png\"><img style=\"padding-left: 0px;padding-right: 0px;padding-top: 0px;border: 0px\" title=\"image\" src=\"https:\/\/pitss.org\/files\/2015\/03\/image_thumb2.png\" alt=\"image\" width=\"801\" height=\"34\" border=\"0\" \/><\/a>\r\n\r\nIf this error is present, the time zone currently set for your Oracle Database does not match the time zone of the database server hosting the database. To solve the problem, you will need to reset the time zone for your database to match what is set in the OS:\r\n\r\n<strong>Windows:<\/strong>\r\n\r\n1. Open up Command Prompt as an administrator\r\n\r\n2. Set the following environment variables*:\r\n<blockquote>set ORACLE_HOME=C:\\app\\%USERNAME%\\product\\11.2.0\\dbhome_1\r\n\r\nset PATH=%ORACLE_HOME%\\BIN;%PATH%\r\n\r\nset ORACLE_SID=&lt;SID&gt;<\/blockquote>\r\n3. Run the following command to reset the time zone: emctl resetTZ dbconsole\r\n\r\n4. After successful completion of step 3, please start the DB console.\r\n\r\n<strong>Unix:<\/strong>\r\n\r\n1. Open up an SSH terminal session\r\n\r\n2. Set the following environment variables*:\r\n<blockquote>export ORACLE_HOME=\/oracle\/app\/$USER\/product\/11.2.0\/dbhome_1\r\n\r\nexport PATH=$ORACLE_HOME\/bin:$PATH\r\n\r\nexport ORACLE_SID=&lt;SID&gt;<\/blockquote>\r\n3. Run the following command to reset the time zone: emctl resetTZ dbconsole\r\n\r\n4. After successful completion of step 3, please start the DB console.\r\n\r\n*=Your DB Oracle Home may differ than the example provided.\r\n\r\nAfter running the steps above, you should be able to successfully start up the DB console for Oracle Enterprise Manager 11g Database Control.","_et_gb_content_width":"","footnotes":""},"categories":[95,14],"tags":[11,16,25,12,27],"class_list":["post-7012","post","type-post","status-publish","format-standard","hentry","category-database","category-resolve-issues","tag-11g","tag-11gr2","tag-customer-support-request","tag-error","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=7012"}],"version-history":[{"count":8,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7012\/revisions"}],"predecessor-version":[{"id":11426,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/7012\/revisions\/11426"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=7012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=7012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=7012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}