3 Replies Latest reply: Jan 9, 2013 8:37 PM by Subhadeep-Oracle RSS

    SQL Server monitoring with 12c Grid control

    Satish Kumar Sadhu
      Dear Gurus

      I want to add my sql server databases in 12c Grid control. for this i have deployed the sql server plugin in 12c grid control but i am unable to add the sql server databases/ servers in 12c grid control.

      Could you please help me in deploying the sql server servers in 12c grid control.

      Thanks & Regards,
      Satish Kumar Sadhu
        • 1. Re: SQL Server monitoring with 12c Grid control
          jstem1177
          Hello,

          Here is a fairly good tutorial from Gavin. This should get you started. Its for an older version of Cloud 12c but is still applicable.

          [12c Plugin for Microsoft SQL Server|http://gavinsoorma.com/2012/06/installing-the-12c-cloud-control-plug-in-for-microsoft-sql-server-database/]

          Jan S.
          • 2. Re: SQL Server monitoring with 12c Grid control
            Satish Kumar Sadhu
            Dear Jan,

            Already I have added the plugin but while adding the target i am getting below error. Can u please give some idea on this

            Test Connection failed: [_WinAuthDLLToLoadDynamicProp;em_error=DLL file 'D:\12c_agent\plugins\oracle.em.smss.agent.plugin_12.1.0.2.0\scripts\emx\microsoft_sqlserver_database..\..\..\..\dependencies\oracle.em.smss\jdbcdriver\sqljdbc_auth.dll' is found missing or not was never copied manually. Please copy amd64 version of sqljdbc_auth.dll at the above location and re-try, MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), WbemRemote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), MSSQLInstance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), OSType_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile)]
            • 3. Re: SQL Server monitoring with 12c Grid control
              Subhadeep-Oracle
              Perform the solution plan as outlined in My Oracle Support portal Doc ID 1472806.1