5 Replies Latest reply: Dec 13, 2012 12:38 PM by jstem1177 RSS

    EM12c - MSSQL Plugin repository mismatch - agent blocked

    jstem1177
      Hello All,

      I'm trying to deploy a simple MSSQL 2005 & 2005 standalone insltance to the EM12c.
      I've deployed the Microsoft SQl Server plugin 12.1.0.2 on the Management Server as well as to the the Management agent on my host.

      Yeah I've gotten the following errors whihc suggests that its not been deployed on the agent?

      Thanks for advice.

      Jan S.
      Metric     Agent blocked status
      Metric Group     OMS communication status
      Target     svr-sql05-01.office.local:3872(Agent)Target Information
      Incident Created     Dec 12, 2012 12:44:49 PM EST
      Last Updated     Dec 12, 2012 12:44:49 PM EST
      Summary     Agent is blocked. Blocked reason is: Plugin mismatches between agent and repository. Check plugin:[ The plug-in is oracle.sysman.oh Version in pla inventory : 12.1.0.2.0 Version on agent : null Content type : AGENT Error code : TARGETS_BEING_MONITORED Error Msg : Targets are being actively monitored by this plug-in and hence upgrade/downgrade/delete is not possible, The plug-in is oracle.sysman.oh Version in pla inventory : 12.1.0.2.0 Version on agent : null Content type : AGENT Error code : NOT_FOUND_IN_INPUT Error Msg : This plug-in is present in the inventory for the given agent but has not been provided in the input]
      Internal Event Name     OMS_COMM_STATUS:blocked_status
      Event Type     Metric Alert
      Category     Unclassified
        • 1. Re: EM12c - MSSQL Plugin repository mismatch - agent blocked
          Adeesh Fulay
          Looks like there might be some issue with the agent. You need to unblock the agent for the plug-in to work. Also, can you try this against a different agent?
          • 2. Re: EM12c - MSSQL Plugin repository mismatch - agent blocked
            Venkata Thiruveedhi-Oracle
            Hi,

            Provide the outputs of following commands:

            <OMS_HOME>/bin>emcli list_plugins_on_server


            <AGENT_HOME>/bin> ./emctl listplugins agent

            Regards,
            Venkat
            • 3. Re: EM12c - MSSQL Plugin repository mismatch - agent blocked
              jstem1177
              Hello ,

              Here is the confirmatiopn tha the MSSQL plugin is installed on the agent and server:
              C:\oracle\product\agent12c\core\12.1.0.2.0\bin>emctl listplugins agent
              Oracle Enterprise Manager Cloud Control 12c Release 2
              Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
              ---------------------------------------------------------------
              oracle.em.smss      12.1.0.2.0 C:\oracle\product\agent12c\plugins\oracle.em.smss
              .agent.plugin_12.1.0.2.0
              [oracle@srv-db-dev03 emcli]$ ./emcli list_plugins_on_server
              OMS name is EMGC_OMS1
              Plug-in Name                                                                                        Version [revision]
              
              Oracle Database                                                                                     12.1.0.2.0[20120804]
              Oracle Exadata                                                                                      12.1.0.3.0
              Oracle Fusion Middleware                                                                            12.1.0.3.0
              Oracle MOS (My Oracle Support)                                                                      12.1.0.2.0
              Oracle Virtualization                                                                               12.1.0.3.0
              Microsoft SQLServer Database                                                                        12.1.0.2.0
              Oracle Chargeback and Capacity Planning                                                             12.1.0.3.0
              Oracle Cloud Application                                                                            12.1.0.4.0
              Oracle Fusion Applications                                                                          12.1.0.3.0
              Thanks for your assistance.

              Jan S.
              • 4. Re: EM12c - MSSQL Plugin repository mismatch - agent blocked
                Venkata Thiruveedhi-Oracle
                Hi Jan,

                Seems the plugins on agent side were not properly deployed.
                I request you to log a Service Request, we can further troubleshoot checking the pluginca logs where it went wrong and which tables were not updated correctly.

                Provide the SR#

                Thanks,
                Venkat
                • 5. Re: EM12c - MSSQL Plugin repository mismatch - agent blocked
                  jstem1177
                  Hello,

                  I've updated an SR I had opened with this issue and the workaround does not work either. (All my tests are on 64bits windows 2008R2). The agent gets blocked if I try to resync the agent. The I have no clue as to how to unlbock it except to deletethe the target.
                   SR 3-6438484081 : Cloud 12c - Error when testing connectioon on MSSQL target Deployment 
                  Known bug - at least for 2008, but it applies to 2005 as well.
                  you may be running into this new bug:
                  Bug 14680497 - "TEST CONNECTION" FAILS WITH [_WINAUTHDLLTOLOADDYNAMICPROP;DB CREDENTIALS ARE FO
                  
                  The workaround is:
                  
                  
                  Ignore the "Test Connection" error. 
                  Click on OK to Add the Microsoft SQL Server target. 
                  This will give a "Metric Collection Error" status. 
                  Target Not Configured - Dynamic Category property error, Get dynamic property 
                  error. 
                  Once added, click on the Microsoft SQL Server drop-down menu > Target Setup > 
                  Monitoring Configuration 
                  
                  The Monitoring Configuration screen matches the previous version "Add 
                  Microsoft SQL Server" screen. 
                  Jan S.

                  Edited by: jstem1177 on Dec 13, 2012 1:38 PM