1 2 3 Previous Next 40 Replies Latest reply: May 10, 2012 9:02 AM by karthiksingh_india RSS

    Oracle EM does not loading properly and cant create repository again help

    karthiksingh_india
      Dear Legends,

      Please help me to solve my OEM has showing that INSTANCE is down and LISTENER STATUS is unavailable.. Help me what to do?
      If I press on startup it takes long time to respond...

      OS : WIN XP

      BANNER
      ----------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
      PL/SQL Release 11.1.0.7.0 - Production
      CORE 11.1.0.7.0 Production
      TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
      NLSRTL Version 11.1.0.7.0 - Production

      My sqlplus is working fine...

      Thanks in advance..
      Karthik.
        • 1. Re: Oracle EM does not loading properly shows DATABASE Instance down
          Fran
          hi,

          could you post the result of "lsnrctl status"? are you sure the database is running?
          • 2. Re: Oracle EM does not loading properly shows DATABASE Instance down
            713555
            lot of info missing here.

            where in OEM is it saying the instance is down?
            how did you login to OEM?
            what do the latest OEM logs say in $ORACLE_HOME/sysman/logs
            what is the status of OEM with emctl?
            did you try to bounce OEM with emctl?
            • 3. Re: Oracle EM does not loading properly shows DATABASE Instance down
              Aman....
              Some times, it takes a while before EM starts showing the database status correctly. Try restarting the EM service using emctl stop/start dbconsole command, wait for some time and then recheck.

              Aman....
              • 4. Re: Oracle EM does not loading properly shows DATABASE Instance down
                karthiksingh_india
                Hi,

                C:\Documents and Settings\SKS>lsnrctl status

                LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 03-MAY-2012 18:20:25

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

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=computer)(PORT=1521)))
                STATUS of the LISTENER
                ------------------------
                Alias LISTENER
                Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
                Start Date 03-MAY-2012 10:08:05
                Uptime 0 days 8 hr. 12 min. 20 sec
                Trace Level off
                Security ON: Local OS Authentication
                SNMP OFF
                Listener Parameter File C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
                Listener Log File c:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
                Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=computer)(PORT=1521)))
                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                Services Summary...
                Service "vess" has 1 instance(s).
                Instance "vess", status READY, has 1 handler(s) for this service...
                Service "vessXDB" has 1 instance(s).
                Instance "vess", status READY, has 1 handler(s) for this service...
                Service "vess_XPT" has 1 instance(s).
                Instance "vess", status READY, has 1 handler(s) for this service...
                The command completed successfully
                • 5. Re: Oracle EM does not loading properly shows DATABASE Instance down
                  Fran
                  if the instance is running and listener is up, check now if OEM is showing the correct information. If not try to restart OEM and tell us if it is ok now.
                  • 6. Re: Oracle EM does not loading properly shows DATABASE Instance down
                    karthiksingh_india
                    Hi,

                    I
                    database instance displays the image as down with red colour arrow..

                    login through start->Programs-> Oracle - OraDb11g_home1 -> Database control - vess (http://computer:1158/em)

                    _ Latest log in ORACLE_HOME-> .. .. -> sysman-> log says_
                    Mar 15, 2012 11:23:15 AM oracle.sysman.emdrep.util.TransxWrapper perform
                    INFO: TransX Loading:C:\app\SKS\product\11.1.0\db_1\sysman\admin\emdrep\rsc\pp\paf\main.dlf
                    Mar 15, 2012 11:23:15 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
                    INFO: Successful Execution of oracle.sysman.emdrep.util.TransxWrapper

                    C:\Documents and Settings\SKS>emctl status dbconsole
                    Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                    Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
                    https://computer:1158/em/console/aboutApplication
                    Oracle Enterprise Manager 11g is running.
                    ------------------------------------------------------------------
                    Logs are generated in directory C:\app\SKS\product\11.1.0\db_1/computer_VESS/sysman/log -----> here i dont know which files to be noted for status..

                    but in db_1/computer_VESS/sysman/log --> emctl.text file says
                    1116 :: Thu May 3 18:35:09 2012::AgentStatus.pm:Processing status agent
                    1116 :: Thu May 3 18:35:10 2012::AgentStatus.pm:emdctl status returned 3

                    and I dont know bounce so i doesnt do it anything regarding bounce..

                    Thanks in advance for all Please help me
                    Karthik..
                    • 7. Re: Oracle EM does not loading properly shows DATABASE Instance down
                      karthiksingh_india
                      Hi AMAN,

                      I have stopped and started the emctl as you said it takes a while to stop and start and again i logged in but the same status shown that INSTANCE down and says EM is not able to connect to the database instance.

                      Please help

                      Karthik..
                      • 8. Re: Oracle EM does not loading properly shows DATABASE Instance down
                        Aman....
                        Its Windows right so how about restarting the EM service from Window's services panel?

                        Aman....
                        • 9. Re: Oracle EM does not loading properly shows DATABASE Instance down
                          Fran
                          "emdctl status agent returned 3" means "Management Agent is up and running. No action required from you."

                          To see the log you must go to C:\app\SKS\product\11.1.0\db_1/computer_VESS/sysman/log and look for emctl.log by default. But its looks like it is fine in emctl.txt.

                          Could you provide us the result of "select open_mode from v$database" and "select status from v$instance"?
                          • 10. Re: Oracle EM does not loading properly shows DATABASE Instance down
                            713555
                            in the sysman/logs folder post the last 30-40 lines from

                            emoms.log and emctl.log
                            • 11. Re: Oracle EM does not loading properly shows DATABASE Instance down
                              karthiksingh_india
                              Hi Fran,


                              SQL> select * from v$instance;

                              INSTANCE_NUMBER INSTANCE_NAME
                              --------------- ----------------
                              HOST_NAME
                              ----------------------------------------------------------------
                              VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
                              ----------------- --------- ------------ --- ---------- ------- ---------------
                              LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
                              ---------- --- ----------------- ------------------ --------- ---
                              1 vess
                              COMPUTER
                              11.1.0.7.0 03-MAY-12 OPEN NO 1 STOPPED
                              ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO


                              SQL> select status from v$instance;

                              STATUS
                              ------------
                              OPEN
                              • 12. Re: Oracle EM does not loading properly shows DATABASE Instance down
                                Fran
                                like you are in windows, could you restart services?

                                Start > Settings > Control Panel > Services > Oracle... (OracleDBConsole, OracleService and Oracle Listener)
                                • 13. Re: Oracle EM does not loading properly shows DATABASE Instance down
                                  karthiksingh_india
                                  Aman,

                                  you are saying about the service in control panel? I have tried stopping it and starting it but it takes a long time and says an error it doesnot respond in timely manner..

                                  but the service being started or restarted which shows the status as "starting" but after sometimes it shows starting only

                                  but in cmd prompt status

                                  C:\Documents and Settings\SKS>emctl stop dbconsole
                                  Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                                  Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
                                  https://computer:1158/em/console/aboutApplication
                                  The requested pause or stop is not valid for this service.

                                  More help is available by typing NET HELPMSG 2191.


                                  C:\Documents and Settings\SKS>emctl status dbconsole
                                  Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                                  Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
                                  https://computer:1158/em/console/aboutApplication
                                  Oracle Enterprise Manager 11g is not running.
                                  ------------------------------------------------------------------
                                  Logs are generated in directory C:\app\SKS\product\11.1.0\db_1/computer_VESS/sysman/log

                                  C:\Documents and Settings\SKS>emctl start dbconsole
                                  Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                                  Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
                                  https://computer:1158/em/console/aboutApplication
                                  - An instance of Oracle Enterprise Manager 11g Database Control is already running.

                                  Karthik..
                                  • 14. Re: Oracle EM does not loading properly shows DATABASE Instance down
                                    Fran
                                    the new information change my opinion about your problem. You need to recreate the repository:

                                    1)emca -deconfig dbcontrol db -repos drop

                                    2) DROP USER sysman CASCADE;
                                    DROP PUBLIC SYNONYM setemviewusercontext;
                                    DROP ROLE mgmt_user;
                                    DROP PUBLIC SYNONYM mgmt_target_blackouts;
                                    DROP USER mgmt_view;

                                    3)emca -config dbcontrol db -repos create
                                    1 2 3 Previous Next