7 Replies Latest reply: Jun 23, 2010 2:50 AM by 780090 RSS

    Starting OEM is failed

    780090
      I'm newbie but i've read lost of documents about oracle and it's errors and i couldnt find anything.

      Guest OS : CentOS 5.5, 2.6.18-194.3.1.el5 @ Virtualbox
      Host OS: Archlinux
      Oracle 11gR1

      When i was installing Oracle the only error that i had got "Error securing Database Control, Database Control has been brought up in non-secure mode." and gave me a to do list to secure Database Control.

      On early everything seemed ok.

      *$emctl start dbconsole*
      Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
      Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
      http://oracle.mathman.local:1158/em/console/aboutApplication
      Starting Oracle Enterprise Manager 11g Database Control .... started.

      *$emctl status dbconsole*
      Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
      Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
      http://oracle.mathman.local:1158/em/console/aboutApplication
      EM Daemon is not running.
      ------------------------------------------------------------------
      Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/oracle.mathman.local_orcl/sysman/log

      emctl status agent
      Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
      Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
      ---------------------------------------------------------------
      ERROR: lfimkpth failed
      ERROR: nmeudir_setup_dir failed

      When i log into http://localhost:1158/em/ i see error like that
      Status: Status Pending
      Status Pending Since: Unavailable

      I'd tried to reconfigure OEM but i didnt work.
      emca -config dbcontrol db -repos recreate

      Is there anything else that i can do to overcome this problem?
        • 1. Re: Starting OEM is failed
          780090
          I've got error like that
               Number of Active Agents exceeded the critical threshold (1). Current value: 0
          so do i need to install Linux_Grid_Control_agent on my system?
          • 2. Re: Starting OEM is failed
            mdtaylor
            Do a relink all as the oracle owner to see if your executables all relink properly. Also consider using the bridged networking mode in Virtualbox to provide a real IP address to the guest rather than a NAT'd 10.2.0.2 address. Specify that real IP address in /etc/hosts in the guest, and comment out any IPv6 entries.
            • 3. Re: Starting OEM is failed
              780090
              Yes i did relink all and relink oracle in bin directory but not help me.

              I'm not familiar to oracle but i've been using linux-like OS for years and installing a program shouldnt be hard as oracle. I made two time fresh install step by step what i read from documents.

              Guest OS is using only IPv4 and real IP on bridge mode.

              again same error. is it possible the problem related with CentOS 5.5?

              SQL> startup
              ORACLE instance started.

              Total System Global Area 422670336 bytes
              Fixed Size 1300352 bytes
              Variable Size 306186368 bytes
              Database Buffers 109051904 bytes
              Redo Buffers 6131712 bytes
              Database mounted.


              Database opened.
              SQL> exit
              ---------------------------------------
              [oracle@oracle ~]$ lsnrctl start

              LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 19-JUN-2010 22:46:30

              Copyright (c) 1991, 2007, Oracle. All rights reserved.

              Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

              TNSLSNR for Linux: Version 11.1.0.6.0 - Production
              System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
              Log messages written to /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.mathman.local)(PORT=1521)))

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
              Start Date 19-JUN-2010 22:46:32
              Uptime 0 days 0 hr. 0 min. 0 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
              Listener Log File /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.mathman.local)(PORT=1521)))
              Services Summary...
              Service "orcl" has 1 instance(s).
              Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
              The command completed successfully
              [oracle@oracle ~]$
              ------------------------------------------------------------------
              [oracle@oracle ~]$ emctl start dbconsole
              Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
              Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
              http://oracle.mathman.local:1158/em/console/aboutApplication
              Starting Oracle Enterprise Manager 11g Database Control .... started.
              ------------------------------------------------------------------
              Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/oracle.mathman.local_orcl/sysman/log
              [oracle@oracle ~]$ emctl status dbconsole
              Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
              Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
              http://oracle.mathman.local:1158/em/console/aboutApplication
              EM Daemon is not running.
              ------------------------------------------------------------------
              Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/oracle.mathman.local_orcl/sysman/log
              [oracle@oracle ~]$

              Edited by: user13224494 on Jun 19, 2010 1:00 PM
              • 4. Re: Starting OEM is failed
                EricvdS
                Could be a TimeZone problem; Take a look at No agent with "emctl status agent" Check the mentioned trace file for timezone issue.

                Eric
                • 5. Re: Starting OEM is failed
                  780090
                  @EricvdS

                  Maybe you are right ..

                  $ tail -f emdb.nohup

                  ----- Mon Jun 21 20:46:46 2010::omsRecvDir is set? = 1 -----
                  ----- Mon Jun 21 20:46:46 2010::Console Launched with PID 3280 at time Mon Jun 21 20:46:46 2010 -----
                  ----- Mon Jun 21 20:46:47 2010::ERROR: lfimkpth failed
                  -----
                  ----- Mon Jun 21 20:46:47 2010::ERROR: nmeudir_setup_dir failed -----
                  ----- Mon Jun 21 20:46:49 2010::*Mismatch detected between timezone in env (Turkey) and in /u01/app/oracle/product/11.1.0/db_1/oracle.mathman.local_orcl/sysman/config/emd.properties (Turkey). Forcing value to latter*.. -----
                  ----- Mon Jun 21 20:46:51 2010::ERROR: lfimkpth failed
                  -----
                  ----- Mon Jun 21 20:46:51 2010::ERROR: nmeudir_setup_dir failed -----
                  ----- Mon Jun 21 20:46:51 2010::The agentTZRegion value in /u01/app/oracle/product/11.1.0/db_1/oracle.mathman.local_orcl/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.
                  If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>) to get the value propagated to repository -----

                  ---------------------------------------------------------------------------
                  SQL> SELECT dbtimezone FROM DUAL;
                  DBTIME
                  ------
                  +00:00
                  SQL> SELECT sessiontimezone FROM DUAL;
                  SESSIONTIMEZONE
                  ---------------------------------------------------------------------------
                  +03:00
                  SQL>

                  i think dbtimezone and sessiontimezone must be the same isnt right? My timezone Europe/Istanbul +02:00 and here is summer so daylight savings time it's +03:00. I tried to change dbtimezone by
                  ALTER DATABASE SET TIME_ZONE='Europe/Istanbul';
                  i got error "the database contains a table with a TIMESTAMP WITH LOCAL TIME ZONE column and the column contains data".
                  Maybe i need to execute as user 'sysman'

                  SQL> exec mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>)

                  but i dont know what is my agent_name? I'm just using database control, I dont have grid control. When we come to emd.properties agentTZRegion=Turkey i changed it to agentTZRegion=Turkey/Istanbul but i didnt work. I'm a little bit confused.
                  • 6. Re: Starting OEM is failed
                    EricvdS
                    Looks like at timezone issue. Though it is for OEM Grid Control 10.2 the note: Startup Agent: Agent fails to start due to TZ issues [ID 403018.1] may give you more information.
                    Or: Dbconsole fails to start - java.lang.Exception: Exception in sending Request :: null [ID 454708.1]
                    Troubleshooting Database Control Startup Issues [ID 549079.1]
                    I could not find a note about this issue specific for 11g

                    In 10g you can find the supported timezones in ORACLE_HOME/sysman/admin/supportedtzs.lst
                    I think in your case the agentTZRegion=Turkey/Istanbul should be Asia/Istanbul or Europe/Istanbul (is the same)

                    Eric
                    • 7. Re: Starting OEM is failed
                      780090
                      Thank you very much for your interest. I solved my problem.

                      The problem was a well known issue. I had a small problem during installation of Oracle. Enterprise manager configuration succeeded but give me an error about securing Database Control and it had been brought up in non-secure mode. I didnt care too much because it's just a warning not an error. I could startup database and listener so it seemed everthing ok. i thought that i just missed something small but now I found out that i had background problems during installation because of Turkish CentOS.

                      Solution is to change the language to English in CentOS and add Turkish to installation wizard as a second language during installation of Oracle. Now Database Control is in secure-mode and i can start dbconsole without error.