tag:blogger.com,1999:blog-319861215751504095.post4132627899736377606..comments2023-06-29T09:30:14.465-04:00Comments on Not just a DBA !!!: "EM daemon is not running" dbconsole statusUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-319861215751504095.post-42243802519470549552014-04-30T11:59:25.333-04:002014-04-30T11:59:25.333-04:00Thank you so much bro.... may ALLAH give HIS grace...Thank you so much bro.... may ALLAH give HIS grace so that u can achieve the ended limits of whatever u want, and will b able to give us solutions of related problems.... Thanks again....<br />Tauseef Ahmed g tusi great o..... :) Anonymoushttps://www.blogger.com/profile/10922390522406859206noreply@blogger.comtag:blogger.com,1999:blog-319861215751504095.post-50869371633234550612013-07-18T16:12:58.046-04:002013-07-18T16:12:58.046-04:00Thank you Thank you Thank you Thank you Thank you ...Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you !!!<br />This ended my long search for a solution to this problem........<br /><br />Really, thanks mate. You're a lifesaver :-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-319861215751504095.post-90116081850930225532013-05-21T10:40:34.031-04:002013-05-21T10:40:34.031-04:00Thanks Tauseef Ahmed bhai.Thanks Tauseef Ahmed bhai.obaidulhttps://www.blogger.com/profile/02363505985814098514noreply@blogger.comtag:blogger.com,1999:blog-319861215751504095.post-31611667513229036012013-04-24T17:33:09.981-04:002013-04-24T17:33:09.981-04:00Re: Install Oracle 11gR2 Error?
Posted: Apr 24, 20...Re: Install Oracle 11gR2 Error?<br />Posted: Apr 24, 2013 2:20 PM in response to: Junaid in response to: Junaid<br />em_daemon_is_not_running , agent_is_not_running , em_internal_error , error_database_control , time_zone_problem [Edit]<br /> <br />Click to edit this message... Edit Click to report abuse... Click to reply to this thread Reply<br />AOA/Hello,<br /><br />Dear All,<br /><br />First of all thanks to all of those people who posted solutions in different forums on this issue as this helped me to solve this problem. One more thing, always read documentation and always check log files for error reports as Oracle is not too much interactive.<br /><br />The Problem " Error Starting Database Control Please execute the following command(s) " faced at the end of installation of Oracle 10g / 11g is caused due to Time Zone Values in different files, tables and services of Oracle. Interestingly, these values do not change automatically with the change in OS time zone and you have to do it manually.<br /><br />You also have to set some environment variables manually like ORACLE_UNQNAME, ORACLE_SID, ORACLE_HOSTNAME etc.<br /><br />You also have to set machine name and IP in the hosts file if required so that EM finds the localhost.<br /><br />127.0.0.1 localhost<br />127.0.0.1 computer name / hostname<br /><br />PRAISE ORACLE FOR THIS<br /><br />Following is the Solution which worked well for me.<br /><br />Step 1: Go to dbhome > hostname_SID > Sysman > Config > open emd.properties in notepad and set the value agentTZRegion=+05:00 to the value of your timezone and click save. You can also do it using export and time zone reset commands.<br /><br />Step 2: ALTER DATABASE SET TIME_ZONE='+05:00'; according to your time zone. You can check DB TIME Zone using " select dbtimezone from dual ; ".<br /><br />Step 3: In step 2 if you get the error "ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH<br />LOCAL TIME ZONE columns" then please FOLLOW following steps<br /><br />SQL> select count (*) from dba_tab_columns<br />2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ;<br /><br />COUNT(*)<br />1<br /><br />In this case there is only one table. The owner and name can be determined by:<br /><br />SQL> select owner, table_name from dba_tab_columns<br />2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE';<br /><br />OWNER TABLE_NAME<br />------------------------------<br />OE ORDERS<br /><br />SQL> desc oe.orders ;<br />Name Null? Type<br />-------- ORDER_ID NOT NULL NUMBER(12)<br />ORDER_DATE NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE<br />ORDER_MODE VARCHAR2(8)<br />CUSTOMER_ID NOT NULL NUMBER(6)<br />ORDER_STATUS NUMBER(2)<br />ORDER_TOTAL NUMBER(8,2)<br />SALES_REP_ID NUMBER(6)<br />PROMOTION_ID NUMBER(6)<br /><br />This oe.orders is just a table in the example schema of OE so this colums can be dropped. So please dont install sample schemas if you dont need them.<br /><br />SQL> alter table OE.ORDERS drop column ORDER_DATE ;<br /><br />Table altered.<br /><br />Now the Time Zone can be altered using above command.<br /><br />Step 4: Also check the value of " SELECT SESSIONTIMEZONE FROM DUAL; " and if the value differs from os time zone, db time zone , emd.properties / agent time zone then also set it according to your timezone but I believe it always gives the OS time zone.<br /><br />Step 5: Stop and Restart all Services and check that Oracle DBConsole service is running or not and if not running then start from command prompt " emctl start dbconsole" .<br /><br />NOW THE ENTERPRISE MANAGER WILL WORK WELL BY THE GRACE OF ALMIGHTY ALLAH.<br /><br />Regards,<br /><br />Tauseef Ahmed<br />IT Specialist, TDCP<br /><br />Edited by: 1002308 on Apr 24, 2013 2:22 PMTauseef Ahmedhttp://www.tdcp.gop.pknoreply@blogger.comtag:blogger.com,1999:blog-319861215751504095.post-2796617498456826752012-09-10T13:23:46.100-04:002012-09-10T13:23:46.100-04:00Thank you Janet. Glad that the post helped you.Thank you Janet. Glad that the post helped you.VPhttps://www.blogger.com/profile/01892768066696061161noreply@blogger.comtag:blogger.com,1999:blog-319861215751504095.post-82072189217713539052012-09-07T20:18:37.175-04:002012-09-07T20:18:37.175-04:00Thank you for your website. I've been struggli...Thank you for your website. I've been struggling with this problem for over a month, including opening an SR with Oracle. Oracle never brought up this bug. You are doing a great service to the Oracle DBA community.<br /><br />JanetAnonymousnoreply@blogger.com