11 Replies Latest reply: Mar 3, 2008 5:48 AM by SunilF. RSS

    Linux: Enterprise Manager Repository database is down. Error: 12545

    554340
      Installed the 10g Grid and the emrep database on the same server. The database is up, but OEM says it is down.
        • 1. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
          mnazim-Oracle
          Whats the db vesrion ,os , can you explain your problem in details
          • 2. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
            554340
            The server is Linux Suse SLES10. The database is 10.1.0.4 Enterprise Edition.
            • 3. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
              user148120
              Click the monitoring configuration at the bottom of the page and ensure you can connect to the db with the dbsnmp credentials.
              • 5. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                SunilF.
                I am getting the same error.
                The database status is UP but
                Management Services and Repository is showing as DOWN with error message "Enterprise Manager Repository database is down. Error: 12541"

                I can connect to my Repository database from Grid control
                • 6. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                  623427
                  Check the next information

                  In the OMS MACHINE run

                  $OMS_HOME/bin/emctl status oms

                  $OMS_HOME/opmn/bin/opmnctl status -l

                  $AGENT_HOME/bin/emctl status agent

                  $AGENT_HOME/bin/emctl pingOMS

                  Provide me the output of these comands

                  The Repository Database in your Grid Control Console appear DOWN?

                  Check if the listener of the agent machine have register the SID of repository database

                  Regards
                  • 8. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                    SunilF.
                    OMS_HOME> ./emctl status oms
                    Oracle Enterprise Manager 10g Release 3 Grid Control
                    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                    Oracle Management Server is Up.


                    OMS_HOME> ./opmnctl status -l

                    Processes in Instance: EnterpriseManager0.gboramsd01.uk.com
                    -------------------------------------------------------------------------------------------+------
                    ias-component | process-type | pid | status | uid | memused | uptime | ports
                    -------------------------------------------------------------------------------------------+------
                    DSA | DSA | N/A | Down | N/A | N/A | N/A | N/A
                    HTTP_Server | HTTP_Server | 8077 | Alive | 1109917762 | 144992 | 20:28:49 | http1:7780,http2:7200,https1:4444,https2:1159,http3:4889
                    LogLoader | logloaderd | N/A | Down | N/A | N/A | N/A | N/A
                    dcm-daemon | dcm-daemon | N/A | Down | N/A | N/A | N/A | N/A
                    OC4J | home | 8078 | Alive | 1109917763 | 59420 | 20:28:53 | ajp:12501,rmi:12401,jms:12601
                    OC4J | OC4J_EM | 8079 | Alive | 1109917764 | 677092 | 20:28:53 | ajp:12502,rmi:12402,jms:12602
                    OC4J | OC4J_EMPROV | 8080 | Alive | 1109917765 | 89772 | 20:28:53 | ajp:12503,rmi:12403,jms:12603
                    WebCache | WebCache | 8089 | Alive | 1109917766 | 34352 | 20:28:53 | http:7779,invalidation:9401,statistics:9402
                    WebCache | WebCacheAdmin | 8083 | Alive | 1109917767 | 12188 | 20:28:53 | administration:9400



                    OMS_HOME> $AGENT_HOME/bin/emctl status agent
                    Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                    ---------------------------------------------------------------
                    Agent Version : 10.2.0.3.0
                    OMS Version : 10.2.0.3.0
                    Protocol Version : 10.2.0.2.0
                    Agent Home : /ora01/app/oracle/product/agent10g
                    Agent binaries : /ora01/app/oracle/product/agent10g
                    Agent Process ID : 6572
                    Parent Process ID : 6551
                    Agent URL : https://gboramsd01.uk.com:3872/emd/main/
                    Repository URL : https://gboramsd01.uk.com:1159/em/upload
                    Started at : 2008-02-25 13:25:51
                    Started by user : oramsdev
                    Last Reload : 2008-02-25 14:12:39
                    Last successful upload : 2008-02-26 09:56:14
                    Total Megabytes of XML files uploaded so far : 76.85
                    Number of XML files pending upload : 0
                    Size of XML files pending upload(MB) : 0.00
                    Available disk space on upload filesystem : 50.70%
                    Last successful heartbeat to OMS : 2008-02-26 09:56:52
                    ---------------------------------------------------------------
                    Agent is Running and Ready




                    OMS_HOME> $AGENT_HOME/bin/emctl pingOMS
                    Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                    Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                    ---------------------------------------------------------------
                    EMD pingOMS completed successfully


                    The listener is up. I can connect remotely using the tnsname via listener.

                    Also the database and listener is showing up in the Grid.
                    But "Management Services and Repository" is showing as down with error "Enterprise Manager Repository database is down. Error: 12541"
                    • 9. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                      mnazim-Oracle
                      check dbms_job get schedule or not, please check by query (select job, log_user, schema_user, what, total_time, instance from dba_jobs;)
                      If dbms job is runnung then query will retrun non zero rows and if query return the zero row then it mean dbms job is not running

                      To start the dbms job please follow the step as below

                      1 Stop the all the oms/agents

                      2 . Connect to the repository database with the SYSMAN account
                      SQL> exec emd_maintenance.submit_em_dbms_jobs;
                      SQL> commit;

                      3 start all the oms/agent
                      • 10. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                        623427
                        the true is that your management repository and oms are UP because you can access grid control console.

                        Enable the iasconsole admin by executing

                        emctl start iasconsole

                        check this command executed correct. After this issue checking the jobs that are executing

                        stop all the component in these order

                        stop the listener
                        stop the database
                        stop the oms when run emctl stop oms
                        stop the iasconsole emctl stop iasconsole
                        stop the opmn opmnctl stopall
                        stop the agent emctl stop agent

                        check that any process is in the machine. if you have process kill them

                        start all the components

                        start the database
                        start the listener
                        start the opmn
                        start the oms
                        start the agent
                        start the iasconsole

                        go to grid control console and go to management services and repository page
                        • 11. Re: Linux: Enterprise Manager Repository database is down. Error: 12545
                          SunilF.
                          Hi I logged an SR and its now fixed
                          its a simple solution

                          1. Click Setup >
                          Management Services and Repository
                          > Related Links
                          > Monitoring Configuration.

                          2. Specify values for 'Repository username', 'Repository password' and either 'Repository Connect Descriptor' or 'Repository machine name', 'Reposi
                          tory port' (the listener port) and 'Repository SID' .

                          3. Click 'OK'

                          4. bounce OMS... all works fine